FUNDS REPORTING Table
Departmental funds reporting data
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_FP_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances by Fiscal Period, Summary Statement Detail) when you want to bring up the cost collector data matching the fiscal period on the fact table. For the current fiscal period, the most recent data will be brought in. |
VARCHAR2 |
12 |
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 |
DEPT_HEAD_GENERAL_AMOUNT |
General Funds controlled by the Department Head; administrative flag is DP |
NUMBER |
22 |
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
FR_LEVEL1_CATEGORY |
First Level of Funds Reporting categories: for example, Sources, Uses, and Transfers |
VARCHAR2 |
40 |
FR_LEVEL1_SORT |
Numerical Codes enabling the report to be sorted in order Sources, Uses and Transfers rather than alphabetically |
NUMBER |
22 |
FR_LEVEL2_CATEGORY |
A finer grain of Funds Reporting categories enabling the user to see, e.g., Sources as Beginning Balance, Fees, Gifts, etc; Transfers as Cost Sharing, Drafts or Transfers; Uses similarly by expense categories |
VARCHAR2 |
40 |
FR_LEVEL2_SORT |
Numerical codes enabling the Level 2 Categories to be grouped by kind rather than alphabetically, e.g., all salary lines together, all student costs together, etc. |
NUMBER |
22 |
GROUP_OF_FR_LEVEL2_CATEGORY |
XXX |
VARCHAR2 |
40 |
GROUP_OF_FR_LEVEL2_SORT |
XXX |
NUMBER |
22 |
OTHER_FUNDS_AMOUNT |
FYTD activity for non-sponsored funds (FNDNS) that ARE NOT faculty controlled and are not in Pool Codes A or C. |
NUMBER |
22 |
OTHER_FUNDS_FC_AMOUNT |
FYTD activity for non-sponsored funds (FNDNS) that ARE faculty controlled (admin flag is FC) and are not in Pool Codes A or C. |
NUMBER |
22 |
POOL_A_AMOUNT |
FYTD activity for all pool funds coded "A" |
NUMBER |
22 |
POOL_C_AMOUNT |
FYTD activity for pool funds coded "C" that are department head controlled (administrative flag is DP) |
NUMBER |
22 |
POOL_C_FC_AMOUNT |
FYTD activity for pool funds coded "C" that are faculty controlled (administrative flag is FC) |
NUMBER |
22 |
SPONSORED_FUNDS_AMOUNT |
FYTD activity for sponsored funds controlled by the department head (admin flag is DP) but are not in pool codes A or C |
NUMBER |
22 |
SPONSORED_FUNDS_FC_AMOUNT |
FYTD activity for sponsored funds that are faculty controlled (admin flag is FC) but are not in pool codes A or C |
NUMBER |
22 |
TIME_MONTH_KEY |
Key used only for joining the TIME_MONTH table to other tables, NOT for reporting. |
VARCHAR2 |
6 |
TOTAL_GENERAL_AMOUNT |
General Funds that do not have an administrative flag of RA, RT, or NS (RA Subsidy, Research Telephone Subsidy, or NSF Shortfall) |
NUMBER |
13.2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |