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

          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