EMPLIDEMPL_RCDBEGIN_DTEND_DATEABS_BGN_DTN=Normal
V=Void
GPBR_LEAVE_VW(SQL View) |
Index Back |
|---|---|
Vacations Events VoidedVacations Events Voided Vacation Credit not included |
| SELECT A.EMPLID , A.EMPL_RCD , A.EVT_CONFIG1_DT , A.EVT_CONFIG2_DT , A.BGN_DT , A.END_DT , A.DURATION_ABS , 'V' FROM PS_GP_ABS_EVENT A WHERE EXISTS ( SELECT 'X' FROM PS_GPBR_VACN_AP_VW W WHERE W.EMPLID = A.EMPLID AND W.EMPL_RCD = A.EMPL_RCD AND W.BEGIN_DT = A.EVT_CONFIG1_DT AND W.END_DATE = A.EVT_CONFIG2_DT) AND (A.PRC_EVT_ACTN_OPTN = 'V' OR A.VOIDED_IND = 'Y') AND A.PIN_TAKE_NUM =( SELECT DISTINCT C.PIN_TAKE_NUM FROM PS_GPBR_VACN_PARM C WHERE C.COMPANY = ( SELECT D.COMPANY FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_JOB E WHERE E.EMPLID = D.EMPLID AND E.EMPL_RCD = D.EMPL_RCD AND E.EFFDT <= A.BGN_DT) AND D.EFFSEQ = ( SELECT MAX(F.EFFSEQ) FROM PS_JOB F WHERE F.EMPLID = D.EMPLID AND F.EMPL_RCD = D.EMPL_RCD AND F.EFFDT = D.EFFDT)) AND C.EFFDT = ( SELECT MAX(C2.EFFDT) FROM PS_GPBR_VACN_PARM C2 WHERE C2.COMPANY = C.COMPANY AND C2.EFFDT <= A.BGN_DT)) |
| # | 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 |
| 3 | BEGIN_DT |
Date(10) | DATE | Begin Date |
| 4 | END_DATE |
Date(10) | DATE | End Date |
| 5 | ABS_BGN_DT |
Date(10) | DATE NOT NULL | Absence Begin Date |
| 6 | ABS_END_DT | Date(10) | DATE | Absence End Date |
| 7 | DURATION_ABS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration field containing 2 decimals to handle absence requirements |
| 8 | PRC_EVT_ACTN_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Process Action Event Indicator
N=Normal V=Void |