Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. |
InstanceHFCID | smallint | NOT 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. |
RecordId | int | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(1) | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsDeleted | tinyint | NOT 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. |
IsVersioned | bit | NOT 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. |
CreatedUserId | int | NULL | 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 |
CreationTime | smalldatetime | NULL | Date and time when the record is created. |
SampleID | varchar(24) | NULL | The Sample Id of the specimen. Identifies a sample within an LID |
LID | varchar(24) | NULL | Lab Id. The identifier for a collection of samples. |
SpecimenReceivedDateTime | smalldatetime | NULL | Date/time the specimen was received. |
SampleCollectedStartDateTime | smalldatetime | NULL | Start date/time that the samples was collected. |
SampleCollectedEndDateTime | smalldatetime | NULL | End date/time that the sample was collected. |
VolumeOfSampleToBeCollected | Varchar(12) | NULL | Planned Volume of the sample to be collected. |
UnitOfVolumeOfSampleCollected | varchar(16) | NULL | Unit of measure for the planned volume. |
|
SampleCollectorRemarks | varchar(250) | NULL | Remarks by the sample collector. |
ReasonForNotCollectingSample | varchar(64) | NULL | Reason for not collecting the sample . |
AnatomicalOrigin | varchar(64) | NULL | Part of the body that the specimen originated. |
|
Priority | varchar(32) | NULL | Priority of the specimen collection order |
PriorityCode | tinyint | NULL | Code associated with the priority of the order |
SpecimenName | varchar(64) | NULL | Name of the specimen(unique identifier to HSpecimen table) |
ContainerType | varchar(64) | NULL | Container Type that is used to collect the specimen. |
ActualVolumeOfSampleCollected | Varchar(12) | NULL | Actual volume of the sample collected. |
StrainType | bit | NOT NULL | Whether 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. |
SampleStatus | varchar(40) | NOT NULL | Status of the sample collection |
| | | Allowable Values |
| | | Pending Specimen to be collected |
| | | Pending Specimen to be printed |
| | | Specimen Collected |
| | | Specimen Not Collected |
SampleStatusCode | int | NOT NULL | Code for Sample status |
| | | Allowable Values |
| | | 10 - Pending Specimen to be collected |
| | | 11 - Pending Specimen to be printed |
| | | 12 - Specimen Collected |
| | | 13 - Specimen Not Collected |
StandAlone | bit | NOT NULL | Whether this specimen can be standalone |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True |
SuggestedVolume | Varchar(12) | NULL | Suggested volume to be collected |
SampleUnitType | varchar(16) | NULL | Type of Unit of Measure for the specimen collection(eg Volume, mass etc) |
UnitOfSuggestedQty | varchar(16) | NULL | Unit of Measure for the suggested quantity |
SampleCollectionWarning | bit | NULL | Flag for specifying a warning of some type is associated with this sample |
| | | Allowable Values |
| | | 0 - False |
| | | 1 - True. |
InvestigationAbbreviation | varchar(64) | NOT NULL | ServiceName from the HService is copied over to this column |
QuantityNotSufficient | bit | NULL | Whether the quantity was sufficient or not. |
| | | Allowable Values |
| | | 0 - False |
| | | 1 - True. |
SampleToBeCollectedDateTime | smalldatetime | NULL | Date/time that the sample is to be collected. |
SampleCollector | tinyint | NULL | Staff Name from HStaff who collected the sample |
CollectionIndicator | bit | NOT NULL | Whether the person placing the order has collected the sample or not. |
| | | Allowable Values |
| | | 0 - False |
| | | 1 - True. |
SampleCollectionUnitAbbr | varchar(10) | NULL | Healthcare unit Abbreviation of the sample collector unit |
SampleToBeCollectedByUnitAbbr | varchar(10) | NULL | In case of recurring order , this holds the abbreviation of the unit to do the subsequent collection after the first collection. |
ProviderUnitAbbr | varchar(10) | NULL | Abbreviation of Provider unit of the order |
SampleCollectedBy | varchar(188) | NULL | Staff Name from HStaff who collected the sample |
SampleCollectionMethod | varchar(64) | NULL | Method as to which the sample was collected. |
Patient_oid | int | NOT NULL | ObjectID of the patient in HPatient table |
SampleCollectorUnit_oid | int | NULL | ObjectId of the Sample Collector Unit(HHealthCareUnit) |
External | bit | NOT NULL | Whether this is external or not |
| | | Allowable Values |
| | | 0 - False |
| | | 1 - True. |
Instruction | varchar(255) | NULL | instructions on the order is copied over here as some may need to be followed during specimen collection. |
UnitCodeOfVolumeOfSampleCollected | varchar(16) | NULL | Unit code of the volume that was collected. |
SampleUnitTypeCode | varchar(16) | NULL | Code for the Type of Unit of Measure for Specimen Collection |
UnitCodeOfSuggestedQty | varchar(16) | NULL | The unit code of the suggested quantity |
ReprintIndicator | tinyint | NULL | Whether the label needs reprinted or not |
| | | Allowable Values |
| | | 0 or null - no |
| | | 1 - yes) |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|