| BUILDING |
| Base Object | NSSD_ROOM |
| Attribute Name | Building |
| ColumnName | BUILDING |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| BUILDING Column Properties |
| Datatype | CHAR(8) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BUILDING Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 8 |
| Percent Null | 0 |
| 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 Object | NSSD_ROOM |
| Attribute Name | Room |
| ColumnName | ROOM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ROOM Column Properties |
| Datatype | CHAR(8) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ROOM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 8 |
| Percent Null | 0 |
| 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 Object | NSSD_ROOM |
| Attribute Name | Floor |
| ColumnName | FLOOR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| FLOOR Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FLOOR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| 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 |
| SQFT |
| Base Object | NSSD_ROOM |
| Attribute Name | Square Footage |
| ColumnName | SQFT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SQFT Column Properties |
| Datatype | NUMBER(10, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SQFT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| SQFT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SQFT Security Types |
| Name | Current Value |
| SQFT Bound Attachments |
| Name | Current Value |
| SQFT Data Movement Rules |
| Name | Type | Rule Text/Value |
| SQFT 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 |
| SQFT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SQFT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SQFT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SQFT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESP_DIV |
| Base Object | NSSD_ROOM |
| Attribute Name | Responsible Division |
| ColumnName | RESP_DIV |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| RESP_DIV Column Properties |
| Datatype | CHAR(4) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RESP_DIV Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| RESP_DIV Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RESP_DIV Security Types |
| Name | Current Value |
| RESP_DIV Bound Attachments |
| Name | Current Value |
| RESP_DIV Data Movement Rules |
| Name | Type | Rule Text/Value |
| RESP_DIV 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 |
| RESP_DIV Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESP_DIV Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESP_DIV Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESP_DIV Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESP_ORG |
| Base Object | NSSD_ROOM |
| Attribute Name | Responsible Organization |
| ColumnName | RESP_ORG |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| RESP_ORG Column Properties |
| Datatype | CHAR(8) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RESP_ORG Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 8 |
| Percent Null | 0 |
| RESP_ORG Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RESP_ORG Security Types |
| Name | Current Value |
| RESP_ORG Bound Attachments |
| Name | Current Value |
| RESP_ORG Data Movement Rules |
| Name | Type | Rule Text/Value |
| RESP_ORG 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 |
| RESP_ORG Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESP_ORG Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESP_ORG Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RESP_ORG Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONDITION_CODE |
| Base Object | NSSD_ROOM |
| Attribute Name | Condition Code |
| ColumnName | CONDITION_CODE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| CONDITION_CODE Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CONDITION_CODE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| 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 Object | NSSD_ROOM |
| Attribute Name | Use Code |
| ColumnName | USE_CODE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| USE_CODE Column Properties |
| Datatype | CHAR(2) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| USE_CODE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2 |
| Percent Null | 0 |
| 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 Object | NSSD_ROOM |
| Attribute Name | Useable Code |
| ColumnName | USEABLE_CODE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| USEABLE_CODE Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| USEABLE_CODE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| 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 |