Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse CIS HASS ATTRIBUTE Table


More detailed descriptions of HASS Attributes in CIS Course Catalog


Field Name

Description

Data Type

Length

CIS_ATTRIBUTE_GROUP

Group the CIS attribute belongs to.

VARCHAR2

1

CIS_ATTRIBUTE_GROUP_NOTE

Note about the HASS attribute used in the Course Catalog.

VARCHAR2

59

DESCRIPTION_IN_BULLETIN

Description of the attribute as used in the Course Catalog online bulletin.

VARCHAR2

40

DESCRIPTION_ON_FORM

Description of the attribute as used on the Course Catalog form

VARCHAR2

40

HASS_ATTRIBUTE

HASS attributes in use since academic year 2011. Eg. "HA", "HH", "HS", "HE", "HA,HH", etc.

VARCHAR2

8

ICON_GIF_NAME

Name of the gif image in the online bulletin.

VARCHAR2

20

ICON_HEIGHT

Height of icon gif image in the online bulletin.

VARCHAR2

2

ICON_WIDTH

Width of icon gif image in the online bulletin.

VARCHAR2

2

LAST_ACTIVITY_DATE

Date when information in the record was last updated.

DATE

8

LAST_UPDATE_USER

Last person that changed this record.

VARCHAR2

12

WAREHOUSE_LOAD_DATE

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

DATE

8