ARRA REPORTING DETAIL Table
View exposing American Recovery and Reinvestment Act (ARRA) reporting detail records including recipient, funding, employment, and quarterly activity data used for federal stimulus compliance reporting and audit.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPT_FTE_PERCENT_EFFORT |
Appt fte percent effort as provided by the source. |
NUMBER |
7,4 |
ARRA_FTE |
Arra fte as provided by the source. |
NUMBER |
|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
DISTRIBUTION_BEGIN_DATE |
Date associated with distribution begin. |
DATE |
|
DISTRIBUTION_END_DATE |
Date associated with distribution end. |
DATE |
|
DISTRIBUTION_PERCENT |
Distribution percent as provided by the source. |
NUMBER |
5,2 |
HOURS_WORKED |
Hours worked as provided by the source. |
NUMBER |
6,2 |
HR_APPT_SUBTYPE_CODE |
Code identifying hr appt subtype. |
VARCHAR2 |
4 |
HR_JOB_FP_KEY |
Surrogate key identifying the hr job fp. |
VARCHAR2 |
14 |
HR_ORG_UNIT_FP_KEY |
Surrogate key identifying the hr org unit fp. |
VARCHAR2 |
14 |
HR_POSITION_FP_KEY |
Surrogate key identifying the hr position fp. |
VARCHAR2 |
14 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PAYROLL_AREA_CODE |
Code identifying payroll area. |
VARCHAR2 |
2 |
PAYROLL_FOR_PERIOD_KEY |
Surrogate key identifying the payroll for period. |
VARCHAR2 |
8 |
PAYROLL_IN_PERIOD_KEY |
Surrogate key identifying the payroll in period. |
VARCHAR2 |
8 |
PERIOD_ARRA_FTE |
Period arra fte as provided by the source. |
NUMBER |
|
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
TIME_BASE_PERCENT |
Time base percent as provided by the source. |
NUMBER |
5,2 |
TIME_MONTH_KEY |
Surrogate key identifying the time month. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |