MEMBER_PAT_LINKS
Description:
This table contains link(s) to patient record(s) associated with member.
Primary Key
Column Name
Ordinal Position
BENEFIT_USAGE_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
BENEFIT_USAGE_ID
VARCHAR
No
The unique ID of the benefit usage 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
PAT_ID
VARCHAR
No
The unique patient ID for the member associated with the benefit usage.
4
CARD_ISSUED_DATE
DATETIME
No
The date of the most recent time a card was issued to a member for this benefit usage.