PV_EMP_INFO_VW(SQL View) |
Index Back |
|---|---|
Personnel Data ViewView of data from various personnel tables. |
| SELECT A.EMPLID , C.EMPL_RCD , A.PER_STATUS , D.EMPL_STATUS , D.DEPTID , C.SUPERVISOR_ID , C.PHONE , C.REPORTS_TO FROM PS_PERSONAL_DATA A , PS_EMPLOYMENT C , PS_JOB D WHERE D.EMPLID = C.EMPLID AND A.EMPLID = C.EMPLID AND D.EMPL_RCD = C.EMPL_RCD AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_JOB D1 WHERE D1.EMPLID = D.EMPLID AND D1.EMPL_RCD = D.EMPL_RCD AND D1.EFFDT <= %CurrentDateIn) AND D.EFFSEQ = ( SELECT MAX(D2.EFFSEQ) FROM PS_JOB D2 WHERE D2.EMPLID = D.EMPLID AND D2.EMPL_RCD = D.EMPL_RCD AND D2.EFFDT = D.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 Rcd Nbr |
| 3 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 4 | 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 |
| 5 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 6 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 7 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 8 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |