CLAIM_REFERRAL_LK_HX

Description: |
This table contains the history of referrals linked to AP claims. Amounts and counts calculated during adjudication when these referrals were attached to the AP claim are also included.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CLAIM_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CLAIM_ID | NUMERIC | No |
The unique identifier for the claim info 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 | REFERRAL_ID | NUMERIC | No |
The unique identifier of the referral previously associated with this claim.
4 | VISIT_COUNT | INTEGER | No |
The visit count for this referral when it was linked to the AP claim.
5 | ADJUD_AMT | NUMERIC | No |
The adjudicated dollar amount for this referral when it was linked to the AP claim.
6 | PAID_AMT | NUMERIC | No |
The paid dollar amount for this referral when it was linked to the AP claim.
7 | RFL_ATTACH_SOURCE_C_NAME | VARCHAR | No |
The historical referral attachment source category ID for the AP claim.
May contain organization-specific values: No
Category Entries:
Adjudication Referral Matching
Manual
EDI Claim File