HSB_MPI_ID

Description:

This table includes Identity ID information for the Episode (HSB) master file.

Primary Key

Column Name	Ordinal Position
SUMMARY_BLOCK_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SUMMARY_BLOCK_ID	NUMERIC	No
	The ID of the Summary Block record.
2	LINE	INTEGER	No
	The line number of the related response item.
3	MPI_ID_TYPE	NUMERIC	No
	This item stores the MPI ID Type of the ID found in the MPI_ID column.
4	MPI_ID_TYPE_ID_TYPE_NAME	VARCHAR	No
	The name of the ID Type.
5	MPI_ID	VARCHAR	No
	The MPI ID associated with the MPI ID type found in the MPI_ID_TYPE column of this summary block record.
6	MPI_FROM_DATE	DATETIME	No
	This column contains the first date on which the Identity ID became effective.
7	MPI_TO_DATE	DATETIME	No
	This column contains the date on which the Identity ID will no longer be effective.
8	MPI_RET_CHK_PP_ID	NUMERIC	No
	This column contains the ID of the retrieval check programming point.
9	MPI_RET_CHK_PP_ID_LPP_NAME	VARCHAR	No
	The name of the extension.
10	MPI_RET_CHK_RULE_ID	VARCHAR	No
	This column contains the retrieval check rule.
11	MPI_RET_CHK_RULE_ID_RULE_NAME	VARCHAR	No
	The name of the rule.