PAT_ENC_MSP_EMPLR

Description: |
This table contains the Employer Information part of the Medicare Secondary Payor Information from the Patient (EPT) master file.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 | CONTACT_DATE | DATETIME | No |
The date (calendar format) on which the encounter took place.
3 | PAT_EMPLYD_YN | VARCHAR | No |
Indicates whether the patient is currently employed for the purposes of the MSPQ. Y indicates that the patient is currently employed. N indicates that the patient is not currently employed or has never been employed. A null value indicates this item was not filled out.
May contain organization-specific values: No
Category Entries:
Yes
No
No, Never Employed
No, Retired
Yes, but Retired from Previous Employment
No, but Not Retired
4 | EMPLOYER_NAME | VARCHAR | No |
Name of the patient's employer.
5 | EMPLOYER_SIZE_C_NAME | VARCHAR | No |
The size range category ID of the patient's employer.
May contain organization-specific values: Yes
Category Entries:
Fewer than 20 employees
From 20 to 99 employees
100 or more employees
6 | EMPLOYER_PHONE | VARCHAR | No |
Phone number of the patient's employer.
7 | EMPLOYER_ADR_1 | VARCHAR | No |
Line 1 of the patient's employer's address.
8 | EMPLOYER_ADR_2 | VARCHAR | No |
Line 2 of the patient's employer's address.
9 | EMPLOYER_CITY | VARCHAR | No |
City of the patient's employer.
10 | EMPLOYER_ZIP | VARCHAR | No |
Zip code of the patient's employer.
11 | OTHER_EMPLYD_YN | VARCHAR | No |
Indicates whether the spouse or other family member is currently employed for the purposes of the MSPQ. Y indicates that the spouse or other family member is currently employed. N indicates that the spouse or other family member is not currently employed or has never been employed. A null value indicates this item was not filled out.
May contain organization-specific values: No
Category Entries:
Yes
No
No, Never Employed
No, Retired
Yes, but Retired from Previous Employment
No, but Not Retired
No, Not Married (single, divorced, widowed)
12 | OTHR_FAM_MEM_NAME | VARCHAR | No |
Name of other family members who are employed.
13 | OTHR_FAM_REL_C_NAME | VARCHAR | No |
Employed family member's relationship to the patient.
May contain organization-specific values: Yes
Category Entries:
Self
Spouse
Child
Employee
Unknown
14 | OTHR_EMPLR_NAME | VARCHAR | No |
Employed family member employer's name.
15 | OTHR_EMPLR_SIZE_C_NAME | VARCHAR | No |
Size of the employer of the other employed family member.
The category values for this column were already listed for column: EMPLOYER_SIZE_C_NAME
16 | OTHR_EMPLR_PHONE | VARCHAR | No |
Phone number of the employer of the other employed family member.
17 | OTHR_EMPLR_ADR_1 | VARCHAR | No |
Line 1 of the employer's address of the other employed family member.
18 | OTHR_EMPLR_ADR_2 | VARCHAR | No |
Line 2 of the employer's address of the other employed family member.
19 | OTHR_EMPLR_CITY | VARCHAR | No |
City of the employer of the other employed family member.
20 | OTHR_EMPLR_STATE_C_NAME | VARCHAR | No |
State of the employer of the other employed family member.
May contain organization-specific values: Yes
21 | OTHR_EMPLR_ZIP | VARCHAR | No |
Zip of the employer of the other employed family member.
22 | FAMILY_EMPLR_NAME | VARCHAR | No |
Name of the family member's employer. In some questionnaires, this information is instead stored as part of the spouse / other family member employer information, OTHR_EMPLR_*.
23 | FAMILY_EMPLR_ADR_1 | VARCHAR | No |
First line of the family member's employer's address. In some questionnaires, this information is instead stored as part of the spouse / other family member employer information, OTHR_EMPLR_*.
24 | FAMILY_EMPLR_ADR_2 | VARCHAR | No |
Second line of the family member's employer's address. In some questionnaires, this information is instead stored as part of the spouse / other family member employer information, OTHR_EMPLR_*.
25 | FAMILY_EMPLR_CITY | VARCHAR | No |
The City part of the family member's employer's address.
26 | FAMILY_EMPLR_ZIP | VARCHAR | No |
The ZIP part of the family member's employer's address.
27 | FAMILY_EMPLR_PHONE | VARCHAR | No |
Family member's employer's phone number. In some questionnaires, this information is instead stored as part of the spouse / other family member employer information, OTHR_EMPLR_*.