Shift Identifier |
Base Entity | Shift Summary |
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 Shift Identifier |
NO | ||
OPER (Oracle) SHIFT_SUMM 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 |
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 Calendar Date |
NO | ||
OPER (Oracle) SHIFT_SUMM 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 |
Shift Summary Notes |
Base Entity | Shift Summary |
Attribute Name | Shift Summary Notes |
Logical Rolename | |
ColumnName | SHIFT_SUMM_NOTES |
RoleName | |
Domain | Note |
Logical Only | NO |
Definition | |
Note |
Shift Summary Notes Logical Attribute Properties |
Logical Attribute Name | Shift Summary Notes |
Datatype | VARCHAR(4000) |
Nullable | YES |
Shift Summary Notes Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Shift Summary Notes Security Types |
Name | Current Value |
Shift Summary Notes Bound Attachments |
Name | Current Value |
Shift Summary Notes Data Movement Rules |
Name | Type | Rule Text/Value |
Shift Summary Notes Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Shift Summary Shift Summary Notes |
NO | ||
OPER (Oracle) SHIFT_SUMM SHIFT_SUMM_NOTES |
NO |
Shift Summary Notes Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Summary Notes Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Summary Notes Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Summary Notes Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Start Notes |
Base Entity | Shift Summary |
Attribute Name | Shift Start Notes |
Logical Rolename | |
ColumnName | SHIFT_START_NOTES |
RoleName | |
Domain | Note |
Logical Only | NO |
Definition | |
Note |
Shift Start Notes Logical Attribute Properties |
Logical Attribute Name | Shift Start Notes |
Datatype | VARCHAR(4000) |
Nullable | YES |
Shift Start Notes Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Shift Start Notes Security Types |
Name | Current Value |
Shift Start Notes Bound Attachments |
Name | Current Value |
Shift Start Notes Data Movement Rules |
Name | Type | Rule Text/Value |
Shift Start Notes Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Shift Summary Shift Start Notes |
NO | ||
OPER (Oracle) SHIFT_SUMM SHIFT_START_NOTES |
NO |
Shift Start Notes Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Start Notes Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Start Notes Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Start Notes Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Start Indicator |
Base Entity | Shift Summary |
Attribute Name | Shift Start Indicator |
Logical Rolename | |
ColumnName | SHIFT_START_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Shift Start Indicator Logical Attribute Properties |
Logical Attribute Name | Shift Start Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Shift Start Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Shift Start 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 |
Shift Start Indicator Security Types |
Name | Current Value |
Shift Start Indicator Bound Attachments |
Name | Current Value |
Shift Start Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Shift Start Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Shift Summary Shift Start Indicator |
NO | ||
OPER (Oracle) SHIFT_SUMM SHIFT_START_IND |
NO |
Shift Start Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Start Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Start Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Start Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Summary Posted Indicator |
Base Entity | Shift Summary |
Attribute Name | Shift Summary Posted Indicator |
Logical Rolename | |
ColumnName | SHIFT_SUMM_POSTED_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Shift Summary Posted Indicator Logical Attribute Properties |
Logical Attribute Name | Shift Summary Posted Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Shift Summary Posted Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Shift Summary Posted 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 |
Shift Summary Posted Indicator Security Types |
Name | Current Value |
Shift Summary Posted Indicator Bound Attachments |
Name | Current Value |
Shift Summary Posted Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Shift Summary Posted Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Shift Summary Shift Summary Posted Indicator |
NO | ||
OPER (Oracle) SHIFT_SUMM SHIFT_SUMM_POSTED_IND |
NO |
Shift Summary Posted Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Summary Posted Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Summary Posted Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Shift Summary Posted Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |