OSP WORKLOAD SIM CURR LOAD Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVE_FLAG |
XXX |
VARCHAR2 |
3 |
ARRIVAL_DATE |
XXX |
DATE |
|
ASSIGNED_BY |
XXX |
VARCHAR2 |
2 |
COMPLEXITY |
XXX |
NUMBER |
5,2 |
INACTIVE_DATE |
XXX |
DATE |
|
LEAD_UNIT |
XXX |
VARCHAR2 |
8 |
OSP_APPROVER_MIT_ID |
XXX |
VARCHAR2 |
40 |
OSP_APPROVER_USER_ID |
XXX |
VARCHAR2 |
100 |
POINT_OF_CONTACT_MIT_ID |
XXX |
VARCHAR2 |
40 |
POINT_OF_CONTACT_USER_ID |
XXX |
VARCHAR2 |
100 |
PROPOSAL_NUMBER |
A unique number assigned by OSP to each proposal submitted to a sponsor. |
VARCHAR2 |
8 |
REROUTED_FLAG |
XXX |
VARCHAR2 |
3 |
ROUTING_NUMBER |
XXX |
VARCHAR2 |
10 |
SIM_CURRENT_LOAD_ID |
XXX |
NUMBER |
12 |
SIM_ID |
XXX |
NUMBER |
|
SIM_MIT_ID |
XXX |
VARCHAR2 |
40 |
SIM_USER_ID |
XXX |
VARCHAR2 |
100 |
SPONSOR_GROUP |
XXX |
VARCHAR2 |
50 |
SPONSOR_KEY |
Key identifying an entry in the Sponsor master table. This field should only be used for linking tables together, not for reporting. |
VARCHAR2 |
8 |
UPDATE_TIMESTAMP |
Date that a record was last updated by OSP. |
DATE |
|
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |