OSP RCR TRAINING NEEDED Table
View exposing research conduct and responsible conduct of research (RCR) training requirements for award personnel including training type, deadline, and completion status used for compliance verification.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
100 |
FULL_NAME |
Full name associated with the record. |
VARCHAR2 |
100 |
PAYROLL_DIST_AMOUNT |
Payroll dist amount associated with the record. |
NUMBER |
28,7 |
PAYROLL_FOR_PERIOD_KEY |
Surrogate key identifying the payroll for period. |
VARCHAR2 |
8 |
PAYROLL_PAYMENT_DATE |
Date associated with payroll payment. |
DATE |
|
PERSON_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
POSITION_TITLE |
Position title associated with the record. |
VARCHAR2 |
40 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
40 |
PROJECT_WBS_EFFECTIVE_DATE |
Date associated with project wbs effective. |
DATE |
|
PROJECT_WBS_EXPIRATION_DATE |
Date associated with project wbs expiration. |
DATE |
|
PROJECT_WBS_ID |
Business identifier for the project wbs. |
VARCHAR2 |
7 |
SUPERVISOR |
Supervisor associated with the record. |
VARCHAR2 |
30 |
TIME_LAPSE |
Time lapse associated with the record. |
NUMBER |
28,7 |
TRAINING_COMPLETED_DATE |
Date associated with training completed. |
VARCHAR2 |
18 |
TRAINING_COMPLETED_FLAG |
Indicator identifying whether training completed (Y/N). |
NUMBER |
28,7 |
TRAINING_DUE_DATE |
Date associated with training due. |
DATE |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |