PV_CAT_SEC_H_VW

(SQL View)
 Index Back

Catalog Security Header

Rule Based Catalog - IntersectPolicy implementation

SELECT SETID_SECTYPE , PV_SECURITY_TYPE , PV_VALUE , USE_ASSGN_CAT_ONLY , PV_ENABLED FROM PS_PV_CAT_SEC_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID_SECTYPE Character(5) VARCHAR2(5) NOT NULL Security Type SetID
2 PV_SECURITY_TYPE Character(30) VARCHAR2(30) NOT NULL Security Type
3 PV_VALUE Character(150) VARCHAR2(150) NOT NULL Value
4 USE_ASSGN_CAT_ONLY Character(1) VARCHAR2(1) NOT NULL Use Only Assigned Catalogs

Y/N Table Edit

Default Value: N

5 PV_ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.
N=No
Y=Yes

Y/N Table Edit

Default Value: N