EMPLIDPOI_TYPEPrompt Table: POI_TYPE_ADD_VW
PER_POI_SRCH3(SQL View) |
Index Back |
|---|---|
Search view for only POIsSearch view to return only POIs without Jobs . |
| SELECT A.EMPLID ,A.POI_TYPE , NM.NAME FROM PS_PER_POI_TYPE A , PS_PERSON_NAME NM WHERE A.EMPLID = NM.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | POI_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Defines the Transactional usage of POIs in HRMS.
Prompt Table: POI_TYPE_ADD_VW |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |