LN_AUTH_REF_FULL_REFERRAL

Description: |
This table holds the full list of referral and authorization records available for consideration when determining the referral number for the service line. This may include records that were not referenced in the lookup because the authorization number was found earlier in the list or from another source.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
INVOICE_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | INVOICE_ID | NUMERIC | No |
The unique identifier (.1 item) for the invoice record.
2 | GROUP_LINE | INTEGER | No |
The line number for the information associated with this record.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of data within this record.
4 | LN_AUTH_REF_NUM_REFERRAL_ID | NUMERIC | No |
The unique ID of each referral record considered in the referral number lookup, whether we read the referral number from the record or not.