POI_TYPE_AD3_VW (SQL View)	Index Back
POI Types for online Add The 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.

POI_TYPE_AD3_VW

(SQL View)

POI Types for online Add

The 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 ,DESCR ,DESCRSHORT ,EFF_STATUS FROM PS_POI_TYPE_TBL WHERE JOB_REQUIRED = 'N' AND USE_IN_POI_ADD = 'Y'

Related Language Record: POI_TYPE_ADD_LN

# 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

#	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