SEC_RULEDFN_VW (SQL View)	Index Back
Security Rules Page Security Rules definition page

SEC_RULEDFN_VW

(SQL View)

Security Rules Page

Security Rules definition page

SELECT SEC_RULE , FIELDNAME , DESCR FROM PS_SEC_RULE_DEFN

Related Language Record: SEC_RULEDFN_LV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEC_RULE Character(10) VARCHAR2(10) NOT NULL Security Rule

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: SEC_FIELDS_VW

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEC_RULE	Character(10)	VARCHAR2(10) NOT NULL	Security Rule
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: SEC_FIELDS_VW
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description