GPBR_NRP_MAV_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
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	EFFDT	Date(10)	DATE	Effective Date
6	CANCEL	Character(1)	VARCHAR2(1) NOT NULL	Cancel
7	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
8	ABS_BGN_DT	Date(10)	DATE	Absence Begin Date
9	GPBR_DAYS	Number(3,0)	SMALLINT NOT NULL	Days
10	ABS_END_DT	Date(10)	DATE	Absence End Date
11	GPBR_LEAVE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Leave Status 01=Programmed 03=Calculated 04=Confirmed 05=Cancelled 06=Closed
12	GPBR_13TH_ADVANCE	Number(1,0)	SMALLINT NOT NULL	Advance payment 13th Month
13	GPBR_PAY_CREDIT	Number(1,0)	SMALLINT NOT NULL	Y N field Pay Credit for Programed Leaves
14	GPBR_CREDIT_DAYS	Number(3,0)	SMALLINT NOT NULL	Credit Days
15	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
16	ABSENCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
17	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason
18	GPBR_REMAINING_BAL	Character(2)	VARCHAR2(2) NOT NULL	Remaining Balance Used in Mass Vacation 10=Paid 20=Returns 30=Maintain Balance
19	COMMENTS	Long Character	CLOB	Comment
20	GPBR_PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Proportional Brazil