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