OSP NEGOTIATION ACTIVITIES Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_DATE |
The date of the last major change in the employment status. The date records only hires, leaves, terminations, retirements, and deaths. |
DATE |
|
ACTIVITY_NUMBER |
XXX |
NUMBER |
22 |
CREATE_DATE |
Date when UROP applicatioan initiated. |
DATE |
|
DESCRIPTION |
the description |
VARCHAR2 |
2000 |
DOC_FILE_ADDRESS |
XXX |
VARCHAR2 |
255 |
FOLLOWUP_DATE |
XXX |
DATE |
|
NEGOTIATION_ACT_TYPE_CODE |
XXX |
NUMBER |
22 |
NEGOTIATION_NUMBER |
XXX |
VARCHAR2 |
25 |
RESTRICTED_VIEW |
XXX |
VARCHAR2 |
1 |
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 |