OPRIDEMPLIDPOI_TYPEPOI_SRCH(SQL View) |
Index Back |
|---|---|
POI Search |
| SELECT DISTINCT B.OPRID , SEC.EMPLID ,SEC.POI_TYPE , NM.NAME , NM.LAST_NAME_SRCH , NM.SECOND_LAST_SRCH ,SEC.BUSINESS_UNIT ,SEC.LOCATION ,SEC.INSTITUTION ,SEC.NATIONAL_ID FROM PS_SJT_CLASS OPR , PSOPRCLS B , PS_SJT_PERSON SEC , PS_PERSON_NAME NM WHERE B.OPRCLASS = OPR.CLASSID AND ( OPR.SCRTY_TYPE_CD = SEC.SCRTY_TYPE_CD AND OPR.SCRTY_KEY1 = SEC.SCRTY_KEY1 AND OPR.SCRTY_KEY2 = SEC.SCRTY_KEY2 AND OPR.SCRTY_KEY3 = SEC.SCRTY_KEY3) AND SEC.EMPLID = NM.EMPLID |
| # | 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 | POI_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Defines the Transactional usage of POIs in HRMS. |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 6 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 9 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 10 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |