This page (revision-59) was last changed on 26-Nov-2021 10:22 by khiggs

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
59 26-Nov-2021 10:22 37 KB khiggs to previous
58 26-Nov-2021 10:22 37 KB kparrott to previous | to last
57 26-Nov-2021 10:22 37 KB rforbes to previous | to last
56 26-Nov-2021 10:22 60 KB rforbes to previous | to last
55 26-Nov-2021 10:22 60 KB rforbes to previous | to last
54 26-Nov-2021 10:22 60 KB jmyers to previous | to last
53 26-Nov-2021 10:22 60 KB jmyers to previous | to last
52 26-Nov-2021 10:22 60 KB jmyers to previous | to last
51 26-Nov-2021 10:22 65 KB jmyers to previous | to last
50 26-Nov-2021 10:22 67 KB jmyers to previous | to last
49 26-Nov-2021 10:22 67 KB jmyers to previous | to last
48 26-Nov-2021 10:22 64 KB jmyers to previous | to last
47 26-Nov-2021 10:22 64 KB jmyers to previous | to last
46 26-Nov-2021 10:22 64 KB jmyers to previous | to last
45 26-Nov-2021 10:22 64 KB jmyers to previous | to last
44 26-Nov-2021 10:22 63 KB jmyers to previous | to last
43 26-Nov-2021 10:22 67 KB jmyers to previous | to last
42 26-Nov-2021 10:22 67 KB jmyers to previous | to last
41 26-Nov-2021 10:22 67 KB jmyers to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 311 changed one line
[UPPHF_02.JPG]
At line 313 changed one line
!Multiple Fields processing
!Multiple Fields Processing
[UPPHF_03.JPG]
At line 315 changed one line
- on IDIF derivation expression, user can specify multiple variable names processing by indicating the lexicon value of the X_INF_VARIABLE_NAME inside the bracket [ ], e.g. [320001]
On IDIF derivation expression, user can specify multiple variable names processing by indicating the lexicon value of the X_INF_VARIABLE_NAME inside the bracket [ ], e.g. [320001]
At line 317 changed one line
- lexicon values available from IMLN for X_INF_VARIABLE_NAME are: 32nnnn, 35nnnn
Lexicon values available from IMLN for X_INF_VARIABLE_NAME are: 32nnnn, 35nnnn
At line 319 changed one line
- this provides the full list of INF variables interchangeably for UPPHF, UEEF as long as the Database tables are being loaded according to the Interface Level parameter of the run
This provides the full list of INF variables interchangeably for UPPHF, UEEF as long as the Database tables are being loaded according to the Interface Level parameter of the run
At line 321 changed one line
- please see example below
Please see example below:
At line 324 added one line
__Example: Record # 50, Field # 20 Requirement for Employee Row id or Unit id:__
At line 324 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 if the Journal Entry is reporting for 'Hours', then use the Identities eid.id on the interface file field, otherwise, use the Unit dun.id on the field for all other situation
At line 326 changed one line
Example: Record # 50, Field # 20 Requirement for Employee Row id or Unit id:
From above IDIF set up, you 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 328 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 if the Journal Entry is reporting for ‘Hours’, then use the Identities eid.id on the interface file field, otherwise, use the Unit dun.id on the field for all other situation
In derivation expression, enter:\\decode(~,'Y',decode([320803],'02',[320009],[350400]),[350400])\\where:
|[320803]|Journal Type (DGA), 01 - Financial Journal, 02 - Statistical Journal
|[320009]|Identity eid_id
|[350400]|Unit dun_id (DUN)
This derivation expression means:
At line 330 removed 13 lines
- 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',decode([320803],'02',[320009],[350400]),[350400])
where:
[320803] - Journal Type (DGA), 01 – Financial Journal, 02 – Statistical Journal
[320009] - Identity eid_id
[350400] - Unit dun_id (DUN)
- this derivation expression means: