EMPLIDREGISTRATION_NUMSTART_DTC=Cubic Centimeters
I=Cubic Inches
DIE=Diesel with cylinder capacity
OTH=Car without cylinder capacity
PET=Petrol with cylinder capacity
GPGB_CAR_VW(SQL View) |
Index Back |
|---|---|
Car Details ViewConsolidated view of car details, used by P11D Extractor |
| SELECT A.EMPLID ,B.REGISTRATION_NUM ,A.START_DT ,A.END_DT ,B.REGISTRATION_DT ,B.MANUFACT_CD ,B.MODEL_DESCR ,C.LIST_COST ,C.ENGINE_SIZE ,C.ENGINE_SIZE_UNITS ,C.ENGINE_TYPE_CD ,C.C02_EMISSIONS FROM PS_CAR_ALLOC A ,PS_CAR_DATA B ,PS_CAR_MODEL C WHERE B.CAR_ID = A.CAR_ID AND C.MANUFACT_CD = B.MANUFACT_CD AND C.MODEL_DESCR = B.MODEL_DESCR AND C.EFFDT = ( SELECT MAX(CC.EFFDT) FROM PS_CAR_MODEL CC WHERE CC.MANUFACT_CD = C.MANUFACT_CD AND CC.MODEL_DESCR = C.MODEL_DESCR AND CC.EFFDT <= B.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | REGISTRATION_NUM |
Character(8) | VARCHAR2(8) NOT NULL | Registration Number |
| 3 | START_DT |
Date(10) | DATE | Start Date |
| 4 | END_DT | Date(10) | DATE | end date |
| 5 | REGISTRATION_DT | Date(10) | DATE | Registration Date |
| 6 | MANUFACT_CD | Character(4) | VARCHAR2(4) NOT NULL | Manufacturer |
| 7 | MODEL_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Model Description |
| 8 | LIST_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | List Cost |
| 9 | ENGINE_SIZE | Number(4,0) | SMALLINT NOT NULL | Engine Capacity (cc) |
| 10 | ENGINE_SIZE_UNITS | Character(1) | VARCHAR2(1) NOT NULL |
Engine Size
C=Cubic Centimeters I=Cubic Inches |
| 11 | ENGINE_TYPE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Engine Type
DIE=Diesel with cylinder capacity OTH=Car without cylinder capacity PET=Petrol with cylinder capacity |
| 12 | C02_EMISSIONS | Number(3,0) | SMALLINT NOT NULL | C02 Emissions g/km |