ARPB_TX_MODERATE
Description:
Transaction Information that is used moderately often.

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 ORIGINATING_TAR_ID NUMERIC No
This item holds the originating temporary transaction ID for this transaction. If the transaction is a charge, then the originating temporary transaction ID will be the temporary transaction ID of the charge. If transaction is a payment, then the originating temporary transaction ID will be the payment temporary transaction ID unless the payment is from fast payment. In the fast payment case, the originating temporary transaction ID will be the charge temporary transaction ID.
3 SOURCE_TAR_ID NUMERIC No
This item holds the source temporary transaction ID for this transaction. The source temporary transaction ID will always be equal to the temporary transaction ID that generates the transaction.
4 SRC_TAR_CHG_LINE INTEGER No
Indicates the temporary transaction charge line this transaction originated from.
5 PAT_AGING_DATE DATETIME No
Aging date used for self-pay aged A/R
6 INS_AGING_DATE DATETIME No
Aging date used for insurance aged A/R
7 HOSP_ACCT_ID NUMERIC No
This item stores the hospital account record ID for the transaction.
8 ORDER_ID NUMERIC No
The unique ID of the order record that triggered this transaction. This item is not always populated if you use the Charge Router.
9 EXT_REF_NUM VARCHAR No
External reference number. This is a customer item that can be populated as they see fit. Typically, this item is populated with data from an external system via an interface or transaction import.
10 REFERENCE_NUM VARCHAR No
This item stores the reference number (check number) for a payment transaction.
11 PMT_RECEIPT_NUM VARCHAR No
This item stores the receipt number for a payment transaction.
12 PAT_TYPE_C_NAME VARCHAR No
This item stores the patient type for the patient on this transaction.
May contain organization-specific values: Yes
13 REFERRAL_PROV_ID VARCHAR No
This stores this transaction's referral provider. Note that this field is linked to the referral source master file and not the provider master file.
14 REFERRAL_PROV_ID_REFERRING_PROV_NAM VARCHAR No
The name of the referral source.
15 INSURANCE_AMT_PAID NUMERIC No
This item stores the insurance amount that has been paid on a charge transaction.
16 WRITEOFF_EXCEPT_C_NAME VARCHAR No
The Yes-No write-off category number for a charge transaction. The value indicates whether the charge transaction was adjudicated as a write-off in charge entry and thus the insurance portion write-off is suppressed.
May contain organization-specific values: No
Category Entries:
Yes
Yes, No NCC either
17 PAT_LOCATION_ID_LOC_NAME VARCHAR No
The name of the revenue location.
18 ORIG_PRICE NUMERIC No
This item stores the original price of the transaction if the price was changed during charge entry.
19 EXP_REIMB_DYNAMIC NUMERIC No
The expected reimbursement will be updated whenever reimbursement is calculated. This amount cannot exceed the charge amount.
20 EXPECTED_REIMB NUMERIC No
The expected reimbursement calculated at charge entry. This item is not updated by any change during claims. Also, this amount cannot exceed the charge amount.
21 COVERAGE_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
22 CVG_PLAN_GROUP_ID VARCHAR No
This item stores the employer group (PPG) ID that is associated with this transaction.
23 CVG_PLAN_GROUP_ID_PLAN_GRP_NAME VARCHAR No
The name of the employer group record
24 MED_NEC_YN VARCHAR No
This is the flag that is set in charge entry if medical necessity is needed for a transaction.
May contain organization-specific values: No
Category Entries:
Yes
No
25 TECHNICAL_CHG_FL_YN VARCHAR No
This flag is set to yes if the transaction is a technical charge. This is only populated if using the split billing functionality.
The category values for this column were already listed for column: MED_NEC_YN
26 CNTR_DISCOUNT_AMT VARCHAR No
This item stores the pricing contract discount amount for a transaction.
27 UNDIST_TX_DATE DATETIME No
This items stores the date that a transaction was undistributed (unmatched).
28 UNDIST_CHG_USER_ID VARCHAR No
This item stores the user that unmatched a transaction.
29 UNDIST_CHG_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
30 UNDIST_INSTANT DATETIME (Local) No
This item stores the instant that a transaction was undistributed (unmatched).
31 ORIGINAL_AMT_COPAY NUMERIC No
This item stores the original copay amount for the transaction.
32 BAD_DEBT_CHG_YN VARCHAR No
Indicates whether the charges is written off to bad debt.
May contain organization-specific values: No
Category Entries:
No
Yes
33 AUTO_PAT_WO_C_NAME VARCHAR No
This item stores if a transaction had its self-pay portion automatically written off.
May contain organization-specific values: No
Category Entries:
Yes
yes and new SST
34 TX_USER_COMMENT VARCHAR No
The comments entered by users when they perform an action like transfer, retro, void, and undistribute on a transaction in Transaction Inquiry are stored in this item.
35 CONTESTED_YN VARCHAR No
This item stores a flag to determine if a transaction is contested.
May contain organization-specific values: No
Category Entries:
No
Yes
36 CONTEST_REASON_C_NAME VARCHAR No
This item stores the reason that a transaction is contested if the transaction is contested.
May contain organization-specific values: Yes
Category Entries:
Not Contested
Contested
Contested at Visit Account Level
Not Contested at Visit Account Level
37 MEA_IDENTIFIER_C_NAME VARCHAR No
This item stores the measurement (MEA) identifiers that are entered in charge entry.
May contain organization-specific values: Yes
Category Entries:
Original/Starting dosage
Test Results
38 CRC_CODE_C_NAME VARCHAR No
This item stores the CRC code entered in charge entry.
May contain organization-specific values: Yes
Category Entries:
E1 - Spectacle Lenses
E2 - Contact Lenses
E3 - Spectacle Frames
39 REIMB_CONTRACT_AMT NUMERIC No
Stores the allowed amount as calculated by the reimbursement contract. This amount can exceed the charge amount.
40 EXT_CUR_AGENCY_ID NUMERIC No
The current collections agency.
41 EXT_CUR_AGENCY_ID_COLL_AGENCY_NAME VARCHAR No
The name of the collection agency.
42 EXT_CURAGNCY_STAT_C_NAME VARCHAR No
The current agency status category ID for the transaction.
May contain organization-specific values: No
Category Entries:
Sent to Agency
Returned
43 EXTERNAL_ID VARCHAR No
This item stores the external transaction ID
44 SURGICAL_LOG_ID VARCHAR No
The unique ID associated with the surgical log record for this row. This column is frequently used to link to the OR_LOG table. This item is populated if charge is entered from OpTime.
45 SUPPLY_ID VARCHAR No
The unique ID associated with the supply record for this row. This column is frequently used to link to the OR_SPLY table.
46 SUPPLY_ID_SUPPLY_NAME VARCHAR No
The name of the inventory item.
47 IMPLANT_ID VARCHAR No
The unique ID associated with the implant record for this row. This column is frequently used to link to the OR_IMP table.
48 EXT_AGNCY_SENT_DTTM DATETIME (Local) No
The instant the charge was sent to its current agency.
49 FIRST_SELFPAY_DATE DATETIME No
This items stores the date when a charge first goes to self-pay.
50 PROV_TYPE_C_NAME VARCHAR No
The provider type for the transaction.
May contain organization-specific values: Yes
Category Entries:
Resource
Physician
51 CLAIM_ID NUMERIC No
The claim record for the transaction.
52 IS_WK_COMP VARCHAR No
Indicates whether the transaction is for worker's comp.
53 EOB_UPDATED_DT DATETIME No
Date in which the Explanation of Benefits for this transaction was last updated.
54 RAD_THER_COMP_TX_ID NUMERIC No
This item stores the ID for radiation therapy component transactions and rollup charges.
55 RAD_THER_END_YN VARCHAR No
Indicates whether Radiation Therapy is at the end of treatment for this transaction.
May contain organization-specific values: No
Category Entries:
NO
YES
56 START_TIME DATETIME (Local) No
Start time of a timed procedure.
57 STOP_TIME DATETIME (Local) No
Stop time of a timed procedure.
58 SERVICE_TIME DATETIME (Local) No
Time when service is performed.
59 PURCHASESERVICE_AMT NUMERIC No
This is the amount paid for or to be paid to a third party for performing a service. This field is used to report this amount on claims and statements along with price being charged to the payor or guarantor for the service. This item should only be used if it is desired this purchased service information be reported on claims and statements.
60 THIRD_PARTY_POS_ID_LOC_NAME VARCHAR No
The name of the revenue location.
61 MNL_RETRO_REASON_C_NAME VARCHAR No
The retroadjudication reason category ID for the transaction
May contain organization-specific values: Yes
Category Entries:
Other
Addition/Deletion/Change in Patients
Change Patient Covered Flag
Change Patient Effective Date
Change Coverage Effective Date
New Coverages
Add Member
Change Member Effective Date
Remove Member
Add Account
Change Benefit Plan on Employer Group
Change Coverage Term Date
Change Member Term Date
Change Covered Status
Change Riders on Employer Group
Remove Benefit Plan from Employer Group
Change Activation Date on Employer Group
Change Termination Date on Employer Group
Change Effective Date due to Group Term Date
Change Term Date due to Group Effective Date
Change Coverages
Change Visit Coverage
62 TYPE_OF_SERVICE_C_NAME VARCHAR No
The type of service category number associated with the transaction.
May contain organization-specific values: Yes
Category Entries:
Medical Care
Surgery
Consultation
Diagnostic Radiology
Diagnostic Laboratory
Therapeutic Radiology
Anesthesia
Assistant at Surgery
Other Medical Items or Services
Whole Blood
Used Durable Medical Equipment (DME)
Ambulatory Surgical Center (Facility usage for Surgical Services)
Hospice (Obsolete, Discontinued 1/95)
ESRD Supplies
Monthly Capitation Payment for Dialysis
Kidney Donor
Pneumococcal/Flu Vaccine
Second Opinion on Elective Surgery (Obsolete)
Third Opinion on Elective Surgery (Obsolete)
Diagnostic Medical (Obsolete)
Ancillaries, Hospital and Nursing Home (Obsolete)
Drug Services (Obsolete)
Accommodations, Hospital and Nursing Home (Obsolete)
Dental (Obsolete)
Vision Care and Cataract Lens (Obsolete)
Nuclear Medicine (Obsolete)
Diagnostic X-Ray (Professional) (Obsolete)
Rental of DME
Radiation Therapy (Professional) (Obsolete)
Diagnostic Lab (Professional) (Obsolete)
Diagnostic Medical (Professional) (Obsolete)
DME Purchase (Obsolete)
CRD Equipment (Obsolete)
Pre-Admission Testing (Obsolete)
EPSDT
High Risk Screening Mammography
Low Risk Screening Mammography
Ambulance
Enteral/Parenteral Nutrients/Supplies
Immunosuppressive Drugs
Diabetic Shoes
Hearing Items and Services
Lump Sum Purchase of DME, Prostethics, Orthotics
Vision Items or Services
Surgical Dressings or Other Medical Supplies
Psychological Therapy
Occupational Therapy
Physical Therapy
Medication (Obsolete)
Chiropractic Care
DME Prescription
63 DX_PRIM_CODESET_C_NAME VARCHAR No
This item stores the primary diagnosis codeset for the transaction.
May contain organization-specific values: Yes
Category Entries:
ICD-9-CM
ICD-10-CM
ICD-10-CA
ICD-10-UK
DBC
ICD-10 Dutch
ICD-10-AM
A&E Diagnoses
SKS
ICD-10-THL
ICPC-2
ICD-O-3
ICD-10-GM
ICD-9-CM Supplemental
ICD-10-BE
ICD-10-NO
Apache
DSM-5
KinCor
ORPHA
SNOMED CT
64 DX_ALT_CODESET_C_NAME VARCHAR No
This item stores the alternate diagnosis codeset for the transaction.
The category values for this column were already listed for column: DX_PRIM_CODESET_C_NAME
65 START_DATE DATETIME No
The date on which a service is started.
66 STOP_DATE DATETIME No
The date on which a service was stopped.
67 PROC_MINUTES INTEGER No
The length of time in minutes that this procedure took.
68 CRD_CHARGE_SLIP_NO NUMERIC No
The encounter form number associated with copay payments entered during scheduling.