| Operation Group Identifier |
| Base Entity | Personnel Role Equipment Category 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 Equipment Category Assignment Operation Group Identifier |
NO | ||
| OPER (Oracle) PERS_ROLE_EQUIP_CAT_ASGN EQUIP_CAT_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 |
| BN |
| Base Entity | Personnel Role Equipment Category Assignment |
| Attribute Name | BN |
| Logical Rolename | |
| ColumnName | BN |
| RoleName | |
| Domain | Badge Number |
| Logical Only | NO |
| Definition | |
| Note |
| BN Logical Attribute Properties |
| Logical Attribute Name | BN |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BN Security Types |
| Name | Current Value |
| BN Bound Attachments |
| Name | Current Value |
| BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Personnel Role Equipment Category Assignment BN |
NO | ||
| OPER (Oracle) PERS_ROLE_EQUIP_CAT_ASGN BN |
NO |
| BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note |
| Base Entity | Personnel Role Equipment Category 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 Equipment Category Assignment Note |
NO | ||
| OPER (Oracle) PERS_ROLE_EQUIP_CAT_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 Equipment Category 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 Equipment Category Assignment Add Dte |
NO | ||
| OPER (Oracle) PERS_ROLE_EQUIP_CAT_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 |