P2K_STEEM#

Functionality#

This database function will return the Employment ID (EEM_ID) for the identified employee, for use in subsequent functions.

Parameters#

PERSON_CODE	The employee’s person code
ENTITY_CODE	The entity that the employee works for
AS OF DATE	The date that is desired

Returns:#

Number

Errors:#

None

Examples:#

P2K_STEEM(~,’COMPANY’,trunc(sysdate)) will retrieve the ID of the P2K_HR_EMPLOYMENTS record for the person identified.

Operation:#

This function will retrieve the employment ID (EEM_ID) for the person code indicated, for the entity where the As Of date provided is between the hire date and the end of time, or termination date.

If the employee has multiple employments, only the most future record will be accessed.

---

Notes #

Click to create a new notes page