DOCS_RCVD_INSURANCE

Description: |
Externally received insurance information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
DOCUMENT_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | DOCUMENT_ID | NUMERIC | No |
This item stores the Received Document record ID.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | INSURANCE_REFERENCE_ID | VARCHAR | No |
Externally received insurance reference ID.
6 | INSURANCE_SOURCE_OF_PAY_C_NAME | VARCHAR | No |
Stores the financial source of payment for this coverage.
May contain organization-specific values: No
Category Entries:
Medicare
Medicaid
Miscellaneous/Other
Self-Pay
No Payment, Other
7 | INSURANCE_DO_NOT_BILL_YN | VARCHAR | No |
Stores whether or not this insurance indicates "Do not bill insurance".
May contain organization-specific values: No
Category Entries:
No
Yes
8 | INSURANCE_CHECKSUM | INTEGER | No |
This column stores the checksum of the externally received insurance information.
9 | INSURANCE_SOURCE_CSN | NUMERIC | No |
Stores a contact serial number (CSN) pointer to the Document Exchange record where externally received insurance information originated.
10 | INSURANCE_REF_FIN_CLASS_C_NAME | VARCHAR | No |
Customer mapped reference financial class that coverage is under
May contain organization-specific values: No
Category Entries:
Medicare
Medicaid
Medicare Advantage
Medicaid Replacement
Tricare
Veterans Affairs
Commercial
Blue Cross/Blue Shield Commercial
Third Party Liability
Worker's Comp
Other
Not Insurance
Pending Medicaid