SCI_HIGH_ID |
Base Object | SCI_HIGH |
Attribute Name | Science Highlight Identifier |
ColumnName | SCI_HIGH_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
SCI_HIGH_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SCI_HIGH_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
SCI_HIGH_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SCI_HIGH_ID Security Types |
Name | Current Value |
SCI_HIGH_ID Bound Attachments |
Name | Current Value |
SCI_HIGH_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SCI_HIGH_ID 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 |
SCI_HIGH_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SCI_HIGH_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SCI_HIGH_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SCI_HIGH_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE |
Base Object | SCI_HIGH |
Attribute Name | Start Date |
ColumnName | START_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
START_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
START_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
START_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
START_DTE Security Types |
Name | Current Value |
START_DTE Bound Attachments |
Name | Current Value |
START_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
START_DTE 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_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
START_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
COMPL_DTE |
Base Object | SCI_HIGH |
Attribute Name | Completion Date |
ColumnName | COMPL_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
COMPL_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
COMPL_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
COMPL_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
COMPL_DTE Security Types |
Name | Current Value |
COMPL_DTE Bound Attachments |
Name | Current Value |
COMPL_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
COMPL_DTE 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 |
COMPL_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
COMPL_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
COMPL_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
COMPL_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NOTE |
Base Object | SCI_HIGH |
Attribute Name | Note |
ColumnName | NOTE |
Logical Rolename | |
RoleName | |
Domain | Note |
Physical Only | NO |
Definition | |
Note |
NOTE Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NOTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
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 |
SCI_HIGH_CAT_ID |
Base Object | SCI_HIGH |
Attribute Name | Science Highlight Category Identifier |
ColumnName | SCI_HIGH_CAT_ID |
Logical Rolename | |
RoleName | SCI_HIGH_CAT_ID |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
SCI_HIGH_CAT_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SCI_HIGH_CAT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
SCI_HIGH_CAT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SCI_HIGH_CAT_ID Security Types |
Name | Current Value |
SCI_HIGH_CAT_ID Bound Attachments |
Name | Current Value |
SCI_HIGH_CAT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SCI_HIGH_CAT_ID 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 |
SCI_HIGH_CAT_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SCI_HIGH_CAT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SCI_HIGH_CAT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SCI_HIGH_CAT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HIGH_TITLE |
Base Object | SCI_HIGH |
Attribute Name | Highlight Title |
ColumnName | HIGH_TITLE |
Logical Rolename | |
RoleName | |
Domain | Title |
Physical Only | NO |
Definition | |
Note |
HIGH_TITLE Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
HIGH_TITLE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
HIGH_TITLE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HIGH_TITLE Security Types |
Name | Current Value |
HIGH_TITLE Bound Attachments |
Name | Current Value |
HIGH_TITLE Data Movement Rules |
Name | Type | Rule Text/Value |
HIGH_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 |
HIGH_TITLE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HIGH_TITLE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HIGH_TITLE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HIGH_TITLE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ABSTRACT |
Base Object | SCI_HIGH |
Attribute Name | Abstract |
ColumnName | ABSTRACT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
ABSTRACT Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ABSTRACT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
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 Object | SCI_HIGH |
Attribute Name | Paper Title |
ColumnName | PAPER_TITLE |
Logical Rolename | |
RoleName | |
Domain | Title |
Physical Only | NO |
Definition | |
Note |
PAPER_TITLE Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PAPER_TITLE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
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 |
PUB_TITLE |
Base Object | SCI_HIGH |
Attribute Name | Publication Title |
ColumnName | PUB_TITLE |
Logical Rolename | |
RoleName | |
Domain | Title |
Physical Only | NO |
Definition | |
Note |
PUB_TITLE Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUB_TITLE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
PUB_TITLE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUB_TITLE Security Types |
Name | Current Value |
PUB_TITLE Bound Attachments |
Name | Current Value |
PUB_TITLE Data Movement Rules |
Name | Type | Rule Text/Value |
PUB_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 |
PUB_TITLE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_TITLE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_TITLE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_TITLE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
KEYWORD |
Base Object | SCI_HIGH |
Attribute Name | Keyword |
ColumnName | KEYWORD |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
KEYWORD Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
KEYWORD Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
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 |
IMG_FILE_NM |
Base Object | SCI_HIGH |
Attribute Name | Image File Name |
ColumnName | IMG_FILE_NM |
Logical Rolename | |
RoleName | |
Domain | File Name |
Physical 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 |
IMG_FILE_NM Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
IMG_FILE_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
IMG_FILE_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
IMG_FILE_NM Security Types |
Name | Current Value |
IMG_FILE_NM Bound Attachments |
Name | Current Value |
IMG_FILE_NM Data Movement Rules |
Name | Type | Rule Text/Value |
IMG_FILE_NM 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 |
IMG_FILE_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
IMG_FILE_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
IMG_FILE_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
IMG_FILE_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
WK_SPOT |
Base Object | SCI_HIGH |
Attribute Name | Weekly Spotlight |
ColumnName | WK_SPOT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
WK_SPOT Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
WK_SPOT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
WK_SPOT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
WK_SPOT Security Types |
Name | Current Value |
WK_SPOT Bound Attachments |
Name | Current Value |
WK_SPOT Data Movement Rules |
Name | Type | Rule Text/Value |
WK_SPOT 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 |
WK_SPOT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
WK_SPOT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
WK_SPOT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
WK_SPOT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
STORYTIP |
Base Object | SCI_HIGH |
Attribute Name | Storytip |
ColumnName | STORYTIP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
STORYTIP Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
STORYTIP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
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 |
IMG_CAP |
Base Object | SCI_HIGH |
Attribute Name | Image Caption |
ColumnName | IMG_CAP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
IMG_CAP Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
IMG_CAP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
IMG_CAP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
IMG_CAP Security Types |
Name | Current Value |
IMG_CAP Bound Attachments |
Name | Current Value |
IMG_CAP Data Movement Rules |
Name | Type | Rule Text/Value |
IMG_CAP 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 |
IMG_CAP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
IMG_CAP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
IMG_CAP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
IMG_CAP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CER_REL_DTE |
Base Object | SCI_HIGH |
Attribute Name | CER Release Date |
ColumnName | CER_REL_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
CER_REL_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CER_REL_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
CER_REL_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
CER_REL_DTE Security Types |
Name | Current Value |
CER_REL_DTE Bound Attachments |
Name | Current Value |
CER_REL_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
CER_REL_DTE 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_REL_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CER_REL_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CER_REL_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CER_REL_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BRINKMAN_REL_DTE |
Base Object | SCI_HIGH |
Attribute Name | Brinkman Release Date |
ColumnName | BRINKMAN_REL_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
BRINKMAN_REL_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BRINKMAN_REL_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
BRINKMAN_REL_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
BRINKMAN_REL_DTE Security Types |
Name | Current Value |
BRINKMAN_REL_DTE Bound Attachments |
Name | Current Value |
BRINKMAN_REL_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
BRINKMAN_REL_DTE 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_REL_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BRINKMAN_REL_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BRINKMAN_REL_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BRINKMAN_REL_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOE_REL_DTE |
Base Object | SCI_HIGH |
Attribute Name | DOE Release Date |
ColumnName | DOE_REL_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
DOE_REL_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DOE_REL_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
DOE_REL_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
DOE_REL_DTE Security Types |
Name | Current Value |
DOE_REL_DTE Bound Attachments |
Name | Current Value |
DOE_REL_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
DOE_REL_DTE 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_REL_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOE_REL_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOE_REL_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOE_REL_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LEE_REL_DTE |
Base Object | SCI_HIGH |
Attribute Name | Lee Release Date |
ColumnName | LEE_REL_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
LEE_REL_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
LEE_REL_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
LEE_REL_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
LEE_REL_DTE Security Types |
Name | Current Value |
LEE_REL_DTE Bound Attachments |
Name | Current Value |
LEE_REL_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
LEE_REL_DTE 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_REL_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LEE_REL_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LEE_REL_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LEE_REL_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_REL_DTE |
Base Object | SCI_HIGH |
Attribute Name | ORNL Feature Release Date |
ColumnName | ORNL_REL_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
ORNL_REL_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ORNL_REL_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
ORNL_REL_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
ORNL_REL_DTE Security Types |
Name | Current Value |
ORNL_REL_DTE Bound Attachments |
Name | Current Value |
ORNL_REL_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
ORNL_REL_DTE 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_REL_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_REL_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_REL_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_REL_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_WEB_REL_DTE |
Base Object | SCI_HIGH |
Attribute Name | NSCD Web Release Date |
ColumnName | NSCD_WEB_REL_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
NSCD_WEB_REL_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NSCD_WEB_REL_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
NSCD_WEB_REL_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
NSCD_WEB_REL_DTE Security Types |
Name | Current Value |
NSCD_WEB_REL_DTE Bound Attachments |
Name | Current Value |
NSCD_WEB_REL_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
NSCD_WEB_REL_DTE 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_REL_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_WEB_REL_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_WEB_REL_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_WEB_REL_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_REL |
Base Object | SCI_HIGH |
Attribute Name | Other Release |
ColumnName | OTHER_REL |
Logical Rolename | |
RoleName | |
Domain | Note |
Physical Only | NO |
Definition | |
Note |
OTHER_REL Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OTHER_REL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
OTHER_REL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OTHER_REL Security Types |
Name | Current Value |
OTHER_REL Bound Attachments |
Name | Current Value |
OTHER_REL Data Movement Rules |
Name | Type | Rule Text/Value |
OTHER_REL 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_REL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_REL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_REL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_REL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TOPIC_ID |
Base Object | SCI_HIGH |
Attribute Name | Topic Identifier |
ColumnName | TOPIC_ID |
Logical Rolename | |
RoleName | TOPIC_ID |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
TOPIC_ID Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TOPIC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
TOPIC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TOPIC_ID Security Types |
Name | Current Value |
TOPIC_ID Bound Attachments |
Name | Current Value |
TOPIC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
TOPIC_ID 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_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TOPIC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TOPIC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TOPIC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_CONT_BN |
Base Object | SCI_HIGH |
Attribute Name | NScD Contact Badge Number |
ColumnName | NSCD_CONT_BN |
Logical Rolename | |
RoleName | |
Domain | Badge Number |
Physical Only | NO |
Definition | |
Note |
NSCD_CONT_BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NSCD_CONT_BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
NSCD_CONT_BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NSCD_CONT_BN Security Types |
Name | Current Value |
NSCD_CONT_BN Bound Attachments |
Name | Current Value |
NSCD_CONT_BN Data Movement Rules |
Name | Type | Rule Text/Value |
NSCD_CONT_BN 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_CONT_BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_CONT_BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_CONT_BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NSCD_CONT_BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL_ADDR |
Base Object | SCI_HIGH |
Attribute Name | Email Addr |
ColumnName | EMAIL_ADDR |
Logical Rolename | |
RoleName | |
Domain | Email Addr |
Physical Only | NO |
Definition | Email Address: |
Note |
EMAIL_ADDR Column Properties |
Datatype | VARCHAR2(75) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EMAIL_ADDR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
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 |