Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Description |
---|
 | RecordID | bigint | 8 | NOT NULL | 1 - 1 | Key to the Records table |
| ProviderID | bigint | 8 | NULL allowed | | Provider. Link to Touchworks Provider.ID |
 | PatientID | bigint | 8 | NOT NULL | | Patient. Link to Touchworks Person.ID |
 | EncounterID | bigint | 8 | NULL allowed | | Encounter. Link to Touchworks Encounter.ID |
 | DocumentID | bigint | 8 | NULL allowed | | Document. Link to Touchworks Document.DocumentID |
| SourceType | varchar(100) | 100 | NULL allowed | | Where the data came from |
| Specifier | varchar(50) | 50 | NULL allowed | | Semicolon delimited list of codespec lists. A codespec list is a comma-delimited list of codes. |
| TimeRecorded | datetime | 8 | NOT NULL | | Recorded DTTM |
| ChartFlag | int | 4 | NOT NULL | | Bit mask used by GUI modules to further classify the finding(0,1,2,4,8,16,32,64,128,256) |
| RangeScale | int | 4 | NOT NULL | | Calculated Range Scale |
| RangeNormalLow | float | 8 | NOT NULL | | Normal value for the Low range |
| RangeNormalHigh | float | 8 | NOT NULL | | Normal value for the High range |
| Text | varchar(max) | max | NULL allowed | | Human readable text to use when rendering this entry. Optional. |
 | MedcinID | int | 4 | NOT NULL | | Medcin ID |
| Prefix | varchar(2) | 2 | NULL allowed | | Medin Code Prefix Code string |
| Modifier | varchar(2) | 2 | NULL allowed | | Medcin Modifier Code string |
| ResultCode | char(1) | 1 | NULL allowed | | A for Abnormal, N for Normal |
| Status | char(1) | 1 | NULL allowed | | Medin Status Code |
| Value | varchar(100) | 100 | NULL allowed | | Measurement Value |
| Unit | varchar(50) | 50 | NULL allowed | | Unit for the Value field |
| Notation | varchar(max) | max | NULL allowed | | Free-text notes related to the finding |
| Onset | varchar(100) | 100 | NULL allowed | | Onset Date in Medcin Format YYYYMMDDHHNN |
| Duration | varchar(100) | 100 | NULL allowed | | Duration of the finding maintained as a unit of time (a number followed by a unit of time specification character). |
| Episode | varchar(100) | 100 | NULL allowed | | Packed version of episode fields; the format: expression|FreqFm|FreqTo|DurFm|DurTo |