Clock Card Information#

Functionality:#

This function retrieves information as seen on ITCC for an employee

Parameters:#

EEM_ID	The actual ID for the employee (employment record) that you are inquiring about
WHAT	Identifies which field in the P2K_TS_CLOCK_CARD_DETAILS or P2K_TS_CLOCK_CARDSS table you wish to retrieve. If a column exists in both tables (like CHANGE_USER) then the value from the P2K_TS_CLOCK_CARD_DETAILS is used.
AS_OF	Optional. The effective date you want the clock card information for. If not provided, the current date is used

WHAT Parameter Values#

• Any field name from P2K_TS_CLOCK_CARDS
• Any field name from P2K_TS_CLOCK_CARD_DETAILS

Returns: #

Varchar2 (regardless of the type of data being requested)

Errors: #

• *BAD EEM_ID When there is no employment record with the ID provided
• *BAD WHAT When the WHAT parameter is not one of the values supported

If there is no clock card associated to that employee, NULL is returned.

Example: #

P2K_PU.TCC(~,'CLOCK_CARD_CODE) - Using Employment ID as the passed parameter (~)

Will return the Clock Card Code assigned to that employee as of today (current date)

---

Notes#

Click to create a new notes page