EMPLIDEMPL_RCDEFFDTDefault Value: %date
GPIN_FT_TERM_DT(SQL View) |
Index Back |
|---|---|
Future termination dateFuture Termination Dated Employees |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.TERMINATION_DT FROM PS_JOB A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_JOB A_ED WHERE A_ED.EMPLID = A.EMPLID AND A_ED.EMPL_RCD = A.EMPL_RCD) AND A.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_JOB A_ES WHERE A_ES.EMPLID = A.EMPLID AND A_ES.EMPL_RCD = A_ES.EMPL_RCD AND A_ES.EFFDT = A.EFFDT) AND A.HR_STATUS = 'I' |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | TERMINATION_DT | Date(10) | DATE | Termination Date |