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

          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

            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