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 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.
10 SPLIT_RELATED_HAR_RULE_ID_RULE_NAME VARCHAR No
The name of the rule.
11 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
12 REV_SPEC_GROUPER_ID_GROUPER_NAME VARCHAR No
Record name
13 REV_SUBSPEC_GROUPER_ID_GROUPER_NAME VARCHAR No
Record name