PAYER_MEM_MATCH
Description:
This table contains rows for each time that a payer has matched this member using the FHIR $member-match or $bulk-member-match operations.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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 MEM_MATCH_CLIENT_IDENT VARCHAR No
The client who performed this member match.
4 MEM_MATCH_REQUEST_IDENT VARCHAR No
The Bulk Request ID this member match is part of.
5 MEM_MATCH_COVERAGE_ID NUMERIC No
The coverage (CVG) this member match is associated with.
6 MEM_MATCH_MATCHED_UTC_DTTM DATETIME (UTC) No
The UTC instant this member match occurred.