PAT_ENC_BCB_HST
Description:
Extracts information regarding the bed charge billing history for a patient's encounter.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4 PAT_ENC_DATE_REAL FLOAT No
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
5 BED_CHARGE_DATE DATETIME No
The dates that bed charges have been generated for this patient.
6 HTR VARCHAR No
Link to the transaction that represents the bed charge on the hospital account record (HAR).
7 BED_CHARGE_BCC_ID NUMERIC No
The unique ID of the cost center record associated with the bed charge.
8 BED_CHARGE_BCC_ID_COST_CENTER_NAME VARCHAR No
The name of the cost center.
9 BED_CHARGE_UNIT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
10 BED_CHARGE_PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
11 BED_CHARGE_DTTM DATETIME (Local) No
Contains the instant for which the bed charge was dropped.
12 BED_CHARGE_ROOM_ID_ROOM_NAME VARCHAR No
The name of the Room record.
13 BED_CHARGE_BED_ID VARCHAR No
The unique ID of the bed where the patient is charged for.
14 BED_CHARGE_BED_ID_BED_LABEL VARCHAR No
The name of the bed.
15 BED_CHARGE_ACCOMMODATION_C_NAME VARCHAR No
The accommodation code category ID the patient is charged for.
May contain organization-specific values: Yes