GP_PYE_ITER_WRK (SQL Table)	Index Back
Payee Iterative List Work Tbl Work Table for Pay

GP_PYE_ITER_WRK

(SQL Table)

Payee Iterative List Work Tbl

Work Table for Pay

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

3 PRC_NUM Number(5,0) INTEGER NOT NULL Process Number

4 PRC_ACTN Character(1) VARCHAR2(1) NOT NULL Process Action within a Global Payroll Iteration.
A=Added
C=Calculated
N=Not Calculated
R=Removed
S=Status Changed

5 PRC_RSN Character(1) VARCHAR2(1) NOT NULL Reason for an Action within a Global Payroll Iteration
C=Cancelled - By User
D=Error in Processing
E=Previously in Error
F=Frozen - Run Control
I=Initial Identify
N=Initial Calculation
O=Iterative Trigger
P=ReCalc - By User
R=ReCalc All - Run Control
S=Suspended - By User
T=Suspended - By System
U=Uncancelled - By User
V=Unsuspended - By System
W=Unfrozen - By Run Control
Z=Time & Labor Feed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	PRC_NUM	Number(5,0)	INTEGER NOT NULL	Process Number
4	PRC_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Process Action within a Global Payroll Iteration. A=Added C=Calculated N=Not Calculated R=Removed S=Status Changed
5	PRC_RSN	Character(1)	VARCHAR2(1) NOT NULL	Reason for an Action within a Global Payroll Iteration C=Cancelled - By User D=Error in Processing E=Previously in Error F=Frozen - Run Control I=Initial Identify N=Initial Calculation O=Iterative Trigger P=ReCalc - By User R=ReCalc All - Run Control S=Suspended - By User T=Suspended - By System U=Uncancelled - By User V=Unsuspended - By System W=Unfrozen - By Run Control Z=Time & Labor Feed