EMPLIDEMPL_RCDPrompt Table: EMPLMT_SRCH_GBL
Default Value: GP_ABS_EVENT.BGN_DT
GPES_CERTF_VW(SQL View) |
Index Back |
|---|---|
Employees with IT/AT/MT/REGeneric view that shows employees with absence event of IT/AT/MT/RE |
| SELECT A1.EMPLID , A1.EMPL_RCD , A2.ABS_TYPE_OPTN , A1.BGN_DT , A1.END_DT , A1.ORIG_BEGIN_DT FROM PS_GP_ABS_EVENT A1 , PS_GP_ABS_TAKE A2 WHERE A2.PIN_NUM = A1.PIN_TAKE_NUM AND A2.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GP_ABS_TAKE WHERE PIN_NUM = A2.PIN_NUM AND EFFDT <= A1.END_DT) AND A2.EFF_STATUS = 'A' AND A1.PRC_EVT_ACTN_OPTN = 'N' AND A1.VOIDED_IND = 'N' |
| # | 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 Record
Prompt Table: EMPLMT_SRCH_GBL |
| 3 | ABS_TYPE_OPTN | Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 4 | BGN_DT | Date(10) | DATE | Begin Date |
| 5 | END_DT | Date(10) | DATE | end date |
| 6 | ORIG_BEGIN_DT | Date(10) | DATE |
original begin date
Default Value: GP_ABS_EVENT.BGN_DT |