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

UI Submission -Correction and Replacement - Record Id Implementation for each 1095 runs.

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      New column addition & population

      Steps
      In this table - ACA_1095CEmployeeLevelData ,
      1. Add new column named RecordId.
      2. Create a function which should take a ReportRunId as a Parameter & perform below functionality...

      • Should update it by sequentially for each ReportRunId.
      • Record Id should be start with 1 against each reportrunid.

        Attachments

          Issue Links

            Activity

            revansiddha.gaur Revansiddha Gaur (Inactive) created issue -
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-1771 [ WT-1771 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Satya [ ID10004 ] Yogesh Chaudhari [ yogesh.chaudhari ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Revansiddha Gaur [ revansiddha.gaur ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Attachment OES_SP_ACA_UpdateRecordId.sql [ 15724 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: ACA(10104)
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Yogesh Chaudhari [ yogesh.chaudhari ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Attachment OES_SP_ACA_UpdateRecordId.sql [ 15724 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Attachment Add_Column_RecordID.sql [ 15836 ]
            Attachment OES_SP_ACA_UpdateRecordId.sql [ 15837 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Component/s ACA [ 10004 ]
            Issue Category EBS [ 10350 ] Harbinger [ 10700 ]
            Item State Parent values: LB QA(10201)
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Sachin Hingole [ sachin.hingole ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            rakeshr Rakesh Roy (Inactive) made changes -
            Developer Revansiddha Gaur [ revansiddha.gaur ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Attachment Prod_OroginalUniqueSubmissionID.png [ 18506 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Attachment Prod_OroginalUniqueSubmissionID.png [ 18506 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              revansiddha.gaur Revansiddha Gaur (Inactive)
              Developer:
              Revansiddha Gaur (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: