| Equip Id |
| Base Entity | Magnet Checklist |
| Attribute Name | Equip Id |
| Logical Rolename | |
| ColumnName | Equip Id |
| RoleName | |
| Domain | Asset Identifier |
| Logical Only | NO |
| Definition | Equipment Identifier: The SNS barcode number used to uniquely identify equipment. |
| Note |
| Equip Id Logical Attribute Properties |
| Logical Attribute Name | Equip Id |
| Datatype | VARCHAR(30) |
| Nullable | NO |
| Equip Id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Equip Id Security Types |
| Name | Current Value |
| Equip Id Bound Attachments |
| Name | Current Value |
| Equip Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Equip Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Equip Id |
NO |
| Equip Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_0M |
| Base Entity | Magnet Checklist |
| Attribute Name | TF1_0M |
| Logical Rolename | |
| ColumnName | TF1_0M |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Transfer Function 1.0 Measured Indicator: The transfer function at 1.0 GeV measured indicator. |
| Note |
| TF1_0M Logical Attribute Properties |
| Logical Attribute Name | TF1_0M |
| Datatype | CHAR(1) |
| Nullable | NO |
| TF1_0M Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| TF1_0M Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| TF1_0M Security Types |
| Name | Current Value |
| TF1_0M Bound Attachments |
| Name | Current Value |
| TF1_0M Data Movement Rules |
| Name | Type | Rule Text/Value |
| TF1_0M Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist TF1_0M |
NO |
| TF1_0M Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_0M Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_0M Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_0M Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_0M Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | TF1_0M Cmnt |
| Logical Rolename | |
| ColumnName | TF1_0M Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Transfer Function 1.0 Measured Comment: The transfer function at 1.0 GeV measured comment. |
| Note |
| TF1_0M Cmnt Logical Attribute Properties |
| Logical Attribute Name | TF1_0M Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| TF1_0M Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TF1_0M Cmnt Security Types |
| Name | Current Value |
| TF1_0M Cmnt Bound Attachments |
| Name | Current Value |
| TF1_0M Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| TF1_0M Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist TF1_0M Cmnt |
NO |
| TF1_0M Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_0M Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_0M Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_0M Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_3M |
| Base Entity | Magnet Checklist |
| Attribute Name | TF1_3M |
| Logical Rolename | |
| ColumnName | TF1_3M |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Transfer Function 1.3 Measured Indicator: The transfer function at 1.3 GeV measured indicator. |
| Note |
| TF1_3M Logical Attribute Properties |
| Logical Attribute Name | TF1_3M |
| Datatype | CHAR(1) |
| Nullable | NO |
| TF1_3M Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| TF1_3M Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| TF1_3M Security Types |
| Name | Current Value |
| TF1_3M Bound Attachments |
| Name | Current Value |
| TF1_3M Data Movement Rules |
| Name | Type | Rule Text/Value |
| TF1_3M Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist TF1_3M |
NO |
| TF1_3M Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_3M Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_3M Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_3M Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_3M Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | TF1_3M Cmnt |
| Logical Rolename | |
| ColumnName | TF1_3M Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Transfer Function 1.3 Measured Commnent: The transfer function at 1.3 GeV measured comment. |
| Note |
| TF1_3M Cmnt Logical Attribute Properties |
| Logical Attribute Name | TF1_3M Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| TF1_3M Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TF1_3M Cmnt Security Types |
| Name | Current Value |
| TF1_3M Cmnt Bound Attachments |
| Name | Current Value |
| TF1_3M Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| TF1_3M Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist TF1_3M Cmnt |
NO |
| TF1_3M Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_3M Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_3M Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF1_3M Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | TF Ind |
| Logical Rolename | |
| ColumnName | TF Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Transfer Function Indicator: Indicates whether the integral transfer function is satisfactory. |
| Note |
| TF Ind Logical Attribute Properties |
| Logical Attribute Name | TF Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| TF Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| TF Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| TF Ind Security Types |
| Name | Current Value |
| TF Ind Bound Attachments |
| Name | Current Value |
| TF Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| TF Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist TF Ind |
NO |
| TF Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | TF Cmnt |
| Logical Rolename | |
| ColumnName | TF Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Transfer Function Comment: A free form text field relating to the Transfer Function Indicator. |
| Note |
| TF Cmnt Logical Attribute Properties |
| Logical Attribute Name | TF Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| TF Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TF Cmnt Security Types |
| Name | Current Value |
| TF Cmnt Bound Attachments |
| Name | Current Value |
| TF Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| TF Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist TF Cmnt |
NO |
| TF Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TF Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mul Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Mul Ind |
| Logical Rolename | |
| ColumnName | Mul Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Magnetic Harmonic Indicator |
| Note |
| Mul Ind Logical Attribute Properties |
| Logical Attribute Name | Mul Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Mul Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Mul Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Mul Ind Security Types |
| Name | Current Value |
| Mul Ind Bound Attachments |
| Name | Current Value |
| Mul Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mul Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Mul Ind |
NO |
| Mul Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mul Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mul Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mul Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mul Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Mul Cmnt |
| Logical Rolename | |
| ColumnName | Mul Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Magnetic Harmonic Comment |
| Note |
| Mul Cmnt Logical Attribute Properties |
| Logical Attribute Name | Mul Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Mul Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Mul Cmnt Security Types |
| Name | Current Value |
| Mul Cmnt Bound Attachments |
| Name | Current Value |
| Mul Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mul Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Mul Cmnt |
NO |
| Mul Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mul Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mul Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mul Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Data Ind |
| Logical Rolename | |
| ColumnName | Data Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Data Indicator: Indicates if the data was properly transferred to the database tables. |
| Note |
| Data Ind Logical Attribute Properties |
| Logical Attribute Name | Data Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Data Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Data Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Data Ind Security Types |
| Name | Current Value |
| Data Ind Bound Attachments |
| Name | Current Value |
| Data Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Data Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Data Ind |
NO |
| Data Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Data Cmnt |
| Logical Rolename | |
| ColumnName | Data Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Data Comment: A free form text field relating to the data ind field. |
| Note |
| Data Cmnt Logical Attribute Properties |
| Logical Attribute Name | Data Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Data Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Data Cmnt Security Types |
| Name | Current Value |
| Data Cmnt Bound Attachments |
| Name | Current Value |
| Data Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Data Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Data Cmnt |
NO |
| Data Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mech Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Mech Ind |
| Logical Rolename | |
| ColumnName | Mech Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Mechanical Indicator: Used to indicate if the mechanical test is complete. |
| Note |
| Mech Ind Logical Attribute Properties |
| Logical Attribute Name | Mech Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Mech Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Mech Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Mech Ind Security Types |
| Name | Current Value |
| Mech Ind Bound Attachments |
| Name | Current Value |
| Mech Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mech Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Mech Ind |
NO |
| Mech Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mech Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mech Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mech Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mech Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Mech Cmnt |
| Logical Rolename | |
| ColumnName | Mech Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Mechanical Comment: A free form text field relating to the mechanical indicator. |
| Note |
| Mech Cmnt Logical Attribute Properties |
| Logical Attribute Name | Mech Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Mech Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Mech Cmnt Security Types |
| Name | Current Value |
| Mech Cmnt Bound Attachments |
| Name | Current Value |
| Mech Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mech Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Mech Cmnt |
NO |
| Mech Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mech Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mech Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mech Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Elec Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Elec Ind |
| Logical Rolename | |
| ColumnName | Elec Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Electrical Indicator: Used to indicate if the electrical test is complete. |
| Note |
| Elec Ind Logical Attribute Properties |
| Logical Attribute Name | Elec Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Elec Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Elec Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Elec Ind Security Types |
| Name | Current Value |
| Elec Ind Bound Attachments |
| Name | Current Value |
| Elec Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Elec Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Elec Ind |
NO |
| Elec Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Elec Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Elec Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Elec Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Elec Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Elec Cmnt |
| Logical Rolename | |
| ColumnName | Elec Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Electrical Comment: A free form text field relating to the Electrical Indicator. |
| Note |
| Elec Cmnt Logical Attribute Properties |
| Logical Attribute Name | Elec Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Elec Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Elec Cmnt Security Types |
| Name | Current Value |
| Elec Cmnt Bound Attachments |
| Name | Current Value |
| Elec Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Elec Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Elec Cmnt |
NO |
| Elec Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Elec Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Elec Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Elec Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shim Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Shim Ind |
| Logical Rolename | |
| ColumnName | Shim Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Shim Indicator: Used to indicated if the magnet is shimmed. |
| Note |
| Shim Ind Logical Attribute Properties |
| Logical Attribute Name | Shim Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Shim Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Shim Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Shim Ind Security Types |
| Name | Current Value |
| Shim Ind Bound Attachments |
| Name | Current Value |
| Shim Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Shim Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Shim Ind |
NO |
| Shim Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shim Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shim Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shim Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shim Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Shim Cmnt |
| Logical Rolename | |
| ColumnName | Shim Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Shimmed Comment: A free form text field relating to the Shimmed Indicator. |
| Note |
| Shim Cmnt Logical Attribute Properties |
| Logical Attribute Name | Shim Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Shim Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Shim Cmnt Security Types |
| Name | Current Value |
| Shim Cmnt Bound Attachments |
| Name | Current Value |
| Shim Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Shim Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Shim Cmnt |
NO |
| Shim Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shim Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shim Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shim Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sort Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Sort Ind |
| Logical Rolename | |
| ColumnName | Sort Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Sort Indicator: Used to indicate if the magnetic check is sorted. |
| Note |
| Sort Ind Logical Attribute Properties |
| Logical Attribute Name | Sort Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Sort Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Sort Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Sort Ind Security Types |
| Name | Current Value |
| Sort Ind Bound Attachments |
| Name | Current Value |
| Sort Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sort Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Sort Ind |
NO |
| Sort Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sort Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sort Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sort Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sort Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Sort Cmnt |
| Logical Rolename | |
| ColumnName | Sort Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Sort Comment: A free form text field relating to the Sort Indicator. |
| Note |
| Sort Cmnt Logical Attribute Properties |
| Logical Attribute Name | Sort Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Sort Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Sort Cmnt Security Types |
| Name | Current Value |
| Sort Cmnt Bound Attachments |
| Name | Current Value |
| Sort Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sort Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Sort Cmnt |
NO |
| Sort Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sort Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sort Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sort Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Surv Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Surv Ind |
| Logical Rolename | |
| ColumnName | Surv Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Survey Indicator: Indicates if the survey is complete. |
| Note |
| Surv Ind Logical Attribute Properties |
| Logical Attribute Name | Surv Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Surv Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Surv Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Surv Ind Security Types |
| Name | Current Value |
| Surv Ind Bound Attachments |
| Name | Current Value |
| Surv Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Surv Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Surv Ind |
NO |
| Surv Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Surv Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Surv Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Surv Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Surv Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Surv Cmnt |
| Logical Rolename | |
| ColumnName | Surv Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Survey Comment: A free from text field relating to the Sort Indicator. |
| Note |
| Surv Cmnt Logical Attribute Properties |
| Logical Attribute Name | Surv Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Surv Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Surv Cmnt Security Types |
| Name | Current Value |
| Surv Cmnt Bound Attachments |
| Name | Current Value |
| Surv Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Surv Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Surv Cmnt |
NO |
| Surv Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Surv Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Surv Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Surv Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Doc Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Doc Ind |
| Logical Rolename | |
| ColumnName | Doc Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Documentation Indicator: Use to indicated if the documentation is complete. |
| Note |
| Doc Ind Logical Attribute Properties |
| Logical Attribute Name | Doc Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Doc Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Doc Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Doc Ind Security Types |
| Name | Current Value |
| Doc Ind Bound Attachments |
| Name | Current Value |
| Doc Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Doc Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Doc Ind |
NO |
| Doc Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Doc Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Doc Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Doc Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Doc Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Doc Cmnt |
| Logical Rolename | |
| ColumnName | Doc Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Documentation Comment: A free form text field relating to the documentatiion indicator. |
| Note |
| Doc Cmnt Logical Attribute Properties |
| Logical Attribute Name | Doc Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Doc Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Doc Cmnt Security Types |
| Name | Current Value |
| Doc Cmnt Bound Attachments |
| Name | Current Value |
| Doc Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Doc Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Doc Cmnt |
NO |
| Doc Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Doc Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Doc Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Doc Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HCA Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | HCA Ind |
| Logical Rolename | |
| ColumnName | HCA Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Half Cell Assigned Indicator: Used to indicated if the half-cell is assigned. |
| Note |
| HCA Ind Logical Attribute Properties |
| Logical Attribute Name | HCA Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| HCA Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| HCA Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| HCA Ind Security Types |
| Name | Current Value |
| HCA Ind Bound Attachments |
| Name | Current Value |
| HCA Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| HCA Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist HCA Ind |
NO |
| HCA Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HCA Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HCA Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HCA Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HCA Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | HCA Cmnt |
| Logical Rolename | |
| ColumnName | HCA Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Half-Cell Comment: A free form text field relating to the Half-Cell Indicator. |
| Note |
| HCA Cmnt Logical Attribute Properties |
| Logical Attribute Name | HCA Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| HCA Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HCA Cmnt Security Types |
| Name | Current Value |
| HCA Cmnt Bound Attachments |
| Name | Current Value |
| HCA Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| HCA Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist HCA Cmnt |
NO |
| HCA Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HCA Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HCA Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HCA Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sumry Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Sumry Ind |
| Logical Rolename | |
| ColumnName | Sumry Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Survey Indicator: Used to indicate if the survey is complete. |
| Note |
| Sumry Ind Logical Attribute Properties |
| Logical Attribute Name | Sumry Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Sumry Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Sumry Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Sumry Ind Security Types |
| Name | Current Value |
| Sumry Ind Bound Attachments |
| Name | Current Value |
| Sumry Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sumry Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Sumry Ind |
NO |
| Sumry Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sumry Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sumry Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sumry Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sumry Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Sumry Cmnt |
| Logical Rolename | |
| ColumnName | Sumry Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Survey Comment: A free form text field relating to the Survey Indicator. |
| Note |
| Sumry Cmnt Logical Attribute Properties |
| Logical Attribute Name | Sumry Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Sumry Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Sumry Cmnt Security Types |
| Name | Current Value |
| Sumry Cmnt Bound Attachments |
| Name | Current Value |
| Sumry Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sumry Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Sumry Cmnt |
NO |
| Sumry Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sumry Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sumry Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sumry Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Meas Data Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Meas Data Ind |
| Logical Rolename | |
| ColumnName | Meas Data Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Measurement Data Indicator. Used to indicate if the data was sent to SNS. |
| Note |
| Meas Data Ind Logical Attribute Properties |
| Logical Attribute Name | Meas Data Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Meas Data Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Meas Data Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Meas Data Ind Security Types |
| Name | Current Value |
| Meas Data Ind Bound Attachments |
| Name | Current Value |
| Meas Data Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Meas Data Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Meas Data Ind |
NO |
| Meas Data Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Meas Data Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Meas Data Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Meas Data Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Meas Data Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Meas Data Cmnt |
| Logical Rolename | |
| ColumnName | Meas Data Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Measurement Data Comment: A free from text field related to the Measurement Data Indicator. |
| Note |
| Meas Data Cmnt Logical Attribute Properties |
| Logical Attribute Name | Meas Data Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Meas Data Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Meas Data Cmnt Security Types |
| Name | Current Value |
| Meas Data Cmnt Bound Attachments |
| Name | Current Value |
| Meas Data Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Meas Data Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Meas Data Cmnt |
NO |
| Meas Data Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Meas Data Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Meas Data Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Meas Data Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl IO Ind |
| Base Entity | Magnet Checklist |
| Attribute Name | Mdl IO Ind |
| Logical Rolename | |
| ColumnName | Mdl IO Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Model Input/Output Indicator: Indicates if the magnet model input and output information was sent to SNS. |
| Note |
| Mdl IO Ind Logical Attribute Properties |
| Logical Attribute Name | Mdl IO Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Mdl IO Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Mdl IO Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Mdl IO Ind Security Types |
| Name | Current Value |
| Mdl IO Ind Bound Attachments |
| Name | Current Value |
| Mdl IO Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mdl IO Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Mdl IO Ind |
NO |
| Mdl IO Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl IO Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl IO Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl IO Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl IO Cmnt |
| Base Entity | Magnet Checklist |
| Attribute Name | Mdl IO Cmnt |
| Logical Rolename | |
| ColumnName | Mdl IO Cmnt |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Model Input/Output Comment: A free form text field relating to the Model Input/Output Indicator. |
| Note |
| Mdl IO Cmnt Logical Attribute Properties |
| Logical Attribute Name | Mdl IO Cmnt |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Mdl IO Cmnt Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Mdl IO Cmnt Security Types |
| Name | Current Value |
| Mdl IO Cmnt Bound Attachments |
| Name | Current Value |
| Mdl IO Cmnt Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mdl IO Cmnt Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Mdl IO Cmnt |
NO |
| Mdl IO Cmnt Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl IO Cmnt Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl IO Cmnt Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl IO Cmnt Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date |
| Base Entity | Magnet Checklist |
| Attribute Name | Modify Date |
| Logical Rolename | |
| ColumnName | MOD_DATE |
| RoleName | |
| Domain | Modify Date |
| Logical Only | NO |
| Definition | Modify Date: The date the current entry was made. |
| Note |
| Modify Date Logical Attribute Properties |
| Logical Attribute Name | Modify Date |
| Datatype | DATE |
| Nullable | NO |
| Modify Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modify Date Security Types |
| Name | Current Value |
| Modify Date Bound Attachments |
| Name | Current Value |
| Modify Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Modify Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Magnet Checklist Modify Date |
NO |
| Modify Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |