SCRTY_ROWSEC_VW (SQL View)	Index Back
Search Rec for Sec by Dept Tbl

SCRTY_ROWSEC_VW

(SQL View)

Search Rec for Sec by Dept Tbl

SELECT DISTINCT A.ROWSECCLASS ,B.CLASSDEFNDESC FROM PS_SCRTY_TBL_DEPT A , PSCLASSDEFN B WHERE A.ROWSECCLASS = B.CLASSID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
Prompt Table: PSCLASSDEFN_SRC

2 CLASSDEFNDESC Character(30) VARCHAR2(30) NOT NULL Permission List Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security Prompt Table: PSCLASSDEFN_SRC
2	CLASSDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Permission List Description