PAT_ENC_MSP_ACCDNT
Description:
This table contains the Accident 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 NON_WORK_ACC_YN VARCHAR No
Indicates whether the illness or injury is the result of a non-work-related accident. Y indicates that the illness or injury is the result of a non-work-related accident. N indicates that the illness or injury is not the result of a non-work-related accident. A null value indicates this item was not filled out.
May contain organization-specific values: No
Category Entries:
Yes
No
4 ACCDNT_TYPE_C_NAME VARCHAR No
The accident type category ID for the MSPQ.
May contain organization-specific values: Yes
Category Entries:
Work
Home
Auto
Other
5 ACCDNT_DATE DATETIME No
The accident date for the MSPQ.
6 ACCDNT_LOCATION_C_NAME VARCHAR No
The accident location category ID for the MSPQ.
May contain organization-specific values: Yes
Category Entries:
Home
Office
OTHER
7 ACCDNT_NON_LIAB_YN VARCHAR No
Indicates whether non-liability insurance is available. Y indicates that there is non-liability insurance available. N indicates that there is not non-liability insurance available. A null value indicates this item was not filled out.
May contain organization-specific values: No
Category Entries:
Yes
No
8 INSURED_NAME VARCHAR No
Name of the non-liability insurance holder.
9 INSUR_COMPANY VARCHAR No
Name of the non-liability insurance company.
10 NON_LIAB_POLICY VARCHAR No
Non-liability insurance policy number.
11 NON_LIAB_CLAIM VARCHAR No
Non-liability insurance claim number.
12 NON_LIAB_INS_ADR_1 VARCHAR No
Line 1 of the non-liability insurance company's address.
13 NON_LIAB_INS_ADR_2 VARCHAR No
Line 2 of the non-liability insurance company's address.
14 NON_LIAB_INS_CITY VARCHAR No
Non-liability insurance company's city.
15 N_LIAB_INS_STATE_C_NAME VARCHAR No
The category ID of the non-liability insurance company's state.
May contain organization-specific values: Yes
16 NON_LIAB_INS_ZIP VARCHAR No
Non-liability insurance company's zip code.
17 THRD_PRTY_LIAB_YN VARCHAR No
Indicates whether a third party is liable for this accident. Y indicates that a third party is liable for this accident. N indicates that a third party is not liable for this accident. A null value indicates this item was not filled out.
May contain organization-specific values: No
Category Entries:
Yes
No
18 ATTRNY_USD_YN VARCHAR No
Indicates whether the patient has an attorney for this injury. Y indicates that the patient has an attorney for this injury. N indicates that the patient does not have an attorney for this injury. A null value indicates this item was not filled out.
May contain organization-specific values: Yes
Category Entries:
Yes
No
19 ACCDNT_LIAB_NAME VARCHAR No
Name of the party responsible for the accident.
20 ACCDNT_ATTRNY_NAME VARCHAR No
Name of the patient's attorney or the responsible party's attorney.
21 LIABILITY_POLICY VARCHAR No
Liability insurance policy number.
22 LIABILITY_CLAIM VARCHAR No
Liability claim number.
23 LIABILITY_ADR_1 VARCHAR No
Line 1 of attorney or insurance company's address.
24 LIABILITY_ADR_2 VARCHAR No
Line 2 of attorney or insurance company's address.
25 LIABILITY_CITY VARCHAR No
Attorney or insurance company's city.
26 LIABILITY_STATE_C_NAME VARCHAR No
Attorney or accident liability insurance company's state.
The category values for this column were already listed for column: N_LIAB_INS_STATE_C_NAME
27 LIABILITY_ZIP VARCHAR No
Attorney or insurance company's ZIP Code.
28 ATTRNY_PHONE VARCHAR No
Attorney or insurance company's telephone number.
29 HAS_ADDL_LIAB_YN VARCHAR No
Indicates whether the patient has additional liability insurers. Y indicates that the patient has additional liability insurers. N indicates that the patient does not have additional liability insurers. A null value indicates this item was not filled out. The additional information will be stored in table PAT_ENC_MSP_ADL_LB.
May contain organization-specific values: No
Category Entries:
Yes
No
30 HAS_ADDL_NLIAB_YN VARCHAR No
Indicates whether the patient has additional non-liability insurers. Y indicates that the patient has additional non-liability insurers. N indicates that the patient does not have additional non-liability insurers. A null value indicates this item was not filled out. The additional information will be stored in table PAT_ENC_MSP_ADL_NL.
The category values for this column were already listed for column: HAS_ADDL_LIAB_YN
31 NON_LIAB_SUB_ADR_1 VARCHAR No
Line 1 of the non-liability insurance subscriber's address.
32 NON_LIAB_SUB_ADR_2 VARCHAR No
Line 2 of the non-liability insurance subscriber's address.
33 NON_LIAB_SUB_CITY VARCHAR No
Non-liability insurance subscriber's city.
34 NON_LIAB_SUB_ZIP VARCHAR No
Non-liability insurance subscriber's zip code.
35 RESP_PARTY_ADR_1 VARCHAR No
Line 1 of the responsible party's address.
36 RESP_PARTY_ADR_2 VARCHAR No
Line 2 of the responsible party's address.
37 RESP_PARTY_CITY VARCHAR No
Responsible party's city.
38 RESP_PARTY_ZIP VARCHAR No
Responsible party's zip code.