PAT_PER_CARR_ADDR

Description: |
The PAT_PER_CARR_ADDR table contains patient information as specified by the carrier.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ID | VARCHAR | No |
The unique ID assigned to the patient record. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
2 | LINE | INTEGER | No |
The line number used to identify each line of patient info as specified by the carrier.
3 | CARR_ADDR_DATE | DATETIME | No |
The effective date of the carrier information.
4 | CARR_ADDR_CITY | VARCHAR | No |
The city of the patient address as specified by the carrier.
5 | CARR_ADDR_ZIP | VARCHAR | No |
The ZIP Code of the patient address as specified by the carrier.
6 | CARR_ADDR_HM_PHONE | VARCHAR | No |
The home phone number of the patient as specified by the carrier.
7 | CARR_ADDR_WK_PHONE | VARCHAR | No |
The work phone number of the patient as specified by the carrier.
8 | CARR_ADDR_PAT_NAME | VARCHAR | No |
The name of the patient as specified by the carrier.
9 | CARR_ADDR_BDATE | DATETIME | No |
The birth date of the patient as specified by the carrier.
10 | CARR_ADDR_SEX_C_NAME | VARCHAR | No |
The category value of the sex of the patient as specified by the carrier.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
11 | CARRIER_ID | VARCHAR | No |
The unique ID of the carrier for the patient.
12 | CARRIER_ID_CARRIER_NAME | VARCHAR | No |
The name of the carrier record.
13 | CARR_ADDR_COUNTY_C_NAME | VARCHAR | No |
The category value corresponding to the county in which the patient lives as specified by the carrier.
May contain organization-specific values: Yes
14 | CARR_ADDR_GENDER_IDENTITY_C_NAME | VARCHAR | No |
Stores carrier specific gender identity.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Not Listed
Choose not to disclose
Nonbinary
Genderqueer
15 | CARR_ADDR_HOUSE_NUMBER | VARCHAR | No |
Stores the address house number as specified by the carrier.
16 | CARR_ADDR_DISTRICT_C_NAME | VARCHAR | No |
Stores unique identifier of the address district as specified by the carrier.
May contain organization-specific values: Yes
17 | CARR_ADDR_COUNTRY_C_NAME | VARCHAR | No |
Stores unique identifier of the address country as specified by the carrier.
May contain organization-specific values: Yes
18 | CARR_ADDR_NAME_RECORD_ID | VARCHAR | No |
The name record of the patient as specified by the carrier. This column is frequently used to link to the NAMES table.
19 | CARR_ADDR_MBI | VARCHAR | No |
The Medicare Beneficiary Identifier (MBI) of the patient, as specified by the carrier.
20 | CARR_ADDR_ETHNIC_GROUP_C_NAME | VARCHAR | No |
The external source ethnic group category ID for the patient.
May contain organization-specific values: Yes
21 | CARR_ADDR_SEX_ASGN_AT_BIRTH_C_NAME | VARCHAR | No |
Stores sex assigned at birth as specified by an external source.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Not recorded on birth certificate
Choose not to disclose
Uncertain
22 | CARR_ADDR_SOURCE_NAME | VARCHAR | No |
The source of the patient information as specified by an external source.
23 | CARR_ADDR_PRONOUN | VARCHAR | No |
The member pronoun information as specified by an external source.
24 | CARR_ADDR_PREFERRED_LANGUAGE_C_NAME | VARCHAR | No |
Preferred language as specified by an external source
May contain organization-specific values: Yes
25 | CARR_ADDR_NEEDS_INTERPRETER_YN | VARCHAR | No |
Whether the patient needs an interpreter as specified by an external source.
May contain organization-specific values: No
Category Entries:
Yes
No
26 | CARR_ADDR_PRONOUN_CMT | VARCHAR | No |
A free-text field for documenting comments or instructions relating to a member's pronouns related to an external source.