PARK VISITOR SCRATCH PASS Table
View exposing visitor scratch pass request records including requesting organization, status, quantities, cost objects, and financial attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_REQUEST |
Admin request associated with the record. |
VARCHAR2 |
1 |
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 |
HR_ORG_UNIT |
Hr org unit associated with the record. |
VARCHAR2 |
8 |
JV_INFO |
Jv info associated with the record. |
VARCHAR2 |
19 |
MAILED_BY |
Mailed by associated with the record. |
VARCHAR2 |
12 |
MAILED_DT |
Mailed dt associated with the record. |
VARCHAR2 |
8 |
NUMBER_PASSES |
Number passes associated with the record. |
VARCHAR2 |
4 |
PASS_COST |
Pass cost associated with the record. |
NUMBER |
11,2 |
REQUESTER_KERBID |
Requester kerbid associated with the record. |
VARCHAR2 |
12 |
SCRATCH_PASS_NUMBER |
Scratch pass number associated with the record. |
VARCHAR2 |
10 |
SCRATCH_PASS_STATUS |
Scratch pass status associated with the record. |
VARCHAR2 |
10 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |