Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LSO QUALIFICATION Table


View exposing learning and development qualification reference data.


Field Name

Description

Data Type

Length

IS_EL_REQUIREMENT

Indicator identifying whether el requirement (Y/N).

VARCHAR2

1

LAST_UPDATE_DATE

Date associated with last update.

DATE

LAST_UPDATE_USER

Last update user associated with the record.

VARCHAR2

12

LSO_QUALIFICATION

Lso qualification associated with the record.

VARCHAR2

60

LSO_QUALIFICATION_CODE

Code identifying lso qualification.

VARCHAR2

10

LSO_QUALIFICATION_GROUP

Lso qualification group associated with the record.

VARCHAR2

40

LSO_QUALIFICATION_GROUP_CODE

Code identifying lso qualification group.

VARCHAR2

10

LSO_QUALIFICATION_GROUP_ID

Business identifier for the lso qualification group.

VARCHAR2

12

LSO_QUALIFICATION_ID

Business identifier for the lso qualification.

VARCHAR2

12

LSO_QUALIFICATION_KEY

Surrogate key identifying the lso qualification.

VARCHAR2

10

LSO_QUALIFICATION_TYPE

Lso qualification type associated with the record.

VARCHAR2

12

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE