GPBR_VAC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
3	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
7	END_DATE	Date(10)	DATE NOT NULL	End Date
8	GPBR_AP_VAC_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Acquisitive Period Status 01=In Progress 02=Open 03=Close per Absence 04=Close Expired 05=Close
9	ABS_BGN_DT	Date(10)	DATE NOT NULL	Absence Begin Date
10	ABS_END_DT	Date(10)	DATE	Absence End Date
11	DAYS	Number(3,0)	SMALLINT NOT NULL	Days
12	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason 10=Vacations
13	GPBR_LEAVE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Leave Status 01=Programmed 03=Calculated 04=Confirmed 05=Cancelled 06=Closed
14	GPBR_13TH_ADVANCE	Number(1,0)	SMALLINT NOT NULL	Advance payment 13th Month 1/0 Table Edit (1=True, 0=False)
15	GPBR_PAY_CREDIT	Number(1,0)	SMALLINT NOT NULL	Y N field Pay Credit for Programed Leaves 1/0 Table Edit (1=True, 0=False)
16	GPBR_CREDIT_DAYS	Number(3,0)	SMALLINT NOT NULL	Credit Days
17	GPBR_CRED_BGN_DT	Date(10)	DATE	Credit Begin Date -- Vacations Brazil
18	GPBR_CRED_END_DT	Date(10)	DATE	Credit End Date Vacations Brazil
19	GPBR_MASS_ABS_ID	Character(10)	VARCHAR2(10) NOT NULL	Mass Vacation ID Brazil
20	ORIG_BEGIN_DT	Date(10)	DATE	original begin date
21	ORIG_END_DT	Date(10)	DATE	Original END_DT before adjust
22	ACTION_FLAG	Character(2)	VARCHAR2(2) NOT NULL	Action Flag
23	GPBR_ORI_CR_BGN_DT	Date(10)	DATE	Original Credit Begin Date
24	GPBR_ORI_CR_END_DT	Date(10)	DATE	Original Credit End Date
25	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
26	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
27	GPBR_DAYS	Number(3,0)	SMALLINT NOT NULL	Days