OSP NEGOTIATIONS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLOSED_DATE |
XXX |
DATE |
|
DOC_FILE_ADDRESS |
XXX |
VARCHAR2 |
255 |
NEGOTIATION_AGREE_TYPE_CODE |
XXX |
NUMBER |
22 |
NEGOTIATION_NUMBER |
XXX |
VARCHAR2 |
25 |
NEGOTIATION_STATUS_CODE |
XXX |
NUMBER |
22 |
NEGOTIATOR_ID |
XXX |
VARCHAR2 |
40 |
PRIME_SPONSOR_CODE |
Primary Sponsor code. OSP accounts are coded. Fund accounts are coded if there are restrictions in the award that make accounting system controls desirable. Contracts or grants from federal government and other restrictive sponsors are coded. |
VARCHAR2 |
6 |
PROPOSED_START_DATE |
XXX |
DATE |
|
REQUISITION_NUMBER |
Purchase Requisition Document Number |
VARCHAR2 |
50 |
START_DATE |
The first day of the fiscal period. Specific to HR_POSITION_DETAIL: If the Position is filled, this value equals the appointment begin date of the person filling that position. If the position is unfilled, this value is either the date the last person vacated the position. For new positions that have never been filled, this date is the start date assigned to the position. Specific to GRADUATE_AWARD_TERM_DETAIL: Within the term, this is the earliest date to which the money under this account has been applied. It is calculated differently depending on the type of aid. For TUIT and INS, this is set to the beginning of the term. For STIP, this is set to the earliest date for this account in the term in the stipend distribution section in the RPAGAAID form. UNMATCHED payroll has this set to the earliest date in the unmatched Payroll records. |
DATE |
|
START_DATE_TIME_MONTH_KEY |
XXX |
VARCHAR2 |
6 |
SUBCONTRACTOR_ID |
XXX |
VARCHAR2 |
8 |
UPDATE_TIMESTAMP |
Date that a record was last updated by OSP. |
DATE |
|
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |