Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK PERMIT COST Table


XXX


Field Name

Description

Data Type

Length

ANUAL_CAP

XXX

NUMBER

13,2

CHARGE_ON_WEEKENDS

XXX

VARCHAR2

1

CURRENCY_KEY

Key used to join to the LIBRARY_CURRENCY table. This field should only be used for joining data, NOT for reporting.

VARCHAR2

5

DAILY_FEE_CHARGE_END_TIME

XXX

VARCHAR2

6

DAILY_FEE_CHARGE_START_TIME

XXX

VARCHAR2

6

DAILY_PARKING_CHARGE

XXX

NUMBER

13,2

IS_FEE_TOWARDS_CAP

XXX

VARCHAR2

1

PARK_RECURRING_FREQ_KEY

XXX

VARCHAR2

1

PERMIT_TYPE_ID

XXX

VARCHAR2

4

RECURRING_FEE

XXX

NUMBER

13,2

VALIDITY_END_DATE

XXX

DATE

VALIDITY_START_DATE

XXX

DATE

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE