Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
  | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Vendor_Item table |
(11) | OriginatingID | [dbo].[uniqueid] | 9 | NOT NULL | | ID of the initial record |
 | PreviousItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Previous ID in a series of finding versions |
(11) | NextItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Next ID in a series of finding versions |
(2)![Foreign Keys FK_Vendor_Item_Patient: [dbo].[Patient_Member].PatientID Foreign Keys FK_Vendor_Item_Patient: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient Identifier - Link to Person.ID |
 ![Check Constraints CK_Vendor_Item_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y') Check Constraints CK_Vendor_Item_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y')](../../../../Images/c-constraint.png) | IsErrorFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Entered in Error Indicator Y/N |
| ItemType | varchar(50) | 50 | NOT NULL | | Type Indicator (ex VI, EM) |
(4)![Check Constraints ck_Vendor_Item_VendorID : ([VendorID]='1' OR [VendorID]='2') Check Constraints ck_Vendor_Item_VendorID : ([VendorID]='1' OR [VendorID]='2')](../../../../Images/c-constraint.png) | VendorID | varchar(50) | 50 | NOT NULL | | Vendor Identifier - 1 - Medcin, 2 - User Defined |
| TermType | varchar(255) | 255 | NOT NULL | | Term Type Indicator |
(2) | NomenclatureID | varchar(255) | 255 | NOT NULL | | Nomenclature Identifier - Links to chMedcinSearch.dbo.Search.MedcinID |
 | AddedValueUnit | varchar(255) | 255 | NOT NULL | | Unit type indicator |
 | DocumentID | [dbo].[uniqueid] | 9 | NOT NULL | | Document Identifier - Links to Document.DocumentID |
| NoteSectionDE | [dbo].[dict_id] | 5 | NOT NULL | | Note Section - Links to Note_Section_De.ID |
 ![Foreign Keys FK_Vendor_Item_IDX_User: [dbo].[IDX_User].WhoDidItID Foreign Keys FK_Vendor_Item_IDX_User: [dbo].[IDX_User].WhoDidItID](../../../../Images/fk.png) | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | User that created the entry - Links to IDX_User.ID |
 | WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | | User that owns the entry - Links to IDX_User.ID |
| StatusQualifier | varchar(255) | 255 | NOT NULL | | Unused value |
| Onset | varchar(255) | 255 | NOT NULL | | Onset date |
| Duration | varchar(255) | 255 | NOT NULL | | Length of time finding applied |
| DurationUnit | varchar(255) | 255 | NOT NULL | | Time unit represented with Duration value |
| RangeNormalHigh | varchar(255) | 255 | NOT NULL | | High Reference Range |
| RangeNormalLow | varchar(255) | 255 | NOT NULL | | Low Reference Range |
| EpisodeFreq | char(1) | 1 | NOT NULL | | Episode Frequency |
| EpisodeOccurFrom | varchar(255) | 255 | NOT NULL | | Episode Start Date |
| EpisodeOccurTo | varchar(255) | 255 | NOT NULL | | Episode End Date |
| EpisodeDurationFrom | varchar(255) | 255 | NOT NULL | | Episode Duration Start Date |
| EpisodeDurationTo | varchar(255) | 255 | NOT NULL | | Episode Duration End Date |
| Scale | varchar(255) | 255 | NOT NULL | | Episode Scale |
(2) | RecordedDTTM | datetime | 8 | NOT NULL | | Datetime entry was recorded |
 | CreateDTTM | datetime | 8 | NOT NULL | | Datetime entry was created |
| PerformedDTTM | datetime | 8 | NOT NULL | | Datetime entry was perfomed |
(3) | Prefix | varchar(255) | 255 | NOT NULL | | Finding Prefix |
| Modifier | varchar(255) | 255 | NOT NULL | | Finding Modifier |
 | ChargeID | [dbo].[uniqueid] | 9 | NULL allowed | | Charge Identifier - Links to Charge.ID |
(2)![Foreign Keys FK_Vendor_Item_EncounterID: [dbo].[Encounter].EncounterID Foreign Keys FK_Vendor_Item_EncounterID: [dbo].[Encounter].EncounterID](../../../../Images/fk.png) | EncounterID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Encounter Identifer - Links to Encounter.ID |
![Check Constraints CK_Vendor_Item_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y') Check Constraints CK_Vendor_Item_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')](../../../../Images/c-constraint.png) | IsUnverifiedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Verification Status FLAG Y/N |
| VerificationTaskOwnerID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | UserID of Verification Task owner - links to IDX_User.ID |
| VerificationTaskOwnerType | char(10) | 10 | NOT NULL | ('') | Task Owner Type |
| HeaderID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | Note Header Identifier - Links to Noteform_NAW_Instance_Header.ID |
| SnomedCode | varchar(18) | 18 | NULL allowed | | SNOMED Code value |
| LOINCCode | varchar(10) | 10 | NULL allowed | | LOINC Code value |