ID |
Base Object | PUB_QUEUE |
Attribute Name | ID |
ColumnName | ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ID Column Properties |
Datatype | NUMBER |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ID Security Types |
Name | Current Value |
ID Bound Attachments |
Name | Current Value |
ID Data Movement Rules |
Name | Type | Rule Text/Value |
ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE ID |
NO |
ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TITLE |
Base Object | PUB_QUEUE |
Attribute Name | TITLE |
ColumnName | TITLE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
TITLE Column Properties |
Datatype | VARCHAR2(1024) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TITLE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1024 |
Percent Null | 0 |
TITLE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TITLE Security Types |
Name | Current Value |
TITLE Bound Attachments |
Name | Current Value |
TITLE Data Movement Rules |
Name | Type | Rule Text/Value |
TITLE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE TITLE |
NO |
TITLE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TITLE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TITLE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TITLE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
AUTHORS |
Base Object | PUB_QUEUE |
Attribute Name | AUTHORS |
ColumnName | AUTHORS |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
AUTHORS Column Properties |
Datatype | VARCHAR2(2048) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
AUTHORS Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
AUTHORS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AUTHORS Security Types |
Name | Current Value |
AUTHORS Bound Attachments |
Name | Current Value |
AUTHORS Data Movement Rules |
Name | Type | Rule Text/Value |
AUTHORS Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE AUTHORS |
NO |
AUTHORS Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AUTHORS Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AUTHORS Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AUTHORS Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BEAMLINE |
Base Object | PUB_QUEUE |
Attribute Name | BEAMLINE |
ColumnName | BEAMLINE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
BEAMLINE Column Properties |
Datatype | VARCHAR2(128) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BEAMLINE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 128 |
Percent Null | 0 |
BEAMLINE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BEAMLINE Security Types |
Name | Current Value |
BEAMLINE Bound Attachments |
Name | Current Value |
BEAMLINE Data Movement Rules |
Name | Type | Rule Text/Value |
BEAMLINE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE BEAMLINE |
NO |
BEAMLINE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BEAMLINE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BEAMLINE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BEAMLINE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROPOSAL_ID |
Base Object | PUB_QUEUE |
Attribute Name | PROPOSAL_ID |
ColumnName | PROPOSAL_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PROPOSAL_ID Column Properties |
Datatype | VARCHAR2(128) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PROPOSAL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 128 |
Percent Null | 0 |
PROPOSAL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PROPOSAL_ID Security Types |
Name | Current Value |
PROPOSAL_ID Bound Attachments |
Name | Current Value |
PROPOSAL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PROPOSAL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE PROPOSAL_ID |
NO |
PROPOSAL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROPOSAL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROPOSAL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROPOSAL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SCI_DISCIP |
Base Object | PUB_QUEUE |
Attribute Name | SCI_DISCIP |
ColumnName | SCI_DISCIP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SCI_DISCIP Column Properties |
Datatype | VARCHAR2(128) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SCI_DISCIP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 128 |
Percent Null | 0 |
SCI_DISCIP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SCI_DISCIP Security Types |
Name | Current Value |
SCI_DISCIP Bound Attachments |
Name | Current Value |
SCI_DISCIP Data Movement Rules |
Name | Type | Rule Text/Value |
SCI_DISCIP Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE SCI_DISCIP |
NO |
SCI_DISCIP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SCI_DISCIP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SCI_DISCIP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SCI_DISCIP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_NAME |
Base Object | PUB_QUEUE |
Attribute Name | PUB_NAME |
ColumnName | PUB_NAME |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUB_NAME Column Properties |
Datatype | VARCHAR2(512) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUB_NAME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 512 |
Percent Null | 0 |
PUB_NAME Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUB_NAME Security Types |
Name | Current Value |
PUB_NAME Bound Attachments |
Name | Current Value |
PUB_NAME Data Movement Rules |
Name | Type | Rule Text/Value |
PUB_NAME Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE PUB_NAME |
NO |
PUB_NAME Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_NAME Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_NAME Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_NAME Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_ADD_NAME |
Base Object | PUB_QUEUE |
Attribute Name | PUB_ADD_NAME |
ColumnName | PUB_ADD_NAME |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUB_ADD_NAME Column Properties |
Datatype | VARCHAR2(512) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUB_ADD_NAME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 512 |
Percent Null | 0 |
PUB_ADD_NAME Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUB_ADD_NAME Security Types |
Name | Current Value |
PUB_ADD_NAME Bound Attachments |
Name | Current Value |
PUB_ADD_NAME Data Movement Rules |
Name | Type | Rule Text/Value |
PUB_ADD_NAME Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE PUB_ADD_NAME |
NO |
PUB_ADD_NAME Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_ADD_NAME Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_ADD_NAME Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_ADD_NAME Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_TYPE |
Base Object | PUB_QUEUE |
Attribute Name | PUB_TYPE |
ColumnName | PUB_TYPE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUB_TYPE Column Properties |
Datatype | VARCHAR2(32) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUB_TYPE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 32 |
Percent Null | 0 |
PUB_TYPE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUB_TYPE Security Types |
Name | Current Value |
PUB_TYPE Bound Attachments |
Name | Current Value |
PUB_TYPE Data Movement Rules |
Name | Type | Rule Text/Value |
PUB_TYPE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE PUB_TYPE |
NO |
PUB_TYPE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_TYPE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_TYPE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_TYPE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_VOLUME |
Base Object | PUB_QUEUE |
Attribute Name | PUB_VOLUME |
ColumnName | PUB_VOLUME |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUB_VOLUME Column Properties |
Datatype | VARCHAR2(256) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUB_VOLUME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 256 |
Percent Null | 0 |
PUB_VOLUME Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUB_VOLUME Security Types |
Name | Current Value |
PUB_VOLUME Bound Attachments |
Name | Current Value |
PUB_VOLUME Data Movement Rules |
Name | Type | Rule Text/Value |
PUB_VOLUME Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE PUB_VOLUME |
NO |
PUB_VOLUME Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_VOLUME Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_VOLUME Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_VOLUME Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_PAGE |
Base Object | PUB_QUEUE |
Attribute Name | PUB_PAGE |
ColumnName | PUB_PAGE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUB_PAGE Column Properties |
Datatype | VARCHAR2(256) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUB_PAGE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 256 |
Percent Null | 0 |
PUB_PAGE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUB_PAGE Security Types |
Name | Current Value |
PUB_PAGE Bound Attachments |
Name | Current Value |
PUB_PAGE Data Movement Rules |
Name | Type | Rule Text/Value |
PUB_PAGE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE PUB_PAGE |
NO |
PUB_PAGE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_PAGE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_PAGE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_PAGE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_ISSUE |
Base Object | PUB_QUEUE |
Attribute Name | PUB_ISSUE |
ColumnName | PUB_ISSUE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUB_ISSUE Column Properties |
Datatype | VARCHAR2(256) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUB_ISSUE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 256 |
Percent Null | 0 |
PUB_ISSUE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUB_ISSUE Security Types |
Name | Current Value |
PUB_ISSUE Bound Attachments |
Name | Current Value |
PUB_ISSUE Data Movement Rules |
Name | Type | Rule Text/Value |
PUB_ISSUE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE PUB_ISSUE |
NO |
PUB_ISSUE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_ISSUE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_ISSUE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_ISSUE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_YEAR |
Base Object | PUB_QUEUE |
Attribute Name | PUB_YEAR |
ColumnName | PUB_YEAR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUB_YEAR Column Properties |
Datatype | VARCHAR2(4) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUB_YEAR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
PUB_YEAR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUB_YEAR Security Types |
Name | Current Value |
PUB_YEAR Bound Attachments |
Name | Current Value |
PUB_YEAR Data Movement Rules |
Name | Type | Rule Text/Value |
PUB_YEAR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE PUB_YEAR |
NO |
PUB_YEAR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_YEAR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_YEAR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_YEAR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_MONTH |
Base Object | PUB_QUEUE |
Attribute Name | PUB_MONTH |
ColumnName | PUB_MONTH |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUB_MONTH Column Properties |
Datatype | VARCHAR2(3) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUB_MONTH Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 0 |
PUB_MONTH Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUB_MONTH Security Types |
Name | Current Value |
PUB_MONTH Bound Attachments |
Name | Current Value |
PUB_MONTH Data Movement Rules |
Name | Type | Rule Text/Value |
PUB_MONTH Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE PUB_MONTH |
NO |
PUB_MONTH Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_MONTH Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_MONTH Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_MONTH Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOI |
Base Object | PUB_QUEUE |
Attribute Name | DOI |
ColumnName | DOI |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DOI Column Properties |
Datatype | VARCHAR2(256) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DOI Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 256 |
Percent Null | 0 |
DOI Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DOI Security Types |
Name | Current Value |
DOI Bound Attachments |
Name | Current Value |
DOI Data Movement Rules |
Name | Type | Rule Text/Value |
DOI Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE DOI |
NO |
DOI Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOI Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOI Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOI Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_DIV |
Base Object | PUB_QUEUE |
Attribute Name | ORNL_DIV |
ColumnName | ORNL_DIV |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ORNL_DIV Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ORNL_DIV Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
ORNL_DIV Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ORNL_DIV Security Types |
Name | Current Value |
ORNL_DIV Bound Attachments |
Name | Current Value |
ORNL_DIV Data Movement Rules |
Name | Type | Rule Text/Value |
ORNL_DIV Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE ORNL_DIV |
NO |
ORNL_DIV Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_DIV Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_DIV Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_DIV Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_PTS |
Base Object | PUB_QUEUE |
Attribute Name | ORNL_PTS |
ColumnName | ORNL_PTS |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ORNL_PTS Column Properties |
Datatype | VARCHAR2(128) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ORNL_PTS Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 128 |
Percent Null | 0 |
ORNL_PTS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ORNL_PTS Security Types |
Name | Current Value |
ORNL_PTS Bound Attachments |
Name | Current Value |
ORNL_PTS Data Movement Rules |
Name | Type | Rule Text/Value |
ORNL_PTS Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE ORNL_PTS |
NO |
ORNL_PTS Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_PTS Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_PTS Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_PTS Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUBMITTED_BY |
Base Object | PUB_QUEUE |
Attribute Name | SUBMITTED_BY |
ColumnName | SUBMITTED_BY |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SUBMITTED_BY Column Properties |
Datatype | VARCHAR2(64) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SUBMITTED_BY Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
SUBMITTED_BY Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SUBMITTED_BY Security Types |
Name | Current Value |
SUBMITTED_BY Bound Attachments |
Name | Current Value |
SUBMITTED_BY Data Movement Rules |
Name | Type | Rule Text/Value |
SUBMITTED_BY Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE SUBMITTED_BY |
NO |
SUBMITTED_BY Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUBMITTED_BY Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUBMITTED_BY Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUBMITTED_BY Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Base Object | PUB_QUEUE |
Attribute Name | |
ColumnName | |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
EMAIL Column Properties |
Datatype | VARCHAR2(64) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EMAIL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
EMAIL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EMAIL Security Types |
Name | Current Value |
EMAIL Bound Attachments |
Name | Current Value |
EMAIL Data Movement Rules |
Name | Type | Rule Text/Value |
EMAIL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE |
NO |
EMAIL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EMAIL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
COMMENTS |
Base Object | PUB_QUEUE |
Attribute Name | COMMENTS |
ColumnName | COMMENTS |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
COMMENTS Column Properties |
Datatype | VARCHAR2(1024) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
COMMENTS Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1024 |
Percent Null | 0 |
COMMENTS Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
COMMENTS Security Types |
Name | Current Value |
COMMENTS Bound Attachments |
Name | Current Value |
COMMENTS Data Movement Rules |
Name | Type | Rule Text/Value |
COMMENTS Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE COMMENTS |
NO |
COMMENTS Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
COMMENTS Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
COMMENTS Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
COMMENTS Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MODERATED |
Base Object | PUB_QUEUE |
Attribute Name | MODERATED |
ColumnName | MODERATED |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MODERATED Column Properties |
Datatype | VARCHAR2(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MODERATED Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
MODERATED Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MODERATED Security Types |
Name | Current Value |
MODERATED Bound Attachments |
Name | Current Value |
MODERATED Data Movement Rules |
Name | Type | Rule Text/Value |
MODERATED Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE MODERATED |
NO |
MODERATED Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MODERATED Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MODERATED Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MODERATED Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_UPDATE |
Base Object | PUB_QUEUE |
Attribute Name | LAST_UPDATE |
ColumnName | LAST_UPDATE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
LAST_UPDATE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
LAST_UPDATE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
LAST_UPDATE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LAST_UPDATE Security Types |
Name | Current Value |
LAST_UPDATE Bound Attachments |
Name | Current Value |
LAST_UPDATE Data Movement Rules |
Name | Type | Rule Text/Value |
LAST_UPDATE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
PUBL_V1 (Oracle) PUB_QUEUE LAST_UPDATE |
NO |
LAST_UPDATE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_UPDATE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_UPDATE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_UPDATE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |