GP_PAYEE_DATA

(SQL Table)
Index Back

Payee Data

Payee Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 USE_PE_RTO_LIM_IND Character(1) VARCHAR2(1) NOT NULL Use Pay Entity Retro Limits

Y/N Table Edit

Default Value: Y

3 RTO_PRC_IND Character(1) VARCHAR2(1) NOT NULL Process Retro Ind

Y/N Table Edit

Default Value: N

4 RTO_LIM_BK_OPTN Character(1) VARCHAR2(1) NOT NULL Retro limit field
M=Limit by Months - Backward
N=No Limit - Backward
Y=Limit by Years - Backward

Default Value: N

5 RTO_LIM_BK_MONTHS Number(3,0) SMALLINT NOT NULL Retro limit field
6 RTO_LIM_BK_YEARS Number(3,0) SMALLINT NOT NULL Retro limit field
7 RTO_LIM_BK_MTH Character(2) VARCHAR2(2) NOT NULL Retro limit field
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
8 RTO_LIM_BK_DAY Number(2,0) SMALLINT NOT NULL Retro limit field
9 RTO_LIM_FWD_OPTN Character(1) VARCHAR2(1) NOT NULL Retro limit field
M=Limit by Months - Forward
N=No Limit - Forward
Y=Limit by Years - Forward

Default Value: N

10 RTO_LIM_FWD_MONTHS Number(3,0) SMALLINT NOT NULL Retro limit field
11 RTO_LIM_FWD_YEARS Number(3,0) SMALLINT NOT NULL Retro limit field
12 RTO_LIM_FWD_MTH Character(2) VARCHAR2(2) NOT NULL Retro limit field
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
13 RTO_LIM_FWD_DAY Number(2,0) SMALLINT NOT NULL Retro limit field
14 GP_CALC_BGN_DT Date(10) DATE Date representing a backward limit for retroactive processing. Assigned at payee level, typically initiated to the first hire date.