GPGB_CAR_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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GPGB_CALRUN_VW
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GPGB_PYGRP11_VW
7	CAR_ID	Character(7)	VARCHAR2(7) NOT NULL	Car Identification Number used in Administer Company Cars module.
8	GPGB_RTI_REG_NUM	Character(10)	VARCHAR2(10) NOT NULL	Registration Number for Car Identifier
9	GPGB_TAX_BGN_YR	Number(4,0)	SMALLINT NOT NULL	Tax Year Begins In This Calendar Year
10	START_DT	Date(10)	DATE NOT NULL	Start Date
11	END_DT	Date(10)	DATE	end date
12	GPGB_CAR_MAKE	Character(15)	VARCHAR2(15) NOT NULL	Make of the Car
13	MODEL_DESCR	Character(40)	VARCHAR2(40) NOT NULL	Model Description
14	GPGB_C02_EMISSIONS	Character(3)	VARCHAR2(3) NOT NULL	To capture CO2 emissions of car in RTI
15	GPGB_FUEL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Fuel Type of Car for FPS Car Information A=All Other D=Diesel E=Electric F=Euro standard diesel cars H=Hybrid
16	GPGB_AMENDMENT_IND	Character(1)	VARCHAR2(1) NOT NULL	Amendment Indicator Y/N Table Edit Default Value: N
17	GPGB_CALC_PRICE	Signed Number(11,2)	DECIMAL(9,2) NOT NULL	Calculated price of Car
18	DATE_FREE_FUEL	Date(10)	DATE	Date Free Fuel Provided
19	DATE_FREE_FUEL_W	Date(10)	DATE	Date Free Fuel Withdrawn
20	GPGB_CEQ_FUEL	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	GPGB Cash Equivalent of Fuel PTD
21	GPGB_CEQ_CAR	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	GPGB Cash Equivalent of Car
22	GPGB_RTI_CAR_REP	Character(1)	VARCHAR2(1) NOT NULL	GPGB Car Reported Flag Y/N Table Edit Default Value: N
23	GPGB_CAR_DATE	Date(10)	DATE	Date First Registered
24	GPGB_ZERO_EMI	Number(4,0)	SMALLINT NOT NULL	Zero Emission Mileage