This page (revision-79) was last changed on 20-Sep-2023 14:24 by Lilia Urtan

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
79 20-Sep-2023 14:24 81 KB Lilia Urtan to previous
78 05-May-2023 13:45 81 KB Lilia Urtan to previous | to last
77 21-Mar-2023 10:08 80 KB Kevin Higgs to previous | to last
76 26-Nov-2021 10:22 80 KB kparrott to previous | to last
75 26-Nov-2021 10:22 80 KB khiggs to previous | to last
74 26-Nov-2021 10:22 80 KB khiggs to previous | to last
73 26-Nov-2021 10:22 79 KB khiggs to previous | to last
72 26-Nov-2021 10:22 79 KB khiggs to previous | to last
71 26-Nov-2021 10:22 79 KB khiggs to previous | to last
70 26-Nov-2021 10:22 79 KB rmorrell to previous | to last
69 26-Nov-2021 10:22 79 KB rforbes to previous | to last
68 26-Nov-2021 10:22 78 KB jmyers to previous | to last
67 26-Nov-2021 10:22 78 KB jmyers to previous | to last
66 26-Nov-2021 10:22 78 KB jmyers to previous | to last
65 26-Nov-2021 10:22 78 KB jmyers to previous | to last
64 26-Nov-2021 10:22 78 KB jmyers to previous | to last
63 26-Nov-2021 10:22 78 KB jmyers to previous | to last
62 26-Nov-2021 10:22 78 KB jmyers to previous | to last
61 26-Nov-2021 10:22 79 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
UEEF
UEEF

Version management

Difference between version and

At line 22 changed 10 lines
| 350007 | User Calc (35) | |Indicates this Rec#/Fld# will invoke a UserCalc.\\ \\Users should enter the UserCalc name in the Constant Value field, e.g. BE USERCALC\\ \\Please read [IDIF User Calc|Step3DefiningUserCalcs] section below.
| 350008 | Trial Run (35) | |
| 350020 | First Pay Beg Dt of Yr | Contains the very first pay period start date in a calendar year|
| 350021 | Last Pay End Dt of Yr | Contains the very last pay period end date in a calendar year.|
| 350022 | First BEND effdt | Contains the first enrollment details effective date within the selected period when multiple details are required to be combined (applicable to the ACTIVE and LTD coverage codes only).|
| 350025 | First Pay Beg Dt in Month | |
| 350026 | Last Pay End Dt in Month | |
| 350027 | Nbr Pays in Month | |
| 350030 | Pay Month | |
| 350100 | Entity den_id (DEN) | [P2K_CM_ENTITIES] (DEN) is retrieved from employee's employment. |This field returns the [DEN_ID], you may use this id in derivation expression to return other value that is related to [DEN_ID] e.g. to return the UDF 'COMPANY LICENCE' value from [IDEN], use derivation expression:p2k_smgetudf('P2K_CM_ ENTITIES', 'COMPANY LICENCE',~)
| 350007 | User Calc (35) | |Indicates this Rec#/Fld# will invoke a UserCalc.\\ \\Users should enter the UserCalc name in the Constant Value field, e.g. BE USERCALC\\ \\Please read [IDIF User Calc|UEEF#section-UEEF-Step3DefiningUserCalcs] section below.
| 350008 | Trial Run (35) |From the P_TRIAL (Trial Run) parameter|The value of ‘Y’ or ‘N’ is always returned in P_TRIAL\\ \\If NULL is entered, P_TRIAL is set to ‘N’
| 350100 | Entity den_id (DEN) | [P2K_CM_ENTITIES] (DEN) is retrieved from employee's employment. |This field returns the [DEN_ID], you may use this id in derivation expression to return other value that is related to [DEN_ID]\\ \\e.g. to return the UDF 'COMPANY LICENCE' value from [IDEN], use derivation expression:\\ \\p2k_smgetudf('P2K_CM_ ENTITIES', 'COMPANY LICENCE',~)
At line 35 changed one line
| 350110 | Effective (DED) | From [P2K_CM_ENTITY_DETAILS] (DED) effective as of the As of Date parameter|
| 350110 | Effective (DED) | From [P2K_CM_ENTITY_DETAILS] (DED) effective as of the [UEEF] As of Date parameter|
At line 43 changed one line
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from DED.DLN_ID|If the parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from DED.DLN_ID|If [UEEF] the parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
At line 49 changed 2 lines
| 350207 | Address 2 + City (DLN) |From [P2K_CM_LOCATIONS] (DLN) |Location Address Line 2 and Locality (city) are concatenated
| 350212 | City (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350207 | Addr Ln2 + Locality (DLN) |From [P2K_CM_LOCATIONS] (DLN) |Location Address Line 2 and Locality (city) are concatenated
| 350212 | Locality (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
At line 53 changed one line
| 350215 | Zip (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350215 | Zip Postal (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
At line 57 changed one line
| 350222 | Mail Adr 2 + City (DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address Line 2 and Locality (city) are concatenated
| 350222 | Mail Ln2 + Locality (DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address Line 2 and Locality (city) are concatenated
At line 59 changed one line
| 350224 | Mail State (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350224 | Mail State Province (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
At line 61 changed 2 lines
| 350226 | Mail Zip (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350227 | Mail State+Cntry+Zip(DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address State/Prov, Country and Postal Code are concatenated
| 350226 | Mail Zip Postal (DLN) | From [P2K_CM_LOCATIONS] (DLN)|
| 350227 | Maill State+Cntry+Postal(DLN) | From [P2K_CM_LOCATIONS] (DLN)|Location Mailing Address State/Prov, Country and Postal Code are concatenated
At line 76 changed one line
| 350310 | Effective (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD) effective as of the As of Date parameter|
| 350310 | Effective (DDD) | From [P2K_CM_DEPARTMENT_DETAILS] (DDD) effective as of the [UEEF] As of Date parameter|
At line 92 changed one line
| 350410 | Effective (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD) effective as of the As of Date parameter|
| 350410 | Effective (DUD) | From [P2K_CM_UNIT_DETAILS] (DUD) effective as of the [UEEF] As of Date parameter|
At line 105 changed one line
| 350510 | Effective (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD) effective as of the As of Date parameter|
| 350510 | Effective (DGD) | From [P2K_CM_GROUP_DETAILS] (DGD) effective as of the [UEEF] As of Date parameter|
This page (revision-79) was last changed on 20-Sep-2023 14:24 by Lilia UrtanTop