OSP NEGOTIATION DETAIL Table
View exposing negotiation detail records including proposed terms, counteroffers, amendments, and agreed-upon conditions used for award negotiation history tracking and complete audit trail maintenance.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LEAD_UNIT |
Lead unit associated with the record. |
VARCHAR2 |
8 |
LEAD_UNIT_NAME |
Lead unit name associated with the record. |
VARCHAR2 |
60 |
NEGOTIATION_NUMBER |
Negotiation number associated with the record. |
VARCHAR2 |
25 |
PI_NAME |
Pi name associated with the record. |
VARCHAR2 |
100 |
PI_PERSON_ID |
Business identifier for the pi person. |
VARCHAR2 |
40 |
PI_ROLODEX_ID |
Business identifier for the pi rolodex. |
NUMBER |
28 |
PRIME_SPONSOR_CODE |
Code identifying prime sponsor. |
VARCHAR2 |
6 |
PRIME_SPONSOR_NAME |
Prime sponsor name associated with the record. |
VARCHAR2 |
200 |
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 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |