OSP ERI DISTRIBUTION Table
View exposing Equipment and Research Infrastructure (ERI) fund distribution records including allocation methodology, distributed amounts, recipient departments, and fund usage used for equipment funding tracking and asset management.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_NUMBER |
Cost collector number associated with the record. |
VARCHAR2 |
12 |
DISTRIBUTION_NUMBER |
Distribution number associated with the record. |
NUMBER |
10 |
DISTRIBUTION_PERCENT |
Distribution percent associated with the record. |
NUMBER |
5,2 |
END_DATE |
Date associated with end. |
DATE |
|
FULL_NAME |
Full name associated with the record. |
VARCHAR2 |
220 |
HR_ORG_UNIT_ID |
Business identifier for the hr org unit. |
VARCHAR2 |
10 |
HR_POSITION_KEY |
Surrogate key identifying the hr position. |
VARCHAR2 |
10 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
10 |
PERCENT_EFFORT |
Percent effort associated with the record. |
NUMBER |
5,2 |
START_DATE |
Date associated with start. |
DATE |
|
VERSION_NUMBER |
Version number associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |