REFERRAL_BED_DAY
Description:
The REFERRAL_BED_DAY table contains information on bed days on referrals.

Primary Key
Column Name Ordinal Position
REFERRAL_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 REFERRAL_ID NUMERIC No
The unique ID of the referral in database.
2 LINE INTEGER No
A line number that is used to identify a group of bed day information
3 START_DATE DATETIME No
The date on which the member is scheduled to start treatment associated with each bed day type
4 END_DATE DATETIME No
The date on which the member is scheduled to or actually does complete treatment associated with each bed day type.
5 BED_DAY_TYPE_ID NUMERIC No
The bed day type or classification used to categorize the scheduled days of treatment.
6 BED_DAY_TYPE_ID_BED_DAY_TYPE_NAME VARCHAR No
The name of the bed day type record (i.e. ICU or non-authorized.)
7 ESTIMATED_DAYS NUMERIC No
The estimated number of days the member spends in treatment associated with each bed day type.
8 CONVERTED_DAYS NUMERIC No
A manual conversion of the calculated number of Raw days for each bed day type, the raw days are calculated from the start and end date. Partial days are allowed
9 RAW_DAYS NUMERIC No
Displays the actual number of days the member spends in treatment associated with each bed day type, calculated from the start and end date. Partial days are allowed.
10 OVERRIDE_DAYS NUMERIC No
A manual override of the calculated number of days for each bed day type. Partial days are allowed.
11 AVOID_BED_DAY_RSN_C_NAME VARCHAR No
Track the avoidable bed day reason for the current row in the bed days table.
May contain organization-specific values: Yes
12 BED_DAYS_COMMENTS VARCHAR No
Track the comments for the current row in the bed days table. If the comment is more than 256 characters, it will be truncated to 256.
13 DEN_BED_DAY_RSN_C_NAME VARCHAR No
Track the denied reason for the current row in the bed days table.
May contain organization-specific values: Yes
14 BED_DAY_STATUS_C_NAME VARCHAR No
Track the Approved/Denied status for the current row in the bed days table.
May contain organization-specific values: No
Category Entries:
Approved
Denied
Pending Review
Closed
15 APPR_BED_DAY_RSN_C_NAME VARCHAR No
Track the approved reason for the current row in the bed days table.
May contain organization-specific values: Yes
16 REQUESTED_ON_UTC_DTTM DATETIME (UTC) No
Track the date and time the bed day was requested for the current row in the table.
17 DECIDED_ON_UTC_DTTM DATETIME (UTC) No
Track the date and time a decision was made on the bed day status for the current row in the table.
18 BED_DAY_PRIORITY_C_NAME VARCHAR No
The bed days request priority category ID for the bed day line on the referral record.
May contain organization-specific values: Yes
Category Entries:
Routine
Urgent
Emergency
Elective
Two Week Wait
See Details
19 PEND_BED_DAY_RSN_C_NAME VARCHAR No
Track the pending review reason for the current row in the bed days table.
May contain organization-specific values: Yes
No Entries Defined
20 CLOSED_BED_DAY_RSN_C_NAME VARCHAR No
Track the closed reason for the current row in the bed days table.
May contain organization-specific values: Yes
No Entries Defined
21 BED_DAY_AUTH_REQUEST_TYPE_C_NAME VARCHAR No
The request type of the bed day line.
May contain organization-specific values: No
Category Entries:
Proactive
Preservice
Concurrent
Retro
Externally Tracked
Appeal
22 ELECTRONIC_REQUEST_YN VARCHAR No
Tracks whether the request for the current row in the bed days table was made electronically. If set to electronic, the bed day period will also be evaluated for turnaround times for e-submissions.
May contain organization-specific values: No
Category Entries:
No
Yes