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