GPCH_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 GPCH_AB_EXPECT_DT1 Date(10) DATE NOT NULL Expected Date of Birth
4 BIRTHDATE Date(10) DATE Date of Birth
5 GPCH_AB_LST_WRK_DY Date(10) DATE NOT NULL Maternity - Last Work Day
6 EFFDT Date(10) DATE Effective Date
7 GPCH_AB_BEGIN_DT1 Date(10) DATE Begin Date Maternity
8 GPCH_AB_END_DT1 Date(10) DATE End Date Maternity
9 GPCH_MT_PIN_EL_NUM Number(8,0) INTEGER NOT NULL Absence Take Educational Leave
10 GPCH_AB_BEGIN_DT3 Date(10) DATE Begin Date Educational Leave
11 GPCH_AB_END_DT3 Date(10) DATE End Date Educational Leave
12 GPCH_MT_PIN_MI_NUM Number(8,0) INTEGER NOT NULL Absence Take Educational Leave
13 GPCH_AB_BEGIN_DT2 Date(10) DATE Begin Date Educational Leave
14 GPCH_AB_END_DT2 Date(10) DATE End Date Educational Leave
15 GPCH_MT_PIN_ML_NUM Number(8,0) INTEGER NOT NULL Absence Take Maternity