GP_NEW_RTO_WRK (SQL Table)	Index Back
Payee Slctn temporary table Payee Slctn temporary table

GP_NEW_RTO_WRK

(SQL Table)

Payee Slctn temporary table

# 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID

7 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number

8 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number

9 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

10 SEL_STAT Character(1) VARCHAR2(1) NOT NULL Indicates status of the selected payee in a Calendar Group As they are identified payees are pulled in either as Active or Inactive based on the EMPL_STATUS. The system or the user can remove a payee either permanently or temporarily for various reasons. These are indicated by the status values other than Active and Inactive.
A=Active
C=Cancelled
I=Inactive
S=System Suspend
U=User Suspend

11 SEL_RSN Character(2) VARCHAR2(2) NOT NULL Selection Reason: Indicates why a payee was picked up and processed in a given calendar
01=On Payee List - Active
02=On Payee List - Inactive
03=Active and has PI
04=Active and has Rto Trgr
05=Active in Paygroup
06=Inactive and has PI
07=Inactive and has Rto Trgr
08=Inactive and has Rto Adj
09=Inactive and has Trgt Rto Adj
0A=Calendar Override - Active
0B=Calendar Override - Inactive
20=Absence Forecast

12 RTO_PRC_ID Character(10) VARCHAR2(10) NOT NULL Retro Process Definition ID

13 PYMT_DT Date(10) DATE Payment Date

14 PRC_BGN_DT Date(10) DATE The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.

15 PRC_END_DT Date(10) DATE The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.

#	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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
8	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
9	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
10	SEL_STAT	Character(1)	VARCHAR2(1) NOT NULL	Indicates status of the selected payee in a Calendar Group As they are identified payees are pulled in either as Active or Inactive based on the EMPL_STATUS. The system or the user can remove a payee either permanently or temporarily for various reasons. These are indicated by the status values other than Active and Inactive. A=Active C=Cancelled I=Inactive S=System Suspend U=User Suspend
11	SEL_RSN	Character(2)	VARCHAR2(2) NOT NULL	Selection Reason: Indicates why a payee was picked up and processed in a given calendar 01=On Payee List - Active 02=On Payee List - Inactive 03=Active and has PI 04=Active and has Rto Trgr 05=Active in Paygroup 06=Inactive and has PI 07=Inactive and has Rto Trgr 08=Inactive and has Rto Adj 09=Inactive and has Trgt Rto Adj 0A=Calendar Override - Active 0B=Calendar Override - Inactive 20=Absence Forecast
12	RTO_PRC_ID	Character(10)	VARCHAR2(10) NOT NULL	Retro Process Definition ID
13	PYMT_DT	Date(10)	DATE	Payment Date
14	PRC_BGN_DT	Date(10)	DATE	The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.
15	PRC_END_DT	Date(10)	DATE	The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.