Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FUND ACCOUNT Table


Subset of cost collectors defined as Sponsored or Non-Sponsored Funds. (This table should not be confused with SAP funds or fund centers.)


Field Name

Description

Data Type

Length

ADDRESSEE

The last and first name of the addressee: normally, the Administrative Officer, Financial Officer, or other departmental administrator responsible for monitoring expenses.

VARCHAR2

30

ADDRESSEE_ROOM

The MIT address, building and room number, of the addressee.

VARCHAR2

10

AUTHORIZED_TOTAL_AMOUNT

The amount authorized to be expended for a cost collector, usually by a WBS project sponsor.

NUMBER

9

COSTING_SHEET_DESCRIPTION

Description of the Costing Sheet associated with this Cost Collector. In SAP, the costing sheet is the mechanism used to calculate and post secondary costs such as allocations, employee benefts, and facilities and administration charges to cost collectors.

VARCHAR2

30

COSTING_SHEET_PROCEDURE

Code designating the Costing Sheet associated with this Cost Collector.

VARCHAR2

6

COST_COLLECTOR_ID

7-digit number which uniquely identifies the Cost Collector.

VARCHAR2

7

COST_COLLECTOR_KEY

Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

12

COST_COLLECTOR_NAME

The name of the Cost Collector.

VARCHAR2

40

COST_COLLECTOR_TYPE_CODE

A two-character code identifying the type of Cost Collector. CC=Cost Center, IO=Internal Order, PR=Project or WBS Element.

VARCHAR2

2

COST_COLLECTOR_TYPE_DESC

The full name of the cost collector type

VARCHAR2

20

EFFECTIVE_DATE

In the COST COLLECTOR table: this represents the effective date or starting date of the fund cost collector. In the ASA OFFICER DETAIL table this is the starting date of the tenure of the officer.

DATE

8

EXPIRATION_DATE

In the COST COLLECTOR table: Final or expiration date of the fund cost collector. In the ASA OFFICER DETAIL table, this is the date when the officer's term expires.

DATE

8

FS_CODE

Used to identify the restriction category for MIT's fund cost collectors. U is unrestricted, T is temporarily restricted, and P is permanently restricted. These categories are used in the preparation of MIT's annual financial statements, included in the Treasurer's Report.

VARCHAR2

1

FUND_CENTER_ID

Six-digit number identifying the fund center (example: 100088 Music, 100152 Division of Toxicology).

VARCHAR2

6

FUND_ID

Identification number associated with the Fund (Example: 6779500)

VARCHAR2

7

IS_CLOSED

Y= this account is closed.

VARCHAR2

1

ORGANIZATION_ID

The department, for example, Accounting.

VARCHAR2

6

ORGANIZATION_NAME

The name of the MIT Department or Unit to which the project is assigned, usually the home unit or the Principal Investigator or Co-Investigator.

VARCHAR2

40

POOL_CODE

Indicates which investment pool the funds should placed in.

VARCHAR2

1

POOL_UNITS

The number of pool units allocated to a Fund Cost Collector; supplied by the Treasurer's Office.

VARCHAR2

14

PROFIT_CENTER_ID

A unique key that identifies the profit center.

VARCHAR2

7

PROFIT_CENTER_KEY

Key used to join the Profit Center to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

11

PROFIT_CENTER_NAME

The text name of the profit center.

VARCHAR2

40

SECTION_CODE

A code which classifies cost collectors into sections for financial statement reporting purposes

VARCHAR2

3

SECTION_NAME

Description associated with the Section Code.

VARCHAR2

60

SUPERVISOR

The name of the person responsible for this project, cost center, internal order, or cost center.

VARCHAR2

30

SUPERVISOR_ROOM

The building and room number assigned to the person responsible for this project, center, internal order, or cost center.

VARCHAR2

10

TERM_CODE

** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year.

VARCHAR2

6

TREASURER_REPORT

Not in use in SAP.

VARCHAR2

3

WAREHOUSE_LOAD_DATE

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

DATE

8