POI_SCRTY_VW (SQL View)	Index Back
View of POI Types

POI_SCRTY_VW

(SQL View)

View of POI Types

SELECT SCRTY_TYPE_CD , DESCR , DESCR_LABEL FROM PS_SCRTY_TYPE_TBL WHERE SCRTY_SET_CD = 'PPLPOI' AND SCRTY_TYPE_CD <> '009'

Related Language Record: POI_SCRTY_VW_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCRTY_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Security Type for RowLevelSecurty

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DESCR_LABEL Character(30) VARCHAR2(30) NOT NULL User friendly label to be used in the transaction page when the User is selecting a security type and its values.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCRTY_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Security Type for RowLevelSecurty
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCR_LABEL	Character(30)	VARCHAR2(30) NOT NULL	User friendly label to be used in the transaction page when the User is selecting a security type and its values.