SEC_VIEWS_AET

#	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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	SECURITY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Security C=Permission List Level Security N=No Security O=User ID Level Security
5	BU_SECURITY	Character(1)	VARCHAR2(1) NOT NULL	Business Unit Security
6	SETID_SECURITY	Character(1)	VARCHAR2(1) NOT NULL	TableSet ID Security
7	LEDGER_SECURITY	Character(1)	VARCHAR2(1) NOT NULL	Ledger Security
8	BOOK_SECURITY	Character(1)	VARCHAR2(1) NOT NULL	Book Security
9	PROJECT_SECURITY	Character(1)	VARCHAR2(1) NOT NULL	Project Security N=Do not allow project security Y=Allow project security
10	PYCYCL_SECURITY	Character(1)	VARCHAR2(1) NOT NULL	Pay Cycle Security
11	PL_PRBINS_SECURITY	Character(1)	VARCHAR2(1) NOT NULL	Planning Instance
12	SEARCH_TEXT	Character(15)	VARCHAR2(15) NOT NULL	Search Text for Security Views
13	VIEW_NO_SECURITY	Character(15)	VARCHAR2(15) NOT NULL	No Security View
14	VIEW_OPR_SECURITY	Character(15)	VARCHAR2(15) NOT NULL	User ID Security View
15	VIEW_CLS_SECURITY	Character(15)	VARCHAR2(15) NOT NULL	Permission List Security View
16	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
17	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
18	RECNAME_2	Character(15)	VARCHAR2(15) NOT NULL	Record 2 Name
19	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status
20	RECNAME_3	Character(15)	VARCHAR2(15) NOT NULL	Rename