GPBR_MASVAC_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	GPBR_MASS_ABS_ID	Character(10)	VARCHAR2(10) NOT NULL	Mass Vacation ID Brazil
5	CANCEL	Character(1)	VARCHAR2(1) NOT NULL	Cancel
6	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
7	ABS_BGN_DT	Date(10)	DATE	Absence Begin Date
8	GPBR_DAYS	Number(3,0)	SMALLINT NOT NULL	Days
9	ABS_END_DT	Date(10)	DATE	Absence End Date
10	GPBR_LEAVE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Leave Status 01=Programmed 03=Calculated 04=Confirmed 05=Cancelled 06=Closed
11	GPBR_13TH_ADVANCE	Number(1,0)	SMALLINT NOT NULL	Advance payment 13th Month
12	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
13	ABSENCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
14	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason 10=Vacations
15	COMMENTS	Long Character	CLOB	Comment
16	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
17	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
18	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
19	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
20	BEGIN_DT	Date(10)	DATE	Begin Date
21	BGN_DT	Date(10)	DATE	Begin Date
22	END_DATE	Date(10)	DATE	End Date
23	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
24	SERVICE_YEARS	Number(2,0)	SMALLINT NOT NULL	Years of Service
25	GPBR_CALC_DAYS	Number(3,0)	SMALLINT NOT NULL	Calculated Vacation Days GP Brazil
26	GPBR_BAL_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Balance Vacation Days Brazil
27	GPBR_MAX_VAC_PER	Number(2,0)	SMALLINT NOT NULL	Maximum Vacation Days per Period
28	EVT_CONFIG1	Character(10)	VARCHAR2(10) NOT NULL	config char
29	GPBR_ADJ_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Leave Days Brazil
30	DATE1	Date(10)	DATE	Date 1
31	GPBR_DAYS_TAKE	Number(3,0)	SMALLINT NOT NULL	Days
32	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
33	GPBR_REMAINING_BAL	Character(2)	VARCHAR2(2) NOT NULL	Remaining Balance Used in Mass Vacation 10=Paid 20=Returns 30=Maintain Balance
34	DAYS_CURRENT	Number(3,0)	SMALLINT NOT NULL	Days Current
35	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
36	CHAR_START_DT	Character(10)	VARCHAR2(10) NOT NULL	Session Start Date
37	SERVICE_DT	Date(10)	DATE	Service Date
38	DAYS	Number(3,0)	SMALLINT NOT NULL	Days
39	DURATION_DAYS	Number(7,3)	DECIMAL(6,3) NOT NULL	Duration (Days)
40	GPBR_PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Proportional Brazil
41	ABS_BEGIN_DT	Date(10)	DATE	Absence Begin Date
42	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
43	SUFFIX_SEPARATOR	Character(1)	VARCHAR2(1) NOT NULL	Element Suffix Separator
44	BAL_ACM_SFX	Character(5)	VARCHAR2(5) NOT NULL	Element Accum Suffix
45	ABS_PRD_END_DT	Date(10)	DATE	Absence Period End Date
46	GPBR_DAYS_BEFORE	Number(3,0)	SMALLINT NOT NULL	This field is used to indicate how many days before the current date to show the history date range.
47	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)
48	GPBR_CREDIT_DAYS	Number(3,0)	SMALLINT NOT NULL	Credit Days