PARK PERMIT COST Table
View exposing parking permit cost schedules including validity periods, recurring charges, caps, and related pricing attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ANUAL_CAP |
Anual cap associated with the record. |
NUMBER |
13,2 |
CHARGE_ON_WEEKENDS |
Charge on weekends associated with the record. |
VARCHAR2 |
1 |
CURRENCY_KEY |
Surrogate key identifying the currency. |
VARCHAR2 |
5 |
DAILY_FEE_CHARGE_END_TIME |
Time associated with daily fee charge end. |
VARCHAR2 |
6 |
DAILY_FEE_CHARGE_START_TIME |
Time associated with daily fee charge start. |
VARCHAR2 |
6 |
DAILY_PARKING_CHARGE |
Daily parking charge associated with the record. |
NUMBER |
13,2 |
IS_FEE_TOWARDS_CAP |
Indicator identifying whether fee towards cap (Y/N). |
VARCHAR2 |
1 |
PARK_RECURRING_FREQ_KEY |
Surrogate key identifying the park recurring freq. |
VARCHAR2 |
1 |
PERMIT_TYPE_ID |
Business identifier for the permit type. |
VARCHAR2 |
4 |
RECURRING_FEE |
Recurring fee associated with the record. |
NUMBER |
13,2 |
VALIDITY_END_DATE |
Date associated with validity end. |
DATE |
|
VALIDITY_START_DATE |
Date associated with validity start. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |