HSP_TRANSACTIONS_2

Description: |
This table contains hospital account transaction information from the Hospital Permanent Transactions (HTR) master file.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
This column stores the unique identifier for the hospital billing transaction.
2 | REL_ACCL_INS_BKT_ID | NUMERIC | No |
This column stores the unique identifier for the insurance bucket on the accelerated self-pay adjustment transaction in the self-pay bucket.
3 | IMPLIED_QTY | NUMERIC | No |
The implied quantity for the order at the time this charge was dropped. This represents the quantity used to calculate the billing quantity on a pharmacy charge.
4 | IMPLIED_QTY_UNIT_C_NAME | VARCHAR | No |
This column stores the implied unit for the order at the time a charge was dropped. This represents the unit of the quantity used to calculate the billing quantity on a pharmacy charge.
May contain organization-specific values: Yes
Category Entries:
mL
L
mg
g
Units
mmol
mEq
mcg
%
Int'l Units
Million Units
kcal
ng
mg PE
milli-units
pg
KBq
MBq
GBq
mcL
mL/min
L/min
mg/min
g/min
Units/min
mmol/min
mEq/min
mcg/min
kJ/min
Int'l Units/min
Million Units/min
kcal/min
ng/min
mg PE/min
milli-units/min
pg/min
KBq/min
MBq/min
GBq/min
mcL/min
mL/hr
L/hr
mg/hr
g/hr
Units/hr
mmol/hr
mEq/hr
mcg/hr
kJ/hr
Int'l Units/hr
Million Units/hr
kcal/hr
ng/hr
mg PE/hr
milli-units/hr
pg/hr
KBq/hr
MBq/hr
GBq/hr
mcL/hr
mL/day
L/day
mg/day
g/day
Units/day
mmol/day
mEq/day
mcg/day
kJ/day
Int'l Units/day
Million Units/day
kcal/day
ng/day
mg PE/day
milli-units/day
pg/day
Inch/day
KBq/day
MBq/day
GBq/day
mcL/day
IR/day
BAU/day
PFU/day
Million PFU/day
Million Int'l Units/day
Kilo Int'l Units/day
EIN/day
Million EIN/day
mL/kg
L/kg
mg/kg
g/kg
Units/kg
mmol/kg
mEq/kg
mcg/kg
kJ/kg
Int'l Units/kg
Million Units/kg
kcal/kg
ng/kg
mg PE/kg
milli-units/kg
pg/kg
mg/kg (Actual)
Each/kg
Puff/kg
Package/kg
Drop/kg
Inch/kg
KBq/kg
MBq/kg
GBq/kg
mcL/kg
IR/kg
BAU/kg
Million Int'l Units/kg
mcmol/kg
1e12 Vector Genomes/kg
Vector Genomes/kg
Dose/kg
mcg DFE/kg
Kilo Int'l Units/kg
1e11 Vector Genomes/kg
1e13 Vector Genomes/kg
1e14 Vector Genomes/kg
1e15 Vector Genomes/kg
EIN/kg
IR/min
BAU/min
Million Int'l Units/min
Kilo Int'l Units/min
IR/hr
BAU/hr
Million Int'l Units/hr
Kilo Int'l Units/hr
mL/mL
L/mL
mg/mL
g/mL
Units/mL
mmol/mL
mEq/mL
mcg/mL
kJ/mL
Int'l Units/mL
Million Units/mL
kcal/mL
ng/mL
mg PE/mL
milli-units/mL
pg/mL
KBq/mL
MBq/mL
GBq/mL
mcL/mL
IR/mL
BAU/mL
PFU/mL
Million PFU/mL
Million Int'l Units/mL
mcmol/mL
1e12 Vector Genomes/mL
Vector Genomes/mL
Kilo Int'l Units/mL
1e11 Vector Genomes/mL
1e13 Vector Genomes/mL
1e14 Vector Genomes/mL
1e15 Vector Genomes/mL
millicurie/mL
mL/L
L/L
mg/L
g/L
Units/L
mmol/L
mEq/L
mcg/L
kJ/L
Int'l Units/L
Million Units/L
kcal/L
ng/L
mg PE/L
milli-units/L
pg/L
KBq/L
MBq/L
GBq/L
mcL/L
IR/L
BAU/L
Million Int'l Units/L
Kilo Int'l Units/L
mL/m2
L/m2
mg/m2
g/m2
Units/m2
mmol/m2
mEq/m2
mcg/m2
kJ/m2
Int'l Units/m2
Million Units/m2
kcal/m2
ng/m2
mg PE/m2
milli-units/m2
pg/m2
mg/m2 (Actual)
Each/m2
Puff/m2
Package/m2
Drop/m2
KBq/m2
MBq/m2
GBq/m2
mcL/m2
IR/m2
BAU/m2
Million Int'l Units/m2
mcmol/m2
1e12 Vector Genomes/m2
Vector Genomes/m2
Kilo Int'l Units/m2
1e11 Vector Genomes/m2
1e13 Vector Genomes/m2
1e14 Vector Genomes/m2
1e15 Vector Genomes/m2
mL/1.7m2
L/1.7m2
mg/1.7m2
g/1.7m2
Units/1.7m2
mmol/1.7m2
mEq/1.7m2
mcg/1.7m2
kJ/1.7m2
Int'l Units/1.7m2
Million Units/1.7m2
kcal/1.7m2
ng/1.7m2
mg PE/1.7m2
milli-units/1.7m2
pg/1.7m2
Each/1.7m2
KBq/1.7m2
MBq/1.7m2
GBq/1.7m2
mcL/1.7m2
IR/1.7m2
BAU/1.7m2
Million Int'l Units/1.7m2
Kilo Int'l Units/1.7m2
mL/kg (IDL)
L/kg (IDL)
mg/kg (IDL)
g/kg (IDL)
Units/kg (IDL)
mmol/kg (IDL)
mEq/kg (IDL)
mcg/kg (IDL)
Int'l Units/kg (IDL)
Million Units/kg (IDL)
Kcal/kg (IDL)
ng/kg (IDL)
mg PE/kg (IDL)
milli-units/kg (IDL)
pg/kg (IDL)
mg/m2 (IDL)
mL/kg (ADJ)
L/kg (ADJ)
mg/kg (ADJ)
g/kg (ADJ)
Units/kg (ADJ)
mmol/kg (ADJ)
mEq/kg (ADJ)
mcg/kg (ADJ)
Int'l Units/kg (ADJ)
Million Units/kg (ADJ)
Kcal/kg (ADJ)
ng/kg (ADJ)
mg PE/kg (ADJ)
milli-units/kg (ADJ)
pg/kg (ADJ)
mg/m2 (ADJ)
mL/100 mL
L/100 mL
mg/100 mL
g/100 mL
Units/100 mL
mmol/100 mL
mEq/100 mL
mcg/100 mL
kJ/100 mL
Int'l Units/100 mL
Million Units/100 mL
kcal/100 mL
ng/100 mL
mg PE/100 mL
milli-units/100 mL
pg/100 mL
KBq/100 mL
MBq/100 mL
GBq/100 mL
mcL/100 mL
IR/100 mL
BAU/100 mL
Million Int'l Units/100 mL
Kilo Int'l Units/100 mL
mL/oz
L/oz
mg/oz
g/oz
Units/oz
mmol/oz
mEq/oz
mcg/oz
kJ/oz
Int'l Units/oz
Million Units/oz
kcal/oz
ng/oz
mg PE/oz
milli-units/oz
pg/oz
KBq/oz
MBq/oz
GBq/oz
mcL/oz
IR/oz
BAU/oz
Million Int'l Units/oz
Kilo Int'l Units/oz
mL/kg/min
L/kg/min
mg/kg/min
g/kg/min
Units/kg/min
mmol/kg/min
mEq/kg/min
mcg/kg/min
kJ/kg/min
Int'l Units/kg/min
Million Units/kg/min
kcal/kg/min
ng/kg/min
mg PE/kg/min
milli-units/kg/min
pg/kg/min
KBq/kg/min
MBq/kg/min
GBq/kg/min
mcL/kg/min
mL/kg/min (IDL)
L/kg/min (IDL)
mg/kg/min (IDL)
g/kg/min (IDL)
Units/kg/min (IDL)
mmol/kg/min (IDL)
mEq/kg/min (IDL)
mcg/kg/min (IDL)
Int'l Units/kg/min (IDL)
Million Units/kg/min (IDL)
Kcal/kg/min (IDL)
ng/kg/min (IDL)
mg PE/kg/min (IDL)
milli-units/kg/min (IDL)
pg/kg/min (IDL)
mL/kg/min (ADJ)
L/kg/min (ADJ)
mg/kg/min (ADJ)
g/kg/min (ADJ)
Units/kg/min (ADJ)
mmol/kg/min (ADJ)
mEq/kg/min (ADJ)
mcg/kg/min (ADJ)
Int'l Units/kg/min (ADJ)
Million Units/kg/min (ADJ)
Kcal/kg/min (ADJ)
ng/kg/min (ADJ)
mg PE/kg/min (ADJ)
milli-units/kg/min (ADJ)
pg/kg/min (ADJ)
IR/kg/min
BAU/kg/min
Million Int'l Units/kg/min
Kilo Int'l Units/kg/min
mL/m2/min
L/m2/min
mg/m2/min
g/m2/min
Units/m2/min
mmol/m2/min
mEq/m2/min
mcg/m2/min
kJ/m2/min
Int'l Units/m2/min
Million Units/m2/min
kcal/m2/min
ng/m2/min
mg PE/m2/min
milli-units/m2/min
pg/m2/min
KBq/m2/min
MBq/m2/min
GBq/m2/min
mcL/m2/min
mL/1.7m2/min
L/1.7m2/min
mg/1.7m2/min
g/1.7m2/min
Units/1.7m2/min
mmol/1.7m2/min
mEq/1.7m2/min
mcg/1.7m2/min
kJ/1.7m2/min
Int'l Units/1.7m2/min
Million Units/1.7m2/min
kcal/1.7m2/min
ng/1.7m2/min
mg PE/1.7m2/min
milli-units/1.7m2/min
pg/1.7m2/min
KBq/1.7m2/min
MBq/1.7m2/min
GBq/1.7m2/min
mSv
mGy
mcL/1.7m2/min
mcSv
Sv
µGy
cGy
Gy
mRAD
RAD
mg of pseudoephedrine
mg of ephedrine
IR/m2/min
BAU/m2/min
Million Int'l Units/m2/min
Kilo Int'l Units/m2/min
IR/1.7m2/min
BAU/1.7m2/min
Million Int'l Units/1.7m2/min
Kilo Int'l Units/1.7m2/min
mL/kg/hr
L/kg/hr
mg/kg/hr
g/kg/hr
Units/kg/hr
mmol/kg/hr
mEq/kg/hr
mcg/kg/hr
kJ/kg/hr
Int'l Units/kg/hr
Million Units/kg/hr
kcal/kg/hr
ng/kg/hr
mg PE/kg/hr
milli-units/kg/hr
pg/kg/hr
KBq/kg/hr
MBq/kg/hr
GBq/kg/hr
mcL/kg/hr
mL/kg/hr (IDL)
L/kg/hr (IDL)
mg/kg/hr (IDL)
g/kg/hr (IDL)
Units/kg/hr (IDL)
mmol/kg/hr (IDL)
mEq/kg/hr (IDL)
mcg/kg/hr (IDL)
Int'l Units/kg/hr (IDL)
Million Units/kg/hr (IDL)
Kcal/kg/hr (IDL)
ng/kg/hr (IDL)
mg PE/kg/hr (IDL)
milli-units/kg/hr (IDL)
pg/kg/hr (IDL)
mL/kg/hr (ADJ)
L/kg/hr (ADJ)
mg/kg/hr (ADJ)
g/kg/hr (ADJ)
Units/kg/hr (ADJ)
mmol/kg/hr (ADJ)
mEq/kg/hr (ADJ)
mcg/kg/hr (ADJ)
Int'l Units/kg/hr (ADJ)
Million Units/kg/hr (ADJ)
Kcal/kg/hr (ADJ)
ng/kg/hr (ADJ)
mg PE/kg/hr (ADJ)
milli-units/kg/hr (ADJ)
pg/kg/hr (ADJ)
IR/kg/hr
BAU/kg/hr
Million Int'l Units/kg/hr
Kilo Int'l Units/kg/hr
mL/m2/hr
L/m2/hr
mg/m2/hr
g/m2/hr
Units/m2/hr
mmol/m2/hr
mEq/m2/hr
mcg/m2/hr
kJ/m2/hr
Int'l Units/m2/hr
Million Units/m2/hr
kcal/m2/hr
ng/m2/hr
mg PE/m2/hr
milli-units/m2/hr
pg/m2/hr
KBq/m2/hr
MBq/m2/hr
GBq/m2/hr
mcL/m2/hr
mL/1.7m2/hr
L/1.7m2/hr
mg/1.7m2/hr
g/1.7m2/hr
Units/1.7m2/hr
mmol/1.7m2/hr
mEq/1.7m2/hr
mcg/1.7m2/hr
kJ/1.7m2/hr
Int'l Units/1.7m2/hr
Million Units/1.7m2/hr
kcal/1.7m2/hr
ng/1.7m2/hr
mg PE/1.7m2/hr
milli-units/1.7m2/hr
pg/1.7m2/hr
KBq/1.7m2/hr
MBq/1.7m2/hr
GBq/1.7m2/hr
mcL/1.7m2/hr
IR/1.7m2/hr
BAU/1.7m2/hr
Million Int'l Units/1.7m2/hr
Kilo Int'l Units/1.7m2/hr
IR/m2/hr
BAU/m2/hr
Million Int'l Units/m2/hr
Kilo Int'l Units/m2/hr
mL/kg/day
L/kg/day
mg/kg/day
g/kg/day
Units/kg/day
mmol/kg/day
mEq/kg/day
mcg/kg/day
kJ/kg/day
Int'l Units/kg/day
Million Units/kg/day
kcal/kg/day
ng/kg/day
mg PE/kg/day
milli-units/kg/day
pg/kg/day
Inch/kg/day
KBq/kg/day
MBq/kg/day
GBq/kg/day
mL/kg/day (IDL)
L/kg/day (IDL)
mg/kg/day (IDL)
g/kg/day (IDL)
Units/kg/day (IDL)
mmol/kg/day (IDL)
mEq/kg/day (IDL)
mcg/kg/day (IDL)
Int'l Units/kg/day (IDL)
Million Units/kg/day (IDL)
Kcal/kg/day (IDL)
ng/kg/day (IDL)
mg PE/kg/day (IDL)
milli-units/kg/day (IDL)
pg/kg/day (IDL)
mL/kg/day (ADJ)
L/kg/day (ADJ)
mg/kg/day (ADJ)
g/kg/day (ADJ)
Units/kg/day (ADJ)
mmol/kg/day (ADJ)
mEq/kg/day (ADJ)
mcg/kg/day (ADJ)
Int'l Units/kg/day (ADJ)
Million Units/kg/day (ADJ)
Kcal/kg/day (ADJ)
ng/kg/day (ADJ)
mg PE/kg/day (ADJ)
milli-units/kg/day (ADJ)
pg/kg/day (ADJ)
mcL/kg/day
IR/kg/day
BAU/kg/day
Million Int'l Units/kg/day
mL/m2/day
L/m2/day
mg/m2/day
g/m2/day
Units/m2/day
mmol/m2/day
mEq/m2/day
mcg/m2/day
kJ/m2/day
Int'l Units/m2/day
Million Units/m2/day
kcal/m2/day
ng/m2/day
mg PE/m2/day
milli-units/m2/day
pg/m2/day
KBq/m2/day
MBq/m2/day
GBq/m2/day
mcL/m2/day
mL/1.7m2/day
L/1.7m2/day
mg/1.7m2/day
g/1.7m2/day
Units/1.7m2/day
mmol/1.7m2/day
mEq/1.7m2/day
mcg/1.7m2/day
kJ/1.7m2/day
Int'l Units/1.7m2/day
Million Units/1.7m2/day
kcal/1.7m2/day
ng/1.7m2/day
mg PE/1.7m2/day
milli-units/1.7m2/day
pg/1.7m2/day
KBq/1.7m2/day
MBq/1.7m2/day
GBq/1.7m2/day
mcL/1.7m2/day
mL/oz/day
L/oz/day
mg/oz/day
g/oz/day
Units/oz/day
mmol/oz/day
mEq/oz/day
mcg/oz/day
kJ/oz/day
Int'l Units/oz/day
Million Units/oz/day
kcal/oz/day
ng/oz/day
mg PE/oz/day
milli-units/oz/day
pg/oz/day
KBq/oz/day
MBq/oz/day
GBq/oz/day
mcL/oz/day
IR/m2/day
BAU/m2/day
Million Int'l Units/m2/day
Kilo Int'l Units/m2/day
IR/1.7m2/day
BAU/1.7m2/day
Million Int'l Units/1.7m2/day
Kilo Int'l Units/1.7m2/day
IR/oz/day
BAU/oz/day
Million Int'l Units/oz/day
Kilo Int'l Units/oz/day
kJ/30 mL
kcal/30 mL
Gy-cm2
µGy-cm2
mGy-cm2
cGy-cm2
dGy-cm2
µGy-m2
mGy-m2
cGy-m2
dGy-m2
Gy-m2
mRAD-cm2
RAD-cm2
mL/cm2
mg/cm2
mOsmol
each
tablet
capsule
drop
tsp
puff
suppository
spray
Squirt
inch
patch
Act
ampule
Bar
Bottle
Can
Device
enema
Gallon
Inhaler
kit
lb
lozenge
oz
packet
Stick
strip
Tbsp
Tube
vial
Wafer
Container
Syringe
Package
applicator
cm
Applicatorful
Troche
millicurie
Intra Uterine Device
Part
m
Film
Million Cells
Dose
mm
IR
BAU
kg
cm2
Imperial Gallon
kJ
PFU
Piece
Million PFU
Doses/Fill
Cartridge
Thousand Units
Lipoprotein Lipase Releasing Unit
Scoop
Million Int'l Units
mm2
Pump
fluid ounce
Product
Bag
mcmol
1e12 Vector Genomes
Vector Genomes
millicurie/kg
millicurie/m2
millicurie/1.7m2
microcurie
microcurie/kg
microcurie/m2
microcurie/1.7m2
Canister
mcg DFE
Billion Cells
Application
Box
Capful
Inhalation
Lancet
Needle
Pad
Pen
Piece of gum
Ring
Swab
Sachet
Implant
Insert
Pools
Kilo Int'l Units
Kilo Int'l Units/kg/day
1e11 Vector Genomes
1e13 Vector Genomes
1e14 Vector Genomes
1e15 Vector Genomes
Cells
EIN
Million EIN
EIN/kg/day
mGy-cm
cGy-cm
dGy-cm
Gy-cm
mGy-m
cGy-m
dGy-m
Gy-m
Hounsfield Units
mg/mL/min (AUC)
None / Other
5 | IMPLIED_UNIT_TYPE_C_NAME | VARCHAR | No |
The implied unit type for the order at the time a charge was dropped. This is where the unit was taken from (i.e. dispense unit, package unit, entire package).
May contain organization-specific values: No
Category Entries:
Single Package Unit
Dispense Unit
Entire Package
6 | LATEST_MED_ORD_DAT | NUMERIC | No |
This column stores the most recent Order contact date (DAT) for the medication Order.
7 | SYS_RECLASS_RSN_C_NAME | VARCHAR | No |
Stores the reclassification reason for a transaction reposted for system reasons.
May contain organization-specific values: No
Category Entries:
Financial Class Change
Account Class Change
Primary Payor or Plan Change
Mark/Unmark Account for Separate SA Billing
Surcharge Recalculation
Pricing Contract Reprice
Forced Repost
Rev Code/Non-Covered Flag/Price Change
Bundled Episode Change
Register Number Change
Fee Decision Change
Coverage Automation Plan Change
Service Decision Change
Tax Charge Repost
8 | CHRG_AMT_SRC_FLG_C_NAME | VARCHAR | No |
The charge amount source flag category number for the charge transaction.
May contain organization-specific values: No
Category Entries:
HB Default
Non HB in origin
Manually Overridden
HB Pricing Contract
9 | ORIG_ACCT_COMB_ID | NUMERIC | No |
This column stores the first account that a hospital billing transaction attempted to post to prior to combine accounts or combined account redirection. Resets upon transfer.
10 | PLB_PROV_ID | VARCHAR | No |
Stores PLB (Provider Level Adjustment) provider ID
11 | PLB_FP_DATE | DATETIME | No |
Stores PLB (Provider Level Adjustment) fiscal period date.
12 | PLB_REASON_CODE_C_NAME | VARCHAR | No |
Stores PLB (Provider Level Adjustment) reason code.
May contain organization-specific values: Yes
Category Entries:
Late Charge
Interest Penalty Charge
Authorized Return
Early Payment Allowance
Applied to Borrower's Account
Acceleration of Benefits
Rebate
Recovery Allowance
Bad Debt Adjustment
Bonus
Temporary Allowance
Capitation Interest
Adjustment
Capitation Payment
Capital Passthru
Certified Registered Nurse Anesthetist Passthru
Direct Medical Education Passthru
Withholding
Forwarding Balance
Fund Allocation
Graduate Medical Education Passthru
Incentive Premium Payment
Internal Revenue Service Withholding
Interim Settlement
Nonreimbursable
Penalty
Interest Owed
Levy
Lump Sum
Organ Acquisition Passthru
Offset for Affiliated Providers
Periodic Interim Payment
Payment Final
Retro-activity Adjustment
Return on Equity
Student Loan Repayment
Third Party Liability
Overpayment Recovery
Unspecified Recovery
Mutually Defined
Balance Forward
Student Loan Payment
Offset
IRS Levy
IRS Withholding
Interest
Void / Reissue
Adjustment
Refund
Late Filing Reduction
Payor Specified Code
Advance
Reduction
Unused
Advance Repayment
Accounting Adjustment
Attachments
Amount Brought Forward Claim Adjustment
Amount Brought Forward Advances
Amount Brought Forward Reductions
Amount Brought Forward Other Deductions
Origination Fee
Hemophilia Clotting Factor Supplement
Principal Refund
Interest Refund
Affiliate Withholdings
13 | PLB_REFERENCE_NUM | VARCHAR | No |
Stores PLB (Provider Level Adjustment) reference code.
14 | PLAN_ID_BENEFIT_PLAN_NAME | VARCHAR | No |
The name of the benefit plan record.
15 | RSH_MOD_TYPE_C_NAME | VARCHAR | No |
This column stores the charge's research billing modifier type. Having a value set here should mean that the charge should file to the patient account in order to bill to insurance, instead of filing to the study account. Thus, in most cases, the presence of data in this column should mean that RSH_CHG_ROUTE_C is also set to Yes, because the RSH_CHG_ROUTE_C column actually controls whether the study-related charge files to the patient or to the study budget.
May contain organization-specific values: Yes
Category Entries:
Routine
Investigational/Device
16 | RSH_CHG_ROUTE_C_NAME | VARCHAR | No |
This column indicates whether a research-related charge should route to the patient account or the study account. In most cases, if the charge has a research billing modifier type, it will also file to the patient in order to be billed to insurance. However, the flag that actually determines when a charge will file to the patient account is its charge route value; the value in this column indicates the final determination whether the charge will file to the patient or to the study budget.
May contain organization-specific values: No
Category Entries:
File to Study
File to Patient
17 | ELEC_PMT_AUTH_CODE | VARCHAR | No |
Authorization code sent back by the merchant
18 | TREATMENT_PLAN_CSN | NUMERIC | No |
The contact serial number of the treatment plan that generated this charge and order.
19 | SUP_INV_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
20 | SUP_WASTED_QTY | INTEGER | No |
Wasted quantity
21 | TREATMENT_DAY_CSN | NUMERIC | No |
This column stores the contact serial number of the treatment day that generated this charge's order. This contact serial number can be linked to TRG_UPDATE_INFO.CONTACT_SERIAL_NUM for additional information on the treatment day. This treatment day is contained within the treatment plan specified in HSP_TRANSACTIONS_2.TREATMENT_PLAN_contact serial number (CSN).
22 | OTHER_ADJ_AMOUNT | NUMERIC | No |
Stores the other adjustment amount associated with this payment.
23 | OTHER_ADJ_REF_NUM | VARCHAR | No |
Stores the other adjustment reference number associated with this payment.
24 | OTHER_ADJ_COMMENT | VARCHAR | No |
Stores the other adjustment comment associated with this payment.
25 | PMT_DRG_CODE | VARCHAR | No |
This column stores the diagnosis-related group (DRG) code received on the remittance image.
26 | RATE_CNTR_ID | NUMERIC | No |
The rate center stored in a charge transaction. If a user has chosen to override the default rate center in the procedure master file, the user-entered override rate center will display here.
27 | RATE_CNTR_ID_COST_CENTER_NAME | VARCHAR | No |
The name of the cost center.
28 | DFLT_RATE_CNTR_ID | NUMERIC | No |
This column stores the unique identifier for the default rate center from the procedure master file for a charge transaction.
29 | DFLT_RATE_CNTR_ID_COST_CENTER_NAME | VARCHAR | No |
The name of the cost center.
30 | DX_PRIM_CODE_SET_C_NAME | VARCHAR | No |
The primary diagnosis code set configured in the facility for the service date of 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
MONDO
EPD Short List
Preferred Ancillary Code Sets
31 | DX_ALT_CODE_SET_C_NAME | VARCHAR | No |
The alternate diagnosis code set configured in the facility for the service date of the transaction.
The category values for this column were already listed for column: DX_PRIM_CODE_SET_C_NAME
32 | COMPOUND_DRUG_LINK_NUM | VARCHAR | No |
The link number for compound medication. The link number is used to group charge lines for components from the same compound drug on claim.
33 | LATEST_MED_ORD_DTE | NUMERIC | No |
This column stores the most recent order date (DTE) for the medication order. This column can be used to link to the CONTACT_DATE_REAL column in many order tables to find the correct contact.
34 | FIRST_TX_POST_DATE | DATETIME | No |
This column stores the post date of the first transaction across hospital billing and professional billing in a chain of transfers, reposts, and reversals.
35 | ELEC_PMT_RESP_STS_C_NAME | VARCHAR | No |
Response message status from the gateway. This item is only stored for non-accepted responses.
May contain organization-specific values: No
Category Entries:
Error
Accepted
Declined
36 | ELEC_PMT_RESP_MSG | VARCHAR | No |
Response message from gateway if transaction was not successful. We don't store a message (if any is sent) for accepted transactions.
37 | ACCT_FIN_CLASS_C_NAME | VARCHAR | No |
Holds the financial class of the account when the transaction filed. This is set for all transaction types.
May contain organization-specific values: Yes
Category Entries:
Commercial
Medicare
Medicaid
Self-Pay
Worker's Comp
Tricare
Champva
Group Health Plan
FECA Black Lung
Blue Shield
Medigap
Other
DK Regional
Client
Received Self-Pay
Sent to Consolidated Self-Pay
Patient Assistance Program
38 | PRIMARY_PAYOR_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
39 | DISCOUNT_PERCENT | INTEGER | No |
Stores the discount percentage applied to the self-pay balance.
40 | DISCOUNT_PROGRAM_ID | NUMERIC | No |
Stores the financial assistance program that the hospital account qualified for which caused the financial assistance adjustment to be applied.
41 | DISCOUNT_PROGRAM_ID_PROGRAM_NAME | VARCHAR | No |
The name of the financial assistance program record.
42 | DISCOUNT_COMMENT | VARCHAR | No |
Stores the additional details on why the discount is posted on the hospital account.
43 | PRIMARY_COVERAGE_ID | NUMERIC | No |
Holds the primary coverage of the account when the transaction filed. This is set for all transaction types.
44 | HAR_FIRST_POST_DATE | DATETIME | No |
This column stores the post date of the first hospital billing transaction on the hospital account in a chain of reposts and reversals.
45 | POST_SOURCE_C_NAME | VARCHAR | No |
This column stores the source from which the payment is posted in the system. This is calculated based on the transaction source on the hospital billing transaction.
May contain organization-specific values: No
Category Entries:
Back-end
MyChart
E-Remit
Web Service
Welcome
Auto Pay
Payment Posting
Staff Collected
Refund
ROI
Willow Ambulatory
Two-Way SMS
Multi-Instance Consolidated Balances
Virtual Assistant
46 | SERVICE_SPEC_C_NAME | VARCHAR | No |
The service specialty of the transaction. This may be different from the service provider's specialty for providers working outside their specialty. If this field has no value, the transaction specialty is the same as the service provider's first-listed specialty.
May contain organization-specific values: Yes
47 | BILLING_SPEC_C_NAME | VARCHAR | No |
The billing specialty of the transaction. This may be different from the billing provider's specialty for providers working outside their specialty. If this field has no value, the transaction specialty is the same as the billing provider's first-listed specialty.
The category values for this column were already listed for column: SERVICE_SPEC_C_NAME
48 | ORIG_BUNDPMT_ETR_ID | NUMERIC | No |
This column stores the unique identifier for the professional billing transaction for the original bundled payment.
49 | ORIG_BUNDPMT_HTR_ID | NUMERIC | No |
This column stores the unique identifier for the hospital billing transaction for the original bundled payment.
50 | 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.
51 | 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
52 | SRCHG_CLP_ID | NUMERIC | No |
This column stores the unique identifier for the claim print record containing the values contributing to the surcharge adjustment.
53 | ADJUSTMENT_CAT_C_NAME | VARCHAR | No |
The adjustment category of the adjustment procedure at the time of posting.
May contain organization-specific values: Yes
Category Entries:
Refund
NSF Adjustment/Fee
Contractual
Charity
Capitation
Uninsured Discount/Financial Assistance
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
Discount Offer
54 | WRITE_OFF_RSN_C_NAME | VARCHAR | No |
The mapped write-off reason for the adjustment.
May contain organization-specific values: No
Category Entries:
Contractual
Uninsured Discount/Financial Assistance
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
Discount Offer
N/A - Payment Refund/Reversal
N/A - Resident Trust Account
55 | SCHED_PMT_ID | NUMERIC | No |
Stores the scheduled payment record that resulted in this payment.
56 | PARENT_SCHED_PMT_ID | NUMERIC | No |
Stores the parent scheduled payment record that resulted in this payment.