EMPLIDEMPL_RCDBGN_DTPIN_TAKE_NUMPrompt Table: GP_PIN_ABSTK_VW
END_DTGP_ABS_SS_FCSTD(SQL View) |
Index Back |
|---|---|
Absence Self ServiceAbsence Self Service Forecasting |
| SELECT A.EMPLID , A.EMPL_RCD , A.BGN_DT , A.PIN_TAKE_NUM , A.END_DT FROM PS_GP_ABS_EVENT A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | BGN_DT |
Date(10) | DATE NOT NULL | Begin Date |
| 4 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |
| 5 | END_DT |
Date(10) | DATE | end date |