| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 4 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 5 |
GPJP_TAX_ESTAB |
Character(15) |
VARCHAR2(15) NOT NULL |
Salary Payer Reference Number
|
| 6 |
GPJP_IT_PTOPRV |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
PTO days carried over from the previous year
|
| 7 |
GPJP_IT_PTOCUR |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
The Number of PTO Days that an employee is entitled.
|
| 8 |
GPJP_IT_PTOTTL |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Total PTO days
|
| 9 |
GPJP_IT_PTOTKNP |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
PTO days taken from previous year
|
| 10 |
GPJP_IT_PTOTKNC |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
PTO days taken from current year
|
| 11 |
GPJP_IT_PTOBAL |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Tracks PTO Balance
|