GP_GL_PREP_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	PRD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Period Type C=Current R=Retro
10	FORWARD_IND	Character(1)	VARCHAR2(1) NOT NULL	Y/N indicates whether the delta from a retroactive recalc should be forwarded into the current calculation or not
11	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
12	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
15	RUN_CALC_IND	Character(1)	VARCHAR2(1) NOT NULL	Calculate Payees Y/N Table Edit Default Value: N
16	RUN_FINAL_IND	Character(1)	VARCHAR2(1) NOT NULL	Finalize Entire Run Y/N Table Edit Default Value: N
17	UPDATE_STATS_IND	Character(1)	VARCHAR2(1) NOT NULL	Update Statistics
18	RUN_OPEN_IND	Character(1)	VARCHAR2(1) NOT NULL	Y/N Indicates that processing has been initiated for given run (calendar group).