HEART_RANKING_STATUS_HX

Description:

This table condenses heart status history to a start date and expiration date, and a pointer to the line in TXP_HEART_STATUS_HX where the details can be found.

Primary Key

Column Name	Ordinal Position
SUMMARY_BLOCK_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	SUMMARY_BLOCK_ID	NUMERIC	No
	The unique identifier (.1 item) for the episode 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	START_DT	DATETIME	No
	The date when the heart status in this row became active.
4	END_DT	DATETIME	No
	The date when the heart status in this row expired.
5	SOURCE_LINE	INTEGER	No
	The line in heart status history (HSB 30417) for this heart status. This corresponds to the LINE column in TXP_HEART_STATUS_HX.