P 2 K_PU.PSN
Back to current versionRestore this version

Sundry Line Information#

Functionality:#

This function retrieves information as seen on IPSN, for an employee's sundry transaction. This function does not retrieve sundry line detail information, only P2K_PR_SUNDRY_LINES.

Parameters:#

EEM_ID The actual ID for the employment record belonging to the employee you are getting data for
PC_CODE The pay component code for the sundry line
WHAT Identifies which element of the sundry line you wish to retrieve
AS_OF Optional. Provides a date to narrow down the sundry line retrieval. If not provided, then the current date will be used.

WHAT Parameter Values#

START_DATEEND_DATETIMES_REMAININGTIME_ENTEREDTIME_BASIS
AGENCY_CASE_IDENTIFICATIONDEPENDANT_MEDICAL_COVERAGEDISTRIBUTION_MASKEXTERNAL_DOCUMENT_IDLIEN_DEDUCTION
LIEN_NUMBERMEMORANDUM_1MEMORANDUM_2PAID_TO_ORDER_OFREFERENCE_INFO
SUNDRY_STATUSWCB_CLASSWORK_ORDERPAYEE_NAMEPAYEE_CODE

Returns: #

Varchar2 (regardless of the type of data being requested) If no sundry

Errors: #

Example: #

P2K_PU.PSN(~,'5030','WORK_ORDER') - Using Employment ID as the first parameter (~)

Will return the WORK_ORDER for the employee's sundry transaction for pay component 5030

P2K_PU.PSN(~,'5100','PAYEE_NAME',[350005]) - Using Employment ID as the first parameter (~) and AS OF date from the UEEF/UPPHF screen as the last

Will return the First Name and Last Name of the vendor identified as the Payee for the employee's sundry transaction for pay component 5100, that is in effect as of the date of the UEEF or UPPHF run.


Notes#

Click to create a new notes page