| Question Identifier |
| Base Entity | Instrument Proposal Question |
| Attribute Name | Question Identifier |
| Logical Rolename | |
| ColumnName | QUESTION_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Question Identifier Logical Attribute Properties |
| Logical Attribute Name | Question Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Question Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Question Identifier Security Types |
| Name | Current Value |
| Question Identifier Bound Attachments |
| Name | Current Value |
| Question Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Question Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Proposal Question Question Identifier |
NO | ||
| IPTSv5 (Oracle) INSTR_PRPSL_QUES QUESTION_ID |
NO | ||
| PRPSL (Oracle) INSTR_PRPSL_QUES QUESTION_ID |
NO | ||
| XF_ADMIN (Oracle) INSTR_PRPSL_QUES QUESTION_ID |
NO |
| Question Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Question Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Question Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Question Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Text |
| Base Entity | Instrument Proposal Question |
| Attribute Name | Text |
| Logical Rolename | |
| ColumnName | TEXT |
| RoleName | |
| Domain | Text |
| Logical Only | NO |
| Definition | |
| Note |
| Text Logical Attribute Properties |
| Logical Attribute Name | Text |
| Datatype | VARCHAR(250) |
| Nullable | NO |
| Text Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Text Security Types |
| Name | Current Value |
| Text Bound Attachments |
| Name | Current Value |
| Text Data Movement Rules |
| Name | Type | Rule Text/Value |
| Text Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Proposal Question Text |
NO | ||
| IPTSv5 (Oracle) INSTR_PRPSL_QUES TEXT |
NO | ||
| PRPSL (Oracle) INSTR_PRPSL_QUES TEXT |
NO | ||
| XF_ADMIN (Oracle) INSTR_PRPSL_QUES TEXT |
NO |
| Text Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Text Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Text Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Text Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Question Type Code |
| Base Entity | Instrument Proposal Question |
| Attribute Name | Question Type Code |
| Logical Rolename | |
| ColumnName | QUESTION_TYPE_CD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Question Type Code: Codes indicates what type of answer the question uses. I - Inidicator (Y/N); T - Text; IS - Select from Instrument Pick-from-list; IT - Indicator (Y/N) with Text answer |
| Note |
| Question Type Code Logical Attribute Properties |
| Logical Attribute Name | Question Type Code |
| Datatype | CHAR(1) |
| Nullable | NO |
| Question Type Code Domain Restrictions |
| CheckConstraint | QUESTION_TYPE_CD IN ('I','IS','S','T') | ||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Question Type Code Security Types |
| Name | Current Value |
| Question Type Code Bound Attachments |
| Name | Current Value |
| Question Type Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Question Type Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Proposal Question Question Type Code |
NO | ||
| IPTSv5 (Oracle) INSTR_PRPSL_QUES QUESTION_TYPE_CD |
NO | ||
| PRPSL (Oracle) INSTR_PRPSL_QUES QUESTION_TYPE_CD |
NO | ||
| XF_ADMIN (Oracle) INSTR_PRPSL_QUES QUESTION_TYPE_CD |
NO |
| Question Type Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Question Type Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Question Type Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Question Type Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator |
| Base Entity | Instrument Proposal Question |
| Attribute Name | Display Indicator |
| Logical Rolename | |
| ColumnName | DISP_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Display Indicator Logical Attribute Properties |
| Logical Attribute Name | Display Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Display Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Display Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Display Indicator Security Types |
| Name | Current Value |
| Display Indicator Bound Attachments |
| Name | Current Value |
| Display Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Display Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Instrument Proposal Question Display Indicator |
NO | ||
| IPTSv5 (Oracle) INSTR_PRPSL_QUES DISP_IND |
NO | ||
| PRPSL (Oracle) INSTR_PRPSL_QUES DISP_IND |
NO | ||
| XF_ADMIN (Oracle) INSTR_PRPSL_QUES DISP_IND |
NO |
| Display Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |