PSHUPLD_RUNCTL (SQL Table)	Index Back
Paysheet Load Report Run Cntrl This record is used as the Run Control for the Paysheet Load Report. This Load process is used to create paysheets using data from other products, for example stock and expenses.

PSHUPLD_RUNCTL

(SQL Table)

Paysheet Load Report Run Cntrl

This record is used as the Run Control for the Paysheet Load Report. This Load process is used to create paysheets using data from other products, for example stock and expenses.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 PU_SOURCE Character(2) VARCHAR2(2) NOT NULL Paysheet Update Source
AM=Absence Management
ER=Recruiting Interface
EX=Expense Interface
IM=SIM Interface
OT=Other Sources
RP=Rapid Paysheets
SP=Stock Admin - ESPP Refunds
ST=Stock Admin - Options & ESPP
VC=Variable Compensation
WI=What-If

4 PU_TXN_STATUS Character(1) VARCHAR2(1) NOT NULL Paysheet Update Tax Status
A=Active
I=Inactive

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PU_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Paysheet Update Source AM=Absence Management ER=Recruiting Interface EX=Expense Interface IM=SIM Interface OT=Other Sources RP=Rapid Paysheets SP=Stock Admin - ESPP Refunds ST=Stock Admin - Options & ESPP VC=Variable Compensation WI=What-If
4	PU_TXN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Paysheet Update Tax Status A=Active I=Inactive