| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
DATE_YEAR_VAL |
Number(4,0) |
SMALLINT NOT NULL |
Date Year Value
|
| 3 |
GPJP_YEA_EEPR_STAT |
Character(3) |
VARCHAR2(3) NOT NULL |
YEA Employee Information Status
10=Open
20=Reviewed
30=Rejected
40=Submitted
50=Approved
60=Sent to Payroll
|
| 4 |
GPJP_YEA_EETX_STAT |
Character(3) |
VARCHAR2(3) NOT NULL |
YEA Employee Tax Information Status
10=Open
20=Reviewed
30=Rejected
40=Submitted
50=Approved
60=Sent to Payroll
|
| 5 |
GPJP_YEA_DTAX_STAT |
Character(3) |
VARCHAR2(3) NOT NULL |
YEA Dep Tax Information Status
10=Open
20=Reviewed
30=Rejected
40=Submitted
50=Approved
60=Sent to Payroll
|
| 6 |
GPJP_YEA_LIFE_STAT |
Character(3) |
VARCHAR2(3) NOT NULL |
YEA Life Status
10=Open
20=Reviewed
30=Rejected
40=Submitted
50=Approved
60=Sent to Payroll
|
| 7 |
GPJP_YEA_NLIF_STAT |
Character(3) |
VARCHAR2(3) NOT NULL |
YEA Non Life Status
10=Open
20=Reviewed
30=Rejected
40=Submitted
50=Approved
60=Sent to Payroll
|
| 8 |
GPJP_YEA_SP_STAT |
Character(3) |
VARCHAR2(3) NOT NULL |
YEA Spouse Status
10=Open
20=Reviewed
30=Rejected
40=Submitted
50=Approved
60=Sent to Payroll
|
| 9 |
GPJP_YEA_HOUS_STAT |
Character(3) |
VARCHAR2(3) NOT NULL |
YEA Housing Status
10=Open
20=Reviewed
30=Rejected
40=Submitted
50=Approved
60=Sent to Payroll
|
| 10 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|