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 25 changed 7 lines
| 320004 | System Date/Time (32) | The current system date and time with following, select:to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')|You can use derivation expression SUBSTR to retrieve Date Only or Time Only
| 320005 | From Pay Period (32) | This field holds the earliest pay period that have been processed from all pay headers| This can be used for Header or Trailer record
| 320006 | To Pay Period (32) | This field holds the latest pay period that have been processed from all pay headers|This can be used for Header or Trailer record
| 320007 | Pay Header pph_id (32) | This field holds the id of the current pay header|This can be used in the derivation expression to call some internal [{$applicationname}] functions that needed the pph.id e.g. call Element function to return the value of an element: To retrieve the value of Element 'HOURS COMP TIME'. In Record# 50, Field#20, Variable Name = 'Pay Header [PPH_ID]', then in derivation expression: P2K_PPAMTS.SPELPAY(~,P2K_PPAMTS.SPGETPEL('HOURS COMP TIME'))
| 320008 | Employment eem_id (32) | This field holds the id of the current employment record, from [P2K_HR_EMPLOYMENTS]|
| 320009 | Identity eid_id (32) | This field holds the id of the current identity record from [P2K_HR_IDENTITIES]|This can be used in the derivation expression to call some internal [{$applicationname}] functions that needed the [EID_ID]
| 320010 | Person Code (32) | From [P2K_HR_IDENTITIES], [person_code|PERSON_CODE]|
| 320004 | System Date/Time | The current system date and time with following, select:to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')|You can use derivation expression SUBSTR to retrieve Date Only or Time Only
| 320005 | From Pay Period | This field holds the earliest pay period that have been processed from all pay headers| This can be used for Header or Trailer record
| 320006 | To Pay Period | This field holds the latest pay period that have been processed from all pay headers|This can be used for Header or Trailer record
| 320007 | Pay Header pph_id | This field holds the id of the current pay header|This can be used in the derivation expression to call some internal [{$applicationname}] functions that needed the pph.id e.g. call Element function to return the value of an element: To retrieve the value of Element 'HOURS COMP TIME'.\\ \\ In Record# 50, Field#20, Variable Name = 'Pay Header [PPH_ID]', then in derivation expression: P2K_PPAMTS.SPELPAY(~,P2K_PPAMTS.SPGETPEL('HOURS COMP TIME'))
| 320008 | Employment eem_id | This field holds the id of the current employment record, from [P2K_HR_EMPLOYMENTS]|This can be used in the derivation expression to call some internal functions that needed the eid.id
| 320009 | Identity eid_id | This field holds the id of the current identity record from [P2K_HR_IDENTITIES]|This can be used in the derivation expression to call some internal functions that needed the [EID_ID]
| 320010 | Person Code | From [P2K_HR_IDENTITIES], [person_code|PERSON_CODE]|