POI_TYPE_AD2_VW

(SQL View)
Index Back

Poi_types for PERS_POI_ADD CI

The POI_TYPES that can be added via the PERS_POI_ADD component. Any POI that does not require a JOB can be added thru the CI.

SELECT POI_TYPE ,DESCR ,DESCRSHORT ,EFF_STATUS FROM PS_POI_TYPE_TBL WHERE JOB_REQUIRED = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A