Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK CREDENTIAL OVERRIDE Table


View exposing credential override records including access credentials, override periods, reasons, parking areas, and audit attributes.


Field Name

Description

Data Type

Length

ACCESS_CREDENTIAL_ID

Business identifier for the access credential.

VARCHAR2

16

ACCESS_CRED_REASON

Access cred reason associated with the record.

VARCHAR2

128

ACCESS_CRED_REASON_CODE

Code identifying access cred reason.

VARCHAR2

4

BEGIN_DATE

Date associated with begin.

DATE

CREATED_AT

Time associated with created.

VARCHAR2

6

CREATED_BY

Created by associated with the record.

VARCHAR2

12

CREATED_ON

Date associated with created.

DATE

END_DATE

Date associated with end.

DATE

PARKING_AREA_CODE

Code identifying parking area.

VARCHAR2

4

PARK_ACS_CRED_TYPE_KEY

Surrogate key identifying the park acs cred type.

VARCHAR2

1

UPDATED_AT

Time associated with updated.

VARCHAR2

6

UPDATED_BY

Updated by associated with the record.

VARCHAR2

12

UPDATED_ON

Date associated with updated.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE