RUN_CNTL_SCRTY3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	ASOFDATE	Date(10)	DATE	As of Date
4	SCRTY_UPDATE_ALL	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicated if all of the transactions that were done the day before should be updated in addition to the things that become effective today. Y/N Table Edit Default Value: Y
5	FROMDATE	Date(10)	DATE	From Date
6	THRUDATE	Date(10)	DATE	End Date
7	UPDATE_SEC_ALL	Character(1)	VARCHAR2(1) NOT NULL	Refresh All Sets? 1=All Security Sets 2=One Security Set Default Value: 1
8	SCRTY_SET_CD	Character(10)	VARCHAR2(10) NOT NULL	Security Set Prompt Table: SCRTY_SET_TBL
9	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: RECNAME_SJT_VW
10	UPDATE_ROW_LVL_SEC	Character(1)	VARCHAR2(1) NOT NULL	Refresh All Rows? Y/N Table Edit Default Value: Y
11	UPDATE_SJT_SET	Character(3)	VARCHAR2(3) NOT NULL	Rows to Update 1=Person Organization 10=Matrix ID 2=Person of Interest Type 3=Security Type 4=Group 5=Business Unit 6=Department ID 7=Company 8=List of EMPLID, EMPL_RCD 9=List of EMPLID, Person Type Prompt Table: SCRTY_SJT_UPVW