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 |