Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HSpecimen This table contains definitional data for Specimen used for Sample collection in Laboratory setup.
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 1419. 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(64)NULL User-defined description of the Specimen provided by the user in the application
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 Whether the table data is Versioned or not.
Allowable Values:
0 - No version data captured.
1 - Version changes available in _Ver table.
Once this field is set to 1, you cannot reset it to 0. If value is 1 , the current row represents the latest state , and all version data will be present in another table with the name HSpecimen_Ver.
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.
SpecimenNamevarchar(64)NULL The name of the specimen. This field is unique.
Abbreviationvarchar(16)NULL The abbreviation of the specimen. This field is unique.
UnitTypevarchar(16)NULL The unit type for the specimen.
StartDateTimesmalldatetimeNULL Validity start date/time for the specimen.
EndDateTimesmalldatetimeNULL Validity stop date/time for the specimen.
ObsoleteDateTimesmalldatetimeNULL The date/time that the specimen becomes obsolete.
ValidityStatusvarchar(16)NULL The status of the specimen's validity. eg Active,Inactive
ValidityStatusCodesmallintNULL Code for the Validity Status of the specimen
Allowable Values:
0 - Active
1 - Inactive
2 - Incomplete
3 - Obsolete
ContainerType_oidintNULL The associated container type. ObjectID of HDataDictionaryItem table for ItemTypeCode of OaR.ContainerType.
UnitTypeCodevarchar(16)NULL The associated unit type code.
ReuseTimeframeintNULL The number associated with a period of time for how long this specimen can be re-used.
ReuseTimeframeUnitCodevarchar(16)NULL The unit code associated with the reuse timeframe.
ReuseTimeframeUnitStringvarchar(20)NULL The unit string(for display purposes) associated with the reuse timeframe.
ReuseTimeframeInHoursintNULL The reuse timeframe in hours for use in runtime calculations.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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