CODE_INT_COMB_LN

Description: |
This table holds the combined service lines created by code integration.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HSP_ACCOUNT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HSP_ACCOUNT_ID | NUMERIC | No |
The unique identifier (.1 item) for the hosp acct record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | CODE_INT_REV_CODE_ID | NUMERIC | No |
This column stores the unique identifier for the revenue code for the combined service line.
4 | CODE_INT_REV_CODE_ID_REVENUE_CODE_NAME | VARCHAR | No |
The name of the revenue code.
5 | CODE_INT_CPT | VARCHAR | No |
This item holds the CPT(R)/HCPCS code for the combined service line.
6 | CODE_INT_MOD_1_ID | VARCHAR | No |
This column stores the unique identifier for the first modifier for the combined service line.
7 | CODE_INT_MOD_1_ID_MODIFIER_NAME | VARCHAR | No |
The name of the modifier record.
8 | CODE_INT_MOD_2_ID | VARCHAR | No |
This column stores the unique identifier for the second modifier for the combined service line.
9 | CODE_INT_MOD_2_ID_MODIFIER_NAME | VARCHAR | No |
The name of the modifier record.
10 | CODE_INT_MOD_3_ID | VARCHAR | No |
This column stores the unique identifier for the third modifier for the combined service line.
11 | CODE_INT_MOD_3_ID_MODIFIER_NAME | VARCHAR | No |
The name of the modifier record.
12 | CODE_INT_MOD_4_ID | VARCHAR | No |
This column stores the unique identifier for the fourth modifier for the combined service line.
13 | CODE_INT_MOD_4_ID_MODIFIER_NAME | VARCHAR | No |
The name of the modifier record.
14 | CODE_INT_RATE | NUMERIC | No |
This item holds the daily rate for the combined service line. The rate is only set for accommodation (room charge) revenue codes.
15 | CODE_INT_DATE | DATETIME | No |
This item holds the service date for the combined service line.
16 | CODE_INT_QTY | INTEGER | No |
This item holds the quantity (number of units) for the combined service line.
17 | CODE_INT_AMT | NUMERIC | No |
This item holds the full charge amount for the combined service line. The value includes any non-covered amount for the line.
18 | CODE_INT_NONCVRD | NUMERIC | No |
This item holds the non-covered amount for the combined service line.
19 | CODE_INT_LN_SRC_C_NAME | VARCHAR | No |
This item holds the source for the CPT(R)/HCPCS code and modifiers for the combined service line.
May contain organization-specific values: No
Category Entries:
Charge
Coding
Combined
SNF HIPPS
IRF HIPPS
Extension
Edited
20 | CODE_INT_UNUSED_YN | VARCHAR | No |
This item identifies lines that are not true service lines but represent coded CPT(R)/HCPCS codes that cannot be used to create actual service lines.
May contain organization-specific values: No
Category Entries:
No
Yes
21 | CODE_INT_CHRG_CNT | INTEGER | No |
This item holds the number of charges associated with the combined service line.
22 | CODE_INT_RSN_C_NAME | VARCHAR | No |
This item identifies the reason the coded CPT(R)/HCPCS code could not be used in an actual service line. This item is only set when the unused coded CPT(R)/HCPCS flag (CODE_INT_UNUSED_YN) is Yes.
May contain organization-specific values: No
Category Entries:
No revenue code assigned
User skipped
No charge with same revenue code
Inpatient claim
CMG code on non-inpatient claim
HCPCS/CPT® code suppressed by claim definitions
Accommodation revenue code
Grouped revenue code
Unspecified