# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
2 |
GPJP_CHANGE_DATE |
Date(10) |
DATE |
Single Parent Dependent Details change date
|
3 |
GPJP_CHLD_REAR_NUM |
Character(12) |
VARCHAR2(12) NOT NULL |
Single Parent Dependent Detail child rear number
|
4 |
GPJP_CHILD_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
Single Parent Dependent Detail child name
|
5 |
GPJP_CHLD_EST_INCO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Single Parent Dependent Detail child income
|
6 |
GPJP_CHG_REASON |
Character(80) |
VARCHAR2(80) NOT NULL |
Single Parent Dependent Detail change reason
|