OR_CASE_INSURANCE
Description:
Contains information about patient's case insurance information.

Primary Key
Column Name Ordinal Position
CASE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 CASE_ID VARCHAR No
The unique identifier for the case request 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 INS_FILING_ORDER_C_NAME VARCHAR No
This item identifies the patient's insurance as primary, secondary, or tertiary.
May contain organization-specific values: Yes
Category Entries:
Primary
Secondary
Tertiary
4 INS_PAYOR_ID_PAYOR_NAME VARCHAR No
The name of the payor.
5 INS_PRODUCT_TYPE_C_NAME VARCHAR No
This item contains the patient's insurance product type.
May contain organization-specific values: Yes
6 INS_SUBSCRIBER_NUM VARCHAR No
This item contains the patient's insurance subscriber ID.
7 INS_SUBSCR_DOB_DT DATETIME No
This item contains the patient's insurance subscriber date of birth.
8 INS_POLICY_NUM VARCHAR No
This item contains the patient's insurance policy number.
9 INS_GROUP_NUM VARCHAR No
This item contains the patient's insurance group number.
10 INS_PRECERT_NUM VARCHAR No
This item contains the patient's insurance pre-cert number
11 INS_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
12 INS_SUBSCRIBER_REL_C_NAME VARCHAR No
Describes the Insurance Subscriber Relationship.
May contain organization-specific values: Yes
Category Entries:
Aunt
Brother
Daughter
Father
Friend
Granddaughter
Grandfather
Grandmother
Grandson
Legal Guardian
Mother
Other
Step Father
Sister
Self
Step Mother
Son
Spouse
Uncle
Employer
Unverified Proxy
Transplant Recipient
Visit Contact
13 INS_PHONE_NUM VARCHAR No
Contains the phone number for insurance.