GPJP_SIN_PARENT

(SQL Table)
Index Back

Single Parent Dependent Detail

Single Parent Dependent Details.

# 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