| COMPONENT_ID |
| Base Object | GUIDANCE |
| Attribute Name | Component Identifier |
| ColumnName | COMPONENT_ID |
| Logical Rolename | Component Identifier |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | Component Identifier: The id for identification of each component. |
| Note |
| COMPONENT_ID Column Properties |
| Datatype | INT |
| Nullable | NO |
| Unsigned | NO |
| COMPONENT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| COMPONENT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| COMPONENT_ID Security Types |
| Name | Current Value |
| COMPONENT_ID Bound Attachments |
| Name | Current Value |
| COMPONENT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| COMPONENT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Guidance Component Identifier |
NO | ||
| ALARM_MYSQL (MySQL) GUIDANCE COMPONENT_ID |
NO | ||
| ALARM_ORACLE (Oracle) GUIDANCE COMPONENT_ID |
NO |
| COMPONENT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMPONENT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMPONENT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMPONENT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE |
| Base Object | GUIDANCE |
| Attribute Name | Title |
| ColumnName | TITLE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Title: Brief description of the guidance, which will be displayed in the context menu. |
| Note |
| TITLE Column Properties |
| Datatype | VARCHAR(100) |
| Nullable | NO |
| Unsigned | NO |
| TITLE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 101 |
| Percent Null | 0 |
| TITLE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TITLE Security Types |
| Name | Current Value |
| TITLE Bound Attachments |
| Name | Current Value |
| TITLE Data Movement Rules |
| Name | Type | Rule Text/Value |
| TITLE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Guidance Title |
NO | ||
| ALARM_MYSQL (MySQL) GUIDANCE TITLE |
NO | ||
| ALARM_ORACLE (Oracle) GUIDANCE TITLE |
NO |
| TITLE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GUIDANCE_ORDER |
| Base Object | GUIDANCE |
| Attribute Name | Guidance Order |
| ColumnName | GUIDANCE_ORDER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Order: The order by which the guidance is arranged. |
| Note |
| GUIDANCE_ORDER Column Properties |
| Datatype | INT |
| Nullable | NO |
| Unsigned | NO |
| GUIDANCE_ORDER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| GUIDANCE_ORDER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GUIDANCE_ORDER Security Types |
| Name | Current Value |
| GUIDANCE_ORDER Bound Attachments |
| Name | Current Value |
| GUIDANCE_ORDER Data Movement Rules |
| Name | Type | Rule Text/Value |
| GUIDANCE_ORDER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Guidance Guidance Order |
NO | ||
| ALARM_MYSQL (MySQL) GUIDANCE GUIDANCE_ORDER |
NO | ||
| ALARM_ORACLE (Oracle) GUIDANCE GUIDANCE_ORDER |
NO |
| GUIDANCE_ORDER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GUIDANCE_ORDER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GUIDANCE_ORDER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GUIDANCE_ORDER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DETAIL |
| Base Object | GUIDANCE |
| Attribute Name | Details |
| ColumnName | DETAIL |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Detail: Guidance information which is displayed in the guidance dialog. |
| Note |
| DETAIL Column Properties |
| Datatype | VARCHAR(4000) |
| Nullable | NO |
| Unsigned | NO |
| DETAIL Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2048 |
| Percent Null | 0 |
| DETAIL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DETAIL Security Types |
| Name | Current Value |
| DETAIL Bound Attachments |
| Name | Current Value |
| DETAIL Data Movement Rules |
| Name | Type | Rule Text/Value |
| DETAIL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Guidance Details |
NO | ||
| ALARM_MYSQL (MySQL) GUIDANCE DETAIL |
NO | ||
| ALARM_ORACLE (Oracle) GUIDANCE DETAIL |
NO |
| DETAIL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DETAIL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DETAIL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DETAIL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |