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

Version management

Difference between version and

At line 21 changed 6 lines
| 350004 | System Date/Time (35) | |The system current Date and Time stamp with following Select: SELECT to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')\\ \\You can use derivation expression SUBSTR to retrieve Date only or Time only
| 350005 | As Of Date (35) | From the [UEEF] As Of Date parameter|
| 350006 | Execution ID (35) | From the [UEEF] Execution ID of the run|
| 350007 | User Calc (35) | |Indicates this Rec#/Fld# will invoke a UserCalc.\\ \\You should enter the UserCalc name in the Constant Value field, e.g. BE USERCALC\\ \\Please read [IDIF User Calc|UEEF#section-UEEF-Step3DefiningUserCalcs] section.
| 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',~)
| 350004 | System Date/Time | |The system current Date and Time stamp with following Select: SELECT to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')\\ \\You can use derivation expression SUBSTR to retrieve Date only or Time only
| 350005 | As Of Date | From the [UEEF] As Of Date parameter|
| 350006 | Execution ID | From the [UEEF] Execution ID of the run|
| 350007 | User Calc | |Indicates this Rec#/Fld# will invoke a UserCalc.\\ \\You should enter the UserCalc name in the Constant Value field, e.g. BE USERCALC\\ \\Please read [IDIF User Calc|UEEF#section-UEEF-Step3DefiningUserCalcs] section.
| 350008 | Trial Run |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 38 changed one line
| 350201 | Location Code (DLN) | [P2K_CM_LOCATIONS] (DLN) is retrieved from DED.DLN_ID|If the [UEEF] 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 the [UEEF] parameter 'Er Addr Location' is specified, then this location is used as the Employer Address
At line 121 changed one line
| 350601 | Payroll Code (PPA) | [P2K_PR_PAYROLLS] (PPA) is retrieved from the employee's prime assignment group details|This field returns the [Payroll code|PAYROLL_CODE] from PPA
| 350601 | Payroll Code (PPA) | [P2K_PR_PAYROLLS] (PPA) is retrieved from the employee's prime assignment group details|This field returns the [Payroll code|PAYROLL_CODE] from PPA.
At line 124 changed one line
| 350701 | Pay Calendar Code (PCL) | [P2K_PR_PAY_CALENDARS] (PCL) is retrieved from the employee's prime assignment group details [Payroll code|PAYROLL_CODE]|This field returns the [Pay Calendar code|PAY_CALENDAR_CODE] from PCL
| 350701 | Pay Calendar Code (PCL) | [P2K_PR_PAY_CALENDARS] (PCL) is retrieved from the employee's prime assignment group details [Payroll code|PAYROLL_CODE]|This field returns the [Pay Calendar code|PAY_CALENDAR_CODE] from PCL.
At line 128 changed one line
| 350800 | Govt Regist Number (DGV) |[P2K_CM_GOVT_REGISTRATIONS] (DGV) is retrieved from the employee's prime assignment group details Federal Registration |This field returns the [Govt Regist Number|GOVT_REGIST_NUMBER] from DGV
| 350800 | Govt Regist Number (DGV) |[P2K_CM_GOVT_REGISTRATIONS] (DGV) is retrieved from the employee's prime assignment group details Federal Registration. |This field returns the [Govt Regist Number|GOVT_REGIST_NUMBER] from DGV.
At line 132 changed 2 lines
| 353100 | Person Code (EID) | [P2K_HR_IDENTITIES] (EID) is retrieved for the employee|This field returns the [Person code|PERSON_CODE].
| 353101 | Person eid_id (EID) | From [P2K_HR_IDENTITIES] (EID)|Derivation expression to return other value that is related to [EID_ID] e.g. to return the UDF 'LICENCE' value from [IEID], use derivation expression:p2k_smgetudf('P2K_HR_IDENTITIES','LICENCE',~)
| 353100 | Person Code (EID) | [P2K_HR_IDENTITIES] (EID) is retrieved for the employee.|This field returns the [Person code|PERSON_CODE].
| 353101 | Person eid_id (EID) | From [P2K_HR_IDENTITIES] (EID)|Derivation expression to return other value that is related to [EID_ID] e.g. to return the UDF 'LICENCE' value from [IEID], use derivation expression:p2k_smgetudf ('P2K_HR_IDENTITIES','LICENCE',~).