GPBR_NRP_VAP_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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	EFFDT	Date(10)	DATE	Effective Date
4	GPBR_VACN_DAYS_AP	Number(3,0)	SMALLINT NOT NULL	Vacation Days Per Acquisitive Period
5	GPBR_NEG_BALANCE	Number(1,0)	SMALLINT NOT NULL	Allow Negative Balance Vacation Parameters Brazil
6	GPBR_NEG_BAL_LIMIT	Number(2,0)	SMALLINT NOT NULL	Negative Balance Limit
7	GPBR_LEAVES_PER_AP	Number(2,0)	SMALLINT NOT NULL	Vacation Days per Acquisitive Period
8	GPBR_MIN_AGE_PART	Number(2,0)	SMALLINT NOT NULL	Minimum Age for Partiality
9	GPBR_MAX_AGE_PART	Number(2,0)	SMALLINT NOT NULL	Maximum Age for Partiality
10	GPBR_MIN_DAY_ALLOW	Number(2,0)	SMALLINT NOT NULL	Minimum Days Allowed by Leave
11	GPBR_MAX_VAC_PER	Number(2,0)	SMALLINT NOT NULL	Maximum Vacation Days per Period
12	GPBR_MAX_PCT_LEAVE	Number(6,2)	DECIMAL(5,2) NOT NULL	Maximum Percent per Leave
13	GPBR_CRE_TREATMENT	Character(2)	VARCHAR2(2) NOT NULL	Credit Treatment 01=Starting Month 02=End of Vacations 03=Proportional Vacation Days
14	GPBR_13TH_CALC_SEP	Number(1,0)	SMALLINT NOT NULL	13th Calculate Separately
15	GPBR_NEED_CONFIRM	Number(1,0)	SMALLINT NOT NULL	Needs Confirmation for Program
16	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
17	GPBR_PIN_TAKEC_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Credit Brazil
18	PIN_ENT_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
19	GPBR_CALID_VAC_ABS	Character(14)	VARCHAR2(14) NOT NULL	calendar id
20	GPBR_CALID_VAC_PAY	Character(14)	VARCHAR2(14) NOT NULL	calendar id
21	GPBR_PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Proportional Brazil
22	GPBR_VAC_CRED_PER	Character(1)	VARCHAR2(1) NOT NULL	Union Parameter to indicate if always allow vacation credit.
23	GP_TX_REASON	Character(18)	VARCHAR2(18) NOT NULL	Off Cycle (Transaction) Reason Identifies a particular configuration to be applied to the presentation of off cycle request information