OPRIDRS_OPR_NAME_VW1(SQL View) |
Index Back |
|---|
| SELECT A.OPRID , A.EMPLID , B.NAME , A.LANGUAGE_CD FROM PSOPRDEFN A , PS_PERSONAL_DATA B , PS_JOB C WHERE A.EMPLID = B.EMPLID AND C.EMPLID = B. EMPLID AND C.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_JOB E WHERE E.EMPLID = C.EMPLID AND E.EMPL_RCD = C.EMPL_RCD AND E.EFFDT <= %CurrentDateIn) AND C.EFFSEQ = ( SELECT MAX(F.EFFSEQ) FROM PS_JOB F WHERE F.EMPLID = C.EMPLID AND F.EMPL_RCD = C.EMPL_RCD AND F.EFFDT = C.EFFDT) AND C.EMPL_STATUS NOT IN ('I', 'T', 'S', 'D', 'U', 'V', 'R', 'Q', 'X') |
| # | 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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |