SVC_LN_INFO_3

Description: |
All values associated with a claim are stored in the Claim External Value record. The SVC_LN_INFO_3 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 value record
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | LN_INGRED_COST_PAID | NUMERIC | No |
Drug ingredient cost paid.
4 | LN_DISP_FEE_PAID | NUMERIC | No |
Dispensing fee paid.
5 | LN_PAT_PAY_AMT | NUMERIC | No |
Patient pay amount.
6 | LN_COPAY_AMT | NUMERIC | No |
Amount of patient copay.
7 | LN_COINS_AMT | NUMERIC | No |
Amount of patient coinsurance.
8 | LN_DEDUCT_AMT | NUMERIC | No |
Amount of patient deductible.
9 | LN_REGLTRY_FEE_AMT | NUMERIC | No |
Flat sales tax amount paid.
10 | LN_PCT_TAX_AMT | NUMERIC | No |
Percentage tax amount paid.
11 | LN_INCENTIVE_AMT | NUMERIC | No |
Incentive amount paid.
12 | LN_OTHR_AMT_RECOGZ | NUMERIC | No |
Total amount recognized by the processor of any payment from another source.
13 | LN_NET_AMT_DUE | NUMERIC | No |
Net amount paid to provider by the payer.
14 | LN_DENT_PROS_QUAL | VARCHAR | No |
This item holds a code indicating if the date for a prior crown/prosthesis is estimated or exact.
15 | LN_DENT_PROS_DATE | DATETIME | No |
The date a prior crown/prosthesis was previously placed.
16 | SVC_DENIED_STATUS_IDENT | VARCHAR | No |
This stores the external identifier for the denial status of this line.
17 | PRCS_IND_CD | VARCHAR | No |
Claim line level processing indicator code.
18 | PRCS_IND_CD_DESC | VARCHAR | No |
Claim line level processing indicator code description.
19 | LN_OPR_TAXONOMY | VARCHAR | No |
Stores the Line Operating Provider Taxonomy Code.
20 | LN_APPLIANCE_REPLACEMENT_DATE | DATETIME | No |
The date when an orthodontic appliance was replaced.
21 | LN_TREATMENT_START_DATE | DATETIME | No |
The date of the initial treatment for a dental service.
22 | LN_TREATMENT_COMPLETION_DATE | DATETIME | No |
The date of the completed treatment for a dental service.
23 | LN_FILL_STATUS | VARCHAR | No |
Stores information on whether the prescription was completely or partially filled.
24 | LN_ORD_TAXONOMY | VARCHAR | No |
Stores the National Uniform Claim Committee (NUCC) taxonomy code associated with the line-level operating provider
25 | LN_APPLIANCE_PLACEMENT_DATE | DATETIME | No |
The date when the orthodontic appliance was placed.
26 | LN_LIN_QUALIFIER | VARCHAR | No |
Qualifier code to identify drug code set or the type/source of the descriptive number used in Product/Service ID.
27 | LN_PRESC_PROV_NPI | VARCHAR | No |
This column holds the National Provider Identifier (NPI) of the provider that prescribed the medication on this service.
28 | LN_PRESC_PROV_TAXONOMY | VARCHAR | No |
This column holds the NUCC Taxonomy Code of the provider that prescribed the medication on this service.
29 | LN_SERV_PROV_NPI | VARCHAR | No |
This item holds the National Provider Identifier (NPI) of the pharmacy that filled the prescription.
30 | LN_SERV_PROV_TAXONOMY | VARCHAR | No |
This column holds the NUCC Taxonomy Code of the pharmacy that filled the prescription.
31 | LN_DX_PTR_RANK | VARCHAR | No |
The comma-delimited list of diagnoses ranks for each diagnosis on a service. Each position here corresponds to the same comma-delimited position of the column LN_DX_PTR from the SVC_LN_INFO table. The rank here specifies the ranking of diagnoses for the specific service. This can be different than the rank of the same diagnoses at the header-level or even the same diagnoses for a different service.
32 | LN_PCP_REF_LAST_NM | VARCHAR | No |
This item stores the line's PCP referring provider's last name.
33 | LN_PCP_REF_FIRST_NM | VARCHAR | No |
This item stores the line's PCP referring provider's first name.
34 | LN_PCP_REF_MID_NM | VARCHAR | No |
This item stores the line's PCP referring provider's middle name.
35 | LN_PCP_REF_SUFFIX_NM | VARCHAR | No |
This item stores the line's PCP referring provider's suffix.
36 | LN_PCP_REF_NPI | VARCHAR | No |
This item stores the line's PCP referring provider's NPI.
37 | RX_DATE | DATETIME | No |
The date when the prescription was written.
38 | SUB_CLAR_CODE | VARCHAR | No |
The code indicating that the pharmacist is clarifying the submission.
39 | RX_ORIGIN_CODE | VARCHAR | No |
The code indicating the origin of the prescription.
40 | RX_PHARM_SRV_TYPE | VARCHAR | No |
The type of service being performed by a pharmacy when different contractual terms exist between a payer and the pharmacy, or when benefits are based upon the type of service performed.
41 | RX_PROD_DESC | VARCHAR | No |
The description of the product being submitted on the prescription claim.
42 | OTHER_CVG_CODE | VARCHAR | No |
The code indicating whether or not the patient has other insurance coverage.
43 | RX_SERVICE_LEVEL | VARCHAR | No |
The code indicating the type of service the provider rendered.
44 | QTY_PRESCRIBED | NUMERIC | No |
The quantity of prescription drug expressed in metric decimal units.
45 | REASON_SVC_CODE | VARCHAR | No |
The code identifying the type of utilization conflict detected or the reason for the pharmacist's professional service.
46 | PROF_SRVC_CODE | VARCHAR | No |
The code identifying pharmacist intervention when a conflict code has been identified or service has been rendered.
47 | RES_SVC_CODE | VARCHAR | No |
The code describing a pharmacist's action in response to a professional conflict.
48 | LEVEL_OF_EFFORT | VARCHAR | No |
The code indicating the level of effort as determined by the complexity of decision-making or resources utilized by a pharmacist to perform a professional service.
49 | DOSAGE_FORM_DESC_CD | VARCHAR | No |
The dosage form of the complete compound mixture.
50 | DISP_UNIT_FORM_INDICATOR | VARCHAR | No |
The NCPDP standard product billing codes.
51 | ADMIN_ROUTE | VARCHAR | No |
An override to the "default" route referenced for the product. For a multi-ingredient compound, it is the route of the complete compound mixture.
52 | INGREDIENT_COMPOUND_CNT | INTEGER | No |
The count of compound product IDs (both active and inactive) in the compound mixture submitted.
53 | USUAL_CUSTOMARY_CHG | INTEGER | No |
The amount charged to cash customers for the prescription exclusive of sales tax or other amounts claimed.
54 | COST_BASIS | VARCHAR | No |
The code indicating the method used to calculate the ingredient cost.
55 | INGREDIENT_COST_SUBMITTED | NUMERIC | No |
The product component cost of the dispensed prescription.
56 | DISP_FEE_SUBMITTED | NUMERIC | No |
The dispensing fee submitted by the pharmacy.
57 | PROF_FEE_SUBMITTED | NUMERIC | No |
The amount submitted by the provider for professional services rendered.
58 | INGREDIENT_AMT_SUBMITTED | NUMERIC | No |
The amount representing the fee that is submitted by the pharmacy for contractually agreed upon services.
59 | OTHER_AMT_SUBMITTED | NUMERIC | No |
The amount representing the additional incurred costs for a dispensed prescription or service.
60 | GROSS_AMOUNT_DUE | NUMERIC | No |
The total gross amount submitted on the claim.
61 | LN_PICK_UP_CNTY | VARCHAR | No |
County in which the ambulance pick-up occured.
62 | LN_DROP_OFF_CNTY | VARCHAR | No |
Stores the Line Ambulance Drop-Off Location County
63 | LN_START_LOCAL_DTTM | DATETIME (Local) | No |
Stores the line service start time.
64 | LN_END_LOCAL_DTTM | DATETIME (Local) | No |
Stores the end time for the service.
65 | LN_ELAPSED_TIME | VARCHAR | No |
Stores the time between the start and end time for the service.
66 | SECTION_340B | VARCHAR | No |
Section 340B Program Participant - if drug was dispensed under 340B program (yes/no)
67 | ACTIVITY_TCN | VARCHAR | No |
This item stores the Activity ID of a single activity line on the claim.
68 | ACTIVITY_VAT_PERCENT | NUMERIC | No |
This item stores the VAT percent for a single activity line on the claim.
69 | ACTIVITY_CODE | VARCHAR | No |
This item stores the Activity code of a single activity line on the claim.
70 | ACTIVITY_START_DATE | DATETIME | No |
This item stores the activity start date of a single activity line on the claim.