line_item

Information about a line item for a health, dental, prescription drug, etc. claim

Primary Key:

• line_item_id

Checks:

• line_item_clean_product_service_code_check - (product_service_code = upper(TRIM(BOTH FROM product_service_code)))

Foreign Keys:

• claim_id => claim.claim_id
• product_service_id => product_service_code_lookup.product_service_id

Indexes:

• line_item_claim_id_idx - claim_id
• line_item_product_service_id_idx - product_service_id

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	Link to claim record. Generated through expression:
line_number	text	No	No	Number assigned for differentiation within a transaction set (from LX01) Generated through expression:
rev_code	text	No	No	Service line revenue code (from SV201 / UB04 FL42) Generated through expression:
product_service_code_qualifier	product_service_code_type	Yes	No	Identifies the source coding system of the product/service code, such as HCPCS, ADA, HIPPS, etc. (From SV101_01, SV202_01, SV301_01, SV501_01 / NCPDP 436-E1) Generated through expression:
product_service_code	text	No	No	Product or service identifier (from SV101_02, SV202_02, SV301_02, SV501_02 / UB04 FL44 / HCFA item 24d / NCPDP 407-D7) Generated through expression:
procedure_modifiers	text[]	No	No	Up to four modifiers for X12, ten for NCPDP. This identifies special circumstances related to the performance of the service, as defined by trading partners (from SV101_03-06, SV202_03-06, SV301_03-06, SV501_03-06 / UB04 FL44 / NCPDP 459-ER) Generated through expression:
procedure_description	text	No	No	Free form description of the procedure (from SV101_07, SV202_07, SV301_07, SV501_07 / UB04 FL43) Generated through expression:
billed_amount	numeric	Yes	No	Amount billed (from SV102, SV203, SV302 / UB04 FL47 / HCFA item 24f / NCPDP 430-DU) Generated through expression:
quantity	numeric	Yes	No	Service unit count (from SV104, SV205 [with unit code UN], and SV306 / UB04 FL46 / NCPDP 442-E7) Generated through expression:
place_of_service	text	No	No	Place of service code (from SV105 / HCFA item 24b / NCPDP 307-C7) Generated through expression:
facility_non_covered_amount	numeric	Yes	No	Line item denied or non-covered charge amount (from SV207 / UB04 FL48) Generated through expression:
dme_length_of_medical_necessity_quantity	numeric	Yes	No	Length of medical treatment required (From SV503) Generated through expression:
dme_rental_price	numeric	Yes	No	DME rental price (From SV504) Generated through expression:
dme_purchase_price	numeric	Yes	No	DME purchase price (From SV505) Generated through expression:
ambulance_transport_reason	ambulance_transport_reason_type	Yes	No	Reason for ambulance transport (from CR104) Generated through expression:
ambulance_pickup_address_id	bigint	Yes	No	Ambulance pickup location (From NM1 PW loop) Generated through expression:
ambulance_dropoff_address_id	bigint	Yes	No	Ambulance dropoff location (From NM1 45 loop) Generated through expression:
service_date_from	date	Yes	No	Service date start (from DTP qualifier 472 / UB04 FL45 / HCFA item 24a / NCPDP 401-D1) Generated through expression:
service_date_through	date	Yes	No	Service date end (from DTP qualifier 472 / UB04 FL45 / HCFA item 24a / NCPDP 401-D1) Generated through expression:
last_seen_date	date	Yes	No	Date last seen (From DTP 304) Generated through expression:
initial_treatment_date	date	Yes	No	Date of initial treatment (From DTP 454) Generated through expression:
line_item_provider_control_number	text	No	No	Provider's unique line item reference number (From REF 6R) Generated through expression:
clia_number	text	No	No	Clinical Lab number (From REF X4) Generated through expression:
drug_ndc	text	No	No	National Drug Code (From LIN02) Generated through expression:
drug_units	unit_type	Yes	No	Drug measurement unit (From CTP05) Generated through expression:
drug_quantity	numeric	Yes	No	Drug unit quantity (From CTP04) Generated through expression:
drug_link_sequence_number	text	No	No	Provider assigned number for piecing together drug components (From REF VY) Generated through expression:
prescription_reference_number	text	No	No	For 837 claims, prescription number which can be used to piece together all components of a drug. For NCPDP telecom claims, reference number assigned by the provider for the prescription or service (From REF XZ / NCPDP 402-D2) Generated through expression:
data_errors	text[]	No	No	- Generated through expression:
tpa_network_identifier	text	No	No	Network identifier assigned by the TPA (non-EDI) Generated through expression:
tpa_network_name	text	No	No	Network name assigned by the TPA (non-EDI) Generated through expression:
tpa_network_status	text	No	No	Network status according to the TPA (non-EDI) Generated through expression:
payment_limit	numeric	Yes	No	The max amount a provider can accept as payment for a line item. Under Medicare this is called the limiting charge (participating providers must accept Medicare as full payment, non-participating providers must accept 109.25% of Medicare, but opt-out providers have no limits on what they must accept as payment). A payment limit is usually enforced under a contract, but RBP and other baseline-based programs can also establish a payment limit through other means. A limiting charge is an important tool to protect patients from egregious charges even when a line item is denied coverage. See https://www.medicareresources.org/glossary/limiting-charge/. Payment Limit + Billed Adjustment = Billed Generated through expression:
billed_adjustment	numeric	Yes	No	Adjustments to the billed charge to get to the established payment limit for the line item. Payment Limit + Billed Adjustment = Billed Generated through expression:
allowed_amount	numeric	Yes	No	Amount covered by the plan for this line item. Note that this includes both plan and member responsibility portions (e.g. copay, coinsurance, deductible). Allowed + Not covered = Payment Limit Generated through expression:
not_covered_amount	numeric	Yes	No	Amount not covered by the plan for this line item. Allowed + Not covered = Payment Limit Generated through expression:
allowed_adjustment_amount	numeric	Yes	No	Adjustments to the allowed amount such as payment discounts, etc. Allowed Adjustment + Plan Payment + COB Paid + Copay + Coinsurance + Deductible = Allowed Generated through expression:
plan_payment_amount	numeric	Yes	No	Amount to be paid by the plan for this line item. Allowed Adjustment + Plan Payment + COB Paid + Copay + Coinsurance + Deductible = Allowed Generated through expression:
cob_paid_amount	numeric	Yes	No	Amount paid by another plan for this line item. Allowed Adjustment + Plan Payment + COB Paid + Copay + Coinsurance + Deductible = Allowed Generated through expression:
copay_amount	numeric	Yes	No	A fixed out-of-pocket amount paid by a member for covered services. Allowed Adjustment + Plan Payment + COB Paid + Copay + Coinsurance + Deductible = Allowed (from NCPDP 518-FI) Generated through expression:
coinsurance_amount	numeric	Yes	No	The percentage of covered health costs that a member is responsible for paying after meeting their deductible. Allowed Adjustment + Plan Payment + COB Paid + Copay + Coinsurance + Deductible = Allowed (from NCPDP 572-4U) Generated through expression:
deductible_amount	numeric	Yes	No	The amount a member must pay for covered health services before their health plan begins to pay. Allowed Adjustment + Plan Payment + COB Paid + Copay + Coinsurance + Deductible = Allowed Generated through expression:
payment_identification_code	text	Yes	No	Identifier for the payment transaction. This could be an EFT number, check number, etc. Generated through expression:
payment_method_type	payment_method_type	Yes	No	The method used to make the payment. This could be EFT, check, etc. Generated through expression:
payment_date	date	Yes	No	The date the payment was made Generated through expression:
payment_to_provider	numeric	Yes	No	Payment made to a provider by the plan. A negative amount is a payment from the provider to the plan Generated through expression:
payment_to_member	numeric	Yes	No	Payment made to a member by the plan. A negative amount is a payment from the member to the plan Generated through expression:
diagnosis_code_pointers	smallint[]	No	No	A 1-based array of diagnosis code pointers. Join to 0-based claim_diagnosis.claim_diagnosis_index for details (from SV107, SV311 / HCFA item 24e) Generated through expression:
is_emergency_professional	boolean	Yes	No	Emergency-related indicator (from SV109 / HCFA item 24c) Generated through expression:
is_epsdt_professional	boolean	Yes	No	Indicates whether claim is EPSDT referral (from SV111 / HCFA item 24h) Generated through expression:
is_family_planning_professional	boolean	Yes	No	Family planning involvement indicator (from SV112 / HCFA item 24h) Generated through expression:
dental_prosthesis_crown_or_inlay_placement	dental_prosthesis_crown_or_inlay_placement_type	Yes	No	Reports the placement type for the dental work (From SV305) Generated through expression:
ambulance_transport_distance_quantity	numeric	Yes	No	Distance patient was transported by ambulance (From CR105) Generated through expression:
ambulance_round_trip_purpose_description	text	No	No	Describes why a round trip transport was required (from CR109) Generated through expression:
ambulance_stretcher_purpose_description	text	No	No	Describes why a stretcher was required (From CR110) Generated through expression:
ambulance_patient_count	smallint	Yes	No	Number of patients transported by ambulance (From QTY PT) Generated through expression:
dme_certification_type	certification_type	Yes	No	Type of DME certification (From CR301) Generated through expression:
dme_need_duration_quantity	numeric	Yes	No	Time in months that DME equipment is needed (From CR303) Generated through expression:
dme_certification_date	date	Yes	No	Date of certification or recertification (From DTP 607) Generated through expression:
prescription_date	date	Yes	No	Date of prescription (From DTP 471 / NCPDP 414-DE) Generated through expression:
begin_therapy_date	date	Yes	No	Begin date of therapy (often DME related) (From DTP 463) Generated through expression:
last_certification_date	date	Yes	No	Date of last certification (often DME related) (From DTP 461) Generated through expression:
most_recent_hemoglobin_or_hematocrit_date	date	Yes	No	Date of most recent hemoglobin or hematocrit test (From DTP 738) Generated through expression:
most_recent_serum_creatine_date	date	Yes	No	Date of most recent serum creatine test (From DTP 739) Generated through expression:
shipped_date	date	Yes	No	Date shipped (From DTP 011) Generated through expression:
last_x_ray_date	date	Yes	No	Date of last x-ray (From DTP 455) Generated through expression:
estimated_prior_placement_date	date	Yes	No	Estimated date of prior dental work placement (From DTP 139) Generated through expression:
prior_placement_date	date	Yes	No	Date of prior dental work placement (From DTP 441) Generated through expression:
appliance_placement_date	date	Yes	No	Date of orthodontic applicance placement (From DTP 452) Generated through expression:
replacement_date	date	Yes	No	Date of orthodontic applicance was replaced (From DTP 446) Generated through expression:
treatment_start_date	date	Yes	No	Date of initial impression or preparation for a crown or denture (From DTP 196) Generated through expression:
treatment_completion_date	date	Yes	No	Date of course of treatment was completed (From DTP 198) Generated through expression:
obstetric_anesthesia_additional_units	numeric	Yes	No	Used to report additional complexity beyond the normal services (From QTY FL) Generated through expression:
contract_type	contract_type	Yes	No	Contract type (From CN101) Generated through expression:
contract_amount	numeric	Yes	No	Contract amount (From CN102) Generated through expression:
contract_billed_percentage	numeric	Yes	No	Contract billed percentage (From CN103) Generated through expression:
contract_identification_code	text	No	No	Contract identification code (From CN104) Generated through expression:
contract_version_identifier	text	No	No	Contract version identifier (From CN106) Generated through expression:
repriced_line_item_number	text	No	No	Line number according to the repricing organization or other intermediary (from REF 9A or 9B) Generated through expression:
line_item_prior_authorization_number	text	No	No	Prior authorization number for primary payer (from REF G1 / NCPDP 462-EV) Generated through expression:
mammography_certification_number	text	No	No	Mammography certification number for a certified provider (from REF EW) Generated through expression:
referring_clia_number	text	No	No	Referring clinical Lab number (From REF F4) Generated through expression:
immunization_batch_number	text	No	No	Immunization batch number (From REF BT) Generated through expression:
referral_number	text	No	No	Referral number for primary payer (From REF 9F) Generated through expression:
sales_tax_amount	numeric	Yes	No	Sales tax (From AMT T) Generated through expression:
service_tax_amount	numeric	Yes	No	Goods and services tax (From AMT GT) Generated through expression:
facility_tax_amount	numeric	Yes	No	Facility tax (From AMT N8) Generated through expression:
postage_amount	numeric	Yes	No	Postage amount (From AMT F4) Generated through expression:
purchased_service_provider_identifier	text	No	No	Purchased service provider identifier (From PS101) Generated through expression:
purchased_service_billed_amount	numeric	Yes	No	Purchased service provider charge amount (From PS102) Generated through expression:
reprice_allowed_amount	numeric	Yes	No	Allowed amount according to the repricing organization before adjudication (From HCP02) Generated through expression:
reprice_savings_amount	numeric	Yes	No	Savings amount (From HCP03) Generated through expression:
reprice_organization_identifier	text	No	No	Code identifying the organization that has repriced the claim (from HCP04) Generated through expression:
reprice_per_diem_or_flat_rate_amount	numeric	Yes	No	Per diem or flat rate amount (From HCP05) Generated through expression:
reprice_approved_revenue_code	text	No	No	Approved revenue code (From HCP08) Generated through expression:
reprice_approved_product_service_code	text	No	No	Approved product/service code (From HCP10) Generated through expression:
reprice_approved_units	unit_type	Yes	No	Approved reprice units (From HCP11) Generated through expression:
reprice_approved_quantity	numeric	Yes	No	Approved quantity (From HCP12) Generated through expression:
units	text	No	No	Service unit type (from SV103, SV204, SV306, SV502 / NCPDP 600-28) Generated through expression:
tpa_processed_date	date	Yes	No	Date TPA processed claim (non-EDI) Generated through expression:
contract_terms_discount_percent	numeric	Yes	No	Percentage discount available if paid before the discount due date (From CN105) Generated through expression:
tpa_line_item_status	text	No	No	Indicates disposition of line item (Paid, Denied, Voided, Rejected, Reversed, etc.). This can be used to differentiate between repeated line items (non-EDI) Generated through expression:
line_item_id	bigint	No	Yes	Snowflake ID assigned to line item. Generated through expression:
product_service_id	bigint	Yes	Yes	Links to the unified product/service code lookup. Generated through expression:
copay_status	copay_status_type	Yes	No	Patient is exempt from co-pay (from SV115, SV308) Generated through expression:
dental_oral_cavity_designations	dental_oral_cavity_designation_type[]	No	No	Describes the quadrant or arch and area of the oral cavity when not uniquely defined by the procedure code (From SV304) Generated through expression:
dme_length_of_medical_necessity_units	unit_type	Yes	No	The units for dme_length_of_medical_necessity_quantity (From SV502) Generated through expression:
dme_rental_billing_frequency	frequency_code	Yes	No	DME rental billing frequency (From SV506) Generated through expression:
ambulance_transport_distance_units	unit_type	Yes	No	Units for ambulance_transport_distance_quantity (From CR104) Generated through expression:
ambulance_applicable_conditions	condition_indicator_type[]	No	No	Ambulance certification of applicable patient conditions (From CRC01:07, CRC02:Y, CRC03/4/5) Generated through expression:
ambulance_not_applicable_conditions	condition_indicator_type[]	No	No	Ambulance certification of not applicable patient conditions (From CRC01:07, CRC02:N, CRC03/4/5) Generated through expression:
dme_need_duration_units	unit_type	Yes	No	The units for dme_duration_needed_quantity (From CR302) Generated through expression:
dme_applicable_conditions	condition_indicator_type[]	No	No	DME certification of applicable patient conditions (From CRC01:07, CRC02:Y, CRC03/4) Generated through expression:
dme_not_applicable_conditions	condition_indicator_type[]	No	No	DME certification of non-applicable patient conditions (From CRC01:07, CRC02:N, CRC03/4) Generated through expression:
rendering_provider_is_hospice_employee	boolean	Yes	No	Indicates whether rendering provider is an employee of the hospice (From CRC01:70, CRC02:Y or N) Generated through expression:
adjusted_repriced_line_item_number	text	No	No	Adjusted line item number according to the repricing organization or other intermediary (from REF 9C or 9D) Generated through expression:
predetermination_of_benefits_identifier	text	No	No	Predetermination of benefits identifier for primary payer (from REF G3) Generated through expression:
reprice_methodology	pricing_methodology_type	Yes	No	Code specifying pricing methodology used for repricing (from HCP01) Generated through expression:
reprice_approved_drg_or_apg_code	text	No	No	Code specifying the approved Diagnosis Related Group or Ambulatory Patient Group (from HCP06) Generated through expression:
reprice_approved_drg_or_apg_amount	numeric	Yes	No	Approved DRG or APG amount (From HCP07) Generated through expression:
reprice_approved_product_service_code_qualifier	product_service_code_type	Yes	No	Approved product/service code qualifier (From HCP09) Generated through expression:
reprice_reject_reason	reject_reason_type	Yes	No	Code assigned by issuer to identify reason for rejection (from HCP13) Generated through expression:
reprice_policy_compliance	policy_compliance_type	Yes	No	Code specifying policy compliance (from HCP14) Generated through expression:
reprice_exception	repricing_exception_type	Yes	No	Code specifying the exception reason for consideration of out-of-network health care services (from HCP15) Generated through expression:
intermediary_authorization_type	text	No	No	Indicates that authorization occurred for intermediary processing (from NCPDP 463-EW) Generated through expression:
intermediary_authorization_identifier	text	No	No	Intermediary authorization identifier (from NCPDP 464-EX) Generated through expression:
associated_prescription_reference_number	text	No	No	Reference number of the prescription or service with which this service is associated (from NCPDP 456-EN) Generated through expression:
associated_prescription_service_date	date	Yes	No	Date corresponding to the associated prescription or service (from NCPDP 457-EP) Generated through expression:
rx_fill_number	integer	Yes	No	Indicates the prescription fill sequence (0=original, 1=first fill, 2=second fill, etc., through 99) (from NCPDP 403-D3) Generated through expression:
rx_days_supply	numeric	Yes	No	Estimated number of days the prescription supply will cover (from NCPDP 405-D5) Generated through expression:
rx_dispense_as_written	rx_dispense_as_written_type	Yes	No	Whether the medication was dispensed in accordance with the prescriber's directions on generic substitution (from NCPDP 408-D8) Generated through expression:
rx_refills_authorized	numeric	Yes	No	Count of prescription refills permitted by the prescriber (from NCPDP 415-DF) Generated through expression:
prescription_origin	prescription_origin_type	Yes	No	How the prescription was received by the pharmacy (from NCPDP 419-DJ) Generated through expression:
rx_submission_clarifications	rx_submission_clarification_type[]	No	No	Pharmacist clarifications (up to 3) (from NCPDP 420-DK) Generated through expression:
rx_special_packaging	rx_special_packaging_type	Yes	No	Packaging or unit-dose format used when dispensing the medication (from NCPDP 429-DT) Generated through expression:
originally_prescribed_product_service_code_qualifier	product_service_code_type	Yes	No	The type of code used for the originally prescribed product/service code (from NCPDP 453-EJ) Generated through expression:
originally_prescribed_product_service_code	text	No	No	Identifies the originally prescribed product or service (from NCPDP 445-EA) Generated through expression:
originally_prescribed_quantity	numeric	Yes	No	Quantity of the originally prescribed product (from NCPDP 446-EB) Generated through expression:
scheduled_prescription_id_number	text	No	No	Serial identifier printed on the prescription form or blank used to issue the prescription (from NCPDP 454-EK) Generated through expression:
rx_level_of_service	rx_level_of_service_type	Yes	No	Level or mode of service provided with the prescription (from NCPDP 418-DI) Generated through expression:
prior_authorization_type	prior_authorization_type	Yes	No	Category of prior authorization or benefit exemption represented by the submitted authorization code, which is stored in line_item_prior_authorization_number (from NCPDP 461-EU) Generated through expression:
rx_dispensing_status	rx_dispensing_status_type	Yes	No	Whether the medication was dispensed as a partial fill or as the remainder of a previous partial fill (from NCPDP 343-HD) Generated through expression:
rx_quantity_intended	numeric	Yes	No	Amount of medication originally intended to be dispensed, assuming sufficient inventory (from NCPDP 344-HF) Generated through expression:
rx_days_supply_intended	numeric	Yes	No	Number of days the medication was expected to cover at the initial dispense absent inventory shortages (from NCPDP 345-HG) Generated through expression:
rx_route_of_administration	text	No	No	Route by which the medication is administered when it differs from the product's default route; for compounds, this reflects the route of the finished mixture. Uses SNOMED CT codes (from NCPDP 995-E2) Generated through expression:
rx_compound_type	rx_compound_type	Yes	No	Clarifies the type of compound (from NCPDP 996-G1) Generated through expression:
pharmacy_service_type	pharmacy_service_type	Yes	No	Pharmacy service category used when payer contracts or benefit rules vary based on the type of service provided (from NCPDP 147-U7) Generated through expression:
rx_usual_and_customary_charge	numeric	Yes	No	Price charged for the prescription before taxes or additional claimed amounts (from NCPDP 426-DQ) Generated through expression:
coupon_type	coupon_type	Yes	No	Type of coupon (from NCPDP 485-KE) Generated through expression:
coupon_number	text	No	No	Serial number assigned to the coupon (from NCPDP 486-ME) Generated through expression:
coupon_value_amount	text	No	No	The coupon's value (from NCPDP 487-NE) Generated through expression:
rx_compound_dosage_form	rx_compound_dosage_form_type	Yes	No	Dosage form of the completed compound mixture (from NCPDP 450-EF) Generated through expression:
rx_compound_dispensing_unit	unit_type	Yes	No	Units used for the compound (from NCPDP 451-EG) Generated through expression:
rx_generic_equivalent_product_service_code_qualifier	product_service_code_type	Yes	No	Identifies the type of code used to identify the generic equivalent (from NCPDP 125-TZ) Generated through expression:
rx_generic_equivalent_product_service_code	text	No	No	Identifies the generic equivalent (from NCPDP 126-UA) Generated through expression:
ambulance_patient_weight_units	unit_type	Yes	No	Unit of measure for patient weight (From X12 EDI CR101) Generated through expression:
ambulance_patient_weight_quantity	numeric	Yes	No	Patient Weight (From X12 EDI CR102) Generated through expression:
rx_ingredient_cost_submitted	numeric	Yes	No	Medication ingredient cost submitted by the pharmacy (from NCPDP 409-D9) Generated through expression:
rx_ingredient_cost_paid	numeric	Yes	No	Ingredient cost amount determined by the processor (from NCPDP 506-F6) Generated through expression:
rx_ingredient_cost_basis_submitted	rx_ingredient_cost_basis_type	Yes	No	Method by which the ingredient cost was calculated by the pharmacy (from NCPDP 423-DN) Generated through expression:
rx_ingredient_reimbursement_basis	rx_ingredient_cost_basis_type	Yes	No	Basis used by the processor to determine the ingredient cost paid (from NCPDP 522-FM) Generated through expression:
rx_dispensing_fee_submitted	numeric	Yes	No	Dispensing fee submitted by the pharmacy (from NCPDP 412-DC) Generated through expression:
rx_dispensing_fee_paid	numeric	Yes	No	Dispensing fee amount determined by the processor (from NCPDP 507-F7) Generated through expression:
rx_dispensing_fee_basis_of_calculation	basis_of_calculation_type	Yes	No	Basis used to calculate the dispensing fee paid (from NCPDP 346-HH) Generated through expression:
rx_incentive_amount_submitted	numeric	Yes	No	Incentive amount submitted by the pharmacy (from NCPDP 438-E3) Generated through expression:
rx_incentive_amount_paid	numeric	Yes	No	Incentive amount determined by the processor (from NCPDP 521-FL) Generated through expression:
rx_professional_service_fee_submitted	numeric	Yes	No	Professional service fee submitted by the pharmacy (from NCPDP 477-BE) Generated through expression:
rx_professional_service_fee_paid	numeric	Yes	No	Professional service fee determined by the processor (from NCPDP 562-J1) Generated through expression:
rx_delivery_cost_submitted	numeric	Yes	No	Delivery cost submitted by the pharmacy (from NCPDP 480-H9) Generated through expression:
rx_delivery_amount_paid	numeric	Yes	No	Delivery amount determined by the processor (from NCPDP 565-J4) Generated through expression:
rx_shipping_cost_submitted	numeric	Yes	No	Shipping cost submitted by the pharmacy (from NCPDP 480-H9) Generated through expression:
rx_shipping_amount_paid	numeric	Yes	No	Shipping amount determined by the processor (from NCPDP 565-J4) Generated through expression:
rx_postage_cost_submitted	numeric	Yes	No	Postage cost submitted by the pharmacy (from NCPDP 480-H9) Generated through expression:
rx_postage_amount_paid	numeric	Yes	No	Postage amount determined by the processor (from NCPDP 565-J4) Generated through expression:
rx_administrative_cost_submitted	numeric	Yes	No	Administrative cost submitted by the pharmacy (from NCPDP 480-H9) Generated through expression:
rx_administrative_amount_paid	numeric	Yes	No	Administrative amount determined by the processor (from NCPDP 565-J4) Generated through expression:
rx_compound_preparation_cost_submitted	numeric	Yes	No	Compound preparation cost submitted by the pharmacy (from NCPDP 480-H9) Generated through expression:
rx_compound_preparation_amount_paid	numeric	Yes	No	Compound preparation amount determined by the processor (from NCPDP 565-J4) Generated through expression:
rx_medication_administration_cost_submitted	numeric	Yes	No	Medication administration cost submitted by the pharmacy (from NCPDP 480-H9) Generated through expression:
rx_medication_administration_amount_paid	numeric	Yes	No	Medication administration amount determined by the processor (from NCPDP 565-J4) Generated through expression:
rx_medication_synchronization_cost_submitted	numeric	Yes	No	Medication synchronization cost submitted by the pharmacy (from NCPDP 480-H9) Generated through expression:
rx_medication_synchronization_amount_paid	numeric	Yes	No	Medication synchronization amount determined by the processor (from NCPDP 565-J4) Generated through expression:
rx_adherence_packaging_cost_submitted	numeric	Yes	No	Adherence packaging cost submitted by the pharmacy (from NCPDP 480-H9) Generated through expression:
rx_adherence_packaging_amount_paid	numeric	Yes	No	Adherence packaging amount determined by the processor (from NCPDP 565-J4) Generated through expression:
rx_flat_sales_tax_submitted	numeric	Yes	No	Flat sales tax submitted by the pharmacy (from NCPDP 481-HA) Generated through expression:
rx_flat_sales_tax_paid	numeric	Yes	No	Flat sales tax amount determined by the processor (from NCPDP 558-AW) Generated through expression:
rx_flat_sales_tax_basis_of_calculation	basis_of_calculation_type	Yes	No	Basis used to calculate the flat sales tax paid (from NCPDP 348-HK) Generated through expression:
rx_percentage_sales_tax_submitted	numeric	Yes	No	Percentage sales tax submitted by the pharmacy (from NCPDP 482-GE) Generated through expression:
rx_percentage_sales_tax_paid	numeric	Yes	No	Percentage sales tax amount determined by the processor (from NCPDP 559-AX) Generated through expression:
rx_percentage_sales_tax_rate_submitted	numeric	Yes	No	Percentage sales tax rate submitted by the pharmacy (from NCPDP 483-HE) Generated through expression:
rx_percentage_sales_tax_rate_paid	numeric	Yes	No	Percentage sales tax rate determined by the processor (from NCPDP 560-AY) Generated through expression:
rx_percentage_sales_tax_basis_submitted	rx_percentage_sales_tax_basis_type	Yes	No	Basis for percentage-based sales tax submitted by the pharmacy (from NCPDP 484-JE) Generated through expression:
rx_percentage_sales_tax_basis_paid	rx_percentage_sales_tax_basis_type	Yes	No	Basis for percentage-based sales tax determined by the processor (from NCPDP 561-AZ) Generated through expression:
rx_percentage_sales_tax_basis_of_calculation	basis_of_calculation_type	Yes	No	Basis used to calculate the percentage sales tax paid (from NCPDP 349-HM) Generated through expression:
rx_tax_exempt_indicator	rx_tax_exempt_indicator_type	Yes	No	Indicates whether the payer or patient is exempt from taxes (from NCPDP 557-AV) Generated through expression:
rx_cob_paid_amount_recognized	numeric	Yes	No	Total payment from other sources recognized by the processor (from NCPDP 566-J5) Generated through expression:
rx_total_amount_paid	numeric	Yes	No	Total amount to be paid by the processor (from NCPDP 509-F9) Generated through expression:
rx_amount_attributed_to_sales_tax	numeric	Yes	No	Portion of the patient pay amount attributed to sales tax, determined by the processor (from NCPDP 523-FN) Generated through expression:
rx_accumulated_deductible_amount	numeric	Yes	No	Deductible amount met by the patient or family (from NCPDP 512-FC) Generated through expression:
rx_remaining_deductible_amount	numeric	Yes	No	Remaining deductible amount not yet met by the patient or family (from NCPDP 513-FD) Generated through expression:
rx_remaining_benefit_amount	numeric	Yes	No	Amount remaining in the patient or family periodic benefit maximum (from NCPDP 514-FE) Generated through expression:
rx_amount_applied_to_deductible	numeric	Yes	No	Portion of the patient pay amount applied to a periodic deductible (from NCPDP 517-FH) Generated through expression:
rx_amount_exceeding_benefit_max	numeric	Yes	No	Portion of the patient pay amount due to exceeding a periodic benefit maximum (from NCPDP 520-FK) Generated through expression:
rx_copay_basis_of_calculation	basis_of_calculation_type	Yes	No	Basis used to calculate the copay amount (from NCPDP 347-HJ) Generated through expression:
rx_coinsurance_amount_basis_of_calculation	basis_of_calculation_type	Yes	No	Basis used to calculate the coinsurance amount (from NCPDP 573-4V) Generated through expression:
rx_amount_attributed_to_processor_fee	numeric	Yes	No	Portion of the patient pay amount due to a processing fee imposed by the processor (from NCPDP 571-NZ) Generated through expression:
rx_patient_sales_tax_amount	numeric	Yes	No	Patient sales tax responsibility (from NCPDP 575-EQ) Generated through expression:
rx_plan_sales_tax_amount	numeric	Yes	No	Plan sales tax responsibility (from NCPDP 574-2Y) Generated through expression:
rx_estimated_generic_savings	numeric	Yes	No	Amount the patient would have saved by choosing a generic drug instead of the brand drug (from NCPDP 577-G3) Generated through expression:
rx_spending_account_amount_remaining	numeric	Yes	No	Remaining balance in the patient's spending account after this transaction (from NCPDP 128-UC) Generated through expression:
rx_health_plan_funded_assistance_amount	numeric	Yes	No	Amount from the health plan-funded assistance account applied to reduce the patient pay amount (from NCPDP 129-UD) Generated through expression:
rx_amount_attributed_to_provider_network_selection	numeric	Yes	No	Portion of the patient pay amount due to the patient's provider network selection (from NCPDP 133-UJ) Generated through expression:
rx_amount_attributed_to_brand_selection	numeric	Yes	No	Portion of the patient pay amount due to the patient's selection of a brand product (from NCPDP 134-UK) Generated through expression:
rx_amount_attributed_to_non_preferred_formulary_selection	numeric	Yes	No	Portion of the patient pay amount due to the patient's selection of a non-preferred formulary product (from NCPDP 135-UM) Generated through expression:
rx_amount_attributed_to_brand_non_preferred_formulary_selection	numeric	Yes	No	Portion of the patient pay amount due to the patient's selection of a brand non-preferred formulary product (from NCPDP 136-UN) Generated through expression:
rx_amount_attributed_to_coverage_gap	numeric	Yes	No	Portion of the patient pay amount due to the patient being in a coverage gap (from NCPDP 137-UP) Generated through expression:
rx_ingredient_cost_reimbursable_amount	numeric	Yes	No	Contracted or reimbursable amount for the product being dispensed (from NCPDP 148-U8) Generated through expression:
rx_dispensing_fee_reimbursable_amount	numeric	Yes	No	Contracted or reimbursable dispensing fee for the product being dispensed (from NCPDP 149-U9) Generated through expression: