OI_GEN_DATE_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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
5	DETAIL_CALENDAR	Character(2)	VARCHAR2(2) NOT NULL	Detail Calendar
6	FISCAL_YEAR_FROM	Number(4,0)	SMALLINT NOT NULL	Fiscal Year Prompt Table: %EDITTABLE
7	FISCAL_YEAR_TO	Number(4,0)	SMALLINT NOT NULL	Range To Fiscal Year Prompt Table: %EDITTABLE
8	BALANCE_FWD_SW	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year. N=Not Carry Forward O=Other Y=Carry Forward
9	ADJUSTMENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Type D=Discount S=Surcharge
10	LEVEL1	Number(5,0)	INTEGER NOT NULL	Level 1
11	SUMM_CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	SUMM_CALENDAR_ID
12	HIERARCHY_LABEL	Character(4)	VARCHAR2(4) NOT NULL	HIERARCHY_LABEL MNTH=Month QUTR=Quarter SANN=Semi-Annual WEEK=Week YEAR=Year
13	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
14	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).