This is version 1 2 3 4 5 6 7 . It is not the current version, and thus it cannot be edited.

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_DATE	END_DATE	TIMES_REMAINING	TIME_ENTERED	TIME_BASIS
AGENCY_CASE_IDENTIFICATION	DEPENDANT_MEDICAL_COVERAGE	DISTRIBUTION_MASK	EXTERNAL_DOCUMENT_ID	LIEN_DEDUCTION
LIEN_NUMBER	MEMORANDUM_1	MEMORANDUM_2	PAID_TO_ORDER_OF	REFERENCE_INFO
SUNDRY_STATUS	WCB_CLASS	WORK_ORDER	PAYEE_NAME	PAYEE_CODE

Returns: #

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

Errors: #

• *BAD EEM_ID When there is no employment record with the ID provided
• *BAD PC CODE When there is no such pay component
• *BAD WHAT When the WHAT parameter is not one of the values supported
• *BAD SUNDRY When more than one sundry line meets the criteria.

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