SCRTY_SET_TBL (SQL Table)	Index Back
Security Set Defines a Set of Security Access Types. This allows the security views to select just a SCRTY_SET_CD instead of knowing which SCRTY_TYPE_CDs they need. The SCRTY_TYPE_CD is something that users can add or make inactive so it needs to be dynamic.

SCRTY_SET_TBL

(SQL Table)

Security Set

Defines a Set of Security Access Types. This allows the security views to select just a SCRTY_SET_CD instead of knowing which SCRTY_TYPE_CDs they need. The SCRTY_TYPE_CD is something that users can add or make inactive so it needs to be dynamic.

Related Language Record: SCRTY_SET_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCRTY_SET_CD Character(10) VARCHAR2(10) NOT NULL Security Set

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

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

4 RECNAME_SJT Character(15) VARCHAR2(15) NOT NULL Name of the Security Join Table for the Transaction side of this Security Access Type. "What is being secured". This is not a required field as not all "whats" will need a SJT table.
Prompt Table: PSRECDEFN_VW

5 RECNAME_SJT_TMP Character(15) VARCHAR2(15) NOT NULL Name of the Security Join Table for the Transaction side of this Security Access Type. "What is being secured". This is not a required field as not all "whats" will need a SJT table.
Prompt Table: PSRECDEFN_VW

6 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

7 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit
Default Value: N

8 SEC_SQL_FLDNM Character(30) VARCHAR2(30) NOT NULL Contains the SQLID that is used to load the SJT_RECNAME data for the security Join tables on the transaction side.

9 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCRTY_SET_CD	Character(10)	VARCHAR2(10) NOT NULL	Security Set
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	RECNAME_SJT	Character(15)	VARCHAR2(15) NOT NULL	Name of the Security Join Table for the Transaction side of this Security Access Type. "What is being secured". This is not a required field as not all "whats" will need a SJT table. Prompt Table: PSRECDEFN_VW
5	RECNAME_SJT_TMP	Character(15)	VARCHAR2(15) NOT NULL	Name of the Security Join Table for the Transaction side of this Security Access Type. "What is being secured". This is not a required field as not all "whats" will need a SJT table. Prompt Table: PSRECDEFN_VW
6	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
7	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N
8	SEC_SQL_FLDNM	Character(30)	VARCHAR2(30) NOT NULL	Contains the SQLID that is used to load the SJT_RECNAME data for the security Join tables on the transaction side.
9	COMMENTS	Long Character	CLOB	Comment