OSP PROPOSAL LOG Table
View exposing proposal log records including proposal tracking history, workflow steps, and status progression used for proposal administration and audit trail.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COMMENTS |
Comments associated with the record. |
VARCHAR2 |
300 |
CREATE_TIMESTAMP |
Timestamp associated with create. |
DATE |
|
CREATE_USER |
Create user associated with the record. |
VARCHAR2 |
60 |
DEADLINE_DATE |
Date associated with deadline. |
DATE |
|
LEAD_UNIT |
Lead unit associated with the record. |
VARCHAR2 |
8 |
LOG_STATUS |
Log status associated with the record. |
VARCHAR2 |
1 |
NON_MIT_PERSON_FLAG |
Indicator identifying whether non mit person (Y/N). |
VARCHAR2 |
1 |
PI_ID |
Business identifier for the pi. |
NUMBER |
28 |
PI_NAME |
Pi name associated with the record. |
VARCHAR2 |
100 |
PROPOSAL_NUMBER |
Proposal number associated with the record. |
VARCHAR2 |
8 |
PROPOSAL_TYPE_CODE |
Code identifying proposal type. |
VARCHAR2 |
3 |
SPONSOR_CODE |
Code identifying sponsor. |
VARCHAR2 |
6 |
SPONSOR_NAME |
Sponsor name associated with the record. |
VARCHAR2 |
200 |
TITLE |
Title associated with the record. |
VARCHAR2 |
200 |
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 |