Access LevelPerson RolePrimary IndStudy Authorization Date
| Business Data Model Data Model |
| Description | An association between a study and a researcher or practitioner which identifies the study a researcher has a role in and the data access level he/she holds. |
| Attributes | |
| Access Level |
|
| Person Role |
|
| Primary Ind |
|
| Study Authorization Date |
|
| Relationship | |
 Study Researcher_Study_FK |
|
| Study Researcher_Researcher_FK |
|
| Study / Personnel_Practitioner_FK |
|
| Study / Personnel_PerformedStudyAgentTransfer_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Access Level
| Description | Indicates the amount of access that a staff member has with regard to the data of a particular study. |
| 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 |
Person Role
| Description | Indicates the resposibilities or role that a person has with regards to a study. |
| 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 |
Primary Ind
| Description | Indicates whether this is the main or principal study personnel. Role Code and primary indicator are redundant attributes when role code = "Principal Investigator" and primary indicator ="true". |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Study Authorization Date
| Description | The date upon which the researcher was authorized to perform the study. |
| 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 |
| Relationship Details |
Study Researcher_Study_FK
| Is Identifying Relationship | false |
| Child Table | Study / Personnel |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | RESTRICT |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | RESTRICT |
| Parent Table | Study |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | RESTRICT |
| Parent Referential Integrity: On Update | RESTRICT |
Study Researcher_Researcher_FK
| Is Identifying Relationship | false |
| Child Table | Study / Personnel |
| 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 | Researcher |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Study / Personnel_Practitioner_FK
| Is Identifying Relationship | false |
| Child Table | Study / Personnel |
| 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 |
Study / Personnel_PerformedStudyAgentTransfer_FK
| Is Identifying Relationship | false |
| Child Table | Study / Personnel |
| 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 | Performed Study Agent Transfer |
| 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 |