Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAID DOCS Table


View exposing financial-aid document reference and messaging data including document identifiers, types, creation dates, web-display settings, hyperlink attributes, and related message metadata.


Field Name

Description

Data Type

Length

DATE_MESSAGE_ASSIGNED

Date message assigned associated with the record.

VARCHAR2

10

DISABLE_URL_ON_RAW

Disable url on raw associated with the record.

NUMBER

DOCUMENT_CREATED_DATE

Date associated with document created.

DATE

DOCUMENT_NAME

Document name associated with the record.

VARCHAR2

40

DOCUMENT_SHORT_NAME

Document short name associated with the record.

VARCHAR2

8

DOCUMENT_TYPE

Document type associated with the record.

VARCHAR2

1

DOCUMENT_TYPE_DESC

Description of document type.

VARCHAR2

17

DOC_TOKEN

Doc token associated with the record.

NUMBER

FAID_YEAR

Faid year associated with the record.

NUMBER

HYPERLINK_URL

Hyperlink url associated with the record.

VARCHAR2

200

IDOC_DOCUMENT

Idoc document associated with the record.

NUMBER

MESSAGE_ID

Business identifier for the message.

VARCHAR2

24

MESSAGE_LOCATION

Message location associated with the record.

NUMBER

MESSAGE_TOKEN

Message token associated with the record.

NUMBER

REMOVE_MESSAGE_WHEN_RECEIVED

Remove message when received associated with the record.

NUMBER

USE_HYPERLINK

Use hyperlink associated with the record.

NUMBER

WEB_DISPLAY

Web display associated with the record.

VARCHAR2

1