ARPB_TRANSACTIONS4

Description: |
This table contains information about professional billing transactions.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique identifier (.1 item) for the transaction record.
2 | ENC_CLOSE_UTC_DTTM | DATETIME (UTC) | No |
The instant the encounter was closed
3 | IS_LATE_CHARGE_YN | VARCHAR | No |
Indicates whether the charge was posted after the visit was billed
May contain organization-specific values: No
Category Entries:
No
Yes
4 | ENC_POST_LAG | INTEGER | No |
When the charge posted after the encounter closed and is sent on a claim, this is the difference in seconds between the encounter close and the post instant. Otherwise, it is not set.
5 | FIRST_CLAIM_SENT_LAG | INTEGER | No |
The number of seconds between the encounter close and the first claim sent for the charge
6 | LAST_CLAIM_SENT_LAG | INTEGER | No |
The number of seconds between the encounter close and the last claim sent for the charge
7 | OVR_IGNORE_SYS_CONTRACT_YN | VARCHAR | No |
This item is set to 1-Yes when there is a system calculated contract populated in I ETR 274, but an override action has taken place such that this reimbursement contract should be ignored.
The category values for this column were already listed for column: IS_LATE_CHARGE_YN
8 | SPLIT_RELATED_HAR_TYPE_C_NAME | VARCHAR | No |
Identifies the system calculated related HAR type (I HAR 146) of the HAR that this charge will be split to.
May contain organization-specific values: Yes
Category Entries:
Elective Services
ED/Inpatient Split Billing
Leave of Absence / Bed Hold
Interrupted Stay
Separate Service Area Billing
Home Infusion Medical Benefits
Received Self-Pay
Shadow Billing
Home Infusion Bypass
PAS LPR Hospital at Home Visit
Other
9 | DELEGATE_BILL_SOURCE_TX_ID | NUMERIC | No |
The source Tapestry ETR that the charge is linked to.
10 | SPLIT_RELATED_HAR_RULE_ID | VARCHAR | No |
Indicates the rule in the PB Profile that qualified the charge for the related visit account type stored in item 16801.
11 | SPLIT_RELATED_HAR_RULE_ID_RULE_NAME | VARCHAR | No |
The name of the rule.
12 | OVRD_SPLIT_RELATED_HAR_TYPE_C_NAME | VARCHAR | No |
Identifies the manually overridden related HAR type (I HAR 146) of the HAR that this charge will be split to.
The category values for this column were already listed for column: SPLIT_RELATED_HAR_TYPE_C_NAME
13 | REV_SPEC_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name
14 | REV_SUBSPEC_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name
15 | MEDICATION_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
16 | SPLIT_RELATED_HAR_SOURCE_C_NAME | VARCHAR | No |
Tracks how the related visit account type stored in ETR item 16801/16803 was set.
May contain organization-specific values: No
Category Entries:
User
System
Charge Router Handler
17 | DELEGATE_BILL_SOURCE_CLAIM_ID | NUMERIC | No |
The source Tapestry CLM that the charge is linked to.