EMPLIDEMPL_RCDGP_ABS_SS_ESRCH(SQL View) |
Index Back |
|---|---|
Absence Self ServiceSearch Record for absence self service |
| SELECT DISTINCT A.EMPLID , A.EMPL_RCD FROM PS_JOB A WHERE A.EFFDT=( SELECT MAX(JOB.EFFDT) FROM PS_JOB JOB WHERE JOB.EMPLID=A.EMPLID AND JOB.EMPL_RCD=A.EMPL_RCD AND JOB.EFFDT<=%CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(JOB2.EFFSEQ) FROM PS_JOB JOB2 WHERE JOB2.EMPLID = A.EMPLID AND JOB2.EMPL_RCD = A.EMPL_RCD AND JOB2.EFFDT = A.EFFDT) |
| # | 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 |