ARPB_TRANSACTIONS2

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 for the transaction record.
2	EB_PMT_TOTAL_AMT	NUMERIC	No
	Displays the enterprise payment total amount.
3	FIN_DIV_ID	NUMERIC	No
	The Financial Division for this transaction. Taken from the ETR listed or from the associated Bill Area, as found in ARPB_TRANSACTIONS
4	FIN_DIV_ID_BILL_AREA_NAME	VARCHAR	No
	The record name of this bill area, financial subdivision, or financial division.
5	FIN_SUBDIV_ID	NUMERIC	No
	The Financial Subdivision for this transaction. Taken from the ETR listed or from the associated Bill Area, as found in ARPB_TRANSACTIONS
6	FIN_SUBDIV_ID_BILL_AREA_NAME	VARCHAR	No
	The record name of this bill area, financial subdivision, or financial division.
7	RESEARCH_STUDY_ID_RESEARCH_STUDY_NAME	VARCHAR	No
	The name of the research study record.
8	RSH_MOD_TYPE_C_NAME	VARCHAR	No
	The research billing modifier type for a research study related charge. May contain organization-specific values: Yes Category Entries: Routine Investigational/Device
9	RSH_ORIG_ACCOUNT_ID	NUMERIC	No
	Stores the original patient account for charges billed to the guarantor account related to a research study.
10	OUTSTANDING_FLAG_C_NAME	VARCHAR	No
	The type of balance category ID for the transaction May contain organization-specific values: No Category Entries: Self-Pay Balance Only Insurance Balance Only Both Self-Pay and Insurance Balance
11	VST_DO_NOT_BIL_I_YN	VARCHAR	No
	This item indicates whether the visit has been marked as do not bill insurance. May contain organization-specific values: No Category Entries: No Yes
12	TREATMENT_PLAN_CSN	NUMERIC	No
	The contact serial number of the treatment plan that generated the order, which generated this charge.
13	TX_ENTERED_INSTANT_DTTM	DATETIME (UTC)	No
	The transaction entered instant (date and time in UTC) for manually posted payments. The transaction filing instant (date and time in UTC) for electronically posted payments.
14	CVG_PLAN_ON_PMT_ID_BENEFIT_PLAN_NAME	VARCHAR	No
	The name of the benefit plan record.
15	REVERSED_PMT_TX_ID	NUMERIC	No
	For the negation payment generated during a payment reversal, this item stores the transaction ID of the original payment.
16	PMT_REVERSAL_TX_ID	NUMERIC	No
	This virtual item returns the reversal transaction ID for a reversed payment.
17	STMT_HOLD_DT	DATETIME	No
	The most recent date on which the transaction was held from the Professional Billing statement processing.
18	STMT_HOLD_REASON_C_NAME	VARCHAR	No
	The reason why the transaction was held in PB statement processing. May contain organization-specific values: Yes Category Entries: Minimum guarantor account balance not met Credit balance on the guarantor account Guarantor account already on another run Guarantor account status not to bill Minimum days between two statements not met Guarantor address has no ZIP code Charge Homing is turned on and guarantor account is not in its home Skip guarantor account extension No professional balance and no hospital account to bill No hospital account to bill Guarantor account has a hospital account with a self-pay payment/adjustment posted today Guarantor account has a hospital account on payment plan that did not qualify Form not found Cannot demand if form requires importing images Undistributed non self-pay credits Undistributed self-pay payment Zero Charge Statement already processed this month for payment plan SmartText and Classic forms cannot be included in the same run Cannot send tickler to guarantor for paperless bill Minimum days between guarantor detail bill and statement not met Payment plan already paid for this month Guarantor has a balance notification scheduled or recently sent Payment plan is currently deferred, and guarantor has only plan balances Guarantor billing status not to bill Statement intervention Guarantor does not have new activity Guarantor does not have transactions to bill Excluded during printing Guarantor special billing status set to hold statements Visit auto pay scheduled Cannot send another statement before processing auto pay from the last statement Payment plan processing in progress Voided transactions Payor hold Transaction skip function Contested Debit adjustments Fully Paid Insurance Activity Visit is not discharged Posted Not Billed Consolidated Balance Transaction skip extension Service date range Small balance write off Client guarantor Client next statement date is not before or equal to end batch date
19	REPOST_REASON_C_NAME	VARCHAR	No
	If this transaction was reposted from another, this contains the category value of the reason the transaction was reposted. May contain organization-specific values: Yes Category Entries: Retroadjudication Transfer Reposted Payment Charge Correct Charge Router Repost Payment Reversal
20	SUSP_NRP_INDICATOR_YN	VARCHAR	No
	This item indicates whether NRP is currently suspended. The category values for this column were already listed for column: VST_DO_NOT_BIL_I_YN
21	SUSP_NRP_INST_DTTM	DATETIME (Local)	No
	This item stores the instant (date and time) when the next responsible party action was suspended.
22	SUSP_NRP_USER_ID	VARCHAR	No
	This item stores the suspended next responsible party user for the transaction.
23	SUSP_NRP_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
24	OUTST_CLM_STAT_C_NAME	VARCHAR	No
	The status of an outstanding claim that is attached to a transaction. May contain organization-specific values: Yes Category Entries: Not Outstanding Outstanding Denied Suspended NRP
25	POS_TYPE_C_NAME	VARCHAR	No
	Place of service type for a charge transaction. May contain organization-specific values: Yes Category Entries: Telehealth - Provided in Patient's Home Office Home Assisted Living Facility Group Home Mobile Unit Temporary Lodging Walk-in Retail Health Clinic Place of Employment - Worksite Off Campus - Outpatient Hospital Urgent Care Facility Inpatient Hospital On Campus - Outpatient Hospital Emergency Room - Hospital Ambulatory Surgical Center Birthing Center Military Treatment Facility Outreach Site/Street Skilled Nursing Facility Nursing Facility Custodial Care Facility Hospice Adult Living Care Facility Ambulance - Land Ambulance - Air or Water Independent Clinic Federally Qualified Health Center Inpatient Psychiatric Facility Psychiatric Facility - Partial Hospitalization Community Mental Health Center Intermediate Care Facility/ Individuals with Intellectual Disabilities Residential Substance Abuse Treatment Facility Psychiatric Residential Treatment Center Non-residential Substance Abuse Treatment Facility Non-residential Opioid Treatment Facility Mass Immunization Center Comprehensive Inpatient Rehabilitation Facility Comprehensive Outpatient Rehabilitation Facility End-Stage Renal Disease Treatment Facility Programs of All-Inclusive Care for the Elderly (PACE) Center Public Health Clinic Rural Health Clinic Independent Laboratory Other Place of Service Pharmacy Telehealth - Provided Other than in Patient's Home School Homeless Shelter Indian Health Service Free-standing Facility Indian Health Service Provider-based Facility Tribal 638 Free-standing Facility Tribal 638 Provider-based Facility Prison/Correctional Facility
26	INACTIVE_TYPE_C_NAME	VARCHAR	No
	This column returns the type of an inactive transaction. Inactive transactions are those involved in a void or reversal. This item subcategorizes the transaction's role in the void or reversal. This will be for both the actual voided/reversed credit and the associated negation payment or debit adjustment. May contain organization-specific values: No Category Entries: Voided Credit Reversed Using Debit Adjustment Payment Reversed Using Negation Payment Negation Payment Used in Reversal Debit Adjustment Used to Reverse Credit $0 Debit Adjustment Used in Reversal By Negation
27	VOIDED_INS_AMT	NUMERIC	No
	The total amount owed from insurance at the time a charge was voided. This includes previously applied payments and adjustments.
28	PROV_NETWORK_STAT_C_NAME	VARCHAR	No
	Basic indicator of whether a provider was in or out of network on the service date of a transaction May contain organization-specific values: No Category Entries: Out of Network In Network Self-Pay
29	NETWORK_LEVEL_C_NAME	VARCHAR	No
	The provider's level of network involvement category ID for the transaction. May contain organization-specific values: Yes Category Entries: Not Leveled
30	SPEC_CHG_TYPE_C_NAME	VARCHAR	No
	The special type category ID for the charge. May contain organization-specific values: No Category Entries: Radiation Therapy Rollup Dental Predetermination
31	ORIG_BUNDPMT_ETR_ID	NUMERIC	No
	The original bundled payment transaction ID.
32	ORIG_BUNDPMT_HTR_ID	NUMERIC	No
	The original bundled payment hospital transaction ID.
33	REFERENCE_AMT	NUMERIC	No
	Holds the reference amount that is calculated based on the financial class for the charge. This is set by the system and is applicable only to charges.
34	REFERENCE_AMT_SRC_C_NAME	VARCHAR	No
	Holds the source of the reference amount that is used in the calculation of the reference amount. This is set by the system and is applicable only to charges. May contain organization-specific values: No Category Entries: Reference Amount Fee Schedule Charge Price External Price Reference Amount Override
35	CLM_RMV_RSN_C_NAME	VARCHAR	No
	Stores the reason charge was removed from the claim queue. May contain organization-specific values: No Category Entries: Unspecified No coverage on charge No payer on charge No benefit plan on charge No account on charge No patient on charge Transaction is not a charge Voided charge Radiation therapy charge SBO default account Insurance balance is negative Zero value charge Bad debt charge Insurance balance is zero Resubmitted charge with zero insurance balance Payer on charge does not match payer on claim Charge held for case rate billing Internal payer Additional claim run restriction Reject from claim edit WQ No Claim flag set on temporary transaction Accept assignment flag set to No Secondary write-off Payer on pharmacy charge is adjudicated Charge on Posted Not Billed Demanded charge with non-positive insurance balance Initial charge with non-positive insurance balance Resubmitted charge with non-positive insurance balance
36	ADJUSTMENT_CAT_C_NAME	VARCHAR	No
	Stores the adjustment category of the associated adjustment code when the credit adjustment is posted. May contain organization-specific values: Yes Category Entries: Refund NSF Adjustment/Fee Contractual Charity Capitation Discount Late Fee Bad Debt Write Off PLB Adjustment Escheat Administrative External AR Write Off Payment Reversal Underpayment Denied - Timely Filing Denied - Medical Necessity Denied - Missing Documentation Denied - No Auth Denied - Registration Denied - Miscellaneous Other Allowance Estimate Variance Write Off Resident Trust Account Downgrade
37	WRITE_OFF_RSN_C_NAME	VARCHAR	No
	The reason a credit adjustment was posted. This is determined programmatically when possible (e.g. contractual adjustments, self-pay discounts). Otherwise, this is the write-off reason associated with the adjustment category for this adjustment. May contain organization-specific values: No Category Entries: Contractual Self-Pay Discount/Charity Other Allowance Bad Debt/External AR Administrative Underpayment Denied - Timely Filing Denied - Medical Necessity Denied - Missing Documentation Denied - No Auth Denied - Registration Denied - Miscellaneous PLB Adjustment Estimate Variance Capitation Downgrade N/A - Payment Refund/Reversal N/A - Resident Trust Account
38	SCHED_PMT_ID	NUMERIC	No
	Stores the scheduled payment record that resulted in this payment.
39	TAX_CHARGE_TX_ID	NUMERIC	No
	Stores the source transaction for a tax charge
40	PATIENT_ESTIMATE_ID	NUMERIC	No
	This column contains the Patient Estimate (PES) record ID for a dental estimate that is finalized and is linked to this charge. If the charge was triggered from dental and if there is a dental estimate associated with the encounter (in a status of "Finalized"), that estimate's record ID will be stored in ETR item 1801 and extracted in this column. The item and column are not updated if and when the original finalized estimate is replaced.
41	PATIENT_WISDOM_PROC_ID	NUMERIC	No
	Patient dental procedure that was respected by the temporary transaction that filed into this transaction.
42	RFL_OVRIDE_SRC_C_NAME	VARCHAR	No
	This item stores the referral override source. The options are 1-User or 2-System. May contain organization-specific values: No Category Entries: User System Charge Router Handler
43	RFL_OVRIDE_USER_ID	VARCHAR	No
	This item stores the user who overrode the referral associated with this charge.
44	RFL_OVRIDE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
45	PARENT_SCHED_PMT_ID	NUMERIC	No
	Stores the parent scheduled payment record that resulted in this payment.
46	MANUAL_PRICE_OVRIDE_YN	VARCHAR	No
	Permanent transaction indicator used during repost/correct/retro to determine if the charge's price was originally overridden. The category values for this column were already listed for column: VST_DO_NOT_BIL_I_YN
47	IS_PRE_SERVICE_PMT_YN	VARCHAR	No
	Indicates whether or not this is a pre-service payment, such as a co-pay. This item is only populated for self-pay payments. A payment is considered pre-service if it is a visit pre-pay or co-pay payment (such as during check-in). The category values for this column were already listed for column: VST_DO_NOT_BIL_I_YN
48	FIRST_HTR_TX_ID	NUMERIC	No
	Stores the hospital transaction ID of the first transaction in a chain of transactions. Note that this chain will include transactions from both Hospital Billing and Professional Billing, so this item will return the very first transaction. For a given transaction, either column ARPB_TRANSACTIONS2.FIRST_HTR_ID, or column ARPB_TRANSACTIONS2.FIRST_ETR_ID will be populated. This is different from column ARPB_TRANSACTIONS2.FIRST_TX_ID, which only chains back to the point that the transaction was transferred from Hospital Billing.
49	FIRST_ETR_TX_ID	NUMERIC	No
	Stores the transaction ID of the first transaction in a chain of transactions. Note that this chain will include transactions from both Hospital Billing and Professional Billing, so this item will return the very first transaction. For a given transaction, either column ARPB_TRANSACTIONS2.FIRST_HTR_ID, or column ARPB_TRANSACTIONS2.FIRST_ETR_ID will be populated. This is different from column ARPB_TRANSACTIONS2.FIRST_TX_ID, which only chains back to the point that the transaction was transferred from Hospital Billing.
50	POSTING_DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
51	EXP_REIMB_SYS_AMT	NUMERIC	No
	The item stores the original reimbursement amount calculated by contract if the original reimbursement amount is overridden.
52	EXP_REIMB_SRC_C_NAME	VARCHAR	No
	The item stores how the reimbursement amount was calculated for the charge. May contain organization-specific values: No Category Entries: System Calculated Contract Overridden Expected Amounts Overridden Overridden by Wisdom Estimate
53	RECORD_STATUS_C_NAME	VARCHAR	No
	This column displays the transaction record status. May contain organization-specific values: No Category Entries: Active Inactive Deleted Inactive and Deleted Hidden Inactive and Hidden Deleted and Hidden Inactive Deleted and Hidden
54	RESEARCH_ENROLL_ID	NUMERIC	No
	The unique ID of the research study association linked to this charge.
55	STMT_HOLD_RSN_TEXT	VARCHAR	No
	The free text information related to the reason why the transaction was held in Professional Billing statement processing.
56	E_PMT_RECEIPT_MSG	VARCHAR	No
	Saves the receipt message received from the gateway for an electronic payment transaction.
57	PARENT_TX_ID	NUMERIC	No
	This column contains the charge ID that created this transaction during transaction filing. This is used for anesthesia supplemental charges, charge quantity splitting, and charge shadowing.