GPBR_TR_LE_P_WA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	BEGIN_DT	Date(10)	DATE	Begin Date
9	END_DATE	Date(10)	DATE	End Date
10	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
11	ABS_BGN_DT	Date(10)	DATE NOT NULL	Absence Begin Date
12	ABS_END_DT	Date(10)	DATE NOT NULL	Absence End Date
13	DAYS	Number(3,0)	SMALLINT NOT NULL	Days
14	GPBR_13TH_ADVANCE	Number(1,0)	SMALLINT NOT NULL	Advance payment 13th Month 1/0 Table Edit (1=True, 0=False)
15	GPBR_LEAVE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Leave Status 01=Programmed 03=Calculated 04=Confirmed 05=Cancelled 06=Closed Default Value: 01
16	GPBR_PROG_LEAVE_ID	Character(2)	VARCHAR2(2) NOT NULL	Program Identifier 01=Manual 02=Collective Default Value: 01
17	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)
18	GPBR_CREDIT_DAYS	Number(3,0)	SMALLINT NOT NULL	Credit Days
19	GPBR_CRED_BGN_DT	Date(10)	DATE	Credit Begin Date -- Vacations Brazil
20	GPBR_CRED_END_DT	Date(10)	DATE	Credit End Date Vacations Brazil
21	GPBR_MASS_ABS_ID	Character(10)	VARCHAR2(10) NOT NULL	Mass Vacation ID Brazil
22	ORIG_BEGIN_DT	Date(10)	DATE	original begin date