REG_HX_OLD_MEM_FRM
Description:
After a change to a member's effective-from date, this table contains a list of the old member-level effective-from 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_FROM_DT DATETIME No
After a change to a member's effective-from date, this contains a list of the old member-level effective-from dates for all the member lines on a particular coverage on the patient.