Entity MRN History

DescriptionThe history of Medical Record Numbers (MRN) as applied to a single individual.

Attributes
Former MRN NumFormer MRN Num

Relationship
is History for MRNis History for MRN

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Former MRN Num
DescriptionA medical record number (MRN) formerly used to for the patient. Now superseded by the current MRN.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 is History for MRN
Is Identifying Relationshipfalse
Child TableMRN History
Child Role Nameis history for
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient
Parent Role Namehas history
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE