EMPLIDEMPL_RCDACTION_DT_SSEFFSEQHR_JOB_JOBCD_V(SQL View) |
Index Back |
|---|---|
Job - Jobcode viewThis view selects from JOB and JOBCODE_TBL the current jobcode |
| SELECT A.EMPLID ,A.EMPL_RCD , A.ACTION_DT_SS , A.EFFSEQ ,JOB.SETID_JOBCODE ,JOB.JOBCODE ,JC.DESCR FROM PS_JOB JOB ,PS_JOBCODE_TBL JC , PS_HR_TERM_DAT A WHERE JOB.JOBCODE = JC.JOBCODE AND JOB.SETID_JOBCODE = JC.SETID AND A.EMPLID = JOB.EMPLID AND A.EMPL_RCD = JOB.EMPL_RCD AND JC.EFFDT = ( SELECT MAX(JC1.EFFDT) FROM PS_JOBCODE_TBL JC1 WHERE JC1.JOBCODE = JC.JOBCODE AND JC1.SETID = JC.SETID AND JC1.EFFDT <= 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 | ACTION_DT_SS |
Date(10) | DATE | Termination Date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |