PAT_REL_PHONE_NUM

Description:

This table contains information about the patient contacts' phone numbers. The records included in this table are Patient Relationships (RLA) records.

Primary Key

Column Name	Ordinal Position
PAT_RELATIONSHIP_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_RELATIONSHIP_ID	NUMERIC	No
	The unique identifier for the patient contact 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	PHONE_NUM	VARCHAR	No
	Patient contact's phone number.
4	PHONE_NUM_TYPE_C_NAME	VARCHAR	No
	The phone number type category ID for the patient contact's phone number. May contain organization-specific values: Yes Category Entries: Mobile Pager Home Fax Other Fax Assistant TTY Home Phone Work Phone Video Phone
5	PRIMARY_PHONE_YN	VARCHAR	No
	Indicates whether the phone number for this patient contact is the primary email address May contain organization-specific values: No Category Entries: No Yes