GPDE_AB_MATERN

(SQL Table)
Index Back

Employee Level Maternity Data

Employee Level Maternity Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 GPDE_AB_EXPECT_DT1 Date(10) DATE Expected Date of Birth
4 BIRTHDATE Date(10) DATE Date of Birth
5 GPDE_AB_EE_EXTNSMT Character(1) VARCHAR2(1) NOT NULL Extension of maternity for multiple birth e.g. Twins, triplet and premature birth.

Y/N Table Edit

Default Value: N

6 GPDE_AB_BEGIN_DT1 Date(10) DATE Begin Date Maternity
7 GPDE_AB_END_DT1 Date(10) DATE End Date Maternity
8 GPDE_MT_PIN_ML_NUM Number(8,0) INTEGER NOT NULL Absence Take Maternity

Prompt Table: GP_PIN_ABSTK_VW

9 GPDE_AB_BEGIN_DT2 Date(10) DATE Begin Date Educational Leave
10 GPDE_AB_END_DT2 Date(10) DATE End Date Educational Leave
11 GPDE_MT_PIN_EL_NUM Number(8,0) INTEGER NOT NULL Absence Take Educational Leave

Prompt Table: GP_PIN_ABSTK_VW