OL_NAME |
Base Object | OL$ |
Attribute Name | OL_NAME |
ColumnName | OL_NAME |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
OL_NAME Column Properties |
Datatype | VARCHAR2(30) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OL_NAME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 30 |
Percent Null | 0 |
OL_NAME Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OL_NAME Security Types |
Name | Current Value |
OL_NAME Bound Attachments |
Name | Current Value |
OL_NAME Data Movement Rules |
Name | Type | Rule Text/Value |
OL_NAME Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ OL_NAME |
NO |
OL_NAME Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OL_NAME Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OL_NAME Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OL_NAME Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SQL_TEXT |
Base Object | OL$ |
Attribute Name | SQL_TEXT |
ColumnName | SQL_TEXT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SQL_TEXT Column Properties |
Datatype | LONG |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SQL_TEXT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
SQL_TEXT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SQL_TEXT Security Types |
Name | Current Value |
SQL_TEXT Bound Attachments |
Name | Current Value |
SQL_TEXT Data Movement Rules |
Name | Type | Rule Text/Value |
SQL_TEXT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ SQL_TEXT |
NO |
SQL_TEXT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SQL_TEXT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SQL_TEXT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SQL_TEXT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TEXTLEN |
Base Object | OL$ |
Attribute Name | TEXTLEN |
ColumnName | TEXTLEN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
TEXTLEN Column Properties |
Datatype | NUMBER |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TEXTLEN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
TEXTLEN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TEXTLEN Security Types |
Name | Current Value |
TEXTLEN Bound Attachments |
Name | Current Value |
TEXTLEN Data Movement Rules |
Name | Type | Rule Text/Value |
TEXTLEN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ TEXTLEN |
NO |
TEXTLEN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TEXTLEN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TEXTLEN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TEXTLEN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SIGNATURE |
Base Object | OL$ |
Attribute Name | SIGNATURE |
ColumnName | SIGNATURE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SIGNATURE Column Properties |
Datatype | RAW(16) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SIGNATURE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 16 |
Percent Null | 0 |
SIGNATURE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SIGNATURE Security Types |
Name | Current Value |
SIGNATURE Bound Attachments |
Name | Current Value |
SIGNATURE Data Movement Rules |
Name | Type | Rule Text/Value |
SIGNATURE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ SIGNATURE |
NO |
SIGNATURE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SIGNATURE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SIGNATURE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SIGNATURE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HASH_VALUE |
Base Object | OL$ |
Attribute Name | HASH_VALUE |
ColumnName | HASH_VALUE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
HASH_VALUE Column Properties |
Datatype | NUMBER |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
HASH_VALUE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
HASH_VALUE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HASH_VALUE Security Types |
Name | Current Value |
HASH_VALUE Bound Attachments |
Name | Current Value |
HASH_VALUE Data Movement Rules |
Name | Type | Rule Text/Value |
HASH_VALUE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ HASH_VALUE |
NO |
HASH_VALUE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HASH_VALUE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HASH_VALUE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HASH_VALUE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HASH_VALUE2 |
Base Object | OL$ |
Attribute Name | HASH_VALUE2 |
ColumnName | HASH_VALUE2 |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
HASH_VALUE2 Column Properties |
Datatype | NUMBER |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
HASH_VALUE2 Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
HASH_VALUE2 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HASH_VALUE2 Security Types |
Name | Current Value |
HASH_VALUE2 Bound Attachments |
Name | Current Value |
HASH_VALUE2 Data Movement Rules |
Name | Type | Rule Text/Value |
HASH_VALUE2 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ HASH_VALUE2 |
NO |
HASH_VALUE2 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HASH_VALUE2 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HASH_VALUE2 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HASH_VALUE2 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CATEGORY |
Base Object | OL$ |
Attribute Name | CATEGORY |
ColumnName | CATEGORY |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CATEGORY Column Properties |
Datatype | VARCHAR2(30) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CATEGORY Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 30 |
Percent Null | 0 |
CATEGORY Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CATEGORY Security Types |
Name | Current Value |
CATEGORY Bound Attachments |
Name | Current Value |
CATEGORY Data Movement Rules |
Name | Type | Rule Text/Value |
CATEGORY Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ CATEGORY |
NO |
CATEGORY Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CATEGORY Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CATEGORY Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CATEGORY Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
VERSION |
Base Object | OL$ |
Attribute Name | VERSION |
ColumnName | VERSION |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
VERSION Column Properties |
Datatype | VARCHAR2(64) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
VERSION Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
VERSION Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
VERSION Security Types |
Name | Current Value |
VERSION Bound Attachments |
Name | Current Value |
VERSION Data Movement Rules |
Name | Type | Rule Text/Value |
VERSION Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ VERSION |
NO |
VERSION Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
VERSION Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
VERSION Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
VERSION Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CREATOR |
Base Object | OL$ |
Attribute Name | CREATOR |
ColumnName | CREATOR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CREATOR Column Properties |
Datatype | VARCHAR2(30) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CREATOR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 30 |
Percent Null | 0 |
CREATOR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CREATOR Security Types |
Name | Current Value |
CREATOR Bound Attachments |
Name | Current Value |
CREATOR Data Movement Rules |
Name | Type | Rule Text/Value |
CREATOR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ CREATOR |
NO |
CREATOR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CREATOR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CREATOR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CREATOR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TIMESTAMP |
Base Object | OL$ |
Attribute Name | TIMESTAMP |
ColumnName | TIMESTAMP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
TIMESTAMP Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TIMESTAMP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
TIMESTAMP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TIMESTAMP Security Types |
Name | Current Value |
TIMESTAMP Bound Attachments |
Name | Current Value |
TIMESTAMP Data Movement Rules |
Name | Type | Rule Text/Value |
TIMESTAMP Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ TIMESTAMP |
NO |
TIMESTAMP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TIMESTAMP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TIMESTAMP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TIMESTAMP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FLAGS |
Base Object | OL$ |
Attribute Name | FLAGS |
ColumnName | FLAGS |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FLAGS Column Properties |
Datatype | NUMBER |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FLAGS Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
FLAGS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FLAGS Security Types |
Name | Current Value |
FLAGS Bound Attachments |
Name | Current Value |
FLAGS Data Movement Rules |
Name | Type | Rule Text/Value |
FLAGS Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ FLAGS |
NO |
FLAGS Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FLAGS Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FLAGS Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FLAGS Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HINTCOUNT |
Base Object | OL$ |
Attribute Name | HINTCOUNT |
ColumnName | HINTCOUNT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
HINTCOUNT Column Properties |
Datatype | NUMBER |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
HINTCOUNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
HINTCOUNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HINTCOUNT Security Types |
Name | Current Value |
HINTCOUNT Bound Attachments |
Name | Current Value |
HINTCOUNT Data Movement Rules |
Name | Type | Rule Text/Value |
HINTCOUNT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ HINTCOUNT |
NO |
HINTCOUNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HINTCOUNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HINTCOUNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HINTCOUNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SPARE1 |
Base Object | OL$ |
Attribute Name | SPARE1 |
ColumnName | SPARE1 |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SPARE1 Column Properties |
Datatype | NUMBER |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SPARE1 Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
SPARE1 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SPARE1 Security Types |
Name | Current Value |
SPARE1 Bound Attachments |
Name | Current Value |
SPARE1 Data Movement Rules |
Name | Type | Rule Text/Value |
SPARE1 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ SPARE1 |
NO |
SPARE1 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SPARE1 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SPARE1 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SPARE1 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SPARE2 |
Base Object | OL$ |
Attribute Name | SPARE2 |
ColumnName | SPARE2 |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SPARE2 Column Properties |
Datatype | VARCHAR2(1000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SPARE2 Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1000 |
Percent Null | 0 |
SPARE2 Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SPARE2 Security Types |
Name | Current Value |
SPARE2 Bound Attachments |
Name | Current Value |
SPARE2 Data Movement Rules |
Name | Type | Rule Text/Value |
SPARE2 Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SURVEY (Oracle) OL$ SPARE2 |
NO |
SPARE2 Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SPARE2 Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SPARE2 Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SPARE2 Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |