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 736 changed 10 lines
*This derivation expression means:
**decode the value of ~ from UDF
***if the value = ‘Y’, then
****decode the value from [320803] Journal Type
*****if Journal Type = ‘02’ Statistical Journal, then
******return [320009] Identify eid.id
*****otherwise
******return [350400] Unit dun_id
*****otherwise
******return [350400] Unit dun_id
This derivation expression means:
*decode the value of ~ from UDF
**if the value = 'Y', then
***decode the value from [320803] Journal Type
****if Journal Type = '02' Statistical Journal, then
*****return [320009] Identify eid.id
****otherwise
*****return [350400] Unit dun_id
****otherwise
*****return [350400] Unit dun_id
At line 747 added one line
__Example: Record # 50, Field # 10 Requirement: Work Date or Pay Period__
At line 748 changed one line
Example: Record # 50, Field # 10 Requirement: Work Date or Pay Period
*If Pay Header Group User Defined Field (UDF) 'PROJECT HOURS BY PERSON' is 'Y', this means the employee is an 'ADMIN' employee, then use the Pay Period on the interface file field, otherwise use the GL Effective date on the interface file field
At line 750 changed one line
- if Pay Header Group User Defined Field (UDF) ‘PROJECT HOURS BY PERSON’ is ‘Y’, this means the employee is an ‘ADMIN’ employee, then use the Pay Period on the interface file field, otherwise use the GL Effective date on the interface file field
*From above IDIF set up, user should specify the Variable Name using 'UDF (DGD)' and enter the UDF name in Constant Value field, then the value of UDF will be returned and represented as ~ in the derivation expression
At line 752 changed one line
- from above IDIF set up, user should specify the Variable Name using ‘UDF (DGD)’ and enter the UDF name in Constant Value field, then the value of UDF will be returned and represented as ~ in the derivation expression
In derivation expression, enter:\\decode(~,'Y',[320102],to_char(to_date([320756]),'DD/MM/YYYY'))\\where:
|[320102]|- Pay Period
|[320756]|- GL Eff Date (PJD)
At line 754 changed one line
- in derivation expression, enter:
This derivation expression means:
*decode the value of ~ from UDF
**if the value = 'Y', then
***return [320009] Identify eid.id
**otherwise
***return [350400] Unit dun_id
**otherwise
***return [350400] Unit dun_id
At line 756 changed 4 lines
decode(~,'Y',[320102],to_char(to_date([320756]),'DD/MM/YYYY'))
where:
[320102] - Pay Period
[320756] - GL Eff Date (PJD)
!P2K Internal Functions
At line 761 changed one line
- this derivation expression means:
The user has ability to call some P2K internal functions in the derivation expression under the guidance of HL consultant. The following example is for UPPHF Payroll History Interface only, and is used to demonstrate Derivation Expression only. In this example, the Element value of ‘HOURS COMP TIME’ will be returned for Variable Name ‘Pay Header pph_id’.
At line 763 changed 5 lines
- decode the value of ~ from UDF
- if the value = ‘Y’, then
- return the value from [320102] Pay Period
- otherwise
- return the value from [320756] GL Effective date with the date format of ‘DD/MM/YYYY’
%%Information the IDIF screen layout is revised as above, the screen prints in this section are example of Derivation Expression only and therefore are not matched with revised layout above, please ignore the layout format.%%
At line 772 added one line
INSERT GRAPHIC
At line 774 added one line
The above example can also be achieved by setting up Variable Name = ‘Element pph Value’ with the Element Code specified in the Constant Value field.
At line 776 added one line
INSERT GRAPHIC
At line 778 added 22 lines
!P2K Internal Functions with Parameters
The user has ability to call some P2K internal functions in the derivation expression under the guidance of HL consultant and pass the following internal parameters in order to perform some internal calculation:
#PPH_ID# - must be capital letters, this #PPH_ID# will be replaced by the current Pay Header’s pph.id
#EEM_ID# - must be capital letters, this #EEM_ID# will be replaced by the current Employment’s eem.id
#EID_ID# - must be capital letters, this #EID_ID# will be replaced by the current Identity’s eid.id
e.g.. the Element PC value of ‘HOURS O/T’ will be retrieved first and is represented as ~ in derivation expression
- the derivation expression will return the Element value of ‘HOURS COMP TIME’ for #PPH_ID# and add to value of ~
User may perform some internal mathematic calculation in the derivation expression to return some prorated amount.
Value of a PC in ‘HOURS O/T’ element * Benefit Element ‘HOURS COMP TIME’
Value of ‘HOURS O/T’ Element