This page (revision-64) was last changed on 19-Mar-2024 10:20 by Kevin Higgs

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
64 19-Mar-2024 10:20 113 KB Kevin Higgs to previous
63 19-Mar-2024 10:13 63 KB Kevin Higgs to previous | to last
62 19-Mar-2024 10:05 63 KB Kevin Higgs to previous | to last
61 19-Mar-2024 10:04 63 KB Kevin Higgs to previous | to last

Page References

Incoming links Outgoing links
UPPHF
UPPHF

Version management

Difference between version and

At line 335 added 9 lines
*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 336 changed 9 lines
- 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
__Example: Record # 50, Field # 10 Requirement: Work Date or Pay Period__
At line 347 added 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
At line 347 changed one line
Example: Record # 50, Field # 10 Requirement: Work Date or Pay Period
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 349 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
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 351 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
This derivation expression means:
*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'
At line 353 removed 15 lines
- in derivation expression, enter:
decode(~,'Y',[320102],to_char(to_date([320756]),'DD/MM/YYYY'))
where:
[320102] - Pay Period
[320756] - GL Eff Date (PJD)
- this derivation expression means:
- 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’
At line 370 changed one line
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, 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’.
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, 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 372 changed one line
Note: 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
%%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.%%
This page (revision-64) was last changed on 19-Mar-2024 10:20 by Kevin HiggsTop