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