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 | 0 |
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 | 0 |
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 | 0 |
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 | 0 |
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 | 0 |
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 | 0 |
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 | 7 |
Percent Null | 0 |
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 | 0 |
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 | 0 |
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 | 0 |
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 |