BED_DAYS_MATCH

Description:

The BED_DAYS_MATCH table contains bed day information for claims. Different bed day types can have different weights which are applied to the quantity of bed day services to get a converted number of bed days for a referral.

Primary Key

Column Name	Ordinal Position
CLAIM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CLAIM_ID	NUMERIC	No
	The unique identifier of the accounts payable claim record.
2	LINE	INTEGER	No
	The line number for the bed types associated with this claim. Multiple bed types can be associated with this claim.
3	BED_DAY_TYPE_ID	NUMERIC	No
	This item stores the ID of the bed day type
4	BED_DAY_TYPE_ID_BED_DAY_TYPE_NAME	VARCHAR	No
	The name of the bed day type record (i.e. ICU or non-authorized.)
5	REL_WT_BED_DAY	NUMERIC	No
	This item stores the relative weight of the bed day type
6	BED_DAY_WT	NUMERIC	No
	This item stores the total weight of the bed day type
7	BED_DAY_QTY	NUMERIC	No
	This is used to store the quantity of the bed day type services
8	BED_DAY_CONV_RFL	NUMERIC	No
	Converted bed days for the bed day type on the referral