Tables [dbo].[Vendor_Item]
Medcin Findings patient data
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Vendor_Item_ID: IDIndexes NIX_Vendor_Item_RecordedDttm_INC_IDID[dbo].[uniqueid]9NOT NULLKey to the Vendor_Item table
Indexes NIX_Vendor_Item_EncounterID_WithIncludeColumns, NIX_Vendor_Item_OriginatingID_INC_NextItemID_VendorID, NIX_Vendor_Item_PatientID_WithIncludeColumns, NIX_Vendor_Item_PreviousItemID_WithIncludeColumns, TWstat_Vendor_Item_EncounterID_OriginatingID_NextItemID, TWstat_Vendor_Item_IsErrorFLAG_OriginatingID_NextItemID, STAT_Vendor_Item_Nomenclature, TWstat_Vendor_Item_PatientID_OriginatingID_NextItemID, TWstat_Vendor_Item_Prefix_OriginatingID_NextItemID, TWstat_Vendor_Item_WhoDidItID_OriginatingID_NextItemID, TWstat_Vendor_Item_WhoForID_OriginatingID_NextItemID(11)OriginatingID[dbo].[uniqueid]9NOT NULLID of the initial record
Indexes NIX_Vendor_Item_PreviousItemID_WithIncludeColumnsPreviousItemID[dbo].[uniqueid]9NOT NULLPrevious ID in a series of finding versions
Indexes NIX_Vendor_Item_EncounterID_WithIncludeColumns, NIX_Vendor_Item_OriginatingID_INC_NextItemID_VendorID, NIX_Vendor_Item_PatientID_WithIncludeColumns, NIX_Vendor_Item_PreviousItemID_WithIncludeColumns, TWstat_Vendor_Item_EncounterID_OriginatingID_NextItemID, TWstat_Vendor_Item_IsErrorFLAG_OriginatingID_NextItemID, STAT_Vendor_Item_Nomenclature, TWstat_Vendor_Item_PatientID_OriginatingID_NextItemID, TWstat_Vendor_Item_Prefix_OriginatingID_NextItemID, TWstat_Vendor_Item_WhoDidItID_OriginatingID_NextItemID, TWstat_Vendor_Item_WhoForID_OriginatingID_NextItemID(11)NextItemID[dbo].[uniqueid]9NOT NULLNext ID in a series of finding versions
Indexes NIX_Vendor_Item_PatientID_WithIncludeColumns, TWstat_Vendor_Item_PatientID_OriginatingID_NextItemID(2)Foreign Keys FK_Vendor_Item_Patient: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient Identifier - Link to Person.ID
Indexes TWstat_Vendor_Item_IsErrorFLAG_OriginatingID_NextItemIDCheck Constraints CK_Vendor_Item_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y')IsErrorFLAG[dbo].[BOOL]1NOT NULLEntered in Error Indicator Y/N
ItemTypevarchar(50)50NOT NULLType Indicator (ex VI, EM)
Indexes NIX_Vendor_Item_EncounterID_WithIncludeColumns, NIX_Vendor_Item_OriginatingID_INC_NextItemID_VendorID, NIX_Vendor_Item_PatientID_WithIncludeColumns, NIX_Vendor_Item_PreviousItemID_WithIncludeColumns(4)Check Constraints ck_Vendor_Item_VendorID : ([VendorID]='1' OR [VendorID]='2')VendorIDvarchar(50)50NOT NULLVendor Identifier - 1 - Medcin, 2 - User Defined
TermTypevarchar(255)255NOT NULLTerm Type Indicator
Indexes NIX_Vendor_Item_PatientID_WithIncludeColumns, STAT_Vendor_Item_Nomenclature(2)NomenclatureIDvarchar(255)255NOT NULLNomenclature Identifier - Links to chMedcinSearch.dbo.Search.MedcinID
Indexes TWstat_Vendor_Item_AddedValueUnitAddedValueUnitvarchar(255)255NOT NULLUnit type indicator
Indexes IX_Vendor_Item_4DocumentID[dbo].[uniqueid]9NOT NULLDocument Identifier - Links to Document.DocumentID
NoteSectionDE[dbo].[dict_id]5NOT NULLNote Section - Links to Note_Section_De.ID
Indexes TWstat_Vendor_Item_WhoDidItID_OriginatingID_NextItemIDForeign Keys FK_Vendor_Item_IDX_User: [dbo].[IDX_User].WhoDidItIDWhoDidItID[dbo].[uniqueid]9NOT NULLUser that created the entry - Links to IDX_User.ID
Indexes TWstat_Vendor_Item_WhoForID_OriginatingID_NextItemIDWhoForID[dbo].[uniqueid]9NOT NULLUser that owns the entry - Links to IDX_User.ID
StatusQualifiervarchar(255)255NOT NULLUnused value
Onsetvarchar(255)255NOT NULLOnset date
Durationvarchar(255)255NOT NULLLength of time finding applied
DurationUnitvarchar(255)255NOT NULLTime unit represented with Duration value
RangeNormalHighvarchar(255)255NOT NULLHigh Reference Range
RangeNormalLowvarchar(255)255NOT NULLLow Reference Range
EpisodeFreqchar(1)1NOT NULLEpisode Frequency
EpisodeOccurFromvarchar(255)255NOT NULLEpisode Start Date
EpisodeOccurTovarchar(255)255NOT NULLEpisode End Date
EpisodeDurationFromvarchar(255)255NOT NULLEpisode Duration Start Date
EpisodeDurationTovarchar(255)255NOT NULLEpisode Duration End Date
Scalevarchar(255)255NOT NULLEpisode Scale
Indexes NIX_Vendor_Item_RecordedDttm_INC_ID, TWstat_Vendor_Item_RecordedDTTM(2)RecordedDTTMdatetime8NOT NULLDatetime entry was recorded
Indexes Portal_Vendor_Item_CreateDTTMCreateDTTMdatetime8NOT NULLDatetime entry was created
PerformedDTTMdatetime8NOT NULLDatetime entry was perfomed
Indexes NIX_Vendor_Item_PatientID_WithIncludeColumns, STAT_Vendor_Item_Nomenclature, TWstat_Vendor_Item_Prefix_OriginatingID_NextItemID(3)Prefixvarchar(255)255NOT NULLFinding Prefix
Modifiervarchar(255)255NOT NULLFinding Modifier
Indexes TWstat_Vendor_Item_ChargeIDChargeID[dbo].[uniqueid]9NULL allowedCharge Identifier - Links to Charge.ID
Indexes NIX_Vendor_Item_EncounterID_WithIncludeColumns, TWstat_Vendor_Item_EncounterID_OriginatingID_NextItemID(2)Foreign Keys FK_Vendor_Item_EncounterID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULL(0)Encounter Identifer - Links to Encounter.ID
Check Constraints CK_Vendor_Item_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')IsUnverifiedFLAG[dbo].[BOOL]1NOT NULL('N')Verification Status FLAG Y/N
VerificationTaskOwnerID[dbo].[uniqueid]9NOT NULL(0)UserID of Verification Task owner - links to IDX_User.ID
VerificationTaskOwnerTypechar(10)10NOT NULL('')Task Owner Type
HeaderID[dbo].[uniqueid]9NOT NULL((0))Note Header Identifier - Links to Noteform_NAW_Instance_Header.ID
SnomedCodevarchar(18)18NULL allowedSNOMED Code value
LOINCCodevarchar(10)10NULL allowedLOINC Code value