This entity represents resources such as users, rooms, and equipment configured in the practice. The attached contains the required format for the IResource.CSV with a sample record.


The Type defines how the sample file handles the data type to produce the correct delimiters for each field. Make sure to change the custom field format if any fields noted as "integer" contain alphanumeric data.

Fields

Field Name 

Required 

Type 

Description 

SiteID 

 

nvarchar(MAX) 

Id of site if more than one site location is being converted 

ParentID 

 

nvarchar(MAX) 

 

Type 

Y 

nvarchar(MAX) 

Default is User 

FirstName 

Y 

nvarchar(MAX) 

FirstName 

LastName 

Y 

nvarchar(MAX) 

LastName 

FullName 

 

nvarchar(MAX) 

FullName 

Description 

 

nvarchar(MAX) 

 

Abbreviation 

 

nvarchar(MAX) 

 

Password 

 

nvarchar(MAX) 

 

DeaNumber 

 

nvarchar(MAX) 

 

Prefix 

 

nvarchar(MAX) 

Dr., Miss, etc. 

DeaExpirationDate 

 

datetime2(7) 

 

LicenseNumber 

 

nvarchar(MAX) 

 

LicenseExpirationDate 

 

datetime2(7) 

 

IsSchedulable 

 

bit 

 

IsUser 

 

bit 

Defaults to 1 

IsProvider 

 

bit 

enabled (1) if user is a provider 

Inactive 

 

bit 

 

IsDeleted 

 

bit 

 

[Key] 

 

nvarchar(4000) 

unique id for the record.  This needs to be the same between trial and final 

PmsID 

 

nvarchar(MAX) 

The can be the same as the key. 


Sample File