GPCH_AB_MT_NRVW

(SQL View)
 Index Back

Employee Level Maternity Data

Employee Level Maternity Data

SELECT EMPLID , EMPL_RCD , GPCH_AB_EXPECT_DT1 , BIRTHDATE , GPCH_AB_LST_WRK_DY , EFFDT , GPCH_AB_BEGIN_DT1 , GPCH_AB_END_DT1 , GPCH_MT_PIN_EL_NUM + 50000000 , GPCH_AB_BEGIN_DT3 , GPCH_AB_END_DT3 , GPCH_MT_PIN_MI_NUM + 50000000 , GPCH_AB_BEGIN_DT2 , GPCH_AB_END_DT2 , GPCH_MT_PIN_ML_NUM + 50000000 FROM PS_GPCH_AB_MATERN

# 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