GP_PAYEE_DATA(SQL Table) |
Index Back |
---|---|
Payee DataPayee 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. |