Skip to navigation

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

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 the service line was deleted in 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

custom_procedure_code
STRING

Custom Procedure Code configured for the organization. Only populated if the value was used to set charge amount.

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
JSON

List of Modifiers. Delivered as ARRAY<STRING> in BigQuery-direct datasets.

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

Whether the service line was deleted in the Candid system. Deleted service lines remain in this table as tombstones so incremental consumers can remove them.

prior_authorization_number
STRING

Prior Authorization Number

Sync columns

_cds_row_version
TIMESTAMP

Time when this row’s delivered data last changed. Use this for incremental ingestion.

_cds_row_fingerprint
STRING

Hash of this row’s delivered data. Changes whenever any value in the row changes.