This entity represents the categories assigned to billable codes such as Service, Inventory, or Laboratory. The attached contains the required format for the ICodeCategory.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 

 

String/Varchar(Max) 

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

Code 

Y 

String/Varchar(Max) 

 

ParentCodeCategoryID 

 

 

 

Type 

Y 

String 

Service,Inventory, or Laboratory 

Description 

Y 

String/Varchar(Max) 

 

IsDeleted 

 

Boolean/bit 

Defaults to 0 

Inactive 

 

Boolean/bit 

Defaults to 0 

Key 

 

String/Varchar(4000) 

Concatenation of Code, |, Type (If using SiteID concatenate to the end) 

PmsID 

 

String/Varchar(Max) 

Concatenation of Code, |, Type (If using SiteID concatenate to the end) 


Sample File