EMPLIDPrompt Table: PERSON
EMPL_RCDGPDE_AB_EXPECT_DT1GPDE_AL_SEQNUMPrompt Table: GP_PIN_ABSTK_VW
GPDE_AB_MT_ELVW(SQL View) |
Index Back |
|---|---|
Parental LeaveParental Leave |
| SELECT EMPLID ,EMPL_RCD ,GPDE_AB_EXPECT_DT1 ,GPDE_AL_SEQNUM ,BGN_DT ,END_DT ,GPDE_MT_PIN_EL_NUM + 50000000 FROM PS_GPDE_AB_MAT_EL |
| # | 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 | GPDE_AL_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | BGN_DT | Date(10) | DATE NOT NULL | Begin Date |
| 6 | END_DT | Date(10) | DATE NOT NULL | end date |
| 7 | GPDE_MT_PIN_EL_NUM | Number(8,0) | INTEGER NOT NULL |
Absence Take Educational Leave
Prompt Table: GP_PIN_ABSTK_VW |