WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-8829

Workterra field mapping definitions

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Query Resolution
    • Reported by:
      Support
    • Module:
      Platform
    • Severity:
      Simple

      Description

      Attached [^Field Mapping Definitions - 20160712.xls] is the field mapping definitions we have currently. Would it be possible to get an updated data dictionary for the Workterra fields.

      Cc: Abhay Patil Amit Thorve

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-9922 Need to remove/hide unused fields from import/export mappings.

          • Medium - Has the potential to affect progress.
          • New Request

          Support Activity - Support Activity WT-9122 Workterra - Data Dictionary: database tables and their relationship (primary and foreign keys)

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 13/Mar/17 12:53 PM
            • Time Spent:
              0.5h
               

              Discussion and understanding

            Permalink
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 14/Mar/17 12:54 PM
            • Time Spent:
              4h
               
              <No comment>
            Permalink
            aniruddha.dev Aniruddha Dev (Inactive) logged work - 15/Mar/17 11:44 AM
            • Time Spent:
              0.25h
               

              Discussion With Lalit

            Permalink
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 16/Mar/17 09:04 AM
            • Time Spent:
              2h
               

              Checked below fields implementation in Export.

              • Import/Export Card/Welcome Pkg Indicator
              • Import/Export Claims Free Indicator
              • Import/Export Name Print Indicator
              • Import/Export Medical Flex Spending Account
              • Import/Export Transaction Code
              • Import/Export Dependent Care Flex Spending Account
              • Import/Export Child Serial Number
              • Import/Export Beneficiary Serial Number
              • Import/Export Emload Change Reason
              • Import/Export Country Code
              • Import/Export Action Type
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 16/Mar/17 01:04 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 07/Apr/17 09:39 AM
            • Time Spent:
              4.5h
               

              Review all the fields

              Classifying the fields into :

              1) Indicators - Behavioral fields
              2) Macro's - Business Logic fields
              3) Direct Fields -

              Merging the DTS transformation sheet with Field sheet by finding each listed field from the sheet provided by Vinayak K.

              Discussion with Satya on the same.

            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 07/Apr/17 01:51 PM
            • Time Spent:
              1h
               

              Getting DTS information.

            Permalink
            lalit.kumar Lalit Kumar (Inactive) logged work - 11/Apr/17 05:38 PM
            • Time Spent:
              2h
               

              Updating fields description

            Permalink
            lalit.kumar Lalit Kumar (Inactive) logged work - 12/Apr/17 04:06 PM - edited
            • Time Spent:
              2h
               

              Added description for fields in data dictionary

            Permalink
            lalit.kumar Lalit Kumar (Inactive) logged work - 12/Apr/17 04:35 PM
            • Time Spent:
              0.75h
               

              Field description discussion with EDI team

            Permalink
            lalit.kumar Lalit Kumar (Inactive) logged work - 13/Apr/17 04:08 PM - edited
            • Time Spent:
              1.5h
               

              Added description for fields in data dictionary

            Permalink
            lalit.kumar Lalit Kumar (Inactive) logged work - 14/Apr/17 04:11 PM - edited
            • Time Spent:
              2.5h
               

              Updated field description

            Permalink
            lalit.kumar Lalit Kumar (Inactive) logged work - 14/Apr/17 04:34 PM
            • Time Spent:
              0.75h
               

              Fields description discussion with EDI team

            Permalink
            lalit.kumar Lalit Kumar (Inactive) logged work - 17/Apr/17 04:33 PM
            • Time Spent:
              1h
               

              Reviewing list of fields for deletion with dev team

            Permalink
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 18/Apr/17 12:00 PM
            • Time Spent:
              2h
               
              <No comment>
            Permalink
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 19/Apr/17 01:15 PM
            • Time Spent:
              6.5h
               
              <No comment>
            Permalink
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 20/Apr/17 12:00 PM
            • Time Spent:
              2h
               
              <No comment>
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 20/Apr/17 05:57 PM
            • Time Spent:
              1h
               
              <No comment>
            Permalink
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 21/Apr/17 01:17 PM
            • Time Spent:
              8h
               
              <No comment>
            Permalink
            rajendra.pawar Rajendra Pawar (Inactive) logged work - 24/Apr/17 01:16 PM
            • Time Spent:
              4h
               

              Done with all remaining export fields description.

            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 25/Apr/17 06:07 PM
            • Time Spent:
              1h
               
              <No comment>

              People

              Assignee:
              Vinayak.Kulkarni Vinayak Kulkarni (Inactive)
              Reporter:
              satyap Satya
              Account Executive:
              Cindy Wibbing (Inactive)
              Developer:
              Lalit Kumar (Inactive)
              QA:
              Hrishikesh Deshpande (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h Original Estimate - 8h
                  8h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 47.75h
                  47.75h