PARK VISITOR LOT PASS Table
View exposing visitor lot pass records including pass identifiers, lot assignments, requester attributes, cost objects, and financial attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_REQUEST |
Admin request associated with the record. |
VARCHAR2 |
1 |
CANCELLED_BY |
Cancelled by associated with the record. |
VARCHAR2 |
12 |
CANCELLED_DT |
Cancelled dt associated with the record. |
VARCHAR2 |
8 |
CANC_ADMIN_REQUEST |
Canc admin request associated with the record. |
VARCHAR2 |
1 |
CANC_COST_OBJECT |
Canc cost object associated with the record. |
VARCHAR2 |
12 |
CANC_JV_INFO |
Canc jv info associated with the record. |
VARCHAR2 |
19 |
COST_OBJECT |
Cost object associated with the record. |
VARCHAR2 |
12 |
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
12 |
CREATED_DT |
Created dt associated with the record. |
VARCHAR2 |
8 |
DAY_OF_WEEK |
Day of week associated with the record. |
VARCHAR2 |
10 |
HR_ORG_UNIT |
Hr org unit associated with the record. |
VARCHAR2 |
8 |
JV_INFO |
Jv info associated with the record. |
VARCHAR2 |
19 |
PARKING_LOT_ID |
Business identifier for the parking lot. |
VARCHAR2 |
4 |
PASS_COST |
Pass cost associated with the record. |
NUMBER |
11,2 |
PASS_DATE |
Date associated with pass. |
VARCHAR2 |
8 |
PASS_NUMBER |
Pass number associated with the record. |
VARCHAR2 |
10 |
PASS_STATUS |
Pass status associated with the record. |
VARCHAR2 |
10 |
REQUESTER_KERBID |
Requester kerbid associated with the record. |
VARCHAR2 |
12 |
TIME_IN |
Time in associated with the record. |
VARCHAR2 |
6 |
TIME_OUT |
Time out associated with the record. |
VARCHAR2 |
6 |
VISITOR_NAME |
Visitor name associated with the person. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |