FAMILY_PATS
Description:
The FAMILY_PATS table stores the list of patients included in a family. It includes active family members in addition to family members who were previously deleted or marked as historic.

Primary Key
Column Name Ordinal Position
FAMILY_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 FAMILY_ID NUMERIC No
The unique identifier (.1 item) for the family 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 PAT_ID VARCHAR No
The unique ID of the patient who is a member of the family.
4 FAMILY_ROLE_C_NAME VARCHAR No
The family role category ID for the family member.
May contain organization-specific values: Yes
Category Entries:
Child
Parent
Legal Guardian
Caregiver
5 PRIMARY_HOUSEHOLD_YN VARCHAR No
Indicates whether the family member is part of the primary household for this family. 'Y' indicates that they are a primary household member. 'N' indicates that they are not.
May contain organization-specific values: No
Category Entries:
No
Yes