Answer Response TxtPre-Populated Validation StatusResponse Answer Annotation TxtSurvey Answer Response Date
| Business Data Model Data Model |
| Description | An actual answer that is in response to a survey question. If the question had a pre-define set of allowable answers, there will be a link to survey answer. |
| Attributes | |
| Answer Response Txt |
|
| Pre-Populated Validation Status |
|
| Response Answer Annotation Txt |
|
| Survey Answer Response Date |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Answer Response Txt
| Description | A free-form answer to a survey question that is only used if the question expects a free-form answer, and does not reflect the text of a predefined, coded allowable value answer. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pre-Populated Validation Status
| Description | Describes the current status of user validation of a pre-populated response on a survey, questionnaire or other communication. |
| 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 |
Response Answer Annotation Txt
| Description | A response answer may be different than its associated Clinical Finding value. In this case an annotation should indicate why a difference exists. |
| 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 |
Survey Answer Response Date
| Description | A date type answer to a survey question. |
| 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 |
Survey Result Answer_Survey Answer_FK
| Is Identifying Relationship | false |
| Child Table | Survey Response Answer |
| 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 | Survey Answer |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Survey Result Answer_Survey Result_FK
| Is Identifying Relationship | true |
| Child Table | Survey Response Answer |
| 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 | Survey Response |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Survey Result Answer_Survey Question_FK
| Is Identifying Relationship | true |
| Child Table | Survey Response Answer |
| 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 | Survey Question |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Survey Response Answer_User_FK
| Is Identifying Relationship | false |
| Child Table | Survey Response Answer |
| Child Role Name | pre-populated validation user |
| 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 | User |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Survey Response Answer_Clinical Finding_FK
| Is Identifying Relationship | false |
| Child Table | Survey Response Answer |
| 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 | Clinical Finding |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Survey Response Answer_Clinical Finding_FK1
| Is Identifying Relationship | false |
| Child Table | Survey Response Answer |
| 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 | Clinical Finding |
| 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 |