RESEARCH VOLUME BY PI Table
Stores research financial volume measures summarized by principal investigator (PI/supervisor) and fiscal year, including GL category, profit center, administrative flag, and year-to-date and cumulative amounts and budget. Each row represents a PI-level fiscal-year summary.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADMIN_FLAG |
Administrative flag code used to categorize the record (as defined by source). |
VARCHAR2 |
8 |
CUMULATIVE_AMOUNT |
Cumulative amount for research volume for the PI across the defined accumulation period (as defined by source). |
NUMBER |
|
FISCAL_YEAR |
Four-digit fiscal year for the summarized research volume record. |
VARCHAR2 |
4 |
FISCAL_YEAR_BUDGET |
Budget amount for the fiscal year associated with the PI-level research volume record. |
NUMBER |
|
FYTD_AMOUNT |
Fiscal year-to-date amount for research volume for the PI and fiscal year. |
NUMBER |
|
GL_CATEGORY |
General ledger category used to classify the financial activity included in the research volume. |
VARCHAR2 |
40 |
PROFIT_CENTER_ID |
Profit center identifier associated with the summarized financial activity. |
VARCHAR2 |
28 |
SUPERVISOR_MIT_ID |
MIT ID number of the supervising PI/person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
36 |