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