Data Element Data TypeElement CodeElement DescrElement NameElement TsElement TxtElement Unit Of MeasureElement Val
| Business Data Model Data Model |
| Description | A generic way of separating a data element from a data set so that the data set cannot be connected to a particular individual. |
| Attributes | |
| Data Element Data Type |
|
| Element Code |
|
| Element Descr |
|
| Element Name |
|
| Element Ts |
|
| Element Txt |
|
| Element Unit Of Measure |
|
| Element Val |
|
| Relationship | |
 De-Identified Data Element_Study Subject_FK |
|
| De-Identified Data Element_Study Case_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Data Element Data Type
| Description | Identifies the nature of the data element. For example: Code Text Numeric Timestamp |
| 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 |
Element Code
| Description | A code representing the actual value of the data element as a code. The data type of the element must indicate a code. |
| 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 |
Element Descr
| Description | A short description of the data element, also identifying its origin. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Element Name
| Description | The text description of a data element. |
| 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 |
Element Ts
| Description | A timestamp representing the actual value of the data element. The data type of the element must be timestamp or date. |
| 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 |
Element Txt
| Description | Text representing the actual value of the data element. The data type of the element must be a character type. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Element Unit Of Measure
| Description | Identifies the actual unit of measure of the data element. The data type of the element must be numeric. |
| 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 |
Element Val
| Description | A numeric value representing the value of the data element as a quantity. The data type of the element must be a numeric type. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Float [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
De-Identified Data Element_Study Subject_FK
| Is Identifying Relationship | false |
| Child Table | De-Identified Data Element |
| 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 |
De-Identified Data Element_Study Case_FK
| Is Identifying Relationship | false |
| Child Table | De-Identified Data Element |
| 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 Case |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |