Business Data Model Data Model

Entity

Entity Specimen

Description

A limited quantity of biological material that is typically removed from a person for use in medical laboratory tests in order to study the presence or absence of microorganisms. Other sources of specimens include environmental samples of soil, water or air.

For example:
Blood
Tissue
Urine
Sputum

Attributes
Accession Num
Filler Order Num
Grouped Specimen Cnt
Placer Order Num
Specimen Action Type
Specimen Appropriateness
Specimen Availability
Specimen Collection End Ts
Specimen Collection Method
Specimen Collection Qty
Specimen Collection Quantity Unit Of Measure
Specimen Collection Site
Specimen Collection Ts
Specimen Condition
Specimen Container Cnt
Specimen Current Qty
Specimen Descr
Specimen Expiration Ts
Specimen Id
Specimen Quality
Specimen Received Ts
Specimen Source Group Code
Specimen Source Site
Specimen Type
Transport Logistics Collected Sample Name

Relationship
Biospecimen_Provider_FK
Specimen_Clinical Finding_FK
Specimen_Procedure_FK
Specimen_Clinical Order_FK
Biospecimen_Location_FK
Specimen_Patient_FK
Parent Biospecimen FK
Specimen_Practitioner_FK
Specimen_Study Subject_FK
Specimen_Specimen / Specimen_FK
Specimen_ExperimentalUnit_FK
Specimen_Material_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Accession Num

Description	Identifies the product/test that initiated the specimen collection.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Filler Order Num

Description	A reference code or identification number associated with the filling application.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Grouped Specimen Cnt

Description	The total number of individual specimens of a particular specimen type. All specimens in this group of specimens will have identical attributes.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Placer Order Num

Description	A reference code or identification number for the placer application's order number.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Action Type

Description	The type of action taken for a specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Appropriateness

Description	Indicates the suitability of a collected specimen for its particular planned use. For example: Preferred Inappropriate Appropriate
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Availability

Description	Indicates whether or not the collected specimen is ready for use in laboratory or observation analysis.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Collection End Ts

Description	The date and time when the specimen collection ended.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Collection Method

Description	Indicates the procedure or process by which a specimen is collected.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Collection Qty

Description	A number either integer or decimal that describes the volume or mass of the collected specimen. This amount can only be specified after the specimen has been collected.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Collection Quantity Unit Of Measure

Description	Indicates the units in which the amount of the collected specimen is expressed. These units of measure should come from a recognized standard. For example: ml for milliliters mg for milligrams
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Collection Site

Description	The origin, normally a body part, from which a specimen is collected. Specimen collection site and specimen source site can be different, but normally work in tandem to describe the specimen collection details. For example: The specimen source site is "liver", if the procedure were a liver biopsy. If the liver biopsy uses a percutaneous needle, the specimen collection site is "eye of the needle".
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Collection Ts

Description	The date and time that the specimen was acquired from the source, normally the patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Condition

Description	Describes the nature of the specimen or its condition at time of receipt at the lab. For example: Hemolyzed Icteric Lipemic Autolyzed Clotted Contaminated Frozen
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Container Cnt

Description	The number of containers required to hold the collected sample. For example: A blood sample taken in a single procedure may be split across multiple syringes.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Current Qty

Description	A number, either decimal or integer, that describes the volume or amount of collected specimen available for use in further testing.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Descr

Description	A free-form textual description that provides additional information about the collected specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Expiration Ts

Description	The date and time when the collected specimen can no longer be used for its intended purpose. The specimen-rejected reason contains "expired" when this time is reached.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Id

Description	Identifies an instance of a specimen. A unique series of numbers and or letters assigned by the data provider that names one and only one specimen.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Quality

Description	Indicates the degree, grade or condition of excellence for the collected specimen at the time of receipt. The condition is judged by a person at the filling system. These values can be user-defined. For example: Excellent Good Fair Poor
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Received Ts

Description	The date and time that the specimen was received at the diagnostic service for examination.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Source Group Code

Description	Indicates a common code which represents the name for a group of specimens. For example: If the specimen is kidney, the Specimen Group is urinary tract.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Source Site

Description	The origin, normally a body part, from which the specimen material was obtained. For example: The specimen source site is "liver", if the procedure were a liver biopsy.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Specimen Type

Description	Identifies the precise nature of the collected specimen. The specimen described is a physical substance and it can be either a complex organism or a specific cellular mass.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Transport Logistics Collected Sample Name

Description	A textual description of the transport logistics for the collected sample.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Biospecimen_Provider_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Provider
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Specimen_Clinical Finding_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Clinical Finding
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Specimen_Procedure_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Procedure
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Specimen_Clinical Order_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Laboratory Order
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Biospecimen_Location_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Specimen_Patient_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Parent Biospecimen FK

Is Identifying Relationship	false
Child Table	Specimen
Child Role Name	is part of
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Specimen
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Specimen_Practitioner_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Specimen_Study Subject_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Study Subject
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Specimen_Specimen / Specimen_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Specimen / Specimen
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Specimen_ExperimentalUnit_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Experimental Unit
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Specimen_Material_FK

Is Identifying Relationship	false
Child Table	Specimen
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Material
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Overview

Top

Package

Entity

Business Data Model Data Model