VISITOR PARKING DETAIL Table
View exposing visitor parking detail records including visitor, permit, lot, and parking activity attributes used for parking administration and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPARTMENT_CONTACT_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
DEPARTMENT_CONTACT_NAME |
Department contact name associated with the record. |
VARCHAR2 |
40 |
DEPARTMENT_CONTACT_OFFICE_ADDR |
Department contact office addr associated with the record. |
VARCHAR2 |
40 |
DEPARTMENT_CONTACT_PHONE |
Department contact phone associated with the record. |
VARCHAR2 |
15 |
DEPARTMENT_CONTACT_TITLE |
Department contact title associated with the record. |
VARCHAR2 |
50 |
HOURS_RESERVED |
Hours reserved associated with the record. |
NUMBER |
2 |
PARKING_COST_ACTUAL |
Parking cost actual associated with the record. |
NUMBER |
12,2 |
PARKING_COST_ESTIMATED |
Parking cost estimated associated with the record. |
NUMBER |
12,2 |
PARKING_LOT_KEY |
Surrogate key identifying the parking lot. |
VARCHAR2 |
8 |
PARKING_RESERVATION_DATE |
Date associated with parking reservation. |
DATE |
|
PARKING_RESERVATION_NUMBER |
Parking reservation number associated with the record. |
VARCHAR2 |
7 |
PARKING_RESERVATION_STATUS_KEY |
Surrogate key identifying the parking reservation status. |
VARCHAR2 |
20 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
RESERVATION_CREATED_BY_USER |
Reservation created by user associated with the record. |
VARCHAR2 |
12 |
RESERVATION_CREATE_DATE |
Date associated with reservation create. |
DATE |
|
RESERVATION_END_TIME |
Time associated with reservation end. |
VARCHAR2 |
17 |
RESERVATION_LAST_UPDATE_DATE |
Date associated with reservation last update. |
DATE |
|
RESERVATION_START_TIME |
Time associated with reservation start. |
VARCHAR2 |
17 |
RESERVATION_STATUS_LINE |
Reservation status line associated with the record. |
VARCHAR2 |
80 |
RESERVATION_UPDATED_BY_USER |
Reservation updated by user associated with the record. |
VARCHAR2 |
12 |
SETTLEMENT_COST_COLLECTOR_KEY |
Surrogate key identifying the settlement cost collector. |
VARCHAR2 |
12 |
VISITOR_NAME |
Visitor name associated with the record. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |