Skip Ribbon Commands
Skip to main content

Requirements for data retrieved from SQL sources

E-Receptionist supports ODBC data sources. Each row retrieved from a data source may contain the following column aliases:

Staff directory

​Column Required​ Data type​ Description​
​Identifier ​Yes (any)​ A value which uniquely identifies the staff member.​
​Name ​Yes varchar​​ The display name for the staff member.​
​Position ​No varchar​ The staff member's position or role within the firm.​
​Extension ​Yes varchar​ The staff member's telephone extension​.
​FallbackExtension No​ varchar​ Fallback extension or comma-separated list of extension numbers to use if the call is unanswered.​
​Photo No​ varbinary​ Binary image data for a photo of the staff member. Supported formats: JPEG, PNG​, GIF, BMP, TIFF

Global directory

​Column Required​ Data type​ Description​
​Identifier ​Yes (any)​ A value which uniquely identifies the individual.​
​Name ​Yes varchar​​ The display name for the individual.​
​CompanyName ​No varchar​ The name of the firm/company to which the individual belongs.
​Extension ​No varchar​ The telephone extension to dial​.
​FallbackExtension No​ varchar​ Fallback extension or comma-separated list of extension numbers to use if the call is unanswered.​
​IsDeliveryOnly No​ bit Value indicating whether the entry navigates to a deliveries menu instead of dialing a telephone number.

Appointment list

​Column Required​ Data type​ ​Description
​Identifier Yes​ (any)​ A value which uniquely identifies the appointment.​
​Start Yes​ datetime​ The start date and time of the appointment.​
​AttendeeName Yes​ varchar​ The display name for the attendee. Consider using only first name and last initial​ to preserve privacy.
​Extension Yes​ varchar​ ​The appointment organiser's telephone extension​.
​FallbackExtension ​No varchar​​ ​Fallback extension or comma-separated list of extension numbers to use if the call is unanswered.​

Holidays

​Column Required​ ​Data type ​Description
​Name Yes​ varchar​​ The display name for the ​holiday/observance.​
​Date Yes​ datetime​ The date that the office will be closed. Time component is ignored.​