Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse NEW HIRE PROCESS DEVICE USED Table


View exposing devices used in the new-hire process including platform type, certificate support indicator, user agent, device dimensions, and access date and time.


Field Name

Description

Data Type

Length

ACCESS_DATE

Date associated with access.

DATE

ACCESS_TIME

Time associated with access.

VARCHAR2

6

ARE_CERTIFICATES_SUPPORTED

Are certificates supported associated with the record.

VARCHAR2

1

DEVICE_HEIGHT

Device height associated with the record.

VARCHAR2

5

DEVICE_WIDTH

Device width associated with the record.

VARCHAR2

5

NEW_HIRE_EMPLOYEE_KEY

Surrogate key identifying the new hire employee.

VARCHAR2

20

PLATFORM_TYPE

Platform type associated with the record.

VARCHAR2

30

USER_AGENT

User agent associated with the record.

VARCHAR2

255

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE