| Facility Identifier |
| Base Entity | Experiment Facility |
| Attribute Name | Facility Identifier |
| Logical Rolename | |
| ColumnName | FACIL_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Facility Identifer: A unique abbreviated identifier for the facilty in which the proposed experiment is to take place. |
| Note |
| Facility Identifier Logical Attribute Properties |
| Logical Attribute Name | Facility Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Facility Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Facility Identifier Security Types |
| Name | Current Value |
| Facility Identifier Bound Attachments |
| Name | Current Value |
| Facility Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Facility Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Facility Facility Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_FACIL FACIL_ID |
NO | ||
| IPTSv5 (Oracle) EXPT_FACIL FACIL_ID |
NO | ||
| PRPSL (Oracle) EXPT_FACIL FACIL_ID |
NO | ||
| PUBL (Oracle) EXPT_FACIL FACIL_ID |
NO | ||
| XF_ADMIN (Oracle) EXPT_FACIL FACIL_ID |
NO |
| Facility Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Name |
| Base Entity | Experiment Facility |
| Attribute Name | Facility Name |
| Logical Rolename | |
| ColumnName | FACIL_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Facility Name Logical Attribute Properties |
| Logical Attribute Name | Facility Name |
| Datatype | VARCHAR(120) |
| Nullable | NO |
| Facility Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Facility Name Security Types |
| Name | Current Value |
| Facility Name Bound Attachments |
| Name | Current Value |
| Facility Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Facility Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Facility Facility Name |
NO | ||
| EXPRESS (Oracle) EXPT_FACIL FACIL_NM |
NO | ||
| IPTSv5 (Oracle) EXPT_FACIL FACIL_NM |
NO | ||
| PRPSL (Oracle) EXPT_FACIL FACIL_NM |
NO | ||
| PUBL (Oracle) EXPT_FACIL FACIL_NM |
NO | ||
| XF_ADMIN (Oracle) EXPT_FACIL FACIL_NM |
NO |
| Facility Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Addr |
| Base Entity | Experiment Facility |
| Attribute Name | Email Addr |
| Logical Rolename | |
| ColumnName | EMAIL_ADDR |
| RoleName | |
| Domain | Email Addr |
| Logical Only | NO |
| Definition | Email Address: |
| Note |
| Email Addr Logical Attribute Properties |
| Logical Attribute Name | Email Addr |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Email Addr Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Email Addr Security Types |
| Name | Current Value |
| Email Addr Bound Attachments |
| Name | Current Value |
| Email Addr Data Movement Rules |
| Name | Type | Rule Text/Value |
| Email Addr Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Facility Email Addr |
NO | ||
| EXPRESS (Oracle) EXPT_FACIL EMAIL_ADDR |
NO | ||
| IPTSv5 (Oracle) EXPT_FACIL EMAIL_ADDR |
NO | ||
| PRPSL (Oracle) EXPT_FACIL EMAIL_ADDR |
NO | ||
| PUBL (Oracle) EXPT_FACIL EMAIL_ADDR |
NO | ||
| XF_ADMIN (Oracle) EXPT_FACIL EMAIL_ADDR |
NO |
| Email Addr Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Addr Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Addr Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Addr Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Experiment Management System Facility Identifier |
| Base Entity | Experiment Facility |
| Attribute Name | Experiment Management System Facility Identifier |
| Logical Rolename | |
| ColumnName | EMS_FACIL_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Experiment Management System Facility Identifier Logical Attribute Properties |
| Logical Attribute Name | Experiment Management System Facility Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Experiment Management System Facility Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Experiment Management System Facility Identifier Security Types |
| Name | Current Value |
| Experiment Management System Facility Identifier Bound Attachments |
| Name | Current Value |
| Experiment Management System Facility Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Experiment Management System Facility Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Facility Experiment Management System Facility Identifier |
NO | ||
| EXPRESS (Oracle) EXPT_FACIL EMS_FACIL_ID |
NO | ||
| IPTSv5 (Oracle) EXPT_FACIL EMS_FACIL_ID |
NO | ||
| PRPSL (Oracle) EXPT_FACIL EMS_FACIL_ID |
NO | ||
| PUBL (Oracle) EXPT_FACIL EMS_FACIL_ID |
NO | ||
| XF_ADMIN (Oracle) EXPT_FACIL EMS_FACIL_ID |
NO |
| Experiment Management System Facility Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Experiment Management System Facility Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Experiment Management System Facility Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Experiment Management System Facility Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator |
| Base Entity | Experiment Facility |
| Attribute Name | Display Indicator |
| Logical Rolename | |
| ColumnName | DISP_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Display Indicator Logical Attribute Properties |
| Logical Attribute Name | Display Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Display Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Display Indicator 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 |
| Display Indicator Security Types |
| Name | Current Value |
| Display Indicator Bound Attachments |
| Name | Current Value |
| Display Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Display Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Facility Display Indicator |
NO | ||
| EXPRESS (Oracle) EXPT_FACIL DISP_IND |
NO | ||
| IPTSv5 (Oracle) EXPT_FACIL DISP_IND |
NO | ||
| PRPSL (Oracle) EXPT_FACIL DISP_IND |
NO | ||
| PUBL (Oracle) EXPT_FACIL DISP_IND |
NO | ||
| XF_ADMIN (Oracle) EXPT_FACIL DISP_IND |
NO |
| Display Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |