PARK PERMIT REQUEST Table
View exposing parking permit request records including request types, request timestamps, requested locations, statuses, requester attributes, and audit fields.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
12 |
PARK_PERMIT_REQ_STATUS_KEY |
Surrogate key identifying the park permit req status. |
VARCHAR2 |
1 |
PARK_PERMIT_REQ_TYPE_KEY |
Surrogate key identifying the park permit req type. |
VARCHAR2 |
3 |
PERMIT_ID |
Business identifier for the permit. |
VARCHAR2 |
8 |
PERMIT_LOCATION_REQUESTED |
Permit location requested associated with the record. |
VARCHAR2 |
64 |
PERMIT_REQUEST_ID |
Business identifier for the permit request. |
VARCHAR2 |
8 |
REQUEST_BY |
Request by associated with the record. |
VARCHAR2 |
12 |
REQUEST_START_DATE |
Date associated with request start. |
DATE |
|
REQUEST_TIME |
Time associated with request. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |