GPBR_RC_MASSVAC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	GPBR_MASS_ABS_ID	Character(10)	VARCHAR2(10) NOT NULL	Mass Vacation ID Brazil
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	CANCEL	Character(1)	VARCHAR2(1) NOT NULL	Cancel Y/N Table Edit Default Value: N
6	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GPBR_ABSTK_VW
7	ABS_BGN_DT	Date(10)	DATE NOT NULL	Absence Begin Date
8	GPBR_DAYS	Number(3,0)	SMALLINT NOT NULL	Days
9	ABS_END_DT	Date(10)	DATE NOT NULL	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 Default Value: 01
11	GPBR_13TH_ADVANCE	Number(1,0)	SMALLINT NOT NULL	Advance payment 13th Month 1/0 Table Edit (1=True, 0=False)
12	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)
13	GPBR_CREDIT_DAYS	Number(3,0)	SMALLINT NOT NULL	Credit Days
14	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID. Prompt Table: GB_GROUP_TBL
15	ABSENCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
16	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason 10=Vacations Default Value: Y
17	GPBR_REMAINING_BAL	Character(2)	VARCHAR2(2) NOT NULL	Remaining Balance Used in Mass Vacation 10=Paid 20=Returns 30=Maintain Balance Default Value: 10
18	COMMENTS	Long Character	CLOB	Comment
19	GPBR_PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Proportional Brazil Prompt Table: GP_PIN_AE5_VW