It looks like you have an older browser that is not supported by this site. Please click here to update.

Data Specifications

Go Back

Providers

Providers are specialized contacts that are able to place orders directly for patients, such as physicians, doctors or nurse practitioners. These individuals would also have a National Provider Identifier (NPI).
Legend:
Required
Recommended/drive dashboards
hc1 related field
Optional
SaveMode
Selects a method of creating or updating records. Must be one of the options below.
  • insert — Will only create new records. If data already exists, an error will be thrown.
  • upsert — Will look for existing data and update it if found; if not found, a new record will be created.
  • update — Will only update existing records. If data is not found, an error will be thrown.
 
RecordKeyID
🔍︎
The database ID that is assigned to a record upon initial import. This can be found in URL of the record in hc1.
 
RecordKeyConnID
Related to hc1 
🔍︎
Must match a connection ID in hc1.
  • Lab_Interface
 
RecordKeyHostCode
🔍︎
🔍︎
Same as HostCodes for lookup purposes only. When inserting/updating records with more than one hostcode, you must enter the first code as "RecordKeyHostCode" lookup and all other codes under "HostCodes"
  • Provider100
 
HostCodeModes
Use mode to update hostcodes on the contact record.
  • Replace
  • Add
 
ConnIDs
Related to hc1 
🔍︎
Internal hc1 use, must match a connection ID in hc1.
  • Lab_Interface
 
HostCodes Alphanumeric
🔍︎
🔍︎
Used together with ConnID to create a unique identifier.
  • Provider100
  • Provider100^FinProvider999
 
Salutation
🔍︎
Must be one of the 4 available options below.
  • Dr.
  • Mr.
  • Mrs.
  • Ms.
 
FirstName Free text
🔍︎
  • John
 
MiddleName Free text
🔍︎
 
LastName Free text
🔍︎
  • Smith
 
Suffix Free text
🔍︎
  • Jr.
 
OrganizationIDs
The database ID that is assigned to a record upon initial import. This can be found in URL of the record in hc1.
Use either OrganizationIDs or OrganizationConnIDs + OrganizationHostCodes to relate providers to organizations.
 
OrganizationConnIDs
Related to hc1 
Must match a connection ID in hc1.
  • Lab_Interface
 
OrganizationHostCodes Related to hc1 Organization HostCode(s)
🔍︎
Unique organizations the provider is associated with.
  • Org100
  • Org100^Org200
 
OrganizationsMode
Used to determine how to handle the relationship between the provider and associated organization(s). Defaults to append.
  • Append
  • Overwrite
 
OrganizationContactTypeNames
Related to hc1 
🔍︎
Must match a value from the "ContactTypes" tab. There must be a one-to-one relationship between a contact type and an Organization HostCode.
  • Administrator
  • Adminstrator^Physician
 
NPI
🔍︎
National Provider Identifier Number
  • 123456789
 
Credentials Free text
🔍︎
  • MD,PhD
 
JobTitle Free text
🔍︎
  • Oncologist
 
Department Free text
🔍︎
  • Oncology
 
MailingAddressStreet1 Free text
🔍︎
  • 123 Main Street
 
MailingAddressStreet2 Free text
🔍︎
  • Suite 100
 
MailingAddressCity Free text
🔍︎
  • Indianapolis
 
MailingAddressState Free text
🔍︎
  • IN
 
MailingAddressPostalCode Free text
🔍︎
  • 46278
  • 46278-1234
  • 462781234
 
MailingAddressCountry Free text
🔍︎
  • USA
  • United States
 
OtherAddressStreet1 Free text
🔍︎
  • 555 Main Street
 
OtherAddressStreet2 Free text
🔍︎
  • Suite A
 
OtherAddressCity Free text
🔍︎
  • Indianapolis
 
OtherAddressState Free text
🔍︎
  • IN
 
OtherAddressPostalCode Free text
🔍︎
  • 46278
  • 46278-1234
  • 462781234
 
OtherAddressCountry Free text
🔍︎
  • USA
  • United States
 
Phone Free text
🔍︎
  • 555-555-1234
  • (555) 555-1234
  • 5555551234
 
Mobile Free text
🔍︎
  • 555-555-1234
  • (555) 555-1234
  • 5555551234
 
OtherPhone Free text
🔍︎
  • 555-555-1234
  • (555) 555-1234
  • 5555551234
 
Fax Free text
🔍︎
  • 555-555-1234
  • (555) 555-1234
  • 5555551234
 
Email Free text
🔍︎
  • provider@email.com
 
SpecialtyNames
Related to hc1 
🔍︎
Must match a value from the "Specialties" tab.
  • Emergency
  • Emergency^Critical Care
 
IsLead Boolean
🔍︎
Marks whether a provider is a lead/prospect. Defaults to false.
  • false
  • true
 
IsCustomer Boolean
🔍︎
Marks whether a provider is a customer. Defaults to false.
  • false
  • true
 
PreferEmails
Boolean
🔍︎
  • true
  • false
 
PreferTexts
Boolean
🔍︎
  • true
  • false
 
Active Boolean
Marks whether a provider is an active record in hc1. Defaults to true.
  • true
  • false
 

Contact Us



Please contact your Service Delivery Manager or Sales Representative with any questions or concerns you may have.