Activity Identifier |
Base Entity | Operation Activity |
Attribute Name | Activity Identifier |
Logical Rolename | |
ColumnName | ACT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Period Identifier: Abbreviated identifier given to a run cycle period. |
Note |
Activity Identifier Logical Attribute Properties |
Logical Attribute Name | Activity Identifier |
Datatype | VARCHAR(20) |
Nullable | NO |
Activity Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Activity Identifier Security Types |
Name | Current Value |
Activity Identifier Bound Attachments |
Name | Current Value |
Activity Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Activity Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Operation Activity Activity Identifier |
NO | ||
OPER (Oracle) OPER_ACT ACT_ID |
NO |
Activity Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Description |
Base Entity | Operation Activity |
Attribute Name | Activity Description |
Logical Rolename | |
ColumnName | ACT_DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
Activity Description Logical Attribute Properties |
Logical Attribute Name | Activity Description |
Datatype | VARCHAR(120) |
Nullable | NO |
Activity Description Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Activity Description Security Types |
Name | Current Value |
Activity Description Bound Attachments |
Name | Current Value |
Activity Description Data Movement Rules |
Name | Type | Rule Text/Value |
Activity Description Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Operation Activity Activity Description |
NO | ||
OPER (Oracle) OPER_ACT ACT_DESCR |
NO |
Activity Description Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Description Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Description Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Description Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Machine State Indicator |
Base Entity | Operation Activity |
Attribute Name | Machine State Indicator |
Logical Rolename | |
ColumnName | MACH_STATE_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Machine State Indicator Logical Attribute Properties |
Logical Attribute Name | Machine State Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Machine State Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Machine State Indicator Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Machine State Indicator Security Types |
Name | Current Value |
Machine State Indicator Bound Attachments |
Name | Current Value |
Machine State Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Machine State Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Operation Activity Machine State Indicator |
NO | ||
OPER (Oracle) OPER_ACT MACH_STATE_IND |
NO |
Machine State Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Machine State Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Machine State Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Machine State Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |