OSP PROPOSAL SUBMISSION Table
View exposing proposal submission records including submission dates, submission methods, submission status, and submission tracking used for deadline management and submission verification.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CREATE_TIMESTAMP |
Timestamp associated with create. |
DATE |
|
CREATE_USER |
Create user associated with the record. |
VARCHAR2 |
60 |
DATE_REACHED_OSP |
Date reached osp associated with the record. |
DATE |
|
DEADLINE_DATE |
Date associated with deadline. |
DATE |
|
INST_PROPOSAL_NUMBER |
Inst proposal number associated with the record. |
VARCHAR2 |
12 |
LEAD_UNIT |
Lead unit associated with the record. |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
Lead unit name associated with the record. |
VARCHAR2 |
60 |
NUM_OF_DAYS |
Num of days associated with the record. |
NUMBER |
28,7 |
NUM_OF_DAYS_OSP |
Num of days osp associated with the record. |
NUMBER |
28,7 |
PI_ID |
Business identifier for the pi. |
VARCHAR2 |
40 |
PI_NAME |
Pi name associated with the record. |
VARCHAR2 |
90 |
PROPOSAL_NUMBER |
Proposal number associated with the record. |
VARCHAR2 |
12 |
PROPOSAL_TYPE_CODE |
Code identifying proposal type. |
VARCHAR2 |
3 |
ROUTING_START_DATE |
Date associated with routing start. |
DATE |
|
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 |