OSP NEGOTIATIONS Table
View exposing sponsored project negotiation records including negotiation dates, negotiating parties, negotiation status, and terms adjustments/counters used for award finalization tracking and contract execution.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLOSED_DATE |
Date associated with closed. |
DATE |
|
DOC_FILE_ADDRESS |
Doc file address associated with the record. |
VARCHAR2 |
255 |
NEGOTIATION_AGREE_TYPE_CODE |
Code identifying negotiation agree type. |
NUMBER |
22 |
NEGOTIATION_NUMBER |
Negotiation number associated with the record. |
VARCHAR2 |
25 |
NEGOTIATION_STATUS_CODE |
Code identifying negotiation status. |
NUMBER |
22 |
NEGOTIATOR_ID |
Business identifier for the negotiator. |
VARCHAR2 |
40 |
PRIME_SPONSOR_CODE |
Code identifying prime sponsor. |
VARCHAR2 |
6 |
PROPOSED_START_DATE |
Date associated with proposed start. |
DATE |
|
REQUISITION_NUMBER |
Requisition number associated with the record. |
VARCHAR2 |
50 |
START_DATE |
Date associated with start. |
DATE |
|
START_DATE_TIME_MONTH_KEY |
Surrogate key identifying the start date time month. |
VARCHAR2 |
6 |
SUBCONTRACTOR_ID |
Business identifier for the subcontractor. |
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 |