export_service_line | Candid

Data at the service line level.

Primary Key: service_line_id

Identifiers

service_line_id

STRINGRequired

Unique Service Line ID

encounter_id

STRING

Unique ID associated with the encounter 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)

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<STRING>

List of Modifiers

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