-
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
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.
Transition | Time In Source Status | Execution Times |
---|
|
7d 17h 48m | 1 |
|
3s | 1 |
|
3s | 1 |
|
2s | 1 |
|
68d 7h 38m | 1 |
|
2d 19h 26m | 1 |
|
8s | 1 |
|
10s | 1 |