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

ACA - Add Dependant ID column in Spouse and Child for COB template

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA Historical Data Load
    • Reported by:
      Support
    • Module:
      ACA - Reports
    • Issue Importance:
      Must Have

      Description

      Generate unique Dependent ID and update that ID in additional field (Dependant ID) column for the newly added employee in the system.

      1. Add additional field on De pendant and spouse information through form builder
      2. Create one insert trigger Dependant and child table.
      3. Write one SP that will return Max Dependant ID + 1
      4. On trigger call above SP, and update value return by SP in table.

        Attachments

          Activity

          yogesh.chaudhari Yogesh Chaudhari (Inactive) created issue -
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Field Original Value New Value
          Description Generate unique Dependent ID and update that ID in additional field (Dependant ID) column for the newly added employee in the system. Generate unique Dependent ID and update that ID in additional field (Dependant ID) column for the newly added employee in the system.

          1. Add additional field on De pendant and spouse information through form builder
          2. Create one insert trigger Dependant and child table.
          3. Write one SP that will return Max Dependant ID + 1
          4. On trigger call above SP, and update value return by SP in table.

          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Code Review Date 10/Oct/2016
          Code Reviewed By Ramya Tantry [ 13001 ]
          yogesh.chaudhari Yogesh Chaudhari (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)
          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)
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Approved for Development [ 10003 ] In Development [ 10007 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Smita Pawar [ smita.pawar ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Link This issue relates to WT-4088 [ WT-4088 ]
          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: On Hold(10211)
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 4h [ 14400 ]
          Original Estimate 4h [ 14400 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 4h [ 14400 ] 3h 35m [ 12900 ]
          Time Spent 25m [ 1500 ]
          Worklog Id 14229 [ 14229 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Environment Production [ 10005 ]
          Issue Type Change Request [ 10002 ] Support Activity [ 10301 ]
          Status Local Testing [ 10200 ] Closed [ 6 ]
          Support Task Type ACA Historical Data Load [ 11207 ]
          Workflow WT_Features [ 24910 ] WT_Support [ 29158 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Closed [ 6 ] Reopened [ 4 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            Assignee:
            smita.pawar Smita Pawar (Inactive)
            Reporter:
            yogesh.chaudhari Yogesh Chaudhari (Inactive)
            QA:
            Sachin Hingole (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 4h
                4h
                Remaining:
                Time Spent - 25m Remaining Estimate - 3h 35m
                3h 35m
                Logged:
                Time Spent - 25m Remaining Estimate - 3h 35m
                25m