Shift Identifier |
Base Entity | Shift Summary Process Variable Association |
Attribute Name | Shift Identifier |
Logical Rolename | |
ColumnName | SHIFT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Shift Identifier: The name given to a defined shift. |
Note |
Shift Identifier Logical Attribute Properties |
Logical Attribute Name | Shift Identifier |
Datatype | VARCHAR(5) |
Nullable | NO |
Shift Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Shift Identifier Security Types |
Name | Current Value |
Shift Identifier Bound Attachments |
Name | Current Value |
Shift Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Shift Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Shift Summary Process Variable Association Shift Identifier |
NO | ||
OPER (Oracle) SHIFT_SUM_PROC_VAR_ASSC SHIFT_ID |
NO |
Shift Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Calendar Date |
Base Entity | Shift Summary Process Variable Association |
Attribute Name | Calendar Date |
Logical Rolename | |
ColumnName | CAL_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Calendar Date Logical Attribute Properties |
Logical Attribute Name | Calendar Date |
Datatype | DATE |
Nullable | NO |
Calendar Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Calendar Date Security Types |
Name | Current Value |
Calendar Date Bound Attachments |
Name | Current Value |
Calendar Date Data Movement Rules |
Name | Type | Rule Text/Value |
Calendar Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Shift Summary Process Variable Association Calendar Date |
NO | ||
OPER (Oracle) SHIFT_SUM_PROC_VAR_ASSC CAL_DTE |
NO |
Calendar Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Calendar Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Calendar Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Calendar Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sgnl Id |
Base Entity | Shift Summary Process Variable Association |
Attribute Name | Sgnl Id |
Logical Rolename | |
ColumnName | SGNL_ID |
RoleName | |
Domain | Signal Id |
Logical Only | NO |
Definition | Signal Identifier: |
Note |
Sgnl Id Logical Attribute Properties |
Logical Attribute Name | Sgnl Id |
Datatype | VARCHAR(75) |
Nullable | NO |
Sgnl Id Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Sgnl Id Security Types |
Name | Current Value |
Sgnl Id Bound Attachments |
Name | Current Value |
Sgnl Id Data Movement Rules |
Name | Type | Rule Text/Value |
Sgnl Id Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Shift Summary Process Variable Association Sgnl Id |
NO | ||
OPER (Oracle) SHIFT_SUM_PROC_VAR_ASSC SGNL_ID |
NO |
Sgnl Id Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sgnl Id Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sgnl Id Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sgnl Id Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Value |
Base Entity | Shift Summary Process Variable Association |
Attribute Name | Value |
Logical Rolename | |
ColumnName | VAL |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Value Logical Attribute Properties |
Logical Attribute Name | Value |
Datatype | VARCHAR(128) |
Nullable | YES |
Value Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Value Security Types |
Name | Current Value |
Value Bound Attachments |
Name | Current Value |
Value Data Movement Rules |
Name | Type | Rule Text/Value |
Value Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Shift Summary Process Variable Association Value |
NO | ||
OPER (Oracle) SHIFT_SUM_PROC_VAR_ASSC VAL |
NO |
Value Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Value Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Value Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Value Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |