OSP PERSON TRAINING Table
View exposing training and compliance records for project personnel including required certifications (RCR, CITI), training dates, completion status, and expiration dates used for personnel certification tracking and compliance verification.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DATE_ACKNOWLEDGED |
Date acknowledged associated with the record. |
DATE |
|
DATE_REQUESTED |
Date requested associated with the record. |
DATE |
|
DATE_SUBMITTED |
Date submitted associated with the record. |
DATE |
|
FOLLOWUP_DATE |
Date associated with followup. |
DATE |
|
PERSON_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
40 |
SCORE |
Score associated with the record. |
VARCHAR2 |
9 |
TRAINING_CODE |
Code identifying training. |
NUMBER |
|
TRAINING_DESCRIPTION |
Description of training. |
VARCHAR2 |
200 |
TRAINING_NUMBER |
Training number associated with the record. |
NUMBER |
|
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |