GPAU_GLPREP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GP_CAL_RUN1_VW
5	POSTING_DATE	Date(10)	DATE	Posting Date
6	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
7	EMPLID_FROM	Character(11)	VARCHAR2(11) NOT NULL	EMPLID (first for a range)
8	EMPLID_TO	Character(11)	VARCHAR2(11) NOT NULL	EmplID To
9	GPAU_JOURNAL_NAME	Character(10)	VARCHAR2(10) NOT NULL	Journal Name
10	GPAU_JOURNAL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field is used to identify the transactions for the different journal types. The QSP file is reported by journal types. 10=Salary 20=Accrual 30=Employee Entitlement 40=Terminated EE's Entitlement 50=Statistical
11	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
12	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
13	GPAU_BATCH_PERIOD	Character(2)	VARCHAR2(2) NOT NULL	This contains GL Financial Month
14	GPAU_REVERSE_MTH	Number(2,0)	SMALLINT NOT NULL	Reverse Period
15	GPAU_REVERSE_YEAR	Number(1,0)	SMALLINT NOT NULL	Reverse Year
16	GPAU_BATCH_REF	Character(10)	VARCHAR2(10) NOT NULL	Batch Reference
17	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
18	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
19	RUN_CALC_IND	Character(1)	VARCHAR2(1) NOT NULL	Calculate Payees Y/N Table Edit Default Value: N
20	RUN_FINAL_IND	Character(1)	VARCHAR2(1) NOT NULL	Finalize Entire Run Y/N Table Edit Default Value: N
21	UPDATE_STATS_IND	Character(1)	VARCHAR2(1) NOT NULL	Update Statistics
22	RUN_OPEN_IND	Character(1)	VARCHAR2(1) NOT NULL	Y/N Indicates that processing has been initiated for given run (calendar group).