WORKTERRAProject Type: software

WORKTERRA

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

Workterra - Data Dictionary: database tables and their relationship (primary and foreign keys)

    Details

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

      Description

      Hi Indraprakash Tiwari,

      Previously we had shared WORKTERRA data dictionary with EDI team. They need more details in this. Can you please share updated spreadsheet containing below information:

      • share the data model - i.e. database tables and their relationship (primary and foreign keys)

      Parent JIRA ticket WT-2188 has been linked with this.

      Regards,
      Satya Prakash

      Cc: Vijay Siddha Umesh Kanade Lalit Kumar

        Attachments

          Issue Links

          relates to

          Support Activity - Support Activity WT-2188 WORKTERRA - Data type dictionary

          • Medium - Has the potential to affect progress.
          • Resolved

          Support Activity - Support Activity WT-8829 Workterra field mapping definitions

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            satyap Satya created issue -
            satyap Satya made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Indraprakash Tiwari [ indraprakash ]
            satyap Satya made changes -
            Link This issue relates to WT-2188 [ WT-2188 ]
            satyap Satya made changes -
            Link This issue relates to WT-8829 [ WT-8829 ]
            Hide
            Permalink
            indraprakash Indraprakash Tiwari (Inactive) added a comment -

            Satya
            Added workbook for data dictionary. Refer attached work book "Data Dictionary with constraints and reference key.xls"

            Show
            indraprakash Indraprakash Tiwari (Inactive) added a comment - Satya Added workbook for data dictionary. Refer attached work book "Data Dictionary with constraints and reference key.xls"
            Permalink
            indraprakash Indraprakash Tiwari (Inactive) logged work - 07/Apr/17 12:24 PM
            • Time Spent:
              4h
               

              Prepared script and generate data dictionary

            indraprakash Indraprakash Tiwari (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 36853 [ 36853 ]
            indraprakash Indraprakash Tiwari (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Open [ 1 ] Resolved [ 5 ]
            indraprakash Indraprakash Tiwari (Inactive) made changes -
            Assignee Indraprakash Tiwari [ indraprakash ] Satya [ ID10004 ]
            Hide
            Permalink
            satyap Satya added a comment -

            Thanks Indraprakash Tiwari for quickly sharing this

            Regards,
            Satya Prakash

            Show
            satyap Satya added a comment - Thanks Indraprakash Tiwari for quickly sharing this Regards, Satya Prakash
            satyap Satya made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Indraprakash Tiwari (Inactive) made transition -
            Open Resolved
            		7h 47m 1
            Satya made transition -
            Resolved Closed
            		2d 17h 6m 1

              People

              Assignee:
              satyap Satya
              Reporter:
              satyap Satya
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4h
                  4h