|
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 |
|
|