FAMILY_PATS_STATUSES

Description:

The FAMILY_PATS_STATUSES table contains information about the status and status history for a particular family member within a family.

Primary Key

Column Name	Ordinal Position
FAMILY_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	FAMILY_ID	NUMERIC	No
	The unique identifier (.1 item) for the family record.
2	GROUP_LINE	INTEGER	No
	The line number of the patient in the family. Together with FAMILY_ID, this forms the foreign key to the FAMILY_PATS table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple statuses associated with the family and the patient from the FAMILY_PATS table.
4	FAMILY_PAT_STATUS_C_NAME	VARCHAR	No
	The family member status category ID for the family patient. May contain organization-specific values: No Category Entries: Active Previous Deleted