WORKTERRAProject Type: software

WORKTERRA

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

ACA 2017 : PDF Key changes

    Details

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

      Description

      1. Create a table to store PDF keys yearwise.
      2. Table columns are :

      ID Year StaticReportTypeID FieldDescription PDFKey UserID DateTimeStamp

      3. 1095C/B and 1094C/B 's OutputTemplate Table will contain FieldDescription in place of PDFKey.
      4. This FieldDescription will be replaced by specific PDF key as per the Year.
      5. Year wise templates to be maintained.

      Impact: This change will affect following areas:
      1. Employee Level 1095C
      2. Acknowledgement level 1095C
      3. IRS Submission XSLT's
      4. UDF's , SP's and Business logic where hardcoded PDFKeys are used.

      Known issue -
      Only PDF related changes are done, Please do not verify XML Submission.

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-4576 ACA 2017 New Compliance changes

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

            Activity

            Ascending order - Click to sort in descending order
            ramya.tantry Ramya Tantry (Inactive) created issue -
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-4576 [ WT-4576 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Developer Ramya Tantry [ ramya.tantry ]
            QA Sachin Hingole [ sachin.hingole ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Nandkumar [ satyap ] Ramya Tantry [ ramya.tantry ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Description 1. Create a table to store PDF keys yearwise.
            2. Table columns are :

            ||ID||Year||StaticReportTypeID||FieldDescription||PDFKey||UserID||DateTimeStamp||

            3. 1095C/B and 1094C/B 's OutputTemplate Table will contain FieldDescription in place of PDFKey.
            4. This FieldDescription will be replaced by specific PDF key as per the Year.
            5. Year wise templates to be maintained.


            		 1. Create a table to store PDF keys yearwise.
            2. Table columns are :

            ||ID||Year||StaticReportTypeID||FieldDescription||PDFKey||UserID||DateTimeStamp||

            3. 1095C/B and 1094C/B 's OutputTemplate Table will contain FieldDescription in place of PDFKey.
            4. This FieldDescription will be replaced by specific PDF key as per the Year.
            5. Year wise templates to be maintained.

            *Impact*: This change will affect following areas:
            1. Employee Level 1095C
            2. Acknowledgement level 1095C
            3. IRS Submission XSLT's
            4. UDF's and SP's where hardcoded PDFKeys are used.
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Abhijeet Khandagale,Yogesh Chaudhari,Revansiddha Gaur,Kumar Chhajed,Nandkumar Prabhakar Karlekar

            Please review the description and add points,if any which may have been missed.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Abhijeet Khandagale , Yogesh Chaudhari , Revansiddha Gaur , Kumar Chhajed , Nandkumar Prabhakar Karlekar Please review the description and add points,if any which may have been missed.
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Description 1. Create a table to store PDF keys yearwise.
            2. Table columns are :

            ||ID||Year||StaticReportTypeID||FieldDescription||PDFKey||UserID||DateTimeStamp||

            3. 1095C/B and 1094C/B 's OutputTemplate Table will contain FieldDescription in place of PDFKey.
            4. This FieldDescription will be replaced by specific PDF key as per the Year.
            5. Year wise templates to be maintained.

            *Impact*: This change will affect following areas:
            1. Employee Level 1095C
            2. Acknowledgement level 1095C
            3. IRS Submission XSLT's
            4. UDF's and SP's where hardcoded PDFKeys are used.


            		 1. Create a table to store PDF keys yearwise.
            2. Table columns are :

            ||ID||Year||StaticReportTypeID||FieldDescription||PDFKey||UserID||DateTimeStamp||

            3. 1095C/B and 1094C/B 's OutputTemplate Table will contain FieldDescription in place of PDFKey.
            4. This FieldDescription will be replaced by specific PDF key as per the Year.
            5. Year wise templates to be maintained.

            *Impact*: This change will affect following areas:
            1. Employee Level 1095C
            2. Acknowledgement level 1095C
            3. IRS Submission XSLT's
            4. UDF's , SP's and Business logic where hardcoded PDFKeys are used.
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Nandkumar Prabhakar Karlekar

            Below is the high level task breakdown and estimate provided by Abhijeet.

            1. Replace PDF Keys with Field Description of 1095C/B and 1094C/B Sp's. -->20 Hours
            2. While SP Execution,Update the Field Description with PDF Keys of that year. --> 15 Hours
            3. While Dumping, replace PDF Keys with Field Description. --> Will decide once revan's format is finalized. Dumping XML format Change.
            4. Changes in BL, replace PDF Keys with Field Description. --> 15 Hours
            5. Employee Level SP change. --> 8 Hours

            Testing --> 12 Hours

            Revansiddha Gaur : Please provide the required format for data dumping so that we can provide the estimates for 3rd point.

            CC : Abhijeet Khandagale,Yogesh Chaudhari,Kumar Chhajed

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Nandkumar Prabhakar Karlekar Below is the high level task breakdown and estimate provided by Abhijeet. 1. Replace PDF Keys with Field Description of 1095C/B and 1094C/B Sp's. --> 20 Hours 2. While SP Execution,Update the Field Description with PDF Keys of that year. --> 15 Hours 3. While Dumping, replace PDF Keys with Field Description. --> Will decide once revan's format is finalized. Dumping XML format Change. 4. Changes in BL, replace PDF Keys with Field Description. --> 15 Hours 5. Employee Level SP change. --> 8 Hours Testing --> 12 Hours Revansiddha Gaur : Please provide the required format for data dumping so that we can provide the estimates for 3rd point. CC : Abhijeet Khandagale , Yogesh Chaudhari , Kumar Chhajed
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Kumar Chhajed [ kumar.chhajed ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Code Reviewed By Ramya Tantry [ 13001 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Assignee Kumar Chhajed [ kumar.chhajed ] Sachin Hingole [ sachin.hingole ]
            Hide
            Permalink
            kumar.chhajed Kumar Chhajed (Inactive) added a comment -

            Ramya Tantry Nandkumar Prabhakar Karlekar Sachin Hingole

            Changes done are -
            1) PDF keys replaced in all SP's and Business logic files of (1094-95 B & C ).
            2) New templates of 2016 have been uploaded on file server.

            Show
            kumar.chhajed Kumar Chhajed (Inactive) added a comment - Ramya Tantry Nandkumar Prabhakar Karlekar Sachin Hingole Changes done are - 1) PDF keys replaced in all SP's and Business logic files of (1094-95 B & C ). 2) New templates of 2016 have been uploaded on file server.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Description 1. Create a table to store PDF keys yearwise.
            2. Table columns are :

            ||ID||Year||StaticReportTypeID||FieldDescription||PDFKey||UserID||DateTimeStamp||

            3. 1095C/B and 1094C/B 's OutputTemplate Table will contain FieldDescription in place of PDFKey.
            4. This FieldDescription will be replaced by specific PDF key as per the Year.
            5. Year wise templates to be maintained.

            *Impact*: This change will affect following areas:
            1. Employee Level 1095C
            2. Acknowledgement level 1095C
            3. IRS Submission XSLT's
            4. UDF's , SP's and Business logic where hardcoded PDFKeys are used.


            		 1. Create a table to store PDF keys yearwise.
            2. Table columns are :

            ||ID||Year||StaticReportTypeID||FieldDescription||PDFKey||UserID||DateTimeStamp||

            3. 1095C/B and 1094C/B 's OutputTemplate Table will contain FieldDescription in place of PDFKey.
            4. This FieldDescription will be replaced by specific PDF key as per the Year.
            5. Year wise templates to be maintained.

            *Impact*: This change will affect following areas:
            1. Employee Level 1095C
            2. Acknowledgement level 1095C
            3. IRS Submission XSLT's
            4. UDF's , SP's and Business logic where hardcoded PDFKeys are used.


            *Known issue* -
            Only PDF related changes are done, Please do not verify XML Submission.
            kumar.chhajed Kumar Chhajed (Inactive) made changes -
            Developer Ramya Tantry [ ramya.tantry ] Kumar Chhajed [ kumar.chhajed ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Mahendra Mungase [ mahendra.mungase ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned changes on LB [ACA Automation company]

            Tested scenarios are as follows.

            1.Enrolled 15 dependent on 1095-C report and checked whether data is coming properly on the file or not.
            2.Similarly verified forms for 2016 and 2015 1095-C PDF's
            3.Verified 1094-C form for data
            4. Verified B forms for data
            5.Checked whether data is coming properly on the PDF'S or not on 1095-C form

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned changes on LB [ACA Automation company] Tested scenarios are as follows. 1.Enrolled 15 dependent on 1095-C report and checked whether data is coming properly on the file or not. 2.Similarly verified forms for 2016 and 2015 1095-C PDF's 3.Verified 1094-C form for data 4. Verified B forms for data 5.Checked whether data is coming properly on the PDF'S or not on 1095-C form
            smita.pawar Smita Pawar (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)
            smita.pawar Smita Pawar (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)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            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 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Mahendra Mungase [ mahendra.mungase ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned changes on Stage [ACA Automation company]
            Tested scenarios are as follows.

            Its working fine.

            1.Enrolled 15 dependents on 1095-C report and checked whether data is coming properly on the file or not.
            2.Similarly verified forms for 2016 and 2015 1095-C PDF's
            3.Verified 1094-C form for data
            4. Verified B forms for data
            5.Checked whether data is coming properly on the PDF'S or not on 1095-C form

            Enhancement is ready for Production

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned changes on Stage [ACA Automation company] Tested scenarios are as follows. Its working fine. 1.Enrolled 15 dependents on 1095-C report and checked whether data is coming properly on the file or not. 2.Similarly verified forms for 2016 and 2015 1095-C PDF's 3.Verified 1094-C form for data 4. Verified B forms for data 5.Checked whether data is coming properly on the PDF'S or not on 1095-C form Enhancement is ready for Production
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            smita.pawar Smita Pawar (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 -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on production, working fine.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on production, working fine.
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Kumar Chhajed (Inactive) made transition -
            New Request Pending for Approval
            		21d 6h 34m 1
            Kumar Chhajed (Inactive) made transition -
            Pending for Approval Approved for Development
            		7m 5s 1
            Kumar Chhajed (Inactive) made transition -
            Approved for Development In Development
            		5s 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		5d 18h 9m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		15d 6h 7m 1
            Sachin Hingole (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		4s 1
            Sachin Hingole (Inactive) made transition -
            Approved for Stage Stage Testing
            		4s 1
            Smita Pawar (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		2d 54m 1
            Smita Pawar (Inactive) made transition -
            Pending for Production Approval Approved for production
            		5s 1
            Smita Pawar (Inactive) made transition -
            Approved for production In Production Testing
            		2s 1
            Sachin Hingole (Inactive) made transition -
            In Production Testing Production Complete
            		9d 19h 55m 1
            Sachin Hingole (Inactive) made transition -
            Production Complete Closed
            		1m 50s 1

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              ramya.tantry Ramya Tantry (Inactive)
              Developer:
              Kumar Chhajed (Inactive)
              QA:
              Sachin Hingole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: