Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK PERMIT CREDENTIALS Table


XXX


Field Name

Description

Data Type

Length

ACCESS_CREDENTIAL_ID

XXX

VARCHAR2

16

ACCESS_CREDENTIAL_KEY

XXX

VARCHAR2

16

CREATED_AT

XXX

VARCHAR2

6

CREATED_BY

User account or user name of the person who created the record.

VARCHAR2

12

CREATED_ON

XXX

DATE

PARK_ACCESS_CRED_TYPE_KEY

XXX

VARCHAR2

1

PERMIT_BEGIN_DATE

XXX

DATE

PERMIT_END_DATE

XXX

DATE

PERMIT_ID

XXX

VARCHAR2

8

UPDATED_AT

XXX

VARCHAR2

6

UPDATED_BY

XXX

VARCHAR2

12

UPDATED_ON

XXX

DATE

WAREHOUSE_LOAD_DATE

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

DATE