| Facility Identifier |
| Base Entity | Facility Notice |
| 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 Facility Notice Facility Identifier |
NO | ||
| XF_ADMIN (Oracle) FACIL_NOTC 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 |
| Notice Identifer |
| Base Entity | Facility Notice |
| Attribute Name | Notice Identifer |
| Logical Rolename | |
| ColumnName | NOTC_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Notice Identifer Logical Attribute Properties |
| Logical Attribute Name | Notice Identifer |
| Datatype | NUMERIC(10, 0) |
| Nullable | NO |
| Notice Identifer Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Notice Identifer Security Types |
| Name | Current Value |
| Notice Identifer Bound Attachments |
| Name | Current Value |
| Notice Identifer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Notice Identifer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Facility Notice Notice Identifer |
NO | ||
| XF_ADMIN (Oracle) FACIL_NOTC NOTC_ID |
NO |
| Notice Identifer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice Identifer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice Identifer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice Identifer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice |
| Base Entity | Facility Notice |
| Attribute Name | Notice |
| Logical Rolename | |
| ColumnName | NOTC |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Notice Logical Attribute Properties |
| Logical Attribute Name | Notice |
| Datatype | VARCHAR(4000) |
| Nullable | NO |
| Notice Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Notice Security Types |
| Name | Current Value |
| Notice Bound Attachments |
| Name | Current Value |
| Notice Data Movement Rules |
| Name | Type | Rule Text/Value |
| Notice Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Facility Notice Notice |
NO | ||
| XF_ADMIN (Oracle) FACIL_NOTC NOTC |
NO |
| Notice Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice Image |
| Base Entity | Facility Notice |
| Attribute Name | Notice Image |
| Logical Rolename | |
| ColumnName | NOTC_IMG |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Notice Image: Optionally allow an image to be displayed with the notice. |
| Note |
| Notice Image Logical Attribute Properties |
| Logical Attribute Name | Notice Image |
| Datatype | IMAGE/LONG BINARY |
| Nullable | YES |
| Notice Image Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Notice Image Security Types |
| Name | Current Value |
| Notice Image Bound Attachments |
| Name | Current Value |
| Notice Image Data Movement Rules |
| Name | Type | Rule Text/Value |
| Notice Image Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Facility Notice Notice Image |
NO | ||
| XF_ADMIN (Oracle) FACIL_NOTC NOTC_IMG |
NO |
| Notice Image Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice Image Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice Image Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Notice Image Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Indicator |
| Base Entity | Facility Notice |
| Attribute Name | Active Indicator |
| Logical Rolename | |
| ColumnName | ACT_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Active Indicator Logical Attribute Properties |
| Logical Attribute Name | Active Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Active Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Active 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 |
| Active Indicator Security Types |
| Name | Current Value |
| Active Indicator Bound Attachments |
| Name | Current Value |
| Active Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Active Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Facility Notice Active Indicator |
NO | ||
| XF_ADMIN (Oracle) FACIL_NOTC ACT_IND |
NO |
| Active Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Active Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date |
| Base Entity | Facility Notice |
| Attribute Name | Modify Date |
| Logical Rolename | |
| ColumnName | MOD_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| 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 | sysdate |
| 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 Facility Notice Modify Date |
NO | ||
| XF_ADMIN (Oracle) FACIL_NOTC MOD_DTE |
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 |