Overview Top Package Entity

Business Data Model Data Model

---

Entity ENVOY Clearing

Description

Information about ENVOY Corporation, a US claims clearing house, and their processing of a given claim.

Attributes

Eligibility Source

Payor Insured Num

Payor Num

Relationship

ENVOY Clearing_Provider Patient Insurance_FK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 Eligibility Source

Description	Identifies the source of information about the insured's eligibility for benefits.  For example: Insurance company  Employer  Insured presented policy  Insured presented card  Signed statement on file  Verbal information  None
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Payor Insured Num

Description	Identifies the specific office within the insurance carrier that is designated as responsible for the claim.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Payor Num

Description	Identifies the organization from which reimbursement is expected. For example: National Health Plan ID.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

 ENVOY Clearing_Provider Patient Insurance_FK

Is Identifying Relationship	false
Child Table	ENVOY Clearing
Child Role Name	for policy
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Coverage Eligibility
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

Overview Top Package Entity

Business Data Model Data Model