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.