GPGB_FPSXCR_TBL

(SQL Table)
Index Back

FPS XML Car Table

FPS XML Car Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 HIRE_DT Date(10) DATE First Start Date
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 CAR_ID Character(7) VARCHAR2(7) NOT NULL Car Identification Number used in Administer Company Cars module.
6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
7 GPGB_C02_EMISSIONS Character(3) VARCHAR2(3) NOT NULL To capture CO2 emissions of car in RTI
8 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
9 GPGB_RTI_REG_NUM Character(10) VARCHAR2(10) NOT NULL Registration Number for Car Identifier
10 GPGB_AMENDMENT_IND Character(1) VARCHAR2(1) NOT NULL Amendment Indicator
11 START_DT Date(10) DATE Start Date
12 END_DT Date(10) DATE end date
13 DATE_FREE_FUEL Date(10) DATE Date Free Fuel Provided
14 DATE_FREE_FUEL_W Date(10) DATE Date Free Fuel Withdrawn
15 GPGB_CALC_PRICE Signed Number(11,2) DECIMAL(9,2) NOT NULL Calculated price of Car
16 GPGB_CEQ_CAR Signed Number(13,2) DECIMAL(11,2) NOT NULL GPGB Cash Equivalent of Car
17 GPGB_CEQ_FUEL Signed Number(13,2) DECIMAL(11,2) NOT NULL GPGB Cash Equivalent of Fuel PTD
18 GPGB_CAR_DATE Date(10) DATE Date First Registered
19 GPGB_ZERO_EMI Number(4,0) SMALLINT NOT NULL Zero Emission Mileage