PARK PERMIT CREDENTIALS Table
View exposing parking permit credential assignment records including credential identifiers, types, effective dates, and audit attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACCESS_CREDENTIAL_ID |
Business identifier for the access credential. |
VARCHAR2 |
16 |
ACCESS_CREDENTIAL_KEY |
Surrogate key identifying the access credential. |
VARCHAR2 |
16 |
CREATED_AT |
Time associated with created. |
VARCHAR2 |
6 |
CREATED_BY |
Created by associated with the record. |
VARCHAR2 |
12 |
CREATED_ON |
Date associated with created. |
DATE |
|
PARK_ACCESS_CRED_TYPE_KEY |
Surrogate key identifying the park access cred type. |
VARCHAR2 |
1 |
PERMIT_BEGIN_DATE |
Date associated with permit begin. |
DATE |
|
PERMIT_END_DATE |
Date associated with permit end. |
DATE |
|
PERMIT_ID |
Business identifier for the permit. |
VARCHAR2 |
8 |
UPDATED_AT |
Time associated with updated. |
VARCHAR2 |
6 |
UPDATED_BY |
Updated by associated with the record. |
VARCHAR2 |
12 |
UPDATED_ON |
Date associated with updated. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |