| OPER_GRP_ID |
| Base Object | BEAM_DOWNTIME_ACCT |
| Attribute Name | Operation Group Identifier |
| ColumnName | OPER_GRP_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Operation Group |
| Physical Only | NO |
| Definition | Equipment Category Identifier: The unique identifier for a specific equipment category. |
| Note |
| OPER_GRP_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| OPER_GRP_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| OPER_GRP_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OPER_GRP_ID Security Types |
| Name | Current Value |
| OPER_GRP_ID Bound Attachments |
| Name | Current Value |
| OPER_GRP_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| OPER_GRP_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Downtime Accounting Operation Group Identifier |
NO | ||
| OPER (Oracle) BEAM_DOWNTIME_ACCT OPER_GRP_ID |
NO |
| OPER_GRP_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPER_GRP_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPER_GRP_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPER_GRP_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPER_SUBGRP1_ID |
| Base Object | BEAM_DOWNTIME_ACCT |
| Attribute Name | Operation Subgroup1 Identifier |
| ColumnName | OPER_SUBGRP1_ID |
| Logical Rolename | EQUIP_SUBCAT_ID |
| RoleName | OPER_SUBGRP1_ID |
| Domain | |
| Physical Only | NO |
| Definition | Equipment Subcategory Identifier: The unique identifer for an equipment subcategory. |
| Note |
| OPER_SUBGRP1_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| OPER_SUBGRP1_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| OPER_SUBGRP1_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OPER_SUBGRP1_ID Security Types |
| Name | Current Value |
| OPER_SUBGRP1_ID Bound Attachments |
| Name | Current Value |
| OPER_SUBGRP1_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| OPER_SUBGRP1_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Downtime Accounting Operation Subgroup1 Identifier |
NO | ||
| OPER (Oracle) BEAM_DOWNTIME_ACCT OPER_SUBGRP1_ID |
NO |
| OPER_SUBGRP1_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPER_SUBGRP1_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPER_SUBGRP1_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OPER_SUBGRP1_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| downtime_dte |
| Base Object | BEAM_DOWNTIME_ACCT |
| Attribute Name | Downtime Dte |
| ColumnName | downtime_dte |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| downtime_dte Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| downtime_dte Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| downtime_dte Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| downtime_dte Security Types |
| Name | Current Value |
| downtime_dte Bound Attachments |
| Name | Current Value |
| downtime_dte Data Movement Rules |
| Name | Type | Rule Text/Value |
| downtime_dte Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Downtime Accounting Downtime Dte |
NO | ||
| OPER (Oracle) BEAM_DOWNTIME_ACCT downtime_dte |
NO |
| downtime_dte Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| downtime_dte Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| downtime_dte Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| downtime_dte Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| downtime |
| Base Object | BEAM_DOWNTIME_ACCT |
| Attribute Name | Downtime |
| ColumnName | downtime |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Downtime: The amount of beam time down in tenths due to problem that feel within the operation category. |
| Note |
| downtime Column Properties |
| Datatype | NUMBER(3, 1) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| downtime Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2 |
| Percent Null | 0 |
| downtime Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| downtime Security Types |
| Name | Current Value |
| downtime Bound Attachments |
| Name | Current Value |
| downtime Data Movement Rules |
| Name | Type | Rule Text/Value |
| downtime Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Downtime Accounting Downtime |
NO | ||
| OPER (Oracle) BEAM_DOWNTIME_ACCT downtime |
NO |
| downtime Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| downtime Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| downtime Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| downtime Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| notes |
| Base Object | BEAM_DOWNTIME_ACCT |
| Attribute Name | Note |
| ColumnName | notes |
| Logical Rolename | |
| RoleName | |
| Domain | Note |
| Physical Only | NO |
| Definition | |
| Note |
| notes Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| notes Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 5 |
| notes Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| notes Security Types |
| Name | Current Value |
| notes Bound Attachments |
| Name | Current Value |
| notes Data Movement Rules |
| Name | Type | Rule Text/Value |
| notes Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Downtime Accounting Note |
NO | ||
| OPER (Oracle) BEAM_DOWNTIME_ACCT notes |
NO |
| notes Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| notes Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| notes Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| notes Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREV_SHIFT_IND |
| Base Object | BEAM_DOWNTIME_ACCT |
| Attribute Name | Previous Shift Indicator |
| ColumnName | PREV_SHIFT_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Previous Shift Indicator: Indicates the downtime is a continuation from the previous shift. |
| Note |
| PREV_SHIFT_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PREV_SHIFT_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| PREV_SHIFT_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| PREV_SHIFT_IND Security Types |
| Name | Current Value |
| PREV_SHIFT_IND Bound Attachments |
| Name | Current Value |
| PREV_SHIFT_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| PREV_SHIFT_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Downtime Accounting Previous Shift Indicator |
NO | ||
| OPER (Oracle) BEAM_DOWNTIME_ACCT PREV_SHIFT_IND |
NO |
| PREV_SHIFT_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREV_SHIFT_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREV_SHIFT_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREV_SHIFT_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WO_NBR |
| Base Object | BEAM_DOWNTIME_ACCT |
| Attribute Name | Work Order Number |
| ColumnName | WO_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Work Order Number: Assign a DataStream work order initiated to repair the cause of the downtime to the entry. |
| Note |
| WO_NBR Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| WO_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| WO_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| WO_NBR Security Types |
| Name | Current Value |
| WO_NBR Bound Attachments |
| Name | Current Value |
| WO_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| WO_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Beam Downtime Accounting Work Order Number |
NO | ||
| OPER (Oracle) BEAM_DOWNTIME_ACCT WO_NBR |
NO |
| WO_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WO_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WO_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WO_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |