IOC_ID |
Base Object | IOC |
Attribute Name | IOC_ID |
ColumnName | IOC_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
IOC_ID Column Properties |
Datatype | NUMBER |
Nullable | NO |
IOC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
IOC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
IOC_ID Security Types |
Name | Current Value |
IOC_ID Bound Attachments |
Name | Current Value |
IOC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
IOC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
IRMISBase (Oracle) IOC IOC_ID |
NO |
IOC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
IOC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
IOC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
IOC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
IOC_NM |
Base Object | IOC |
Attribute Name | IOC_NM |
ColumnName | IOC_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
IOC_NM Column Properties |
Datatype | VARCHAR2(40) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
IOC_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 40 |
Percent Null | 0 |
IOC_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
IOC_NM Security Types |
Name | Current Value |
IOC_NM Bound Attachments |
Name | Current Value |
IOC_NM Data Movement Rules |
Name | Type | Rule Text/Value |
IOC_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
IRMISBase (Oracle) IOC IOC_NM |
NO |
IOC_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
IOC_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
IOC_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
IOC_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SYSTEM |
Base Object | IOC |
Attribute Name | SYSTEM |
ColumnName | SYSTEM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SYSTEM Column Properties |
Datatype | VARCHAR2(20) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
SYSTEM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
SYSTEM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SYSTEM Security Types |
Name | Current Value |
SYSTEM Bound Attachments |
Name | Current Value |
SYSTEM Data Movement Rules |
Name | Type | Rule Text/Value |
SYSTEM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
IRMISBase (Oracle) IOC SYSTEM |
NO |
SYSTEM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SYSTEM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SYSTEM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SYSTEM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ACTIVE |
Base Object | IOC |
Attribute Name | ACTIVE |
ColumnName | ACTIVE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ACTIVE Column Properties |
Datatype | NUMBER |
Nullable | YES |
ACTIVE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
ACTIVE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ACTIVE Security Types |
Name | Current Value |
ACTIVE Bound Attachments |
Name | Current Value |
ACTIVE Data Movement Rules |
Name | Type | Rule Text/Value |
ACTIVE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
IRMISBase (Oracle) IOC ACTIVE |
NO |
ACTIVE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ACTIVE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ACTIVE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ACTIVE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MODIFIED_DATE |
Base Object | IOC |
Attribute Name | MODIFIED_DATE |
ColumnName | MODIFIED_DATE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MODIFIED_DATE Column Properties |
Datatype | TIMESTAMP(6) |
Nullable | YES |
Not Null Constraint | |
Time Zone | NO |
MODIFIED_DATE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
MODIFIED_DATE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MODIFIED_DATE Security Types |
Name | Current Value |
MODIFIED_DATE Bound Attachments |
Name | Current Value |
MODIFIED_DATE Data Movement Rules |
Name | Type | Rule Text/Value |
MODIFIED_DATE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
IRMISBase (Oracle) IOC MODIFIED_DATE |
NO |
MODIFIED_DATE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MODIFIED_DATE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MODIFIED_DATE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MODIFIED_DATE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MODIFIED_BY |
Base Object | IOC |
Attribute Name | MODIFIED_BY |
ColumnName | MODIFIED_BY |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MODIFIED_BY Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
MODIFIED_BY Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
MODIFIED_BY Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MODIFIED_BY Security Types |
Name | Current Value |
MODIFIED_BY Bound Attachments |
Name | Current Value |
MODIFIED_BY Data Movement Rules |
Name | Type | Rule Text/Value |
MODIFIED_BY Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
IRMISBase (Oracle) IOC MODIFIED_BY |
NO |
MODIFIED_BY Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MODIFIED_BY Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MODIFIED_BY Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MODIFIED_BY Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_MERGE_IND |
Base Object | IOC |
Attribute Name | SNS_MERGE_IND |
ColumnName | SNS_MERGE_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SNS_MERGE_IND Column Properties |
Datatype | NUMBER |
Nullable | YES |
SNS_MERGE_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
SNS_MERGE_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 0 |
Bound Default |
SNS_MERGE_IND Security Types |
Name | Current Value |
SNS_MERGE_IND Bound Attachments |
Name | Current Value |
SNS_MERGE_IND Data Movement Rules |
Name | Type | Rule Text/Value |
SNS_MERGE_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
IRMISBase (Oracle) IOC SNS_MERGE_IND |
NO |
SNS_MERGE_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_MERGE_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_MERGE_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SNS_MERGE_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |