SHIFT_ID |
Base Object | SHIFT_SUM_PROC_VAR_ASSC |
Attribute Name | Shift Identifier |
ColumnName | SHIFT_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Shift Identifier: The name given to a defined shift. |
Note |
SHIFT_ID Column Properties |
Datatype | VARCHAR2(5) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SHIFT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 0 |
SHIFT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SHIFT_ID Security Types |
Name | Current Value |
SHIFT_ID Bound Attachments |
Name | Current Value |
SHIFT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SHIFT_ID 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_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SHIFT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SHIFT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SHIFT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CAL_DTE |
Base Object | SHIFT_SUM_PROC_VAR_ASSC |
Attribute Name | Calendar Date |
ColumnName | CAL_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
CAL_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CAL_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
CAL_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
CAL_DTE Security Types |
Name | Current Value |
CAL_DTE Bound Attachments |
Name | Current Value |
CAL_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
CAL_DTE 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 |
CAL_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CAL_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CAL_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CAL_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SGNL_ID |
Base Object | SHIFT_SUM_PROC_VAR_ASSC |
Attribute Name | Sgnl Id |
ColumnName | SGNL_ID |
Logical Rolename | |
RoleName | |
Domain | Signal Id |
Physical Only | NO |
Definition | Signal Identifier: |
Note |
SGNL_ID Column Properties |
Datatype | VARCHAR2(75) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SGNL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 75 |
Percent Null | 0 |
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 |
VAL |
Base Object | SHIFT_SUM_PROC_VAR_ASSC |
Attribute Name | Value |
ColumnName | VAL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
VAL Column Properties |
Datatype | VARCHAR2(128) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
VAL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 128 |
Percent Null | 0 |
VAL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
VAL Security Types |
Name | Current Value |
VAL Bound Attachments |
Name | Current Value |
VAL Data Movement Rules |
Name | Type | Rule Text/Value |
VAL 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 |
VAL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
VAL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
VAL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
VAL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |