Survey Author NameSurvey DomainSurvey Expiry DateSurvey Issue DateSurvey NameSurvey NumSurvey Subject IndSurvey Version Num
| Business Data Model Data Model |
| Description | A questionnaire or a form that is used to gather some type of information. It can contain one or more questions or a combination of sections, subsections, and related questions. |
| Attributes | |
| Survey Author Name |
|
| Survey Domain |
|
| Survey Expiry Date |
|
| Survey Issue Date |
|
| Survey Name |
|
| Survey Num |
|
| Survey Subject Ind |
|
| Survey Version Num |
|
| Relationship | |
 Survey_Survey Template_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Survey Author Name
| Description | The name of the originator, creator or writer of a survey. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Survey Domain
| Description | The areas or topics covered by the survey. |
| 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 |
Survey Expiry Date
| Description | The date upon which the Survey or form is to or has expired. |
| 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 |
Survey Issue Date
| Description | The date upon which the Survey or form was issued or made available to the public. |
| 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 |
Survey Name
| Description | A name used to identify a survey. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Survey Num
| Description | The survey or form number. |
| 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 |
Survey Subject Ind
| Description | Indicates the nature of the subject about which the survey is intended to elicit information. For example: B = Brand HF = Healthcare Facility HP = Healthcare Provider P = Product |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Survey Version Num
| Description | The version of Survey or form questionnaire. |
| 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 |
| Relationship Details |
Survey_Survey Template_FK
| Is Identifying Relationship | false |
| Child Table | Survey |
| 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 Template |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |