INVOICE_CLM_LN
Description:
This table contains line-level information for the claim generated from this INV record. This information is common to all claims for the INV; use INVOICE_CLM_LN_ADDL for invoice-specific information or line-level overrides.

Primary Key
Column Name Ordinal Position
INVOICE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 INVOICE_ID NUMERIC No
The unique ID of the invoice record.
2 LINE INTEGER No
The line number of the transaction ID item.
3 FROM_DATE_OF_SVC DATETIME No
The earliest date of service that appears on the transaction.
4 TO_DATE_OF_SVC DATETIME No
The latest (most recent) date of service that appears on the transaction.
5 PROC_ID NUMERIC No
The procedure ID that appears on the transaction.
6 MODIFIER_ONE VARCHAR No
The first modifier on the transaction. This is the external modifier, as it would be printed on the claim.
7 MODIFIER_TWO VARCHAR No
The second modifier on the transaction. This is the external modifier, as it would be printed on the claim.
8 MODIFIER_THREE VARCHAR No
The third modifier on the transaction. This is the external modifier, as it would be printed on the claim.
9 MODIFIER_FOUR VARCHAR No
The fourth modifier on the transaction. This is the external modifier, as it would be printed on the claim.
10 QUANTITY NUMERIC No
The quantity that appears on the transaction.
11 CHARGE_AMOUNT NUMERIC No
The dollar amount that appears on the transaction.
12 NON_COVERED_AMT NUMERIC No
The amount not covered on the transaction.
13 TYPE_OF_SERVICE_C_NAME VARCHAR No
The type of service performed for the charge.
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
14 SPECIAL_GRP_TYPE_C_NAME VARCHAR No
This is the type of grouping for this line in the invoice.
May contain organization-specific values: Yes
Category Entries:
Inpatient Charge Transfer
Radiation Therapy by Procedure Treatment Level
Panel Bundling
Global Billing Setup
FQHC Bundling
Medi-Cal Rural Health Bundling
FQHC Billing
FPEP Bundling
Bilateral Bundling
Bundle Tax With Original Charges
Bundle Tax Charges Only
PQRI Bundle Zero Amount
Claim Complete
Professional Claim Line Bundling
Global Payment Setup
Professional and Technical Component Bundling
15 UB_MIN_SERVICE_DT DATETIME No
The UB form minimum service date for the invoice.
16 UB_MAX_SERVICE_DT DATETIME No
The UB form maximum service date for the invoice.
17 DX_POINTER VARCHAR No
Diagnosis pointers. This is a comma-delimited string indicating which diagnosis or diagnoses apply to this line that would appear on the claim. Each pointer corresponds to a line in INV_DX_INFO.