REG_HX_OLD_MEM_TO
Description:
After a change to a member's effective-to date, this table contains a list of the old member-level effective-to dates for all the member lines on a particular coverage on the patient.

Primary Key
Column Name Ordinal Position
NOTE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 NOTE_ID VARCHAR No
The unique identifier for the note 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 OLD_MEM_EFF_TO_DT DATETIME No
After a change to a member's effective-to date, this contains a list of the old member-level effective-to dates for all the member lines on a particular coverage on the patient.