EX_EE_DATA_VW(SQL View) |
Index Back |
|---|---|
Personnel Data ViewView of data from various personnel tables. |
| SELECT A.EMPLID , A.PER_STATUS , D.EMPL_STATUS , D.SUPERVISOR_ID , A.PHONE , D.REPORTS_TO , B.HOME_BASED FROM PS_PERSONAL_DATA A , PS_EX_EE_ORG_DTA B , PS_JOB D WHERE B.EMPLID = A.EMPLID AND D.EMPLID = B.EMPLID 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 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 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 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 5 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 6 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |
| 7 | HOME_BASED | Character(1) | VARCHAR2(1) NOT NULL |
Home Based employee Flag: Y - Home Based, N - Office Based
N=Office Based Y=Home Based |