SEC_VIEWS_LOG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	PTPG_PGRIDNAME	Character(30)	VARCHAR2(30) NOT NULL	Pivot Grid Name (see PSPGCORE).
3	FILTER_ID	Character(10)	VARCHAR2(10) NOT NULL	Filter criteria identification
4	QRYNAME	Character(30)	VARCHAR2(30) NOT NULL	Query Name
5	QRYSECRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Query Security Record Name
6	PS_OWNER	Character(2)	VARCHAR2(2) NOT NULL	PeopleSoft Owner AM=Asset Management AP=Accounts Payable AR=Accounts Receivable BD=Budgets BI=Billing CA=Contracts CM=Cost Management CS=Customer Service EN=Engineering EX=Expenses GL=General Ledger HR=Human Resources IN=Inventory MG=Manufacturing OM=Order Management PC=Project Costing PL=Planning PO=Purchasing PR=Production Control PT=PeopleTools TL=Time and Labor TR=Treasury
7	PSDMUNIT_ID	Character(30)	VARCHAR2(30) NOT NULL	Transaction
8	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
9	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
10	EDITTABLE	Character(15)	VARCHAR2(15) NOT NULL	Edit Table
11	FIELD_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Secured Field Type B=Business Unit Security C=Pay Cycle Security I=Planning Instance Security K=Book Security L=Ledger Security P=Project Security S=SetID Security
12	SECURITY_SW	Character(1)	VARCHAR2(1) NOT NULL	Secured Row Y/N Table Edit
13	OBJECT_TYPE_SEC	Character(2)	VARCHAR2(2) NOT NULL	Object Type 1=Record Definitions 2=Record Field Prompts 3=Queries 4=Pivot Grids 5=Work Center Prompts 8=Mass Transaction Configuration 9=Mass Transaction User Values
14	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp