SCRTY_TYPE_SQL (SQL Table)	Index Back
SQL Statements for Sec Types Contains the SQLIDs that can be used to build the insert statements for the Security Join Transaction tables.

SCRTY_TYPE_SQL

(SQL Table)

SQL Statements for Sec Types

Contains the SQLIDs that can be used to build the insert statements for the Security Join Transaction tables.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 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.

4 SEC_SQL_KEYVAL 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.

5 SEC_SQL_FLDVAL 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.

6 SEC_SQL_FROM 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.

7 SEC_SQL_WHERE 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.

8 SEC_SQL_FUT_WHERE 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCRTY_SET_CD	Character(10)	VARCHAR2(10) NOT NULL	Security Set
2	SCRTY_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Security Type for RowLevelSecurty
3	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.
4	SEC_SQL_KEYVAL	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.
5	SEC_SQL_FLDVAL	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.
6	SEC_SQL_FROM	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.
7	SEC_SQL_WHERE	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.
8	SEC_SQL_FUT_WHERE	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.