Tables [dbo].[Records]
Patient information (Encounterid, providerid, patientid, and IMO problem) used in Quippe note
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_Records_RecordID: RecordIDRecordIDbigint8NOT NULL1 - 1Key to the Records table
ProviderIDbigint8NULL allowedProvider. Link to Touchworks Provider.ID
Indexes NIX_Records_PatientIDPatientIDbigint8NOT NULLPatient. Link to Touchworks Person.ID
Indexes NIX_Records_EncounterIDEncounterIDbigint8NULL allowedEncounter. Link to Touchworks Encounter.ID
Indexes NIX_Records_DocumentIDDocumentIDbigint8NULL allowedDocument. Link to Touchworks Document.DocumentID
SourceTypevarchar(100)100NULL allowedWhere the data came from
Specifiervarchar(50)50NULL allowedSemicolon delimited list of codespec lists. A codespec list is a comma-delimited list of codes.
TimeRecordeddatetime8NOT NULLRecorded DTTM
ChartFlagint4NOT NULLBit mask used by GUI modules to further classify the finding(0,1,2,4,8,16,32,64,128,256)
RangeScaleint4NOT NULLCalculated Range Scale
RangeNormalLowfloat8NOT NULLNormal value for the Low range
RangeNormalHighfloat8NOT NULLNormal value for the High range
Textvarchar(max)maxNULL allowedHuman readable text to use when rendering this entry. Optional.
Indexes NIX_Records_MedcinIDMedcinIDint4NOT NULLMedcin ID
Prefixvarchar(2)2NULL allowedMedin Code Prefix Code string
Modifiervarchar(2)2NULL allowedMedcin Modifier Code string
ResultCodechar(1)1NULL allowedA for Abnormal, N for Normal
Statuschar(1)1NULL allowedMedin Status Code
Valuevarchar(100)100NULL allowedMeasurement Value
Unitvarchar(50)50NULL allowedUnit for the Value field
Notationvarchar(max)maxNULL allowedFree-text notes related to the finding
Onsetvarchar(100)100NULL allowedOnset Date in Medcin Format YYYYMMDDHHNN
Durationvarchar(100)100NULL allowedDuration of the finding maintained as a unit of time (a number followed by a unit of time specification character).
Episodevarchar(100)100NULL allowedPacked version of episode fields; the format: expression|FreqFm|FreqTo|DurFm|DurTo