Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HCollectedSample This table stores the Sample Collection details for Laboratory Orders
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object Identifier of this record. This field is a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1143. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application.
RecordIdintNULL Not Valued in this table. Column exists as part of persistence framework implementation.
Descriptionvarchar(1)NULL Not Valued in this table. Column exists as part of persistence framework implementation.
IsDeletedtinyintNOT NULL Specifies whether the record is soft deleted.
Allowable Values
0 - Active
1 - Marked as Deleted.
Note: The presence of this field in tables depends on the configuration at the time of table design.
IsVersionedbitNOT NULL When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. Note: The presence of this field in tables depends on the configuration at the time of table design.
CreatedUserIdintNULL Object ID of the logged in user who created this record.
This field is linked to HSUser table to get details about the user. For more information see description of HSUser table
CreationTimesmalldatetimeNULL Date and time when the record is created.
SampleIDvarchar(24)NULL The Sample Id of the specimen. Identifies a sample within an LID
LIDvarchar(24)NULL Lab Id. The identifier for a collection of samples.
SpecimenReceivedDateTimesmalldatetimeNULL Date/time the specimen was received.
SampleCollectedStartDateTimesmalldatetimeNULL Start date/time that the samples was collected.
SampleCollectedEndDateTimesmalldatetimeNULL End date/time that the sample was collected.
VolumeOfSampleToBeCollectedVarchar(12)NULL Planned Volume of the sample to be collected.
UnitOfVolumeOfSampleCollectedvarchar(16)NULL Unit of measure for the planned volume.
SampleCollectorRemarksvarchar(250)NULL Remarks by the sample collector.
ReasonForNotCollectingSamplevarchar(64)NULL Reason for not collecting the sample .
AnatomicalOriginvarchar(64)NULL Part of the body that the specimen originated.
Priorityvarchar(32)NULL Priority of the specimen collection order
PriorityCodetinyintNULL Code associated with the priority of the order
SpecimenNamevarchar(64)NULL Name of the specimen(unique identifier to HSpecimen table)
ContainerTypevarchar(64)NULL Container Type that is used to collect the specimen.
ActualVolumeOfSampleCollectedVarchar(12)NULL Actual volume of the sample collected.
StrainTypebitNOT NULLWhether service is of strain type or not. For strain type services system mandates to value enddatetime while capturing sample collection details.
Allowable Values
0 - False
1 - True.
SampleStatusvarchar(40)NOT NULLStatus of the sample collection
Allowable Values
Pending Specimen to be collected
Pending Specimen to be printed
Specimen Collected
Specimen Not Collected
SampleStatusCodeintNOT NULLCode for Sample status
Allowable Values
10 - Pending Specimen to be collected
11 - Pending Specimen to be printed
12 - Specimen Collected
13 - Specimen Not Collected
StandAlonebitNOT NULLWhether this specimen can be standalone
Allowable Values:
0 - False
1 - True
SuggestedVolumeVarchar(12)NULL Suggested volume to be collected
SampleUnitTypevarchar(16)NULL Type of Unit of Measure for the specimen collection(eg Volume, mass etc)
UnitOfSuggestedQtyvarchar(16)NULL Unit of Measure for the suggested quantity
SampleCollectionWarningbitNULL Flag for specifying a warning of some type is associated with this sample
Allowable Values
0 - False
1 - True.
InvestigationAbbreviationvarchar(64)NOT NULLServiceName from the HService is copied over to this column
QuantityNotSufficientbitNULL Whether the quantity was sufficient or not.
Allowable Values
0 - False
1 - True.
SampleToBeCollectedDateTimesmalldatetimeNULL Date/time that the sample is to be collected.
SampleCollectortinyintNULL Staff Name from HStaff who collected the sample
CollectionIndicatorbitNOT NULLWhether the person placing the order has collected the sample or not.
Allowable Values
0 - False
1 - True.
SampleCollectionUnitAbbrvarchar(10)NULL Healthcare unit Abbreviation of the sample collector unit
SampleToBeCollectedByUnitAbbrvarchar(10)NULL In case of recurring order , this holds the abbreviation of the unit to do the subsequent collection after the first collection.
ProviderUnitAbbrvarchar(10)NULL Abbreviation of Provider unit of the order
SampleCollectedByvarchar(188)NULL Staff Name from HStaff who collected the sample
SampleCollectionMethodvarchar(64)NULL Method as to which the sample was collected.
Patient_oidintNOT NULLObjectID of the patient in HPatient table
SampleCollectorUnit_oidintNULL ObjectId of the Sample Collector Unit(HHealthCareUnit)
ExternalbitNOT NULLWhether this is external or not
Allowable Values
0 - False
1 - True.
Instructionvarchar(255)NULL instructions on the order is copied over here as some may need to be followed during specimen collection.
UnitCodeOfVolumeOfSampleCollectedvarchar(16)NULL Unit code of the volume that was collected.
SampleUnitTypeCodevarchar(16)NULL Code for the Type of Unit of Measure for Specimen Collection
UnitCodeOfSuggestedQtyvarchar(16)NULL The unit code of the suggested quantity
ReprintIndicatortinyintNULL Whether the label needs reprinted or not
Allowable Values
0 or null - no
1 - yes)
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates