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 1419. 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(64) | NULL | User-defined description of the Specimen provided by the user in the application |
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 | 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. |
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. |
SpecimenName | varchar(64) | NULL | The name of the specimen. This field is unique. |
Abbreviation | varchar(16) | NULL | The abbreviation of the specimen. This field is unique. |
UnitType | varchar(16) | NULL | The unit type for the specimen. |
StartDateTime | smalldatetime | NULL | Validity start date/time for the specimen. |
EndDateTime | smalldatetime | NULL | Validity stop date/time for the specimen. |
ObsoleteDateTime | smalldatetime | NULL | The date/time that the specimen becomes obsolete. |
ValidityStatus | varchar(16) | NULL | The status of the specimen's validity. eg Active,Inactive |
ValidityStatusCode | smallint | NULL | Code for the Validity Status of the specimen |
| | | Allowable Values: |
| | | 0 - Active |
| | | 1 - Inactive |
| | | 2 - Incomplete |
| | | 3 - Obsolete |
ContainerType_oid | int | NULL | The associated container type. ObjectID of HDataDictionaryItem table for ItemTypeCode of OaR.ContainerType. |
UnitTypeCode | varchar(16) | NULL | The associated unit type code. |
ReuseTimeframe | int | NULL | The number associated with a period of time for how long this specimen can be re-used. |
ReuseTimeframeUnitCode | varchar(16) | NULL | The unit code associated with the reuse timeframe. |
ReuseTimeframeUnitString | varchar(20) | NULL | The unit string(for display purposes) associated with the reuse timeframe. |
ReuseTimeframeInHours | int | NULL | The reuse timeframe in hours for use in runtime calculations. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|