| Science Highlight Identifier |
| Base Entity | Science Highlight |
| Attribute Name | Science Highlight Identifier |
| Logical Rolename | |
| ColumnName | SCI_HIGH_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Science Highlight Identifier Logical Attribute Properties |
| Logical Attribute Name | Science Highlight Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Science Highlight Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Science Highlight Identifier Security Types |
| Name | Current Value |
| Science Highlight Identifier Bound Attachments |
| Name | Current Value |
| Science Highlight Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Science Highlight Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Science Highlight Identifier |
NO | ||
| PRINT (Oracle) SCI_HIGH SCI_HIGH_ID |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH SCI_HIGH_ID |
NO |
| Science Highlight Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Science Highlight Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Science Highlight Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Science Highlight Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date |
| Base Entity | Science Highlight |
| Attribute Name | Start Date |
| Logical Rolename | |
| ColumnName | START_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Start Date Logical Attribute Properties |
| Logical Attribute Name | Start Date |
| Datatype | DATE |
| Nullable | NO |
| Start Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Start Date Security Types |
| Name | Current Value |
| Start Date Bound Attachments |
| Name | Current Value |
| Start Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Start Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Start Date |
NO | ||
| PRINT (Oracle) SCI_HIGH START_DTE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH START_DTE |
NO |
| Start Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Start Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Completion Date |
| Base Entity | Science Highlight |
| Attribute Name | Completion Date |
| Logical Rolename | |
| ColumnName | COMPL_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Completion Date Logical Attribute Properties |
| Logical Attribute Name | Completion Date |
| Datatype | DATE |
| Nullable | YES |
| Completion Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Completion Date Security Types |
| Name | Current Value |
| Completion Date Bound Attachments |
| Name | Current Value |
| Completion Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Completion Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Completion Date |
NO | ||
| PRINT (Oracle) SCI_HIGH COMPL_DTE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH COMPL_DTE |
NO |
| Completion Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Completion Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Completion Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Completion Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note |
| Base Entity | Science Highlight |
| Attribute Name | Note |
| Logical Rolename | |
| ColumnName | NOTE |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Note Logical Attribute Properties |
| Logical Attribute Name | Note |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Note Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Note Security Types |
| Name | Current Value |
| Note Bound Attachments |
| Name | Current Value |
| Note Data Movement Rules |
| Name | Type | Rule Text/Value |
| Note Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Note |
NO | ||
| PRINT (Oracle) SCI_HIGH NOTE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH NOTE |
NO |
| Note Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Science Highlight Category Identifier |
| Base Entity | Science Highlight |
| Attribute Name | Science Highlight Category Identifier |
| Logical Rolename | |
| ColumnName | SCI_HIGH_CAT_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Science Highlight Category Identifier Logical Attribute Properties |
| Logical Attribute Name | Science Highlight Category Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | YES |
| Science Highlight Category Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Science Highlight Category Identifier Security Types |
| Name | Current Value |
| Science Highlight Category Identifier Bound Attachments |
| Name | Current Value |
| Science Highlight Category Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Science Highlight Category Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Science Highlight Category Identifier |
NO | ||
| PRINT (Oracle) SCI_HIGH SCI_HIGH_CAT_ID |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH SCI_HIGH_CAT_ID |
NO |
| Science Highlight Category Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Science Highlight Category Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Science Highlight Category Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Science Highlight Category Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Highlight Title |
| Base Entity | Science Highlight |
| Attribute Name | Highlight Title |
| Logical Rolename | |
| ColumnName | HIGH_TITLE |
| RoleName | |
| Domain | Title |
| Logical Only | NO |
| Definition | |
| Note |
| Highlight Title Logical Attribute Properties |
| Logical Attribute Name | Highlight Title |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Highlight Title Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Highlight Title Security Types |
| Name | Current Value |
| Highlight Title Bound Attachments |
| Name | Current Value |
| Highlight Title Data Movement Rules |
| Name | Type | Rule Text/Value |
| Highlight Title Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Highlight Title |
NO | ||
| PRINT (Oracle) SCI_HIGH HIGH_TITLE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH HIGH_TITLE |
NO |
| Highlight Title Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Highlight Title Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Highlight Title Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Highlight Title Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Abstract |
| Base Entity | Science Highlight |
| Attribute Name | Abstract |
| Logical Rolename | |
| ColumnName | ABSTRACT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| Abstract Logical Attribute Properties |
| Logical Attribute Name | Abstract |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Abstract Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Abstract Security Types |
| Name | Current Value |
| Abstract Bound Attachments |
| Name | Current Value |
| Abstract Data Movement Rules |
| Name | Type | Rule Text/Value |
| Abstract Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Abstract |
NO | ||
| PRINT (Oracle) SCI_HIGH ABSTRACT |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH ABSTRACT |
NO |
| Abstract Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Abstract Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Abstract Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Abstract Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Paper Title |
| Base Entity | Science Highlight |
| Attribute Name | Paper Title |
| Logical Rolename | |
| ColumnName | PAPER_TITLE |
| RoleName | |
| Domain | Title |
| Logical Only | NO |
| Definition | |
| Note |
| Paper Title Logical Attribute Properties |
| Logical Attribute Name | Paper Title |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Paper Title Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Paper Title Security Types |
| Name | Current Value |
| Paper Title Bound Attachments |
| Name | Current Value |
| Paper Title Data Movement Rules |
| Name | Type | Rule Text/Value |
| Paper Title Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Paper Title |
NO | ||
| PRINT (Oracle) SCI_HIGH PAPER_TITLE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH PAPER_TITLE |
NO |
| Paper Title Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Paper Title Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Paper Title Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Paper Title Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Title |
| Base Entity | Science Highlight |
| Attribute Name | Publication Title |
| Logical Rolename | |
| ColumnName | PUB_TITLE |
| RoleName | |
| Domain | Title |
| Logical Only | NO |
| Definition | |
| Note |
| Publication Title Logical Attribute Properties |
| Logical Attribute Name | Publication Title |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Publication Title Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Publication Title Security Types |
| Name | Current Value |
| Publication Title Bound Attachments |
| Name | Current Value |
| Publication Title Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Title Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Publication Title |
NO | ||
| PRINT (Oracle) SCI_HIGH PUB_TITLE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH PUB_TITLE |
NO |
| Publication Title Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Title Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Title Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Title Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Keyword |
| Base Entity | Science Highlight |
| Attribute Name | Keyword |
| Logical Rolename | |
| ColumnName | KEYWORD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Keyword Logical Attribute Properties |
| Logical Attribute Name | Keyword |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Keyword Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Keyword Security Types |
| Name | Current Value |
| Keyword Bound Attachments |
| Name | Current Value |
| Keyword Data Movement Rules |
| Name | Type | Rule Text/Value |
| Keyword Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Keyword |
NO | ||
| PRINT (Oracle) SCI_HIGH KEYWORD |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH KEYWORD |
NO |
| Keyword Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Keyword Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Keyword Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Keyword Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Image File Name |
| Base Entity | Science Highlight |
| Attribute Name | Image File Name |
| Logical Rolename | |
| ColumnName | IMG_FILE_NM |
| RoleName | |
| Domain | File Name |
| Logical Only | NO |
| Definition | File Name: An external file system file name. Often the external file name of data imported into the Rdb, such as EPICS .db files. |
| Note |
| Image File Name Logical Attribute Properties |
| Logical Attribute Name | Image File Name |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Image File Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Image File Name Security Types |
| Name | Current Value |
| Image File Name Bound Attachments |
| Name | Current Value |
| Image File Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Image File Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Image File Name |
NO | ||
| PRINT (Oracle) SCI_HIGH IMG_FILE_NM |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH IMG_FILE_NM |
NO |
| Image File Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Image File Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Image File Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Image File Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Weekly Spotlight |
| Base Entity | Science Highlight |
| Attribute Name | Weekly Spotlight |
| Logical Rolename | |
| ColumnName | WK_SPOT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Weekly Spotlight Logical Attribute Properties |
| Logical Attribute Name | Weekly Spotlight |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Weekly Spotlight Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Weekly Spotlight Security Types |
| Name | Current Value |
| Weekly Spotlight Bound Attachments |
| Name | Current Value |
| Weekly Spotlight Data Movement Rules |
| Name | Type | Rule Text/Value |
| Weekly Spotlight Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Weekly Spotlight |
NO | ||
| PRINT (Oracle) SCI_HIGH WK_SPOT |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH WK_SPOT |
NO |
| Weekly Spotlight Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Weekly Spotlight Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Weekly Spotlight Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Weekly Spotlight Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Storytip |
| Base Entity | Science Highlight |
| Attribute Name | Storytip |
| Logical Rolename | |
| ColumnName | STORYTIP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Storytip Logical Attribute Properties |
| Logical Attribute Name | Storytip |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Storytip Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Storytip Security Types |
| Name | Current Value |
| Storytip Bound Attachments |
| Name | Current Value |
| Storytip Data Movement Rules |
| Name | Type | Rule Text/Value |
| Storytip Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Storytip |
NO | ||
| PRINT (Oracle) SCI_HIGH STORYTIP |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH STORYTIP |
NO |
| Storytip Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Storytip Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Storytip Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Storytip Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Image Caption |
| Base Entity | Science Highlight |
| Attribute Name | Image Caption |
| Logical Rolename | |
| ColumnName | IMG_CAP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Image Caption Logical Attribute Properties |
| Logical Attribute Name | Image Caption |
| Datatype | VARCHAR(50) |
| Nullable | YES |
| Image Caption Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Image Caption Security Types |
| Name | Current Value |
| Image Caption Bound Attachments |
| Name | Current Value |
| Image Caption Data Movement Rules |
| Name | Type | Rule Text/Value |
| Image Caption Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Image Caption |
NO | ||
| PRINT (Oracle) SCI_HIGH IMG_CAP |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH IMG_CAP |
NO |
| Image Caption Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Image Caption Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Image Caption Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Image Caption Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CER Release Date |
| Base Entity | Science Highlight |
| Attribute Name | CER Release Date |
| Logical Rolename | |
| ColumnName | CER_REL_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| CER Release Date Logical Attribute Properties |
| Logical Attribute Name | CER Release Date |
| Datatype | DATE |
| Nullable | YES |
| CER Release Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| CER Release Date Security Types |
| Name | Current Value |
| CER Release Date Bound Attachments |
| Name | Current Value |
| CER Release Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| CER Release Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight CER Release Date |
NO | ||
| PRINT (Oracle) SCI_HIGH CER_REL_DTE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH CER_REL_DTE |
NO |
| CER Release Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CER Release Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CER Release Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CER Release Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Brinkman Release Date |
| Base Entity | Science Highlight |
| Attribute Name | Brinkman Release Date |
| Logical Rolename | |
| ColumnName | BRINKMAN_REL_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Brinkman Release Date Logical Attribute Properties |
| Logical Attribute Name | Brinkman Release Date |
| Datatype | DATE |
| Nullable | YES |
| Brinkman Release Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Brinkman Release Date Security Types |
| Name | Current Value |
| Brinkman Release Date Bound Attachments |
| Name | Current Value |
| Brinkman Release Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Brinkman Release Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Brinkman Release Date |
NO | ||
| PRINT (Oracle) SCI_HIGH BRINKMAN_REL_DTE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH BRINKMAN_REL_DTE |
NO |
| Brinkman Release Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Brinkman Release Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Brinkman Release Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Brinkman Release Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOE Release Date |
| Base Entity | Science Highlight |
| Attribute Name | DOE Release Date |
| Logical Rolename | |
| ColumnName | DOE_REL_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| DOE Release Date Logical Attribute Properties |
| Logical Attribute Name | DOE Release Date |
| Datatype | DATE |
| Nullable | YES |
| DOE Release Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| DOE Release Date Security Types |
| Name | Current Value |
| DOE Release Date Bound Attachments |
| Name | Current Value |
| DOE Release Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| DOE Release Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight DOE Release Date |
NO | ||
| PRINT (Oracle) SCI_HIGH DOE_REL_DTE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH DOE_REL_DTE |
NO |
| DOE Release Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOE Release Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOE Release Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOE Release Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Lee Release Date |
| Base Entity | Science Highlight |
| Attribute Name | Lee Release Date |
| Logical Rolename | |
| ColumnName | LEE_REL_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Lee Release Date Logical Attribute Properties |
| Logical Attribute Name | Lee Release Date |
| Datatype | DATE |
| Nullable | YES |
| Lee Release Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Lee Release Date Security Types |
| Name | Current Value |
| Lee Release Date Bound Attachments |
| Name | Current Value |
| Lee Release Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Lee Release Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Lee Release Date |
NO | ||
| PRINT (Oracle) SCI_HIGH LEE_REL_DTE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH LEE_REL_DTE |
NO |
| Lee Release Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Lee Release Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Lee Release Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Lee Release Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Feature Release Date |
| Base Entity | Science Highlight |
| Attribute Name | ORNL Feature Release Date |
| Logical Rolename | |
| ColumnName | ORNL_REL_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| ORNL Feature Release Date Logical Attribute Properties |
| Logical Attribute Name | ORNL Feature Release Date |
| Datatype | DATE |
| Nullable | YES |
| ORNL Feature Release Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| ORNL Feature Release Date Security Types |
| Name | Current Value |
| ORNL Feature Release Date Bound Attachments |
| Name | Current Value |
| ORNL Feature Release Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| ORNL Feature Release Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight ORNL Feature Release Date |
NO | ||
| PRINT (Oracle) SCI_HIGH ORNL_REL_DTE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH ORNL_REL_DTE |
NO |
| ORNL Feature Release Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Feature Release Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Feature Release Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Feature Release Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NSCD Web Release Date |
| Base Entity | Science Highlight |
| Attribute Name | NSCD Web Release Date |
| Logical Rolename | |
| ColumnName | NSCD_WEB_REL_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| NSCD Web Release Date Logical Attribute Properties |
| Logical Attribute Name | NSCD Web Release Date |
| Datatype | DATE |
| Nullable | YES |
| NSCD Web Release Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| NSCD Web Release Date Security Types |
| Name | Current Value |
| NSCD Web Release Date Bound Attachments |
| Name | Current Value |
| NSCD Web Release Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| NSCD Web Release Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight NSCD Web Release Date |
NO | ||
| PRINT (Oracle) SCI_HIGH NSCD_WEB_REL_DTE |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH NSCD_WEB_REL_DTE |
NO |
| NSCD Web Release Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NSCD Web Release Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NSCD Web Release Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NSCD Web Release Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Release |
| Base Entity | Science Highlight |
| Attribute Name | Other Release |
| Logical Rolename | |
| ColumnName | OTHER_REL |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Other Release Logical Attribute Properties |
| Logical Attribute Name | Other Release |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Other Release Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Other Release Security Types |
| Name | Current Value |
| Other Release Bound Attachments |
| Name | Current Value |
| Other Release Data Movement Rules |
| Name | Type | Rule Text/Value |
| Other Release Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Other Release |
NO | ||
| PRINT (Oracle) SCI_HIGH OTHER_REL |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH OTHER_REL |
NO |
| Other Release Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Release Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Release Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Release Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Topic Identifier |
| Base Entity | Science Highlight |
| Attribute Name | Topic Identifier |
| Logical Rolename | |
| ColumnName | TOPIC_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Topic Identifier Logical Attribute Properties |
| Logical Attribute Name | Topic Identifier |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Topic Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Topic Identifier Security Types |
| Name | Current Value |
| Topic Identifier Bound Attachments |
| Name | Current Value |
| Topic Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Topic Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight Topic Identifier |
NO | ||
| PRINT (Oracle) SCI_HIGH TOPIC_ID |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH TOPIC_ID |
NO |
| Topic Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Topic Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Topic Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Topic Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NScD Contact Badge Number |
| Base Entity | Science Highlight |
| Attribute Name | NScD Contact Badge Number |
| Logical Rolename | |
| ColumnName | NSCD_CONT_BN |
| RoleName | |
| Domain | Badge Number |
| Logical Only | NO |
| Definition | |
| Note |
| NScD Contact Badge Number Logical Attribute Properties |
| Logical Attribute Name | NScD Contact Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| NScD Contact Badge Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NScD Contact Badge Number Security Types |
| Name | Current Value |
| NScD Contact Badge Number Bound Attachments |
| Name | Current Value |
| NScD Contact Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| NScD Contact Badge Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Science Highlight NScD Contact Badge Number |
NO | ||
| PRINT (Oracle) SCI_HIGH NSCD_CONT_BN |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH NSCD_CONT_BN |
NO |
| NScD Contact Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NScD Contact Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NScD Contact Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NScD Contact Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Addr |
| Base Entity | Science Highlight |
| 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 Science Highlight Email Addr |
NO | ||
| PRINT (Oracle) SCI_HIGH EMAIL_ADDR |
NO | ||
| XF_ADMIN (Oracle) SCI_HIGH 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 |