Specimen DMO

Object Properties

Object API Name: ssot__Specimen__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

Relationships

• UsageCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• TypeCodeId has a FOREIGNKEY relationship with the Code Set DMO Id field.
• SourceReferenceRecordId has a FOREIGNKEY relationship with the Patient DMO Id field.
• SourceReferenceRecordId has a FOREIGNKEY relationship with the Location DMO Id field.
• SourceReferenceRecordId has a FOREIGNKEY relationship with the Account DMO Id field.
• FeatureCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• FastingStatusCodeId has a FOREIGNKEY relationship with the Code Set DMO Id field.
• FastingDurationUomId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• ConditionCodeId has a FOREIGNKEY relationship with the Code Set Bundle DMO Id field.
• CollectorRecordId has a FOREIGNKEY relationship with the Healthcare Provider DMO Id field.
• CollectorRecordId has a FOREIGNKEY relationship with the Account DMO Id field.
• CollectionQuantityUomId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• CollectionMethodCodeId has a FOREIGNKEY relationship with the Code Set DMO Id field.
• CollectionDurationUomId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• CollectionDeviceCodeId has a FOREIGNKEY relationship with the Code Set DMO Id field.
• CaseId has a FOREIGNKEY relationship with the Case DMO Id field.
• BodySiteId has a FOREIGNKEY relationship with the Code Set DMO Id field.

Fields

• BodySiteId
• CaseId
• cdp_sys_record_currency
• CollectionDeviceCodeId
• CollectionDurationNumber
• CollectionDurationUomId
• CollectionEndDateTime
• CollectionMethodCodeId
• CollectionQuantity
• CollectionQuantityUomId
• CollectionStartDateTime
• CollectorRecordId
• CollectorRecordObject
• ConditionCodeId
• DataSourceId
• DataSourceObjectId
• FastingDurationNumber
• FastingDurationUomId
• FastingStatusCodeId
• FeatureCodeId
• GroupingMethod
• Id
• InternalOrganizationId
• KQ_BodySiteId
• KQ_CaseId
• KQ_CollectionDeviceCodeId
• KQ_CollectionDurationUomId
• KQ_CollectionMethodCodeId
• KQ_CollectionQuantityUomId
• KQ_CollectorRecordId
• KQ_ConditionCodeId
• KQ_FastingDurationUomId
• KQ_FastingStatusCodeId
• KQ_FeatureCodeId
• KQ_Id
• KQ_SourceReferenceRecordId
• KQ_TypeCodeId
• KQ_UsageCodeId
• ReceivedDateTime
• SourceReferenceRecordId
• SourceReferenceRecordObject
• StatusCode
• TypeCodeId
• UsageCodeId

BodySiteId

• Field API Name: ssot__BodySiteId__c
• Data Type: TEXT
• Description: The body site code set bundle associated with a specimen that represents the anatomical collection site.

CaseId

• Field API Name: ssot__CaseId__c
• Data Type: TEXT
• Description: The case associated with the specimen.

cdp_sys_record_currency

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

CollectionDeviceCodeId

• Field API Name: ssot__CollectionDeviceCodeId__c
• Data Type: TEXT
• Description: The device code set bundle associated with a specimen that represents the device used to collect the specimen. For example, SST tube, red top tube, or 100-mL sterile polycup.

CollectionDurationNumber

• Field API Name: ssot__CollectionDurationNumber__c
• Data Type: DOUBLE
• Description: The total time period over which the specimen was collected.

CollectionDurationUomId

• Field API Name: ssot__CollectionDurationUomId__c
• Data Type: TEXT
• Description: The unit of measure of the collection duration.

CollectionEndDateTime

• Field API Name: ssot__CollectionEndDateTime__c
• Data Type: DATETIME
• Description: The end date and time of the collection from the specimen.

CollectionMethodCodeId

• Field API Name: ssot__CollectionMethodCodeId__c
• Data Type: TEXT
• Description: The method code set bundle associated with a specimen that represents the method used to collect the specimen. For example, Biopsy.

CollectionQuantity

• Field API Name: ssot__CollectionQuantity__c
• Data Type: DOUBLE
• Description: The quantity of specimen collected. For example, the volume of a blood sample, or the physical measurement of an anatomic pathology sample.

CollectionQuantityUomId

• Field API Name: ssot__CollectionQuantityUomId__c
• Data Type: TEXT
• Description: The unit of measure for collected quantity.

CollectionStartDateTime

• Field API Name: ssot__CollectionStartDateTime__c
• Data Type: DATETIME
• Description: The start date and time of the collection from the specimen.

CollectorRecordId

• Field API Name: ssot__CollectorRecordId__c
• Data Type: TEXT
• Description: The account of the healthcare provider that collected the specimen.

CollectorRecordObject

• Field API Name: ssot__CollectorRecordObject__c
• Data Type: TEXT
• Description: The object name of the Collector Record field.

ConditionCodeId

• Field API Name: ssot__ConditionCodeId__c
• Data Type: TEXT
• Description: The condition code set bundle associated with a specimen that represents the state of the specimen.

DataSourceId

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DataSourceObjectId

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

FastingDurationNumber

• Field API Name: ssot__FastingDurationNumber__c
• Data Type: DOUBLE
• Description: The total time period over which the individual fasted before sample collection.

FastingDurationUomId

• Field API Name: ssot__FastingDurationUomId__c
• Data Type: TEXT
• Description: The unit of measure for the fasting duration.

FastingStatusCodeId

• Field API Name: ssot__FastingStatusCodeId__c
• Data Type: TEXT
• Description: The fasting status code set bundle associated with specimen that represents the fasting status of the individual from whom the specimen was collected.

FeatureCodeId

• Field API Name: ssot__FeatureCodeId__c
• Data Type: TEXT
• Description: The feature code set bundle associated with a specimen that represents the type of physical feature or landmark of a specimen, which is highlighted for context by the collector.

GroupingMethod

• Field API Name: ssot__GroupingMethod__c
• Data Type: TEXT
• Description: Specifies whether the specimen is part of a group or pooled with other specimens.

Id

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this Specimen record. Maximum size is 15 characters.

InternalOrganizationId

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

KQ_BodySiteId

• Field API Name: KQ_BodySiteId__c
• Data Type: TEXT
• Description: Key Qualifier system field for BodySiteId

KQ_CaseId

• Field API Name: KQ_CaseId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CaseId

KQ_CollectionDeviceCodeId

• Field API Name: KQ_CollectionDeviceCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CollectionDeviceCodeId

KQ_CollectionDurationUomId

• Field API Name: KQ_CollectionDurationUomId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CollectionDurationUomId

KQ_CollectionMethodCodeId

• Field API Name: KQ_CollectionMethodCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CollectionMethodCodeId

KQ_CollectionQuantityUomId

• Field API Name: KQ_CollectionQuantityUomId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CollectionQuantityUomId

KQ_CollectorRecordId

• Field API Name: KQ_CollectorRecordId__c
• Data Type: TEXT
• Description: Key Qualifier system field for CollectorRecordId

KQ_ConditionCodeId

• Field API Name: KQ_ConditionCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ConditionCodeId

KQ_FastingDurationUomId

• Field API Name: KQ_FastingDurationUomId__c
• Data Type: TEXT
• Description: Key Qualifier system field for FastingDurationUomId

KQ_FastingStatusCodeId

• Field API Name: KQ_FastingStatusCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for FastingStatusCodeId

KQ_FeatureCodeId

• Field API Name: KQ_FeatureCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for FeatureCodeId

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

KQ_SourceReferenceRecordId

• Field API Name: KQ_SourceReferenceRecordId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SourceReferenceRecordId

KQ_TypeCodeId

• Field API Name: KQ_TypeCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for TypeCodeId

KQ_UsageCodeId

• Field API Name: KQ_UsageCodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UsageCodeId

ReceivedDateTime

• Field API Name: ssot__ReceivedDateTime__c
• Data Type: DATETIME
• Description: The date and time when a specimen is received by the testing laboratory.

SourceReferenceRecordId

• Field API Name: ssot__SourceReferenceRecordId__c
• Data Type: TEXT
• Description: Represents where a specimen came from. For example, from a patient, from a location (the source of an environmental sample), a sampling of a substance, a biologically derived product, or a device.

SourceReferenceRecordObject

• Field API Name: ssot__SourceReferenceRecordObject__c
• Data Type: TEXT
• Description: The object name of the Source Reference Record field.

StatusCode

• Field API Name: ssot__StatusCode__c
• Data Type: TEXT
• Description: The status of the specimen, such as available, unavailable, unsatisfactory, or entered-in-error.

TypeCodeId

• Field API Name: ssot__TypeCodeId__c
• Data Type: TEXT
• Description: The type code set bundle associated with a specimen that represents the type of material that forms the specimen.

UsageCodeId

• Field API Name: ssot__UsageCodeId__c
• Data Type: TEXT
• Description: The usage code set bundle associated with a specimen that represents the role of the specimen in the testing workflow.