FS_AUDIT_SEARCH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FS_APPLICATION_CD	Character(4)	VARCHAR2(4) NOT NULL	Translate field that has application/product codes. DBI=Billing DEB=eBill Payment FAM=Asset Management FAP=Accounts Payable FAR=Accounts Receivable FGL=General Ledger FRE=Real Estate Management
2	FS_DOCUMENT_CD	Character(8)	VARCHAR2(8) NOT NULL	Document Code Prompt Table: FS_AUDIT_DOCS
3	SEQ_NBR_3	Number(3,0)	SMALLINT NOT NULL	Sequence
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	VAT_PAGEFIELD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Page Field Type 4=Edit Box 5=Drop Down List Box 7=Check Box
6	PROMPTFIELD	Character(18)	VARCHAR2(18) NOT NULL	Dropdown Prompt Field
7	BEGIN_WITH_IND	Character(1)	VARCHAR2(1) NOT NULL	A yes/no flag that determines if search key qualifiers are to be used. Examples of Search key qualifiers are... Begins with, contains, ends with etc. Y/N Table Edit Default Value: N
8	SETID_BASED	Character(1)	VARCHAR2(1) NOT NULL	Setid Based Y/N Table Edit Default Value: N
9	FS_SET_CNTRL_VALUE	Character(1)	VARCHAR2(1) NOT NULL	Yes/No field to identify if a column is a Set Control Value Y/N Table Edit Default Value: N
10	SEARCH_CRITERIA	Character(1)	VARCHAR2(1) NOT NULL	Search Criteria Y/N Table Edit Default Value: Y
11	PURGE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Purge History without Archive Y/N Table Edit Default Value: Y
12	REQUIRED_FIELD	Character(1)	VARCHAR2(1) NOT NULL	* Required Field Y/N Table Edit Default Value: Y