Data Warehouse

COST_COLLECTOR_CATEGORY_CODE

Code identifying the categories of Cost Collectors: AUXIL (auxiliary), FNDNS (fund-nonsponsored), FNDSP (fund-sponsored), GENER (general), OTHER (other), RSRCH (research). See also COST_COLLECTOR_CATEGORY-DESC.

VARCHAR2

5

COST_COLLECTOR_CATEGORY_DESC

Description identifying the categories of Cost Collectors: Auxiliary, Fund -- Not Sponsored, Fund -- Sponsored, General, Other, Research. AUXILIARY cost centers are used by auxiliary enterprises (MIT Press, Housing & Dining, etc.) which are budgeted centrally but required to break even. FUNDS--NOT SPONSORED: those with non-sponsored revenue sources and contain MIT's endowments, loan funds, discretionary funds, and other accumulated net assets. All are internal orders. FUNDS--SPONSORED: have an external sponsor as the revenue source. Sponsored activity in the Fund range is non-organized research. All are WBS elements. GENERAL : All MIT Operating Cost Centers (cost objects budgeted centrally) except the Auxiliary cost centers defined above. RESEARCH: All of MIT's sponsored research activity is in this category. Revenue is assumed to be equal to expenses. All are WBS elements. OTHER: Internal Orders and WBS elements that hold activity that should not be part of MIT's revenues and expenses. This includes activity which will be distributed to General, Funds, and Research in the future using allocations, depreciation, or billings for services rendered, and activity being administered by MIT on behalf of others.

VARCHAR2

30

COST_COLLECTOR_CATEGORY_KEY

This key field is used to join COST COLLECTOR CATEGORY and MASTER PROJECT HISTORY DETAIL tables.

VARCHAR2

5

WAREHOUSE_LOAD_DATE

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

DATE

8