Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK PERMIT ATTR Table


XXX


Field Name

Description

Data Type

Length

ALL_LOTS_ACCESS

XXX

VARCHAR2

1

ALL_LOTS_RESERVED

XXX

VARCHAR2

1

FAMILY

XXX

VARCHAR2

1

HEAD_OF_HOUSE

XXX

VARCHAR2

1

PARKING_PERMIT_ID

XXX

VARCHAR2

8

PARK_PAYMENT_METHOD_KEY

XXX

VARCHAR2

1

PERMIT_AREA_CODE

XXX

VARCHAR2

4

PERMIT_CREATED_AT

XXX

VARCHAR2

6

PERMIT_CREATED_BY

XXX

VARCHAR2

12

PERMIT_CREATED_ON

XXX

DATE

PERMIT_END_DATE

XXX

DATE

PERMIT_START_DATE

XXX

DATE

PERMIT_UPDATED_AT

XXX

VARCHAR2

6

PERMIT_UPDATED_BY

XXX

VARCHAR2

12

PERMIT_UPDATED_ON

XXX

DATE

WAREHOUSE_LOAD_DATE

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

DATE