WORKTERRAProject Type: software

WORKTERRA

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

          Ascending order - Click to sort in descending order
          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)
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have done corresponding changes on LB and sent file to client for review.
          We will work on this ticket once it will get feed back client.
          Till the time marking ticket as ON HOLD

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have done corresponding changes on LB and sent file to client for review. We will work on this ticket once it will get feed back client. Till the time marking ticket as ON HOLD
          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 ]
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 19/Dec/16 12:13 PM
          • Time Spent:
            25m
             

            We have done this support activity on LB & Production company.
            Closing this ticket.

          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 ]
          Transition Time In Source Status Execution Times
          Sachin Hingole (Inactive) made transition -
          New Request Pending for Approval
          		7d 17h 48m 1
          Sachin Hingole (Inactive) made transition -
          Pending for Approval Approved for Development
          		3s 1
          Sachin Hingole (Inactive) made transition -
          Approved for Development In Development
          		3s 1
          Sachin Hingole (Inactive) made transition -
          In Development In LB Testing
          		2s 1
          Smita Pawar (Inactive) made transition -
          In LB Testing Closed
          		68d 7h 38m 1
          Sachin Hingole (Inactive) made transition -
          Closed Reopen
          		2d 19h 26m 1
          Sachin Hingole (Inactive) made transition -
          Reopen Resolved
          		8s 1
          Sachin Hingole (Inactive) made transition -
          Resolved Closed
          		10s 1

            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