WORKTERRAProject Type: software

WORKTERRA

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

        1. 1094B_Request_BB2D9_20160511T223218129Z.xml
          15 kB
          Sachin Hingole
        2. Add_Column_RecordID.sql
          0.5 kB
          Yogesh Chaudhari
        3. OES_SP_ACA_UpdateRecordId.sql
          2 kB
          Yogesh Chaudhari
        4. OES_UDF_ACA_GetCorrectionIdentification.sql
          2 kB
          Yogesh Chaudhari

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-1771 Correction and replacement XML Creation [correction]

          • Critical - This problem will block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            This is a sub task required in correction & replacement for ui submission.

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - This is a sub task required in correction & replacement for ui submission.
            Hide
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hi Revan,

            As we discuss, I have added one column RecordID in ACA_1095CEmployeeLevelData table. Also I have created stored procedure that update RecordID in ACA_1095CEmployeeLevelData table as per its ReportRunID by Row_Number.

            Please find the attached stored procedure and review this.

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hi Revan, As we discuss, I have added one column RecordID in ACA_1095CEmployeeLevelData table. Also I have created stored procedure that update RecordID in ACA_1095CEmployeeLevelData table as per its ReportRunID by Row_Number. Please find the attached stored procedure and review this.
            Hide
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            OES_SP_ACA_UpdateRecordId.sql

            GO
            IF Not EXISTS (SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
            WHERE TABLE_NAME = 'ACA_1095CEmployeeLevelData' AND COLUMN_NAME = 'RecordId')
            BEGIN
            Alter table [dbo].[ACA_1095CEmployeeLevelData] add RecordId BIGINT

            END
            GO

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - OES_SP_ACA_UpdateRecordId.sql GO IF Not EXISTS (SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ACA_1095CEmployeeLevelData' AND COLUMN_NAME = 'RecordId') BEGIN Alter table [dbo] . [ACA_1095CEmployeeLevelData] add RecordId BIGINT END GO
            Hide
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Yogesh Chaudhari,

            1. Sp should work not only for 'C' EmployeeLevelData but also it should work for 'B', So please make it generic accordingly to generate Record ID.

            2. Please do proper indentation,casing & ensure once proper naming convention as per Indra's mail before committing to repository .

            Thanks & Regards,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Yogesh Chaudhari , 1. Sp should work not only for 'C' EmployeeLevelData but also it should work for 'B', So please make it generic accordingly to generate Record ID. 2. Please do proper indentation,casing & ensure once proper naming convention as per Indra's mail before committing to repository . Thanks & Regards, Revan
            Hide
            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

            Hi Revansiddha Gaur

            Please find the attached updated sql function which return correction identification and stored procedure that will update RecordID in 1095 tables.
            OES_UDF_ACA_GetCorrectionIdentification.sql Add_Column_RecordID.sql OES_SP_ACA_UpdateRecordId.sql

            Please let me know in case of any concern.

            Show
            yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Hi Revansiddha Gaur Please find the attached updated sql function which return correction identification and stored procedure that will update RecordID in 1095 tables. OES_UDF_ACA_GetCorrectionIdentification.sql Add_Column_RecordID.sql OES_SP_ACA_UpdateRecordId.sql Please let me know in case of any concern.
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on LB, working fine.
            Now it starts submission IDs from 1 and increments it by one for next submission IDs.
            Also Record IDs are also start from one for each submission ID and increment it by one for next records.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on LB, working fine. Now it starts submission IDs from 1 and increments it by one for next submission IDs. Also Record IDs are also start from one for each submission ID and increment it by one for next records.
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on Stage for 1094/5 B and C, working fine. refer 1094B_Request_BB2D9_20160511T223218129Z.xml
            Now it starts submission IDs from 1 and increments it by one for next submission IDs.
            Also Record IDs are also start from one for each submissions and increment it by one for next records.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on Stage for 1094/5 B and C, working fine. refer 1094B_Request_BB2D9_20160511T223218129Z.xml Now it starts submission IDs from 1 and increments it by one for next submission IDs. Also Record IDs are also start from one for each submissions and increment it by one for next records.
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on production for 1094/5 B and C, working fine. refer

            It starts submission IDs from 1 and increments it by one for next submission IDs.
            Also Record IDs are also start from one for each submissions and increment it by one for next records.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on production for 1094/5 B and C, working fine. refer It starts submission IDs from 1 and increments it by one for next submission IDs. Also Record IDs are also start from one for each submissions and increment it by one for next records.

              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: