Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FINAID OUTSIDE SCHOL Table


This table contains outside scholarships information -- such as outside scholarhip codes, outside scholarship names, types, renewable status -- which may be included in a student's financial aid package.


Field Name

Description

Data Type

Length

IS_RENEWABLE

Whether this fund/award/outside scholarship is renewable for another year; Y=Yes, N=No

VARCHAR2

1

LAST_ACTIVITY_DATE

Date when information in the record was last updated.

DATE

8

OUTSIDE_SCHOL_CODE

The code identifies the outside scholarship received by the student. Eg. BYRDR-, MERIT. MITFS-, MASBE-

VARCHAR2

6

OUTSIDE_SCHOL_KEY

Key identifying an entry in the FINAID OUTSIDE SCHOL table. This field should only be used for linking together the tables FINAID OUTSIDE SCHOL and FINAID AWARD DETAIL, not for reporting. STATUS Table.

VARCHAR2

6

OUTSIDE_SCHOL_NAME

The name of the outside scholarship received by the student. Eg. "R.C. Byrd Scholarship", "National Merit Scholarhip".

VARCHAR2

30

OUTSIDE_SCHOL_TYPE

Financial aid outside scholarship types

VARCHAR2

1

WAREHOUSE_LOAD_DATE

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

DATE

8