HSP_ACCT_BLD_REV

Description:

This table contains blood review information from the Hospital Accounts Receivable (HAR) master file.

Primary Key

Column Name	Ordinal Position
HSP_ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account with associated blood review information.
2	LINE	INTEGER	No
	The line number in the results of a query. Each blood review will have its own line number.
3	BLD_RVW_UNITS	INTEGER	No
	Number of blood units used for the blood review associated with the hospital account.
4	BLD_RVW_DT	DATETIME	No
	Date of blood review associated with hospital account.
5	BLD_RVW_PHYS_ID	VARCHAR	No
	This column stores the unique identifier for the physician who did the blood review associated with the hospital account.
6	BLD_RVW_COMP_C_NAME	VARCHAR	No
	This column stores the blood component of the blood review associated with the hospital account. e.g., Cryoprecipitate, Fresh frozen plasma, Platelets, Packed red blood cells, etc. May contain organization-specific values: Yes
7	BR_CRIT_MET_C_NAME	VARCHAR	No
	Were the criteria of the blood review associated with the hospital account met? 1-yes 2-no 3-N/A May contain organization-specific values: No Category Entries: Yes No N/A