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	NUMERIC	No
	This item contains the patient's insurance carrier.
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	NUMERIC	No
	This item contains the patient's insurance plan.
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.