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