Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FAID APPLICANT BUDGET ITEMS Table


XXX


Field Name

Description

Data Type

Length

BASE_BUDGET_AMOUNT

XXX

NUMBER

BUDCAT_ITEM_TOKEN

XXX

NUMBER

BUDGET_ADJUSTMENT_AMOUNT

XXX

NUMBER

BUDGET_CATEGORY_DESC

XXX

VARCHAR2

20

BUDGET_CATEGORY_ITEM_DESC

XXX

VARCHAR2

40

BUDGET_CATEGORY_TOKEN

XXX

NUMBER

FAID_APPLICANT_KEY

XXX

VARCHAR2

21

FAID_TERM

XXX

VARCHAR2

13

FAID_YEAR

XXX

NUMBER

FAID_YEAR_DESC

XXX

VARCHAR2

23

MITSIS_TERM_CODE

XXX

VARCHAR2

42

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

10

SBI_DT_TOKEN

XXX

NUMBER

STUDENT_TOKEN

XXX

NUMBER

STU_AWARD_YEAR_TOKEN

XXX

NUMBER

WAREHOUSE_INSERT_TIMESTAMP

XXX

DATE

WAREHOUSE_UPDATE_TIMESTAMP

XXX

DATE