OPRIDEMPLIDTD_APPR_INFO_VW(SQL View) |
Index Back |
|---|---|
Personnel Data ViewView of data from various personnel tables. |
| SELECT B.OPRID , A.EMPLID , D.DEPTID , C.SUPERVISOR_ID , C.PHONE , C.REPORTS_TO , B.EMAILID FROM PS_PERSONAL_DATA A , PSOPRDEFN B , PS_EMPLOYMENT C , PS_JOB D WHERE D.EMPLID = C.EMPLID AND A.EMPLID = C.EMPLID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_JOB D1 WHERE D1.EMPLID = D.EMPLID AND D1.EFFDT <= %CurrentDateIn) AND D.EFFSEQ = ( SELECT MAX(D2.EFFSEQ) FROM PS_JOB D2 WHERE D2.EMPLID = D.EMPLID AND D2.EFFDT = D.EFFDT) AND A.EMPLID = B.EMPLID AND D.EMPL_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 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 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |