| # |
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.
|