HR_GRPANNIV_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	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
5	BUDGET_START_DT	Date(10)	DATE	Budget Period Start Date
6	VERSIONGBQDM	Number(10,0)	DECIMAL(10) NOT NULL	Version Number
7	BUDGET_END_DT	Date(10)	DATE	Budget End Date
8	BUDGET_ID	Character(10)	VARCHAR2(10) NOT NULL	Budget ID
9	END_DT_DAY	Number(2,0)	SMALLINT NOT NULL	Day
10	END_DT_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
11	END_DT_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
12	HIRE_DT_DAY	Number(2,0)	SMALLINT NOT NULL	Day
13	HIRE_DT_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
14	HIRE_DT_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
15	START_DT_DAY	Number(2,0)	SMALLINT NOT NULL	Day
16	START_DT_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
17	START_DT_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
18	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
19	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
20	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
21	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
22	HIRE_DT	Date(10)	DATE	First Start Date
23	FROMDATE	Date(10)	DATE	From Date