IDENTITY_HQA_ID_HX

Description:

This table contains the system Master Person Index (MPI) ID history for questionnaire answers. Each questionnaire answer may have multiple MPI IDs. A line number is used to identify each identification number for a questionnaire answer. A row will only exist in this table if an ID is no longer valid for a questionnaire answer record.

Primary Key

Column Name	Ordinal Position
ANSWER_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ANSWER_ID	VARCHAR	No
	The unique identifier (.1 item) for the answer record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	MPI_HX_IDENTITY_ID	VARCHAR	No
	The historical identifier - if any - that resulted from the audit event.
4	MPI_HX_INSTANT_DTTM	DATETIME (Attached)	No
	The instant at which the audit event was logged for the identifier.
5	MPI_HX_IDENTITY_TYPE_ID	NUMERIC	No
	The ID Type (IIT) ID of the identifier.
6	MPI_HX_IDENTITY_TYPE_ID_ID_TYPE_NAME	VARCHAR	No
	The name of the ID Type.
7	MPI_HX_USER_ID	VARCHAR	No
	The User (EMP) ID that triggered the audit event for the identifier.
8	MPI_HX_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	MPI_HX_AUDIT_CHG_TYPE_C_NAME	VARCHAR	No
	The audit event type for the update made to the identifier. May contain organization-specific values: No Category Entries: NEW CHANGE DELETED MERGE UNMERGE EXPIRED
10	MPI_HX_NEW_ID	VARCHAR	No
	The new identifier - if any - that resulted from the audit event.
11	MPI_HX_DOTONE	VARCHAR	No
	The internal Chronicles ID of the record for which this audit event was logged.
12	MPI_HX_ID_EFF_FROM_DATE	DATETIME	No
	The effective "from" date - if it is new or updated - for the identifier.
13	MPI_HX_ID_EFF_TO_DATE	DATETIME	No
	The effective "to" date - if it is new or updated - for the identifier.