This entity represents patient medical history line items including services and notes. The attached contains the required format for the IMedicalHistory.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 |
PatientID | Y | nvarchar(4000) | patient unique identifier |
Date | Y | datetime2(7) | The date of the history line item |
CodeID |
| nvarchar(4000) | PIMS code assigned - typically service or inventory code |
Code |
| nvarchar(MAX) | PIMS code assigned - typically service or inventory code |
ShortDescription |
| nvarchar(MAX) |
|
Description | Y | nvarchar(MAX) | PIMS description & PIMS notes associated with the history line item |
Quantity |
| float | Quantity |
ProviderID |
| nvarchar(MAX) | Employee unique code (abbreviation or other code) used in the PIMS |
EnteredByID |
| nvarchar(MAX) | Employee unique code (abbreviation or other code) used in the PIMS |
IsNote |
| boolean | True = Description contains a note |
IsDeclined |
| boolean | True = Line item was declined |
[Key] |
| nvarchar(4000) | Unique identifier for this record |