EMPLIDEMPL_RCDLANGUAGE_CDEFFDTDefault Value: %date
EFFSEQHR_EC_JOBS_LV(SQL View) |
Index Back |
|---|---|
Compensation HistoryFluid Compensation History uses this view to load multiple jobs titles in job selectory field. |
| SELECT DISTINCT JOB.EMPLID , JOB.EMPL_RCD , JCL.LANGUAGE_CD , JOB.EFFDT , JOB.EFFSEQ , JCL.DESCR FROM PS_JOB JOB , PS_JOBCODE_LANG JCL WHERE JOB.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_JOB ED WHERE ED.EMPLID = JOB.EMPLID AND ED.EMPL_RCD = JOB.EMPL_RCD AND ED.EFFDT <= %CurrentDateIn) AND JOB.EFFSEQ = ( SELECT MAX(ES.EFFSEQ) FROM PS_JOB ES WHERE ES.EMPLID = JOB.EMPLID AND ES.EMPL_RCD = JOB.EMPL_RCD AND ES.EFFDT = JOB.EFFDT) AND JOB.SETID_JOBCODE = JCL.SETID AND JOB.JOBCODE = JCL.JOBCODE AND %EffdtCheck(JOBCODE_LANG, JCL, JOB.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 |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |