| POI_TYPE_ADD_LN(SQL View) | Index Back | 
|---|---|
| Poi_types for PERS_POI_ADDThe POI_TYPES that can be added via the PERS_POI_ADD component. Some POI_TYPEs need to be added from product specific Components. Others can use the generic PERS_POI_ADD component. | 
| SELECT POI_TYPE , LANGUAGE_CD ,DESCR ,DESCRSHORT FROM PS_POI_TYPE_LNG | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | Defines the Transactional usage of POIs in HRMS. | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description | 
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |