Clock Card Information#
Functionality:#
This function retrieves information as seen on ITCC for an employeeParameters:#
| 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)
