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:
Authorized
Denied
Pending Review
Closed
Withdrawn
Dismissed
No Authorization Required
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
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
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
23 ADDL_INFO_REQ_OVR_UTC_DTTM DATETIME (UTC) No
The user-override value of the additional information request instant for a bed day line.
24 ADDL_INFO_REQ_OVR_LOCAL_DTTM DATETIME (Local) No
The user-override value of the additional information request instant for a bed day line. This is a virtual copy of RFL 2411 that contains the system local time.
25 ADDL_INFO_RCPT_OVR_UTC_DTTM DATETIME (UTC) No
The user-override value of the additional information receipt instant for a bed day line.
26 ADDL_INFO_RCPT_OVR_LOCAL_DTTM DATETIME (Local) No
The user-override value of the additional information receipt instant for a bed day line. This is a virtual copy of RFL 2413 that contains the system local time.
27 ADDL_INFO_EXTENSION_TAKEN_YN VARCHAR No
Whether an additional information request extension was taken for the bed day line.
The category values for this column were already listed for column: ELECTRONIC_REQUEST_YN
28 MANUAL_EXTENSION_DAYS INTEGER No
The number of manual extension days taken for the bed day.
29 WITHDRAWN_BED_DAY_RSN_C_NAME VARCHAR No
Track the withdrawn reason for the current row in the bed days table.
May contain organization-specific values: Yes
No Entries Defined
30 DISMISSED_BED_DAY_RSN_C_NAME VARCHAR No
Track the dismissed reason for the current row in the bed days table.
May contain organization-specific values: Yes
No Entries Defined
31 NO_AUTH_RQ_BED_DAY_RSN_C_NAME VARCHAR No
Track the no authorization required reason for the current row in the bed days table.
May contain organization-specific values: Yes
No Entries Defined