|
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 |
| Other |
| 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 |
|
|
