PARK PERMIT ATTR Table
View exposing parking permit attribute records including payment methods, permit areas, eligibility indicators, effective dates, and audit attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALL_LOTS_ACCESS |
All lots access associated with the record. |
VARCHAR2 |
1 |
ALL_LOTS_RESERVED |
All lots reserved associated with the record. |
VARCHAR2 |
1 |
FAMILY |
Family associated with the record. |
VARCHAR2 |
1 |
HEAD_OF_HOUSE |
Head of house associated with the record. |
VARCHAR2 |
1 |
PARKING_PERMIT_ID |
Business identifier for the parking permit. |
VARCHAR2 |
8 |
PARK_PAYMENT_METHOD_KEY |
Surrogate key identifying the park payment method. |
VARCHAR2 |
1 |
PERMIT_AREA_CODE |
Code identifying permit area. |
VARCHAR2 |
4 |
PERMIT_CREATED_AT |
Time associated with permit created. |
VARCHAR2 |
6 |
PERMIT_CREATED_BY |
Permit created by associated with the record. |
VARCHAR2 |
12 |
PERMIT_CREATED_ON |
Permit created on associated with the record. |
DATE |
|
PERMIT_END_DATE |
Date associated with permit end. |
DATE |
|
PERMIT_START_DATE |
Date associated with permit start. |
DATE |
|
PERMIT_UPDATED_AT |
Time associated with permit updated. |
VARCHAR2 |
6 |
PERMIT_UPDATED_BY |
Permit updated by associated with the record. |
VARCHAR2 |
12 |
PERMIT_UPDATED_ON |
Permit updated on associated with the record. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |