SETIDEMPLIDEMPL_RCDEFFDTEFFSEQJOB_JOBCODE_VW(SQL View) |
Index Back |
|---|---|
Job - Jobcode viewThis view selects from JOB and JOBCODE_TBL the current jobcode and the indicator as to whether the jobcode is or is not used by Position Management. |
| SELECT JOB.SETID_DEPT ,JOB.EMPLID ,JOB.EMPL_RCD ,JOB.EFFDT ,JOB.EFFSEQ ,JOB.SETID_JOBCODE ,JOB.JOBCODE ,JC.POSN_MGMT_INDC FROM PS_JOB JOB ,PS_JOBCODE_TBL JC WHERE JOB.JOBCODE = JC.JOBCODE AND JOB.SETID_JOBCODE = JC.SETID 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 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 7 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 8 | POSN_MGMT_INDC | Character(1) | VARCHAR2(1) NOT NULL | Used by Position Management |