CANCER_PROB_MERGE_HISTORY
Description:
This table stores a list of changes to the problem specified in the PROBLEM_LIST_ID column that happened during a problem merge.

Primary Key
Column Name Ordinal Position
PROBLEM_LIST_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PROBLEM_LIST_ID NUMERIC No
The unique identifier (.1 item) for the problem record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 MERGE_INTO_PROBLEM_LIST_ID NUMERIC No
This is the LPL ID of the problem that was merged into.
4 MERGE_INTO_HISTORY_LINE INTEGER No
This is the line number of the problem history related group (SI LPL 1100) for the problem that was merged into.
5 MERGE_FROM_PROBLEM_LIST_ID NUMERIC No
This is the LPL ID of the problem that this piece of data came from during a merge.
6 IS_ADDED_DATA_YN VARCHAR No
This stores whether this related line represents added data. Yes means the data was added, otherwise the data was removed.
May contain organization-specific values: No
Category Entries:
No
Yes
7 MERGED_LINKED_EPISODE_ID NUMERIC No
This stores a linked episode (HSB) ID that was added or removed during a problem merge.
8 MERGED_ONC_HISTORY_EVENT_LINE INTEGER No
This stores an oncology history event line number that was added or removed during a problem merge.
9 MERGED_LINKED_STAGE_ID NUMERIC No
This stores an active cancer stage (STG) ID that was added to or removed from a problem during a merge.
10 MERGED_DELETED_STAGE_ID NUMERIC No
This stores a deleted cancer stage (STG) ID that was added to or removed from a problem during a merge.
11 MERGED_TREAT_SUMMARY_NOTE_ID VARCHAR No
This stores an active treatment summary HNO ID that was added to or removed from a problem during a merge.
12 MERGED_DEL_TREAT_SUM_NOTE_ID VARCHAR No
This stores a deleted treatment summary HNO ID that was added to or removed from a problem during a merge.
13 LOCAL_RECUR_PROBLEM_LIST_ID NUMERIC No
This stores a local recurrence problem ID that was added to or removed from a cancer problem during a merge.
14 DISTANT_METS_PROBLEM_LIST_ID NUMERIC No
This stores a distant metastasis problem ID that was added to or removed from a cancer problem during a merge.
15 MERGED_DISEASE_STATUS_LINE INTEGER No
This stores a disease status line number that was added to or removed from a cancer problem during a merge.