ARPB_TRANSACTIONS3

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 | IS_SCANNED_CHECK_YN | VARCHAR | No |
Indicates if a transaction was made using a scanned check.
May contain organization-specific values: No
Category Entries:
No
Yes
3 | SUSP_NRP_SRC_COVERAGE_ID | NUMERIC | No |
This column stores the coverage when the next responsible party (NRP) action was suspended.
4 | SUSP_NRP_DST_COVERAGE_ID | NUMERIC | No |
This column stores the coverage for the suspended NRP action.
5 | SUSP_NRP_AMT | NUMERIC | No |
This column stores the amount of the suspended NRP action.
6 | SUSP_NRP_ASSIGN_C_NAME | VARCHAR | No |
This column stores the assignment value for the suspended NRP action.
May contain organization-specific values: No
Category Entries:
Yes
No
Yes, No Claim
No, Submit Claim
Yes, Cross Over
7 | SUSP_NRP_SOURCE_MODULE_C_NAME | VARCHAR | No |
This column stores the module for the suspended NRP action.
May contain organization-specific values: No
Category Entries:
Account Maintenance
Payment Posting
Adjustment Posting
Collection (text)
Collection Workqueue
Charge Entry
Retroadjudication
Small Balance Write-off in Bills
Transfer
Transaction Import
Claim Processing
MyChart Web
Electronic Remittance
Claim Bundling Utility
Real Time Charge Interface
Secondary Write-off
Dental Treatment Plan
Transaction Maintenance Utilities
Follow-up workqueue User
Check-in/Check-out
Charge Homing
Release of Information
Enterprise Payment Posting
Reimbursement Recalculation Utility
Charge Correction
Charge Repost
Claim Edit Workqueue
Patient Refund
HB Integrity Checks
Welcome
PB Extract Framework
SBO Collection Actions
Nightly Processing
Web Service
Auto Pay Payment Plan
Pharmacy
Payment Collection
Financial Assistance
Credit Workqueue System
Credit Workqueue User
Follow-up Workqueue System
Self-Pay Discount
Adjustment Review Workqueue
Charge Router Void
Charge Router Repost
Rescheduling Repost
Prepay Discount Adjustment
Bundled Payment Distribution
Account Workqueue
Claim run Accept
Change Guarantor
MyChart Mobile
Guest Pay
Visit Auto Pay
Dental Upgrade Adjustment
Promotion Discount
Discretionary Discount
Non-Primary Not Allowed Adjustment
Estimate
Adjustment Review WQ Decline
Two-Way SMS
Shadow Charging
Reeval Reimbursement (User)
Override Reimbursement (User)
Override Reimbursement (System)
Same-Instance Consolidated Balances
Estimate Variance Write-Off
Multi-Instance Consolidated Balances
Virtual Assistant
Discount Offer
Post-payment Recovery
8 | SUSP_NRP_COMMENT | VARCHAR | No |
This column stores the comment for the suspended NRP action.
9 | EB_PMT_HTT_ID | NUMERIC | No |
The Enterprise payment hospital temporary transaction ID.
10 | IS_CSA_PAYMENT_YN | VARCHAR | No |
Indicates that a payment was identified as coming from a consumer spending account during professional billing remittance processing.
The category values for this column were already listed for column: IS_SCANNED_CHECK_YN
11 | BFD_COVERAGE_ID | NUMERIC | No |
This item stores the coverage used to compute reimbursement and pricing contracts for charge lines that qualify for bill for denial workflows.
12 | ADV_PRICING_DESCRIPTION | VARCHAR | No |
Description of the advanced pricing line in ECP used for this charge.
13 | ADV_PRICING_INDEX_ID | VARCHAR | No |
Component or component group used in advanced pricing.
14 | ADV_PRICING_INDEX_ID_COMPONENT_INDEX_NAME | VARCHAR | No |
The name of the component index record
15 | ADV_PRICING_RULE_ID | VARCHAR | No |
Rule used for advanced pricing.
16 | ADV_PRICING_RULE_ID_RULE_NAME | VARCHAR | No |
The name of the rule.
17 | ADV_PRICING_MECHANISM_C_NAME | VARCHAR | No |
Advanced pricing mechanism used.
May contain organization-specific values: No
Category Entries:
Percent of Fee Schedule
Minimum of Options
Maximum of Options
Extension
Percent of Base Price
18 | ADV_PRICING_FSC1_ID | NUMERIC | No |
Fee schedule 1 used in advanced pricing.
19 | ADV_PRICING_FSC1_ID_FEE_SCHEDULE_NAME | VARCHAR | No |
The name of each fee schedule.
20 | ADV_PRICING_FSC2_ID | NUMERIC | No |
Fee schedule 2 used in advanced pricing.
21 | ADV_PRICING_FSC2_ID_FEE_SCHEDULE_NAME | VARCHAR | No |
The name of each fee schedule.
22 | ADV_PRICING_FSC_PERC_1 | NUMERIC | No |
Percent of specified fee schedule 1 used in advanced pricing.
23 | ADV_PRICING_FSC_PERC_2 | NUMERIC | No |
Percent of specified fee schedule 2 used in advanced pricing.
24 | ADV_PRICING_PERC_BASE | INTEGER | No |
Percent of base price used in advanced pricing.
25 | ADV_PRICING_LPP_ID | NUMERIC | No |
Pricing extension used in advanced pricing.
26 | ADV_PRICING_LPP_ID_LPP_NAME | VARCHAR | No |
The name of the extension.
27 | PRIM_TIMELY_FILE_DEADLINE_DATE | DATETIME | No |
The primary timely filing deadline date.
28 | PAT_PMT_COLL_WKFL_C_NAME | VARCHAR | No |
This column contains the workflow category ID performed to collect a patient payment from the point of view of the user. For example, MyChart eCheck-in vs. MyChart One-Touch.
May contain organization-specific values: No
Category Entries:
Staff Collected
MyChart Billing
MyChart One-Touch
MyChart Pay as Guest
MyChart Visit Payment
MyChart eCheck-in
MyChart Virtual Assistant
Welcome Balance Payment
Welcome Check-in
Two-Way SMS
Payment Posting
Lockbox
Release of Information
Willow Ambulatory
Web Service
29 | MYC_SIGNIN_METHOD_C_NAME | VARCHAR | No |
This column denotes how the patient or guarantor logged in to MyChart to either post the payment or create an agreement that will post a payment via Auto Pay. Only populated for agreements made via MyChart.
May contain organization-specific values: No
Category Entries:
Password Sign-in
Demographics Sign-in
No Sign-in
30 | POSTING_MYPT_ID | VARCHAR | No |
This column contains either the MyChart account that created the agreement that resulted in the self-pay payment (if applicable) or the MyChart account that posted the self-pay payment.
31 | POSTING_MYC_STATUS_C_NAME | VARCHAR | No |
This item contains either the status of the MyChart account that created the agreement that resulted in the self-pay payment (if applicable) or the status of the MyChart account that posted the self-pay payment. An active MyChart account status is defined as whether a MyChart user could log into the account with a user name and password. Accounts that are not yet active, deactivated, or are proxy accounts are considered inactive.
May contain organization-specific values: Yes
Category Entries:
ACTIVE
INACTIVE
32 | EB_TX_SOURCE_C_NAME | VARCHAR | No |
This column stores the enterprise posting module for the transaction. This is calculated based on the professional billing transaction source for the transaction.
May contain organization-specific values: No
Category Entries:
Payment Plan Auto Pay
Enterprise Payment Posting
HB Payment Posting
PB Payment Posting
Electronic Remittance
PB Charge Entry Fast Pay
POS Quick Pay
Welcome
MyChart Web
PB Release of Information
Transaction Import
Web Service
Payment Collection
Willow Ambulatory
Distribution
Transfer from PB
Transfer from HB
MyChart Mobile
Guest Pay
Account Maintenance Refund
Patient Refund
Back-End Refund
Visit Auto Pay
Trust Recurring Payment
Premium Billing Auto Pay
Premium Billing One Time Payment
Premium Billing Payment Posting
Two-Way SMS
External Agency Payment
Multi-Instance Consolidated Balances
Virtual Assistant
33 | IMPLIED_QTY | NUMERIC | No |
The implied quantity for a charge.
34 | IMPLIED_QTY_UNIT_C_NAME | VARCHAR | No |
The implied quantity's unit.
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
35 | IMPLIED_UNIT_TYPE_C_NAME | VARCHAR | No |
The unit type of the implied quantity.
May contain organization-specific values: No
Category Entries:
Single Package Unit
Dispense Unit
Entire Package
36 | OVR_REIMB_CONTRACT_ID | NUMERIC | No |
The override reimbursement contract that was entered.
37 | OVR_REIMB_CONTRACT_ID_CONTRACT_NAME | VARCHAR | No |
The name of the Vendor-Network contract.
38 | OVR_REIMB_CONTRACT_DATE | DATETIME | No |
The contact that should be used of the override reimbursement contract that was entered.
39 | OVR_EXPECTED_REIMB_AMOUNT | NUMERIC | No |
Stores the expected reimbursement override amount for the charge. This override amount was entered by a user.
40 | PMT_PLAN_AGRMT_SCHED_PMT_ID | NUMERIC | No |
The unique ID of the transaction's target guarantor's active payment plan agreement record at the time of filing.
41 | IS_EST_PRE_SERVICE_PLAN_PMT_YN | VARCHAR | No |
Indicates whether this payment was made on an estimated balance on a payment plan at time of filing ('Y'). 'N' or NULL indicates that the transaction is not a payment, the payment is not on a balance on a payment plan, or the balance was not estimated at the time of filing.
The category values for this column were already listed for column: IS_SCANNED_CHECK_YN
42 | IS_PRE_SERVICE_PLAN_PMT_YN | VARCHAR | No |
Indicates whether this payment was made toward a hospital account on a payment plan that was added by an estimate ('Y'). 'N' or NULL indicates that the transaction is not a payment or the payment was not made toward a hospital account on a payment plan that was added by an estimate.
The category values for this column were already listed for column: IS_SCANNED_CHECK_YN
43 | EST_VARIANCE_WO_ESTIMATE_ID | NUMERIC | No |
If this transaction is part of an automatic estimate variance write-off, this item stores the estimate that this is a write off towards.
44 | INTEND_VISIT_ACCT_CALC_MTHD_C_NAME | VARCHAR | No |
The calculation method of the Intended Visit Account HAR.
May contain organization-specific values: No
Category Entries:
Default
Estimate Payment
Predetermined
45 | NCC_OVERRIDE_COVERAGE_ID | NUMERIC | No |
When a coverage other than the normal reimbursement coverage is used to override the reimbursement contract used by a charge, this item contains that coverage.
46 | POST_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
The instant the charge was posted
47 | IS_PREPAY_PMT_YN | VARCHAR | No |
Indicates whether this is a prepay payment. This includes visit prepay payments and copay payments (such as during check-in). This column is only populated for self-pay payments.
The category values for this column were already listed for column: IS_SCANNED_CHECK_YN