| Badge Number |
| Base Entity | Personnel Role Operation SubGroup Assignment |
| Attribute Name | Badge Number |
| Logical Rolename | |
| ColumnName | BN |
| RoleName | |
| Domain | Badge Number |
| Logical Only | NO |
| Definition | |
| Note |
| Badge Number Logical Attribute Properties |
| Logical Attribute Name | Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Badge Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Badge Number Security Types |
| Name | Current Value |
| Badge Number Bound Attachments |
| Name | Current Value |
| Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Badge Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Operation SubGroup Assignment Badge Number |
NO | ||
| NS_OPER (Oracle) PERS_ROLE_OPER_SUBGRP_ASGN BN |
NO |
| Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier |
| Base Entity | Personnel Role Operation SubGroup Assignment |
| Attribute Name | Operation Group Identifier |
| Logical Rolename | |
| ColumnName | OPER_GRP_ID |
| RoleName | |
| Domain | Operation Group |
| Logical Only | NO |
| Definition | Equipment Category Identifier: The unique identifier for a specific equipment category. |
| Note |
| Operation Group Identifier Logical Attribute Properties |
| Logical Attribute Name | Operation Group Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Operation Group Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Operation Group Identifier Security Types |
| Name | Current Value |
| Operation Group Identifier Bound Attachments |
| Name | Current Value |
| Operation Group Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Operation Group Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Operation SubGroup Assignment Operation Group Identifier |
NO | ||
| NS_OPER (Oracle) PERS_ROLE_OPER_SUBGRP_ASGN OPER_GRP_ID |
NO |
| Operation Group Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Subgroup1 Identifier |
| Base Entity | Personnel Role Operation SubGroup Assignment |
| Attribute Name | Operation Subgroup1 Identifier |
| Logical Rolename | |
| ColumnName | OPER_SUBGRP1_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Equipment Subcategory Identifier: The unique identifer for an equipment subcategory. |
| Note |
| Operation Subgroup1 Identifier Logical Attribute Properties |
| Logical Attribute Name | Operation Subgroup1 Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Operation Subgroup1 Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Operation Subgroup1 Identifier Security Types |
| Name | Current Value |
| Operation Subgroup1 Identifier Bound Attachments |
| Name | Current Value |
| Operation Subgroup1 Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Operation Subgroup1 Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Operation SubGroup Assignment Operation Subgroup1 Identifier |
NO | ||
| NS_OPER (Oracle) PERS_ROLE_OPER_SUBGRP_ASGN OPER_SUBGRP1_ID |
NO |
| Operation Subgroup1 Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Subgroup1 Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Subgroup1 Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Subgroup1 Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note |
| Base Entity | Personnel Role Operation SubGroup Assignment |
| Attribute Name | Note |
| Logical Rolename | |
| ColumnName | NOTE |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Note Logical Attribute Properties |
| Logical Attribute Name | Note |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Note Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Note Security Types |
| Name | Current Value |
| Note Bound Attachments |
| Name | Current Value |
| Note Data Movement Rules |
| Name | Type | Rule Text/Value |
| Note Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Operation SubGroup Assignment Note |
NO | ||
| NS_OPER (Oracle) PERS_ROLE_OPER_SUBGRP_ASGN NOTE |
NO |
| Note Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Add Dte |
| Base Entity | Personnel Role Operation SubGroup Assignment |
| Attribute Name | Add Dte |
| Logical Rolename | |
| ColumnName | Add Dte |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Add Dte Logical Attribute Properties |
| Logical Attribute Name | Add Dte |
| Datatype | DATE |
| Nullable | NO |
| Add Dte Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Add Dte Security Types |
| Name | Current Value |
| Add Dte Bound Attachments |
| Name | Current Value |
| Add Dte Data Movement Rules |
| Name | Type | Rule Text/Value |
| Add Dte Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Operation SubGroup Assignment Add Dte |
NO | ||
| NS_OPER (Oracle) PERS_ROLE_OPER_SUBGRP_ASGN ADD_DTE |
NO |
| Add Dte Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Add Dte Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Add Dte Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Add Dte Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |