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

        1. Table and Column from MasterCompanyDB.XLS
          2.00 MB
          Shubhankar Joshi
        2. Table and Column from MasterCompanyDB.XLS
          1.98 MB
          Indraprakash Tiwari

          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
            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
            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
            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
            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.
            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
            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
            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

              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: