SVC_LN_INFO_2
Description:
All values associated with a claim are stored in the Claim External Value record. The SVC_LN_INFO_2 table holds information about the service lines on the claim.

Primary Key
Column Name Ordinal Position
RECORD_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier for the claim record.
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 LN_TOS VARCHAR No
This item holds the type of service for the procedure on the service line.
4 LN_DATE_QUAL VARCHAR No
This item holds a qualifier to distinguish between a single date (when the from and to dates are the same) and a date range (when the from and to dates are different).
5 LN_PURCH_SERV_AMT NUMERIC No
This item holds the purchased service charge amount for the line.
6 LN_REFERRING_CLIA VARCHAR No
This item holds the Clinical Laboratory Improvement Amendment (CLIA) number of the referring lab for the line.
7 LN_HOSPICE_EMP_IND VARCHAR No
This item holds the Hospice Employee Indicator.
8 LN_HOSPICE_COND_IND VARCHAR No
This item holds the Hospice Condition Indicator.
9 LN_TTL_AMT_PAID NUMERIC No
This item holds the total amount paid for the line by all payers. This item is populated for both paper and electronic Professional Billing Centers for Medicare and Medicaid Services (CMS) claims but is only used when printing paper claims.
10 LN_ADJR_ITM_REF_NUM VARCHAR No
This item stores the Adjusted Repriced Line Item Reference Number.
11 LN_SERV_TAX_AMT NUMERIC No
This item stores the line's Service Tax Amount.
12 LN_FAC_TAX_AMT NUMERIC No
This item stores the line's Facility Tax Amount.
13 LN_REP_ITM_REF_NUM VARCHAR No
This item stores the Repriced Line Item Reference Number.
14 LN_PRC_METHOD VARCHAR No
This item stores the Line Pricing Methodology.
15 LN_ALLOWED_AMT NUMERIC No
This item stores the Line Allowed Amount.
16 LN_SAVINGS_AMT NUMERIC No
This item stores the Line Savings Amount.
17 LN_REP_ORG_ID VARCHAR No
This item stores the Line Repricing Organization Identification Number.
18 LN_PRICING_RATE NUMERIC No
This item stores the Line Pricing Rate.
19 LN_APPRVED_DRG_CODE VARCHAR No
This item stores the Line's Approved diagnosis related group (DRG) Code.
20 LN_APP_DRG_AMT NUMERIC No
This item stores the Line Approved diagnosis related group (DRG) Code.
21 LN_APP_REV_CODE VARCHAR No
This item stores the Line Approved Revenue Code.
22 LN_REPAPR_HCPCS_QL VARCHAR No
This item stores the Line Repriced Approved Healthcare common Procedure Coding System (HCPS).
23 LN_REPAPP_HCPCS VARCHAR No
This item stores the Line Repriced Approved (Healthcare Common Procedure Coding System (HCPCS) Code.
24 LN_UNIT_MSRMNT_CODE VARCHAR No
This item stores the Line Unit or Basis for Measurement Code.
25 LN_APR_SVC_UNT NUMERIC No
This item stores the Line Approved Service Units or Inpatient Days.
26 LN_OPR_SER_ETQ VARCHAR No
This item stores the Entity Type Qualifier for line's Operating Physician ID.
27 LN_OPR_LAST_NAME VARCHAR No
This item stores the line's Operating Physician's Last Name.
28 LN_OPR_FIRST_NAME VARCHAR No
This item stores the line's Operating Physician's First Name.
29 LN_OPR_MID_NAME VARCHAR No
This item stores the line's Operating Physician's Middle Name.
30 LN_OPR_NAME_SUFFIX VARCHAR No
This item stores the line's Operating Physician's Name Suffix.
31 LN_OPR_NPI VARCHAR No
This item stores the line's Operating Physician's ID.
32 LN_OTH_OPR_ETQ VARCHAR No
This item stores the qualifier for line's Other Operating Physician.
33 LN_OTH_OPR_LAST_NM VARCHAR No
This item stores the line's Other Operating Physician's Last Name.
34 LN_OTH_OPR_FIRST_NM VARCHAR No
This items stores the line's Other Operating Physician's First Name.
35 LN_OTH_OPR_MID_NM VARCHAR No
This item stores the line's Other Operating Physician's Middle Name.
36 LN_OTH_OPR_SUF_NM VARCHAR No
This item stores the line's Other Operating Physician's Name Suffix.
37 LN_OTH_OPR_NPI VARCHAR No
This item stores the line's Other Operating Physician ID.
38 LN_REF_ETQ VARCHAR No
This item stores the line's Referring Provider's Entity Type Qualifier.
39 LN_REF_LAST_NM VARCHAR No
This item stores the line's Referring Provider's Last Name.
40 LN_REF_FIRST_NM VARCHAR No
This item stores line's Referring Provider's First Name.
41 LN_REF_MID_NM VARCHAR No
This item stores the line's Referring Provider's Middle Name.
42 LN_REF_SUFFIX_NM VARCHAR No
This item stores the line's Referring Provider's Name Suffix.
43 LN_REF_NPI VARCHAR No
This item stores the line's Referring Provider's National Provider Identifier (NPI).
44 LN_DME_PROC_CD VARCHAR No
Stores Line durable medical equipment (DME) Procedure Code
45 LN_DME_QTY NUMERIC No
Stores Line durable medical equipment (DME) Length of Medical Necessity
46 LN_DME_RENTAL_PRICE NUMERIC No
Stores Line durable medical equipment (DME) Rental Unit Price Indicator
47 LN_DME_PUR_PRICE NUMERIC No
Stores Line durable medical equipment (DME) Purchase Price
48 LN_DME_RUP_IND VARCHAR No
Stores Line DME Rental Unit Price Indicator
49 LN_AMB_PAT_WT NUMERIC No
Stores Line Ambulance Patient Weight
50 LN_AMB_TRANS_RSN_CD VARCHAR No
Stores Line Ambulance Transport Reason Code
51 LN_AMB_TRANS_DIST NUMERIC No
Stores Line Ambulance Transport Distance
52 LN_AMB_RND_TRIP_DES VARCHAR No
Stores Line Ambulance Round Trip Purpose Description
53 LN_AMB_STRETCH_DESC VARCHAR No
Stores Line Ambulance Stretcher Purpose Description
54 LN_RX_DT DATETIME No
Stores Line Prescription Date
55 LN_LST_CERT_DT DATETIME No
Stores Line Last Certification Date
56 LN_LST_SEEN_DT DATETIME No
Stores Line Last Seen Date
57 LN_SHIPPED_DT DATETIME No
Stores Line Shipped Date
58 LN_LST_XRAY_DT DATETIME No
Stores Line Last X-Ray Date
59 LN_INIT_TREAT_DT DATETIME No
Stores Line Initial Treatment Date
60 LN_OBS_ADDL_UNTS NUMERIC No
Stores Line Obstetric Additional Units
61 LN_IMMNZTN_BAT_NUM VARCHAR No
Stores Line Immunization Batch Number
62 LN_SALES_TAX_AMT NUMERIC No
Stores Line Sales Tax Amount
63 LN_POST_CLM_AMT NUMERIC No
Stores Line Postage Claimed Amount
64 LN_ORD_CNCT_NAM VARCHAR No
Stores Line Ordering Provider Contact Name
65 LN_PICK_UP_ADDR_1 VARCHAR No
Stores Line Ambulance Pick-Up Location Street Address Line 1
66 LN_PICK_UP_ADDR_2 VARCHAR No
Stores Line Ambulance Pick-Up Location Street Address Line 2
67 LN_PICK_UP_CITY VARCHAR No
Stores Line Ambulance Pick-Up Location City
68 LN_PICK_UP_STATE VARCHAR No
Stores Line Ambulance Pick-Up Location State
69 LN_PICK_UP_ZIP VARCHAR No
Stores Line Ambulance Pick-Up Location Zip Code
70 LN_PICK_UP_CNTRY VARCHAR No
Stores Line Ambulance Pick-Up Location Country Code
71 LN_PICK_UP_CNTRY_S VARCHAR No
Stores Line Ambulance Pick-Up Location Country Subdivision Code
72 LN_DROP_OFF_NAME VARCHAR No
Stores Line Ambulance Drop-Off Location Name
73 LN_DROP_OFF_ADDR_1 VARCHAR No
Stores Line Ambulance Drop-Off Location Address Line 1
74 LN_DROP_OFF_ADDR_2 VARCHAR No
Stores Line Ambulance Drop-Off Location Street Address Line 2
75 LN_DROP_OFF_CITY VARCHAR No
Stores Line Ambulance Drop-Off Location City
76 LN_DROP_OFF_STATE VARCHAR No
Stores Line Ambulance Drop-Off Location State
77 LN_DROP_OFF_ZIP VARCHAR No
Stores Line Ambulance Drop-Off Location Zip
78 LN_DROP_OFF_CNTRY VARCHAR No
Stores Line Ambulance Drop-Off Location Country Code
79 LN_DROP_OFF_CNTRY_S VARCHAR No
Stores Line Ambulance Drop-Off Location Country Subdivision Code
80 LN_SVC_FAC_IDEN VARCHAR No
Stores line service facility location's entity identifier
81 LN_RECERT_DT DATETIME No
Store line recertification date
82 LN_QTY_TXT VARCHAR No
This item holds the units of quantity string for a service line.
83 LN_NOTE_TPO VARCHAR No
This item holds a line level third party organization note.
84 LN_PURCH_SERV_REF VARCHAR No
This item holds the purchased service reference identifier for the line.
85 LN_DME_LAST_CERT_DT DATETIME No
The last certification date for a durable medical equipment (DME) to be printed on the claim.
86 LN_REF_ENTITY_IDENTIFIER_CODE VARCHAR No
This item stores the line's referring provider's entity identifier code.
87 LN_FILL_NUMBER VARCHAR No
The code indicating whether the prescription is an original or a refill.
88 LN_DAYS_SUPPLY INTEGER No
Estimated number if days the prescription will last.
89 LN_DAW_CODE VARCHAR No
Code indicating whether or not the prescriber's instructions regarding generic substitution were followed.
90 LN_NDC_COST NUMERIC No
This item holds the unit cost associated with the National Drug Code (NDC) for the service line, which is expected to be the charge amount divided by the NDC quantity.
91 LN_MCR_PAID_AMT NUMERIC No
This is the amount that Medicare paid for the service line for field.
92 LN_OTHR_PAID_AMT NUMERIC No
This is the amount that the commercial coverage, if any, paid for this service line.