PROCESS_INSTANCEEMPLIDHIRE_DTEMPL_RCDCAR_IDA=All Other
D=Diesel
E=Electric
F=Euro standard diesel cars
H=Hybrid
GPGB_FPSXCR_TBL(SQL Table) |
Index Back |
|---|---|
FPS XML Car TableFPS 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 |