| Building |
| Base Entity | Neutron Scattering Science Directorate Room |
| Attribute Name | Building |
| Logical Rolename | |
| ColumnName | BUILDING |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Building Logical Attribute Properties |
| Logical Attribute Name | Building |
| Datatype | CHAR(8) |
| Nullable | NO |
| Building Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Building Security Types |
| Name | Current Value |
| Building Bound Attachments |
| Name | Current Value |
| Building Data Movement Rules |
| Name | Type | Rule Text/Value |
| Building Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Neutron Scattering Science Directorate Room Building |
NO | ||
| INVT (Oracle) NSSD_ROOM BUILDING |
NO | ||
| OPER (Oracle) NSSD_ROOM BUILDING |
NO |
| Building Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Building Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Building Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Building Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Room |
| Base Entity | Neutron Scattering Science Directorate Room |
| Attribute Name | Room |
| Logical Rolename | |
| ColumnName | ROOM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Room Logical Attribute Properties |
| Logical Attribute Name | Room |
| Datatype | CHAR(8) |
| Nullable | NO |
| Room Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Room Security Types |
| Name | Current Value |
| Room Bound Attachments |
| Name | Current Value |
| Room Data Movement Rules |
| Name | Type | Rule Text/Value |
| Room Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Neutron Scattering Science Directorate Room Room |
NO | ||
| INVT (Oracle) NSSD_ROOM ROOM |
NO | ||
| OPER (Oracle) NSSD_ROOM ROOM |
NO |
| Room Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Room Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Room Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Room Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Floor |
| Base Entity | Neutron Scattering Science Directorate Room |
| Attribute Name | Floor |
| Logical Rolename | |
| ColumnName | FLOOR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Floor Logical Attribute Properties |
| Logical Attribute Name | Floor |
| Datatype | CHAR(1) |
| Nullable | YES |
| Floor Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Floor Security Types |
| Name | Current Value |
| Floor Bound Attachments |
| Name | Current Value |
| Floor Data Movement Rules |
| Name | Type | Rule Text/Value |
| Floor Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Neutron Scattering Science Directorate Room Floor |
NO | ||
| INVT (Oracle) NSSD_ROOM FLOOR |
NO | ||
| OPER (Oracle) NSSD_ROOM FLOOR |
NO |
| Floor Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Floor Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Floor Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Floor Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Square Footage |
| Base Entity | Neutron Scattering Science Directorate Room |
| Attribute Name | Square Footage |
| Logical Rolename | |
| ColumnName | SQFT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Square Footage Logical Attribute Properties |
| Logical Attribute Name | Square Footage |
| Datatype | NUMERIC(10, 0) |
| Nullable | YES |
| Square Footage Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Square Footage Security Types |
| Name | Current Value |
| Square Footage Bound Attachments |
| Name | Current Value |
| Square Footage Data Movement Rules |
| Name | Type | Rule Text/Value |
| Square Footage Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Neutron Scattering Science Directorate Room Square Footage |
NO | ||
| INVT (Oracle) NSSD_ROOM SQFT |
NO | ||
| OPER (Oracle) NSSD_ROOM SQFT |
NO |
| Square Footage Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Square Footage Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Square Footage Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Square Footage Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Responsible Division |
| Base Entity | Neutron Scattering Science Directorate Room |
| Attribute Name | Responsible Division |
| Logical Rolename | |
| ColumnName | RESP_DIV |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Responsible Division Logical Attribute Properties |
| Logical Attribute Name | Responsible Division |
| Datatype | CHAR(4) |
| Nullable | YES |
| Responsible Division Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Responsible Division Security Types |
| Name | Current Value |
| Responsible Division Bound Attachments |
| Name | Current Value |
| Responsible Division Data Movement Rules |
| Name | Type | Rule Text/Value |
| Responsible Division Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Neutron Scattering Science Directorate Room Responsible Division |
NO | ||
| INVT (Oracle) NSSD_ROOM RESP_DIV |
NO | ||
| OPER (Oracle) NSSD_ROOM RESP_DIV |
NO |
| Responsible Division Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Responsible Division Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Responsible Division Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Responsible Division Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Responsible Organization |
| Base Entity | Neutron Scattering Science Directorate Room |
| Attribute Name | Responsible Organization |
| Logical Rolename | |
| ColumnName | RESP_ORG |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Responsible Organization Logical Attribute Properties |
| Logical Attribute Name | Responsible Organization |
| Datatype | CHAR(8) |
| Nullable | YES |
| Responsible Organization Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Responsible Organization Security Types |
| Name | Current Value |
| Responsible Organization Bound Attachments |
| Name | Current Value |
| Responsible Organization Data Movement Rules |
| Name | Type | Rule Text/Value |
| Responsible Organization Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Neutron Scattering Science Directorate Room Responsible Organization |
NO | ||
| INVT (Oracle) NSSD_ROOM RESP_ORG |
NO | ||
| OPER (Oracle) NSSD_ROOM RESP_ORG |
NO |
| Responsible Organization Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Responsible Organization Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Responsible Organization Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Responsible Organization Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Condition Code |
| Base Entity | Neutron Scattering Science Directorate Room |
| Attribute Name | Condition Code |
| Logical Rolename | |
| ColumnName | CONDITION_CODE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Condition Code Logical Attribute Properties |
| Logical Attribute Name | Condition Code |
| Datatype | CHAR(1) |
| Nullable | YES |
| Condition Code Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Condition Code Security Types |
| Name | Current Value |
| Condition Code Bound Attachments |
| Name | Current Value |
| Condition Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Condition Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Neutron Scattering Science Directorate Room Condition Code |
NO | ||
| INVT (Oracle) NSSD_ROOM CONDITION_CODE |
NO | ||
| OPER (Oracle) NSSD_ROOM CONDITION_CODE |
NO |
| Condition Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Condition Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Condition Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Condition Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Use Code |
| Base Entity | Neutron Scattering Science Directorate Room |
| Attribute Name | Use Code |
| Logical Rolename | |
| ColumnName | USE_CODE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Use Code Logical Attribute Properties |
| Logical Attribute Name | Use Code |
| Datatype | CHAR(2) |
| Nullable | YES |
| Use Code Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Use Code Security Types |
| Name | Current Value |
| Use Code Bound Attachments |
| Name | Current Value |
| Use Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Use Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Neutron Scattering Science Directorate Room Use Code |
NO | ||
| INVT (Oracle) NSSD_ROOM USE_CODE |
NO | ||
| OPER (Oracle) NSSD_ROOM USE_CODE |
NO |
| Use Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Use Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Use Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Use Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Useable Code |
| Base Entity | Neutron Scattering Science Directorate Room |
| Attribute Name | Useable Code |
| Logical Rolename | |
| ColumnName | USEABLE_CODE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Useable Code Logical Attribute Properties |
| Logical Attribute Name | Useable Code |
| Datatype | CHAR(1) |
| Nullable | YES |
| Useable Code Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Useable Code Security Types |
| Name | Current Value |
| Useable Code Bound Attachments |
| Name | Current Value |
| Useable Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Useable Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Neutron Scattering Science Directorate Room Useable Code |
NO | ||
| INVT (Oracle) NSSD_ROOM USEABLE_CODE |
NO | ||
| OPER (Oracle) NSSD_ROOM USEABLE_CODE |
NO |
| Useable Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Useable Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Useable Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Useable Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |