EXPT_RSRC_ID |
Base Object | EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC |
Attribute Name | Experiment Resource Identifier |
ColumnName | EXPT_RSRC_ID |
Logical Rolename | Experiment Resource Identifier |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EXPT_RSRC_ID Column Properties |
Datatype | VARCHAR2(50) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EXPT_RSRC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
EXPT_RSRC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EXPT_RSRC_ID Security Types |
Name | Current Value |
EXPT_RSRC_ID Bound Attachments |
Name | Current Value |
EXPT_RSRC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
EXPT_RSRC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Question Experiment Resource Schedule Association Experiment Resource Identifier |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC EXPT_RSRC_ID |
NO |
EXPT_RSRC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXPT_RSRC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXPT_RSRC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXPT_RSRC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
QUES_ID |
Base Object | EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC |
Attribute Name | Question Identifier |
ColumnName | QUES_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
QUES_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
QUES_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
QUES_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
QUES_ID Security Types |
Name | Current Value |
QUES_ID Bound Attachments |
Name | Current Value |
QUES_ID Data Movement Rules |
Name | Type | Rule Text/Value |
QUES_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Question Experiment Resource Schedule Association Question Identifier |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC QUES_ID |
NO |
QUES_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
QUES_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
QUES_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
QUES_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
YES_NO_NA_IND |
Base Object | EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC |
Attribute Name | Yes/No/NA Indicator |
ColumnName | YES_NO_NA_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | |
Note |
YES_NO_NA_IND Column Properties |
Datatype | CHAR(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
YES_NO_NA_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
YES_NO_NA_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
YES_NO_NA_IND 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 |
YES_NO_NA_IND Security Types |
Name | Current Value |
YES_NO_NA_IND Bound Attachments |
Name | Current Value |
YES_NO_NA_IND Data Movement Rules |
Name | Type | Rule Text/Value |
YES_NO_NA_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Question Experiment Resource Schedule Association Yes/No/NA Indicator |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC YES_NO_NA_IND |
NO |
YES_NO_NA_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
YES_NO_NA_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
YES_NO_NA_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
YES_NO_NA_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT |
Base Object | EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC |
Attribute Name | Comment |
ColumnName | CMNT |
Logical Rolename | |
RoleName | |
Domain | Comment |
Physical Only | NO |
Definition | Comment: General comments. |
Note |
CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CMNT Security Types |
Name | Current Value |
CMNT Bound Attachments |
Name | Current Value |
CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
CMNT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Question Experiment Resource Schedule Association Comment |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_QUES_EXPT_RSRC_SCHED_ASSC CMNT |
NO |
CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |