TV_EE_JOB_DT_VW(SQL View) |
Index Back |
|---|---|
Job Data ViewView of data from Job table. |
| SELECT A.EMPLID , A.EMPL_RCD , A.EMPL_STATUS , A.EFFDT , A.EFFSEQ , B.BUSINESS_UNIT_GL , A.DEPTID , A.SETID_DEPT , A.JOBCODE , A.SETID_JOBCODE , A.CURRENCY_CD , A.SUPERVISOR_ID , A.REPORTS_TO FROM PS_JOB A , PS_EX_EE_ORG_DTL B WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_JOB A1 WHERE A1.EMPLID = A.EMPLID AND A1.EMPL_RCD = A.EMPL_RCD AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A2.EMPLID = A.EMPLID AND A2.EMPL_RCD = A.EMPL_RCD AND A2.EFFDT = A.EFFDT) AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.DFLT_EE_PROF_FLG = 'Y' |
| # | 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 Rcd Nbr |
| 3 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Employee Status
A=Active D=Deceased I=Inactive L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 8 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department SetID
Prompt Table: SETID_TBL |
| 9 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 10 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL |
Job Code SetID
Prompt Table: SETID_TBL |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 13 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |