EMPLIDEMPL_RCDEFFDTDefault Value: %date
EFFSEQCOMP_SS_BASE_VW(SQL View) |
Index Back |
|---|---|
Compensation HistoryUsed in Compensation History Search Query. |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.EFFDT FROM PS_JOB A WHERE A.HR_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_JOB A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.EMPL_RCD = A_ED.EMPL_RCD AND (A_ED.ACTION IN ('ADD','ADL','PAY','HIR', 'REH') OR A_ED.CHANGE_PCT <> 0)) AND A.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_JOB A_ES WHERE A.EMPLID = A_ES.EMPLID AND A.EMPL_RCD = A_ES.EMPL_RCD AND A.EFFDT = A_ES.EFFDT AND (A_ES.ACTION IN ('ADD','ADL','PAY','HIR', 'REH') OR A_ES.CHANGE_PCT <> 0) ) |
| # | 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 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | SS_CHANGE_DATE | Date(10) | DATE |