WORKTERRAProject Type: software

WORKTERRA

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

WORKTERRA - Data type dictionary

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin, Onboard, Recruit, Wellness
    • Labels:
      None
    • Support Task Type:
      BOSS Setup
    • Environment:
      Stage
    • Reported by:
      Support
    • Module:
      Platform

      Description

      Does development have a data type dictionary? We need a document that list out the fields in WORKTERRA outlining what type of field it is and what is the character limit is or what values are allowed.

      Tim Bergin - add you on this ticket since your team could use it too.

        Attachments

          Issue Links

          relates to

          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
            amjohnson Amannda Johnson created issue -
            Hide
            Permalink
            satyap Satya added a comment -

            Sachin KhandgeSamirNandkumar Prabhakar KarlekarRakesh RoyDeepali Tidke

            Hi Indraprakash,

            Can we get this list from database structure? Please share list with QA team at first to share with client.

            Thanks & Regards,
            Satya Prakash

            Show
            satyap Satya added a comment - Sachin Khandge Samir Nandkumar Prabhakar Karlekar Rakesh Roy Deepali Tidke Hi Indraprakash, Can we get this list from database structure? Please share list with QA team at first to share with client. Thanks & Regards, Satya Prakash
            satyap Satya made changes -
            Field Original Value New Value
            Assignee Satya [ ID10004 ] Indraprakash Tiwari [ indraprakash ]
            satyap Satya made changes -
            Module Parent values: BenAdmin(10100) Parent values: Platform(10106)
            indraprakash Indraprakash Tiwari (Inactive) made changes -
            Attachment Table and Column from MasterCompanyDB.XLS [ 16879 ]
            Hide
            Permalink
            indraprakash Indraprakash Tiwari (Inactive) added a comment -

            Hi Satya,

            Refer attached excel sheet "Table and Column from MasterCompanyDB.xls" having tables, columns along with their data type with length.

            Let me know if you need any thing else.

            Regards,
            Indra

            Show
            indraprakash Indraprakash Tiwari (Inactive) added a comment - Hi Satya , Refer attached excel sheet "Table and Column from MasterCompanyDB.xls" having tables, columns along with their data type with length. Let me know if you need any thing else. Regards, Indra
            indraprakash Indraprakash Tiwari (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            indraprakash Indraprakash Tiwari (Inactive) made changes -
            Assignee Indraprakash Tiwari [ indraprakash ] Amannda Johnson [ amjohnson ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            Hide
            Permalink
            amjohnson Amannda Johnson added a comment -

            can you added a column to indicate if the field can be used or not? want to make sure if we use any additional eligibility setup we know what fields can be used and what cannot be used.

            Tim Bergin and Debbie Kulling this way your in the loop

            Show
            amjohnson Amannda Johnson added a comment - can you added a column to indicate if the field can be used or not? want to make sure if we use any additional eligibility setup we know what fields can be used and what cannot be used. Tim Bergin and Debbie Kulling this way your in the loop
            amjohnson Amannda Johnson made changes -
            Resolution Fixed [ 1 ]
            Status Resolved [ 5 ] Reopened [ 4 ]
            Hide
            Permalink
            amjohnson Amannda Johnson added a comment -

            any update on this?

            Show
            amjohnson Amannda Johnson added a comment - any update on this?
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Please update.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Please update.
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Amannda Johnson [ amjohnson ] Satya [ ID10004 ]
            Hide
            Permalink
            satyap Satya added a comment -

            Amit Gude Shubhankar Joshi Sonali Punse Mandar Kulkarni Amruta Lohiya Rakesh Roy Samir

            Hi Vijay,

            We need help of off-shore OEs to fetch out list of fields getting used in Eligibility. Since this has been centralized now, it will be helpful to fetch out this list & share with Amannda. Can you please plan for this activity?

            Thanks & Regards,
            Satya Prakash

            Show
            satyap Satya added a comment - Amit Gude Shubhankar Joshi Sonali Punse Mandar Kulkarni Amruta Lohiya Rakesh Roy Samir Hi Vijay, We need help of off-shore OEs to fetch out list of fields getting used in Eligibility. Since this has been centralized now, it will be helpful to fetch out this list & share with Amannda. Can you please plan for this activity? Thanks & Regards, Satya Prakash
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Vijay Siddha [ vijays ]
            vijays Vijay Siddha (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Sonali Punse [ sonali.punse ]
            sonali.punse Sonali Punse (Inactive) made changes -
            Assignee Sonali Punse [ sonali.punse ] Vijay Siddha [ vijays ]
            Hide
            Permalink
            sonali.punse Sonali Punse (Inactive) added a comment -

            CC : Vijay Siddha

            Show
            sonali.punse Sonali Punse (Inactive) added a comment - CC : Vijay Siddha
            sonali.punse Sonali Punse (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Shubhankar Joshi [ shubhankar ]
            shubhankar Shubhankar Joshi (Inactive) made changes -
            Attachment Table and Column from MasterCompanyDB.XLS [ 26721 ]
            Hide
            Permalink
            shubhankar Shubhankar Joshi (Inactive) added a comment -

            Hi Amannda Johnson, please see attached Table and Column from MasterCompanyDB.XLS , we have added the list of fields that can be used to the spreadsheet.

            CC: Vijay Siddha, Satya, Samir

            Show
            shubhankar Shubhankar Joshi (Inactive) added a comment - Hi Amannda Johnson , please see attached Table and Column from MasterCompanyDB.XLS , we have added the list of fields that can be used to the spreadsheet. CC: Vijay Siddha , Satya , Samir
            shubhankar Shubhankar Joshi (Inactive) made changes -
            Assignee Shubhankar Joshi [ shubhankar ] Amannda Johnson [ amjohnson ]
            Resolution Fixed [ 1 ]
            Status Reopened [ 4 ] Resolved [ 5 ]
            satyap Satya made changes -
            Link This issue relates to WT-9122 [ WT-9122 ]
            satyap Satya made changes -
            Environment_New Stage [ 18443 ]
            Transition Time In Source Status Execution Times
            Indraprakash Tiwari (Inactive) made transition -
            Open In Progress
            		4d 8h 52m 1
            Indraprakash Tiwari (Inactive) made transition -
            In Progress Resolved
            		37m 30s 1
            Amannda Johnson made transition -
            Resolved Reopen
            		7d 11h 31m 1
            Shubhankar Joshi (Inactive) made transition -
            Reopen Resolved
            		124d 11h 54m 1

              People

              Assignee:
              amjohnson Amannda Johnson
              Reporter:
              amjohnson Amannda Johnson
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: