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_*.