ID |
Base Object | PARAMETER |
Attribute Name | ID |
ColumnName | ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ID Security Types |
Name | Current Value |
ID Bound Attachments |
Name | Current Value |
ID Data Movement Rules |
Name | Type | Rule Text/Value |
ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) PARAMETER ID |
NO |
ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NAME |
Base Object | PARAMETER |
Attribute Name | NAME |
ColumnName | NAME |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
NAME Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NAME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
NAME Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NAME Security Types |
Name | Current Value |
NAME Bound Attachments |
Name | Current Value |
NAME Data Movement Rules |
Name | Type | Rule Text/Value |
NAME Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) PARAMETER NAME |
NO |
NAME Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NAME Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NAME Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NAME Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
VALUE |
Base Object | PARAMETER |
Attribute Name | VALUE |
ColumnName | VALUE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
VALUE Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
VALUE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
VALUE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
VALUE Security Types |
Name | Current Value |
VALUE Bound Attachments |
Name | Current Value |
VALUE Data Movement Rules |
Name | Type | Rule Text/Value |
VALUE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) PARAMETER VALUE |
NO |
VALUE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
VALUE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
VALUE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
VALUE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
UNITS |
Base Object | PARAMETER |
Attribute Name | UNITS |
ColumnName | UNITS |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
UNITS Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
UNITS Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
UNITS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
UNITS Security Types |
Name | Current Value |
UNITS Bound Attachments |
Name | Current Value |
UNITS Data Movement Rules |
Name | Type | Rule Text/Value |
UNITS Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) PARAMETER UNITS |
NO |
UNITS Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
UNITS Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
UNITS Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
UNITS Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXPONENT |
Base Object | PARAMETER |
Attribute Name | EXPONENT |
ColumnName | EXPONENT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EXPONENT Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EXPONENT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
EXPONENT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EXPONENT Security Types |
Name | Current Value |
EXPONENT Bound Attachments |
Name | Current Value |
EXPONENT Data Movement Rules |
Name | Type | Rule Text/Value |
EXPONENT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) PARAMETER EXPONENT |
NO |
EXPONENT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXPONENT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXPONENT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXPONENT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RANGE_TOP |
Base Object | PARAMETER |
Attribute Name | RANGE_TOP |
ColumnName | RANGE_TOP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
RANGE_TOP Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RANGE_TOP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
RANGE_TOP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RANGE_TOP Security Types |
Name | Current Value |
RANGE_TOP Bound Attachments |
Name | Current Value |
RANGE_TOP Data Movement Rules |
Name | Type | Rule Text/Value |
RANGE_TOP Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) PARAMETER RANGE_TOP |
NO |
RANGE_TOP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RANGE_TOP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RANGE_TOP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RANGE_TOP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RANGE_BOTTOM |
Base Object | PARAMETER |
Attribute Name | RANGE_BOTTOM |
ColumnName | RANGE_BOTTOM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
RANGE_BOTTOM Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RANGE_BOTTOM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
RANGE_BOTTOM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RANGE_BOTTOM Security Types |
Name | Current Value |
RANGE_BOTTOM Bound Attachments |
Name | Current Value |
RANGE_BOTTOM Data Movement Rules |
Name | Type | Rule Text/Value |
RANGE_BOTTOM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) PARAMETER RANGE_BOTTOM |
NO |
RANGE_BOTTOM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RANGE_BOTTOM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RANGE_BOTTOM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RANGE_BOTTOM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ERROR |
Base Object | PARAMETER |
Attribute Name | ERROR |
ColumnName | ERROR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ERROR Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ERROR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
ERROR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ERROR Security Types |
Name | Current Value |
ERROR Bound Attachments |
Name | Current Value |
ERROR Data Movement Rules |
Name | Type | Rule Text/Value |
ERROR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) PARAMETER ERROR |
NO |
ERROR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ERROR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ERROR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ERROR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOURCE |
Base Object | PARAMETER |
Attribute Name | SOURCE |
ColumnName | SOURCE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SOURCE Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SOURCE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
SOURCE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SOURCE Security Types |
Name | Current Value |
SOURCE Bound Attachments |
Name | Current Value |
SOURCE Data Movement Rules |
Name | Type | Rule Text/Value |
SOURCE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) PARAMETER SOURCE |
NO |
SOURCE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOURCE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SOURCE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOURCE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_MODIFY_TIME |
Base Object | PARAMETER |
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) PARAMETER 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 | PARAMETER |
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) PARAMETER 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 | PARAMETER |
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) PARAMETER 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 |