TR_CONTRAC_BRA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
4	END_DT	Date(10)	DATE NOT NULL	end date
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	PER_END_DT_BRA	Date(10)	DATE	Period End Date -- Vacations Brazil
7	AP_VAC_STATUS_BRA	Character(2)	VARCHAR2(2) NOT NULL	Acquisitive Period Status 01=In Progress 02=Open 03=Close per Absence 04=Close Expired 05=Close Default Value: 02
8	SERVICE_MONTHS	Number(4,1)	DECIMAL(3,1) NOT NULL	Months of Service
9	CALC_DAYS_BRA	Number(3,0)	SMALLINT NOT NULL	Calculated Vacation Days GP Brazil
10	MAX_VAC_PER_BRA	Number(2,0)	SMALLINT NOT NULL	Maximum Vacation Days per Period
11	ADJ_DAYS_BRA	Signed Number(4,0)	DECIMAL(3) NOT NULL	Leave Days Brazil
12	UPD_TYPE_BRA	Character(2)	VARCHAR2(2) NOT NULL	Updater Type Online or Batch 10=On Line 20=Batch
13	ORIG_BEGIN_DT	Date(10)	DATE	original begin date