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 |