This entity represents client classification types used for alerts and discounts in the PIMS. The attached contains the required format for the IClientClassification.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 |
BaseType |
| nvarchar(MAX) |
|
Type | Y | nvarchar(MAX) | Client type assigned in the PIMS typically for alert and/or discount purposes. Examples are ‘A’ for Active regular clients, ‘S’ for Senior citizen discount. |
Code |
| nvarchar(MAX) |
|
Description | Y | nvarchar(MAX) | Description of the client type |
SiteID | Y | nvarchar(MAX) | Id of site if more than one site location is being converted |
[Key] |
| nvarchar(4000) | Unique record ID |
PmsID |
| nvarchar(MAX) | Unique record ID |