GL_IA_PRCS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	DELETE_LIMIT	Number(12,0)	DECIMAL(12) NOT NULL	Used in GL AE batch processes to perform deletes rather than truncate. Default Value: 3000
3	FIRST_PASS_SW	Character(1)	VARCHAR2(1) NOT NULL	First Pass Switch
4	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes
5	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
6	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	SYSTEM_DATE	Date(10)	DATE	System Date
8	SQLROWS_DETAILS	Number(12,0)	DECIMAL(12) NOT NULL	Used in AE
9	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
10	RECNAME_TMP	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name
11	PROMPT_TBL	Character(15)	VARCHAR2(15) NOT NULL	Prompt Table
12	RECNAME_RSEL	Character(15)	VARCHAR2(15) NOT NULL	Selector range table
13	REC_GROUP_ID	Character(10)	VARCHAR2(10) NOT NULL	Record Group ID
14	NEW_CF_EFFDT	Character(1)	VARCHAR2(1) NOT NULL	New ChartField Effective Date
15	FLT_TREE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Use Flatten Tree Switch
16	EDR_CF_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Maintain Chartfield Effective Dated Range data