GPCH_AB_MT_NRAD

(SQL Table)
Index Back

Employee Level Maternity Data

Employee Level Maternity Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 GPCH_AB_EXPECT_DT1 Date(10) DATE Expected Date of Birth
5 BIRTHDATE Date(10) DATE Date of Birth
6 GPCH_AB_LST_WRK_DY Date(10) DATE Maternity - Last Work Day
7 EFFDT Date(10) DATE Effective Date
8 GPCH_AB_BEGIN_DT1 Date(10) DATE Begin Date Maternity
9 GPCH_AB_END_DT1 Date(10) DATE End Date Maternity
10 GPCH_MT_PIN_EL_NUM Number(8,0) INTEGER NOT NULL Absence Take Educational Leave
11 GPCH_AB_BEGIN_DT3 Date(10) DATE Begin Date Educational Leave
12 GPCH_AB_END_DT3 Date(10) DATE End Date Educational Leave
13 GPCH_MT_PIN_MI_NUM Number(8,0) INTEGER NOT NULL Absence Take Educational Leave
14 GPCH_AB_BEGIN_DT2 Date(10) DATE Begin Date Educational Leave
15 GPCH_AB_END_DT2 Date(10) DATE End Date Educational Leave
16 GPCH_MT_PIN_ML_NUM Number(8,0) INTEGER NOT NULL Absence Take Maternity