BUNDLE_CHARGE_MAIN
Description:
Main bundleable charge line table.

Primary Key
Column Name Ordinal Position
RECORD_ID 1

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier (.1 item) for the bundleable charge line record.
2 PROC_ID NUMERIC No
The unique ID of the procedure that is associated with this bundleable charge line.
3 ACCT_ID NUMERIC No
The unique ID of the account that is associated with this bundleable charge line record.
4 ACCT_SERIAL_NUM INTEGER No
The account serial number associated with this charge.
5 CVG_ID NUMERIC No
The unique ID of the coverage that is associated with this bundleable charge line record.
6 DO_NOT_BILL_INS_YN VARCHAR No
Indicates whether to not bill insurance for this charge. Y indicates that the charge should not be billed to insurance.
May contain organization-specific values: No
Category Entries:
No
Yes
7 SERVICE_DATE DATETIME No
The date of service for this charge.
8 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.
9 REQ_GROUPER_ID NUMERIC No
The unique ID of the requisition grouper that is associated with this bundleable charge line record.
10 SUBMITTER_ID NUMERIC No
The unique ID of the submitter that is associated with this bundleable charge line record.
11 SUBMITTER_ID_RECORD_NAME VARCHAR No
The name of the submitter record.
12 PAYOR_ID NUMERIC No
The unique ID of the payor that is associated with this bundleable charge line record.
13 FINANCIAL_CLASS_C_NAME VARCHAR No
The financial class category number for the bundleable charge line record.
May contain organization-specific values: Yes
Category Entries:
Commercial
Medicare
Medicaid
Self-Pay
Worker's Comp
Tricare
Champva
Group Health Plan
FECA Black Lung
Blue Shield
Medigap
Other
DK Regional
Client
Received Self-Pay
Sent to Consolidated Self-Pay Service Area
14 ORDERING_DEPT_ID NUMERIC No
The unique ID of the department that is associated with this bundleable charge line record.
15 PERFORMING_LAB_ID VARCHAR No
The unique ID of the performing lab that is associated with this bundleable charge line record.
16 CHARGE_TYPE_C_NAME VARCHAR No
The linked charge type category ID for the bundleable charge line.
May contain organization-specific values: No
Category Entries:
Professional
Technical
Global
17 NOT_CHARGE_REASON_C_NAME VARCHAR No
The category ID of the reason the charge was voided.
May contain organization-specific values: Yes
Category Entries:
Other
CAP testing
Credit
Duplicate (confirmatory) testing
Employee testing
Non-human testing
Test ordered on wrong patient
Wrong test ordered
18 NOT_CHARGE_USER_ID VARCHAR No
The unique ID of the user who voided this charge.
19 NOT_CHARGE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
20 NOT_CHARGE_COMMENT VARCHAR No
The comment entered by the user who voided this charge.
21 NOT_CHARGE_UTC_DTTM DATETIME (UTC) No
The date and time when this charge was voided.
22 TASK_ID_C_NAME VARCHAR No
The task category ID that triggered the charge.
May contain organization-specific values: Yes
23 PERFORMING_DEPT_ID NUMERIC No
The unique ID of the performing department that is associated with this bundleable charge line record.
24 BILL_PROV_ID VARCHAR No
The unique ID of the billing provider that is associated with this bundleable charge line record.
25 SERV_PROV_ID VARCHAR No
The unique ID of the service provider that is associated with this bundleable charge line record.
26 PAT_CSN NUMERIC No
The unique patient contact series number that is associated with this bundleable charge line record.