| Atomic Warehouse Model Data Model |
| Description | A study report that provides notification of an adverse event, product problem, or information that is relevant to either. A report typically includes causal association, management strategies, authorship, sender and receiver organizations, subject or study subject of adverse event, or name of product. For example: An expedited AE report - a report of a serious and unexpected adverse event that must be submitted within specific timeframes to the sponsor and regulatory agencies. |
| Relationship | |
 Safety Report Detail_Document_FK |
|
| Primary Key | |
 Safety Report Detail PK |
|
| Dependencies | |
 |
|
| |
|
| |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Activity Dttm
| Description | The date and time identified in the document upon which patient related activities are performed. For example: surgery, non-invasive procedure, consultation, examination dates and time etc. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Availability Sts Code Sk
| Description | Identifies a document's availability for use in patient care. For example: Available for patient care Deleted Obsolete Unavailable for patient care |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Change Reason Txt
| Description | Contains the reason for the change in status of the document. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Communication Mode Code Sk
| Description | Specifies the form in which the report is transmitted. For example: Physically present Over the telephone Written communication Electronic |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Completion Sts Code Sk
| Description | Indicates the current completion status of the document. For example: Dictated Documented In Progress Incomplete Pre-authenticated Authenticated Legally authenticated |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Confidentiality Sts Code Sk
| Description | Identifies the status of the special confidentiality protection which should be applied to this information. For example: Very restricted Restricted Usual control |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Document Content Presentation Code Sk
| Description | Indicates the method by which this document was obtained or originated.Conditional field which is required whenever the message contains content as presented in one or more observations. For example: Audio data Formatted text Image data Scanned document |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Document Sk
| Description | Anchor surrogate key for the Pharmacy Order data |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Document Type Code Sk
| Description | Classifies the document by its type (as defined in the transcription system). For example: Autopsy report Cardiodiagnostics Consultation Diagnostic imaging Discharge summary Emergency department report History and physical examination Operative report Psychiatric consultation Psychiatric history and physical examination Procedure note Progress note Surgical pathology Transfer summary |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Due Dt
| Description | The date and time on which the report is expected or scheduled to be submitted. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Nullification Ind
| Description | Specifies whether the report cancels a previously sent adverse event. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Nullification Reason Code Sk
| Description | Specifies why the adverse event report is nullified. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Origination Dttm
| Description | The date and time upon which the document was created (i.e. dictated, recorded, etc.). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Physician Sign Off Ind
| Description | Specifies whether the physician has reviewed and signed off on a version of a report. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Source Code Sk
| Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Storage Sts Code Sk
| Description | Identifies the storage status of the document. For example: Active Active and archived Archived (not active) Purged |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Sub Type Code Sk
| Description | Specifies a further classification of report type. For example: An Adverse Event Report would map to Document Type Code and the Safety Report Sub Type Code would map to a 7-day AE Report. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Transcription Dttm
| Description | The date and time upon which the input was actually transcribed onto the document. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Unique Document File Nm
| Description | Indicates a reference to a website, ftp, file path or other location from which the document contents can be retrieved. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Unique Document Num
| Description | Indicates the unique document identification number assigned by the sending system. |
| 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 |
Valid From Ts
| Description | Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid To Ts
| Description | Ends a period of validity. |
| 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 |
| Relationship Details |
Safety Report Detail_Document_FK
| Is Identifying Relationship | true |
| Child Table | Safety Report Detail |
| 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 | Document |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Safety Report Detail PK
| Key Attribute | Document Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |