PARK PERMIT VEHICLE Table
View exposing vehicle assignment records including permit identifiers, vehicle attributes, effective dates, and audit information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREATED_AT |
Time associated with created. |
VARCHAR2 |
6 |
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
12 |
CREATED_ON |
Date associated with created. |
DATE |
|
END_DATE |
Date associated with end. |
DATE |
|
PERMIT_ID |
Business identifier for the permit. |
VARCHAR2 |
8 |
PLATE_COUNTRY |
Plate country associated with the record. |
VARCHAR2 |
3 |
PLATE_NUMBER |
Plate number associated with the record. |
VARCHAR2 |
32 |
PLATE_NUMBER_SEARCH |
Plate number search associated with the record. |
VARCHAR2 |
32 |
PLATE_STATE |
Plate state associated with the record. |
VARCHAR2 |
3 |
START_DATE |
Date associated with start. |
DATE |
|
UPDATED_AT |
Time associated with updated. |
VARCHAR2 |
6 |
UPDATED_BY |
Updated by associated with the record. |
VARCHAR2 |
12 |
UPDATED_ON |
Date associated with updated. |
DATE |
|
VEHICLE_BODY_TYPE |
Vehicle body type associated with the record. |
VARCHAR2 |
60 |
VEHICLE_BODY_TYPE_CODE |
Code identifying vehicle body type. |
VARCHAR2 |
2 |
VEHICLE_COLOR |
Vehicle color associated with the record. |
VARCHAR2 |
60 |
VEHICLE_MAKE |
Vehicle make associated with the record. |
VARCHAR2 |
60 |
VEHICLE_MODEL |
Vehicle model associated with the record. |
VARCHAR2 |
60 |
VEHICLE_YEAR |
Vehicle year associated with the record. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |