> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://docs.joincandidhealth.com/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.joincandidhealth.com/_mcp/server. # export_service_line > Data at the service line level Data at the service line level. **Primary Key:** `service_line_id` ## Identifiers **`service_line_id`** `STRING` — required Unique Service Line ID --- **`encounter_id`** `STRING` Unique ID associated with the encounter in the Candid system --- **`claim_id`** `STRING` Unique Claim ID in the Candid system --- **`external_id`** `STRING` External ID --- ## Timestamps **`created_at`** `DATETIME` Time at which the service line is first created in the database --- **`updated_at`** `DATETIME` Time at which the service line is updated in the database (note: the database tables overall are updated at 5 AM EST daily) --- **`deleted_at`** `TIMESTAMP` When was the service line soft-deleted from the Candid system? --- ## Organization **`organization_id`** `STRING` User's unique organization ID in the Candid system --- **`organization_name`** `STRING` User's Organization / Company Name --- **`external_organization_id`** `STRING` Organization's External ID - the ID that the organization uses to map to their own upstream system --- ## Referring Provider **`referring_provider_first_name`** `STRING` Referring Provider First Name --- **`referring_provider_last_name`** `STRING` Referring Provider Last Name --- **`referring_provider_organization_name`** `STRING` Referring Provider Organization Name --- **`referring_provider_tax_id`** `STRING` Referring Provider Tax ID --- **`referring_provider_npi`** `STRING` Referring Provider NPI Number --- **`referring_provider_taxonomy_code`** `STRING` Referring Provider Taxonomy Code --- **`referring_provider_qualifier`** `STRING` Specific code used on claim forms to identify the healthcare professional who sent a patient to another provider for services --- **`referring_provider_address_address_1`** `STRING` Referring Provider Address --- **`referring_provider_address_address_2`** `STRING` Referring Provider Address (Additional Information) --- **`referring_provider_address_city`** `STRING` Referring Provider City --- **`referring_provider_address_state`** `STRING` Referring Provider State --- **`referring_provider_address_zip_code`** `STRING` Referring Provider Zip Code --- **`referring_provider_address_zip_plus_four_code`** `STRING` Referring Provider Zip Code (Plus Four Code) --- **`initial_referring_provider_first_name`** `STRING` Initial Referring Provider First Name --- **`initial_referring_provider_last_name`** `STRING` Initial Referring Provider Last Name --- **`initial_referring_provider_organization_name`** `STRING` Initial Referring Provider Organization --- **`initial_referring_provider_tax_id`** `STRING` Initial Referring Provider Tax ID --- **`initial_referring_provider_npi`** `STRING` Initial Referring Provider NPI --- **`initial_referring_provider_taxonomy_code`** `STRING` Initial Referring Provider Taxonomy Code --- **`initial_referring_provider_qualifier`** `STRING` Specific code used on claim forms to identify the initial healthcare professional who sent a patient to another provider for services --- **`initial_referring_provider_address_address_1`** `STRING` Initial Referring Provider Address Line --- **`initial_referring_provider_address_address_2`** `STRING` Initial Referring Provider Address (Second Line) --- **`initial_referring_provider_address_city`** `STRING` Initial Referring Provider City --- **`initial_referring_provider_address_state`** `STRING` Initial Referring Provider State --- **`initial_referring_provider_address_zip_code`** `STRING` Initial Referring Provider Zip Code --- **`initial_referring_provider_address_zip_plus_four_code`** `STRING` Initial Referring Provider Zip Code (Plus Four Code) --- ## Supervising Provider **`supervising_provider_first_name`** `STRING` Supervising Provider First Name --- **`supervising_provider_last_name`** `STRING` Supervising Provider Last Name --- **`supervising_provider_organization_name`** `STRING` Supervising Provider Organization Name --- **`supervising_provider_tax_id`** `STRING` Supervising Provider Tax ID --- **`supervising_provider_npi`** `STRING` Supervising Provider NPI --- **`supervising_provider_taxonomy_code`** `STRING` Supervising Provider Taxonomy Code --- **`supervising_provider_qualifier`** `STRING` Specific code used on a claim form to identify the healthcare professional who was responsible for overseeing the services rendered to a patient --- **`supervising_provider_address_address_1`** `STRING` Supervising Provider Address Line --- **`supervising_provider_address_address_2`** `STRING` Supervising Provider Second Address --- **`supervising_provider_address_city`** `STRING` Supervising Provider City --- **`supervising_provider_address_state`** `STRING` Supervising Provider State --- **`supervising_provider_address_zip_code`** `STRING` Supervising Provider Zip Code --- **`supervising_provider_address_zip_plus_four_code`** `STRING` Supervising Provider Zip Code (Additional Numbers) --- ## Ordering Provider **`ordering_provider_first_name`** `STRING` Ordering Provider's First Name --- **`ordering_provider_last_name`** `STRING` Ordering Provider's Last Name --- **`ordering_provider_organization_name`** `STRING` Ordering Provider's Organization Name --- **`ordering_provider_tax_id`** `STRING` Ordering Provider's Tax ID --- **`ordering_provider_npi`** `STRING` Ordering Provider's NPI number --- **`ordering_provider_taxonomy_code`** `STRING` Ordering Provider's Taxonomy Code --- **`ordering_provider_qualifier`** `STRING` Specific code used in medical billing to identify the healthcare professional who ordered a particular service or item for a patient --- **`ordering_provider_address_address_1`** `STRING` Ordering Provider's Address Line 1 --- **`ordering_provider_address_address_2`** `STRING` Ordering Provider's Address Line 2 --- **`ordering_provider_address_city`** `STRING` Ordering Provider's City --- **`ordering_provider_address_state`** `STRING` Ordering Provider's State --- **`ordering_provider_address_zip_code`** `STRING` Ordering Provider's Zip Code --- **`ordering_provider_address_zip_plus_four_code`** `STRING` Ordering Provider's Zip Code (Additional Numbers) --- ## Received Ordering Provider **`received_ordering_provider_npi`** `STRING` Ordering Provider NPI as originally received on the claim, before any Candid normalization --- **`received_ordering_provider_first_name`** `STRING` Ordering Provider first name as originally received on the claim --- **`received_ordering_provider_last_name`** `STRING` Ordering Provider last name as originally received on the claim --- **`received_ordering_provider_name`** `STRING` Ordering Provider full name as originally received on the claim --- ## Diagnosis **`diagnosis_zero_name`** `STRING` Diagnosis Zero Name --- **`diagnosis_zero_code`** `STRING` Diagnosis Zero Code --- **`diagnosis_zero_code_type`** `STRING` Diagnosis Zero Type --- **`diagnosis_zero_position`** `INTEGER` Diagnosis Zero Position --- **`diagnosis_one_name`** `STRING` Diagnosis One Name --- **`diagnosis_one_code`** `STRING` Diagnosis One Code --- **`diagnosis_one_code_type`** `STRING` Diagnosis One Code Type --- **`diagnosis_one_position`** `INTEGER` Diagnosis One Position --- **`diagnosis_two_name`** `STRING` Diagnosis Two Name --- **`diagnosis_two_code`** `STRING` Diagnosis Two Code --- **`diagnosis_two_code_type`** `STRING` Diagnosis Two Type --- **`diagnosis_two_position`** `INTEGER` Diagnosis Two Position --- **`diagnosis_three_name`** `STRING` Diagnosis Three Name --- **`diagnosis_three_code`** `STRING` Diagnosis Three Code --- **`diagnosis_three_code_type`** `STRING` Diagnosis Three Type --- **`diagnosis_three_position`** `INTEGER` Diagnosis Three Position --- ## Other **`procedure_code`** `STRING` Procedure Code --- **`date_of_service`** `DATE` Date of Service --- **`end_date_of_service`** `DATE` End Date of Service (for an encounter spanning multiple days) --- **`quantity`** `STRING` Quantity of Services Provided --- **`units`** `STRING` Units, usually associated with one CPT code --- **`modifiers`** `ARRAY` List of Modifiers --- **`modifiers_string`** `STRING` Comma-separated string representation of modifiers --- **`revenue_code`** `STRING` Revenue code for the service line (Institutional Claims only) --- **`position`** `INTEGER` Position --- **`drug_identification_service_id_qualifier`** `STRING` Code used to specify the type of identification number being used for a particular drug or product --- **`drug_identification_national_drug_code`** `STRING` Three-segment numerical identifier assigned to each drug product marketed in the United States --- **`drug_identification_national_drug_unit_count`** `STRING` Specifies the exact quantity of a drug administered to a patient --- **`drug_identification_measurement_unit_code`** `STRING` Unit of measure for the quantity of a drug being dispensed or administered --- **`drug_identification_link_sequence_number`** `STRING` Identifier used primarily to connect multiple drug components to a single service or procedure, especially in the case of compound drugs --- **`drug_identification_pharmacy_prescription_number`** `STRING` Sequential identifier assigned by a pharmacy to a specific prescription for a particular patient --- **`conversion_formula`** `STRING` Conversion Formula --- **`drug_description`** `STRING` Drug Description --- **`place_of_service_code`** `STRING` Two-digit code indicating the setting where healthcare services were provided and / or rendered --- **`place_of_service_code_as_submitted`** `STRING` Place of Service Code as it is submitted to the Payer (after it has been run through the Rules Engine / POS configurations) --- **`description`** `STRING` Description --- **`is_deleted`** `BOOLEAN` Has the service line been soft deleted from the Candid system? --- **`prior_authorization_number`** `STRING` Prior Authorization Number ---