OSP WORKLOAD CURRENT LOAD Table
View exposing osp workload current load data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVE_FLAG |
Indicator identifying whether active (Y/N). |
VARCHAR2 |
3 |
ARRIVAL_DATE |
Date associated with arrival. |
DATE |
|
ASSIGNED_BY |
Assigned by associated with the record. |
VARCHAR2 |
2 |
COMPLEXITY |
Complexity associated with the record. |
NUMBER |
5,2 |
INACTIVE_DATE |
Date associated with inactive. |
DATE |
|
LAST_APPROVER |
Last approver associated with the record. |
VARCHAR2 |
100 |
LEAD_UNIT |
Lead unit associated with the record. |
VARCHAR2 |
8 |
OSP_APPROVER_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
40 |
POINT_OF_CONTACT_MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
40 |
PROPOSAL_NUMBER |
Proposal number associated with the record. |
VARCHAR2 |
8 |
REROUTED_FLAG |
Indicator identifying whether rerouted (Y/N). |
VARCHAR2 |
3 |
ROUTING_NUMBER |
Routing number associated with the record. |
VARCHAR2 |
10 |
SPONSOR_GROUP |
Sponsor group associated with the record. |
VARCHAR2 |
50 |
SPONSOR_KEY |
Surrogate key identifying the sponsor. |
VARCHAR2 |
8 |
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 |