GPDE_AB_MT_NRVW

(SQL View)
 Index Back

Employee Maternity Data

Employee Level Maternity Data Export View

SELECT EMPLID , EMPL_RCD , GPDE_AB_EXPECT_DT1 , BIRTHDATE , GPDE_AB_EE_EXTNSMT , GPDE_AB_BEGIN_DT1 , GPDE_AB_END_DT1 , GPDE_MT_PIN_ML_NUM + 50000000 , GPDE_AB_BEGIN_DT2 , GPDE_AB_END_DT2 , GPDE_MT_PIN_EL_NUM + 50000000 FROM PS_GPDE_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 Rcd Nbr
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.
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