PARTY_ID 
Base Object  INVESTIGATOR_LIST 
Attribute Name  PARTY_ID 
ColumnName  PARTY_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

PARTY_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

PARTY_ID Security Types 
Name  Current Value 

PARTY_ID Bound Attachments 
Name  Current Value 

PARTY_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PARTY_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
SICAT (Oracle)
INVESTIGATOR_LIST
PARTY_ID 
NO     

PARTY_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PARTY_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PARTY_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PARTY_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


INVESTIGATION_ID 
Base Object  INVESTIGATOR_LIST 
Attribute Name  ID 
ColumnName  INVESTIGATION_ID 
Logical Rolename   
RoleName  INVESTIGATION_ID 
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

INVESTIGATION_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

INVESTIGATION_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

INVESTIGATION_ID Security Types 
Name  Current Value 

INVESTIGATION_ID Bound Attachments 
Name  Current Value 

INVESTIGATION_ID Data Movement Rules 
Name  Type  Rule Text/Value 

INVESTIGATION_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
SICAT (Oracle)
INVESTIGATOR_LIST
INVESTIGATION_ID 
NO     

INVESTIGATION_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATION_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATION_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATION_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


INVESTIGATOR_NAME 
Base Object  INVESTIGATOR_LIST 
Attribute Name  INVESTIGATOR_NAME 
ColumnName  INVESTIGATOR_NAME 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

INVESTIGATOR_NAME Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

INVESTIGATOR_NAME Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

INVESTIGATOR_NAME Security Types 
Name  Current Value 

INVESTIGATOR_NAME Bound Attachments 
Name  Current Value 

INVESTIGATOR_NAME Data Movement Rules 
Name  Type  Rule Text/Value 

INVESTIGATOR_NAME Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
SICAT (Oracle)
INVESTIGATOR_LIST
INVESTIGATOR_NAME 
NO     

INVESTIGATOR_NAME Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATOR_NAME Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATOR_NAME Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATOR_NAME Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


INVESTIGATOR_ROLE 
Base Object  INVESTIGATOR_LIST 
Attribute Name  INVESTIGATOR_ROLE 
ColumnName  INVESTIGATOR_ROLE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

INVESTIGATOR_ROLE Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

INVESTIGATOR_ROLE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

INVESTIGATOR_ROLE Security Types 
Name  Current Value 

INVESTIGATOR_ROLE Bound Attachments 
Name  Current Value 

INVESTIGATOR_ROLE Data Movement Rules 
Name  Type  Rule Text/Value 

INVESTIGATOR_ROLE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
SICAT (Oracle)
INVESTIGATOR_LIST
INVESTIGATOR_ROLE 
NO     

INVESTIGATOR_ROLE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATOR_ROLE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATOR_ROLE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATOR_ROLE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SATISFACTION_SCORE 
Base Object  INVESTIGATOR_LIST 
Attribute Name  SATISFACTION_SCORE 
ColumnName  SATISFACTION_SCORE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

SATISFACTION_SCORE Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SATISFACTION_SCORE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

SATISFACTION_SCORE Security Types 
Name  Current Value 

SATISFACTION_SCORE Bound Attachments 
Name  Current Value 

SATISFACTION_SCORE Data Movement Rules 
Name  Type  Rule Text/Value 

SATISFACTION_SCORE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
SICAT (Oracle)
INVESTIGATOR_LIST
SATISFACTION_SCORE 
NO     

SATISFACTION_SCORE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SATISFACTION_SCORE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SATISFACTION_SCORE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SATISFACTION_SCORE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SATISFACTION_COMMENTS 
Base Object  INVESTIGATOR_LIST 
Attribute Name  SATISFACTION_COMMENTS 
ColumnName  SATISFACTION_COMMENTS 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

SATISFACTION_COMMENTS Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SATISFACTION_COMMENTS Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

SATISFACTION_COMMENTS Security Types 
Name  Current Value 

SATISFACTION_COMMENTS Bound Attachments 
Name  Current Value 

SATISFACTION_COMMENTS Data Movement Rules 
Name  Type  Rule Text/Value 

SATISFACTION_COMMENTS Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
SICAT (Oracle)
INVESTIGATOR_LIST
SATISFACTION_COMMENTS 
NO     

SATISFACTION_COMMENTS Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SATISFACTION_COMMENTS Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SATISFACTION_COMMENTS Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SATISFACTION_COMMENTS Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LAST_MODIFY_TIME 
Base Object  INVESTIGATOR_LIST 
Attribute Name  LAST_MODIFY_TIME 
ColumnName  LAST_MODIFY_TIME 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

LAST_MODIFY_TIME Column Properties 
Datatype  DATE 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

LAST_MODIFY_TIME Security Types 
Name  Current Value 

LAST_MODIFY_TIME Bound Attachments 
Name  Current Value 

LAST_MODIFY_TIME Data Movement Rules 
Name  Type  Rule Text/Value 

LAST_MODIFY_TIME Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
SICAT (Oracle)
INVESTIGATOR_LIST
LAST_MODIFY_TIME 
NO     

LAST_MODIFY_TIME Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LAST_MODIFY_TIME Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LAST_MODIFY_TIME Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LAST_MODIFY_TIME Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LAST_MODIFIER_ID 
Base Object  INVESTIGATOR_LIST 
Attribute Name  LAST_MODIFIER_ID 
ColumnName  LAST_MODIFIER_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

LAST_MODIFIER_ID Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

LAST_MODIFIER_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

LAST_MODIFIER_ID Security Types 
Name  Current Value 

LAST_MODIFIER_ID Bound Attachments 
Name  Current Value 

LAST_MODIFIER_ID Data Movement Rules 
Name  Type  Rule Text/Value 

LAST_MODIFIER_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
SICAT (Oracle)
INVESTIGATOR_LIST
LAST_MODIFIER_ID 
NO     

LAST_MODIFIER_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LAST_MODIFIER_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LAST_MODIFIER_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LAST_MODIFIER_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


COMMENTS 
Base Object  INVESTIGATOR_LIST 
Attribute Name  COMMENTS 
ColumnName  COMMENTS 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

COMMENTS Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

COMMENTS Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

COMMENTS Security Types 
Name  Current Value 

COMMENTS Bound Attachments 
Name  Current Value 

COMMENTS Data Movement Rules 
Name  Type  Rule Text/Value 

COMMENTS Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
SICAT (Oracle)
INVESTIGATOR_LIST
COMMENTS 
NO     

COMMENTS Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

COMMENTS Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

COMMENTS Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

COMMENTS Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


INVESTIGATOR_EMAIL 
Base Object  INVESTIGATOR_LIST 
Attribute Name  INVESTIGATOR_EMAIL 
ColumnName  INVESTIGATOR_EMAIL 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

INVESTIGATOR_EMAIL Column Properties 
Datatype  VARCHAR2(255) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

INVESTIGATOR_EMAIL Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

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

INVESTIGATOR_EMAIL Security Types 
Name  Current Value 

INVESTIGATOR_EMAIL Bound Attachments 
Name  Current Value 

INVESTIGATOR_EMAIL Data Movement Rules 
Name  Type  Rule Text/Value 

INVESTIGATOR_EMAIL Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
SICAT (Oracle)
INVESTIGATOR_LIST
INVESTIGATOR_EMAIL 
NO     

INVESTIGATOR_EMAIL Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATOR_EMAIL Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATOR_EMAIL Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INVESTIGATOR_EMAIL Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description