This entity represents vital information records associated with patients. The attached contains the required format for the IVitalInfo.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 |
RelationshipType |
| nvarchar(4000) |
|
RelationshipID |
| nvarchar(4000) |
|
PatientID | Y | nvarchar(4000) | Unique identifier-Should match patient.key in Ipatient table. |
Type | Y | nvarchar(MAX) | Examples: Blood Pressure,CRT,HeartRate,Packed Cell Volume,Respiratory,Temperature,Tonometry,Total Protein,Weight |
Value |
| nvarchar(MAX) |
|
Unit | Y | nvarchar(MAX) | Examples: bpm,F,G,g/dL,Kg,Lbs,mmHg,Oz,pct,rpm,seconds |
Status |
| nvarchar(MAX) |
|
Comment |
| nvarchar(MAX) |
|
Sequence |
| int |
|
Date | Y | datetime2(7) | Date of record entry |
[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. |