OSP PROPOSAL TO AWARD MAP Table
View exposing mappings between proposals and resulting awards including linkage identifiers and conversion tracking used for proposal-to-award reconciliation.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
MIT_AWARD_KEY |
Surrogate key identifying the mit award. |
VARCHAR2 |
12 |
OSP_PROPOSAL_KEY |
Surrogate key identifying the osp proposal. |
VARCHAR2 |
8 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
28 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |