PAT_ENC_MSP_HX

Description: |
History of who touched or changed the Medicare as a Secondary Payer Questionnaire (MSPQ) for a contact. Includes the MSPQ status, time of change, and reason incomplete as well.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
2 | LINE | INTEGER | No |
The line number, representing a line of 1 or more history data
3 | MSP_USER_HISTORY | VARCHAR | No |
History of users who have touched the MSPQ for this contact
4 | MSP_USER_HISTORY_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | MSP_STATUS_HISTORY | VARCHAR | No |
History of MSPQ statuses for this contact
6 | MSP_HISTORY_TM | DATETIME (Local) | No |
History of instant of changes/touches of MSPQ for this contact
7 | CONTACT_DATE | DATETIME | No |
Date for this MSPQ History
8 | MSP_COMPLETION_ST_C_NAME | VARCHAR | No |
History of the MSPQ completion status for this contact.
May contain organization-specific values: Yes
Category Entries:
Blank
Complete
Partial