GPBR_VACNWA_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
11	END_DATE	Date(10)	DATE NOT NULL	End Date
12	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
13	GPBR_PER_END_DT	Date(10)	DATE	Period End Date -- Vacations Brazil
14	GPBR_AP_VAC_STATUS	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
15	SERVICE_YEARS	Number(2,0)	SMALLINT NOT NULL	Years of Service
16	GPBR_CALC_DAYS	Number(3,0)	SMALLINT NOT NULL	Calculated Vacation Days GP Brazil
17	GPBR_MAX_VAC_PER	Number(2,0)	SMALLINT NOT NULL	Maximum Vacation Days per Period
18	GPBR_ADJ_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Leave Days Brazil
19	GPBR_UPD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Updater Type Online or Batch 10=On Line 20=Batch Default Value: 10
20	ORIG_BEGIN_DT	Date(10)	DATE	original begin date