GPGB_RTI_CAR

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