Entity Clinical Study

DescriptionA study is an organized effort that obtains or increases medical knowledge by observation or research.

Attributes
OrderableOrderable
Reason For StudyReason For Study

Relationship
Study_Clinical Order Detail_FK1Study_Clinical Order Detail_FK1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Orderable
DescriptionIdentifier for the item ordered by or that is the focus of the study
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Reason For Study
DescriptionIndicates the justification for a study. This may required on the Clinical Order to support reimbursement.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Study_Clinical Order Detail_FK1
Is Identifying Relationshipfalse
Child TableClinical Study
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableClinical Order Item
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE