VISITOR PARKING RESERVATION Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DEPARTMENT_CONTACT_MIT_ID |
XXX |
VARCHAR2 |
9 |
DEPARTMENT_CONTACT_NAME |
XXX |
VARCHAR2 |
40 |
DEPARTMENT_CONTACT_OFFICE_ADDR |
XXX |
VARCHAR2 |
40 |
DEPARTMENT_CONTACT_PHONE |
XXX |
VARCHAR2 |
15 |
DEPARTMENT_CONTACT_TITLE |
XXX |
VARCHAR2 |
50 |
HOURS_RESERVED |
XXX |
NUMBER |
2 |
IS_CLOSED |
Y= this account is closed. |
VARCHAR2 |
1 |
PARKING_COST_ACTUAL |
XXX |
NUMBER |
12,2 |
PARKING_COST_COLLECTOR_KEY |
XXX |
VARCHAR2 |
12 |
PARKING_COST_ESTIMATED |
XXX |
NUMBER |
12,2 |
PARKING_LOT |
XXX |
VARCHAR2 |
30 |
PARKING_RESERVATION_DATE |
XXX |
DATE |
|
PARKING_RESERVATION_NUMBER |
XXX |
VARCHAR2 |
7 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
RESERVATION_CREATED_BY_USER |
XXX |
VARCHAR2 |
12 |
RESERVATION_CREATE_DATE |
XXX |
DATE |
|
RESERVATION_END_TIME |
XXX |
VARCHAR2 |
17 |
RESERVATION_LAST_UPDATE_DATE |
XXX |
DATE |
|
RESERVATION_START_TIME |
XXX |
VARCHAR2 |
17 |
RESERVATION_STATUS_LINE |
XXX |
VARCHAR2 |
80 |
RESERVATION_UPDATED_BY_USER |
XXX |
VARCHAR2 |
12 |
SETTLEMENT_COST_COLLECTOR_KEY |
XXX |
VARCHAR2 |
12 |
VISITOR_NAME |
XXX |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |