QUESTION_ID 
Base Object  INSTR_PRPSL_QUES 
Attribute Name  Question Identifier 
ColumnName  QUESTION_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

QUESTION_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

QUESTION_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

QUESTION_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

QUESTION_ID Security Types 
Name  Current Value 

QUESTION_ID Bound Attachments 
Name  Current Value 

QUESTION_ID Data Movement Rules 
Name  Type  Rule Text/Value 

QUESTION_ID 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_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

QUESTION_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

QUESTION_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

QUESTION_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TEXT 
Base Object  INSTR_PRPSL_QUES 
Attribute Name  Text 
ColumnName  TEXT 
Logical Rolename   
RoleName   
Domain  Text 
Physical Only  NO 
Definition 
 
Note 
 

TEXT Column Properties 
Datatype  VARCHAR2(250) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

TEXT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  4000 
Percent Null 

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_CD 
Base Object  INSTR_PRPSL_QUES 
Attribute Name  Question Type Code 
ColumnName  QUESTION_TYPE_CD 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

QUESTION_TYPE_CD Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

QUESTION_TYPE_CD Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

QUESTION_TYPE_CD Domain Restrictions 
CheckConstraint  QUESTION_TYPE_CD IN ('I','T') 
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

QUESTION_TYPE_CD Security Types 
Name  Current Value 

QUESTION_TYPE_CD Bound Attachments 
Name  Current Value 

QUESTION_TYPE_CD Data Movement Rules 
Name  Type  Rule Text/Value 

QUESTION_TYPE_CD 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_CD Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

QUESTION_TYPE_CD Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

QUESTION_TYPE_CD Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

QUESTION_TYPE_CD Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description