| Person Identifier |
| Base Entity | User Publication |
| Attribute Name | Person Identifier |
| Logical Rolename | |
| ColumnName | PERSON_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
| Note |
| Person Identifier Logical Attribute Properties |
| Logical Attribute Name | Person Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Person Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Person Identifier Security Types |
| Name | Current Value |
| Person Identifier Bound Attachments |
| Name | Current Value |
| Person Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Person Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Person Identifier |
NO | ||
| PRPSL (Oracle) USER_PUBL PERSON_ID |
NO |
| Person Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Person Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Person Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Person Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier |
| Base Entity | User Publication |
| Attribute Name | Proposal Identifier |
| Logical Rolename | |
| ColumnName | PRPSL_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Proposal Identifier Logical Attribute Properties |
| Logical Attribute Name | Proposal Identifier |
| Datatype | NUMERIC(10, 0) |
| Nullable | NO |
| Proposal Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Proposal Identifier Security Types |
| Name | Current Value |
| Proposal Identifier Bound Attachments |
| Name | Current Value |
| Proposal Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Proposal Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Proposal Identifier |
NO | ||
| PRPSL (Oracle) USER_PUBL PRPSL_ID |
NO |
| Proposal Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Digital Object Identifier |
| Base Entity | User Publication |
| Attribute Name | Digital Object Identifier |
| Logical Rolename | |
| ColumnName | DIG_OBJ_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Digital Object Identifier Logical Attribute Properties |
| Logical Attribute Name | Digital Object Identifier |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Digital Object Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Digital Object Identifier Security Types |
| Name | Current Value |
| Digital Object Identifier Bound Attachments |
| Name | Current Value |
| Digital Object Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Digital Object Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Digital Object Identifier |
NO | ||
| PRPSL (Oracle) USER_PUBL DIG_OBJ_ID |
NO |
| Digital Object Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Digital Object Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Digital Object Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Digital Object Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Title |
| Base Entity | User Publication |
| Attribute Name | Title |
| Logical Rolename | |
| ColumnName | TITLE |
| RoleName | |
| Domain | Title |
| Logical Only | NO |
| Definition | |
| Note |
| Title Logical Attribute Properties |
| Logical Attribute Name | Title |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| 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 |
| Logical User Publication Title |
NO | ||
| PRPSL (Oracle) USER_PUBL 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 |
| Publication Year |
| Base Entity | User Publication |
| Attribute Name | Publication Year |
| Logical Rolename | |
| ColumnName | PUB_YEAR |
| RoleName | |
| Domain | Year |
| Logical Only | NO |
| Definition | |
| Note |
| Publication Year Logical Attribute Properties |
| Logical Attribute Name | Publication Year |
| Datatype | VARCHAR(4) |
| Nullable | YES |
| Publication Year Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Publication Year Security Types |
| Name | Current Value |
| Publication Year Bound Attachments |
| Name | Current Value |
| Publication Year Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Year Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Publication Year |
NO | ||
| PRPSL (Oracle) USER_PUBL PUB_YEAR |
NO |
| Publication Year Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Year Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Year Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Year Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Month Day |
| Base Entity | User Publication |
| Attribute Name | Publication Month Day |
| Logical Rolename | |
| ColumnName | PUB_MONTH_DAY |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Publication Month Day: In mm/dd format |
| Note |
| Publication Month Day Logical Attribute Properties |
| Logical Attribute Name | Publication Month Day |
| Datatype | VARCHAR(6) |
| Nullable | YES |
| Publication Month Day Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Publication Month Day Security Types |
| Name | Current Value |
| Publication Month Day Bound Attachments |
| Name | Current Value |
| Publication Month Day Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Month Day Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Publication Month Day |
NO | ||
| PRPSL (Oracle) USER_PUBL PUB_MONTH_DAY |
NO |
| Publication Month Day Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Month Day Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Month Day Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Month Day Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Source |
| Base Entity | User Publication |
| Attribute Name | Source |
| Logical Rolename | |
| ColumnName | SOURCE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Source Logical Attribute Properties |
| Logical Attribute Name | Source |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Source Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Source Security Types |
| Name | Current Value |
| Source Bound Attachments |
| Name | Current Value |
| Source Data Movement Rules |
| Name | Type | Rule Text/Value |
| Source Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Source |
NO | ||
| PRPSL (Oracle) USER_PUBL SOURCE |
NO |
| Source Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Source Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Source Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Source Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Author |
| Base Entity | User Publication |
| Attribute Name | Author |
| Logical Rolename | |
| ColumnName | AUTHOR |
| RoleName | |
| Domain | AUTHORS |
| Logical Only | NO |
| Definition | |
| Note |
| Author Logical Attribute Properties |
| Logical Attribute Name | Author |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Author Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Author Security Types |
| Name | Current Value |
| Author Bound Attachments |
| Name | Current Value |
| Author Data Movement Rules |
| Name | Type | Rule Text/Value |
| Author Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Author |
NO | ||
| PRPSL (Oracle) USER_PUBL AUTHOR |
NO |
| Author Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Author Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Author Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Author Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Volume |
| Base Entity | User Publication |
| Attribute Name | Volume |
| Logical Rolename | |
| ColumnName | VOLUME |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Volume Logical Attribute Properties |
| Logical Attribute Name | Volume |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Volume Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Volume Security Types |
| Name | Current Value |
| Volume Bound Attachments |
| Name | Current Value |
| Volume Data Movement Rules |
| Name | Type | Rule Text/Value |
| Volume Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Volume |
NO | ||
| PRPSL (Oracle) USER_PUBL VOLUME |
NO |
| Volume Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Volume Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Volume Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Volume Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Issue |
| Base Entity | User Publication |
| Attribute Name | Issue |
| Logical Rolename | |
| ColumnName | ISSUE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Issue Logical Attribute Properties |
| Logical Attribute Name | Issue |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Issue Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Issue Security Types |
| Name | Current Value |
| Issue Bound Attachments |
| Name | Current Value |
| Issue Data Movement Rules |
| Name | Type | Rule Text/Value |
| Issue Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Issue |
NO | ||
| PRPSL (Oracle) USER_PUBL ISSUE |
NO |
| Issue Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Issue Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Issue Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Issue Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Page |
| Base Entity | User Publication |
| Attribute Name | Page |
| Logical Rolename | |
| ColumnName | PAGE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Page Logical Attribute Properties |
| Logical Attribute Name | Page |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Page Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Page Security Types |
| Name | Current Value |
| Page Bound Attachments |
| Name | Current Value |
| Page Data Movement Rules |
| Name | Type | Rule Text/Value |
| Page Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Page |
NO | ||
| PRPSL (Oracle) USER_PUBL PAGE |
NO |
| Page Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Page Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Page Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Page Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Date |
| Base Entity | User Publication |
| Attribute Name | Current Date |
| Logical Rolename | |
| ColumnName | CUR_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| Note |
| Current Date Logical Attribute Properties |
| Logical Attribute Name | Current Date |
| Datatype | DATE |
| Nullable | YES |
| Current Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Current Date Security Types |
| Name | Current Value |
| Current Date Bound Attachments |
| Name | Current Value |
| Current Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Current Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Current Date |
NO | ||
| PRPSL (Oracle) USER_PUBL CUR_DTE |
NO |
| Current Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publish Indicator |
| Base Entity | User Publication |
| Attribute Name | Publish Indicator |
| Logical Rolename | |
| ColumnName | PUBL_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Publish Indicator: Indicates the PI was not able to publish for the given experiment. |
| Note |
| Publish Indicator Logical Attribute Properties |
| Logical Attribute Name | Publish Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Publish Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Publish Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Publish Indicator Security Types |
| Name | Current Value |
| Publish Indicator Bound Attachments |
| Name | Current Value |
| Publish Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publish Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Publish Indicator |
NO | ||
| PRPSL (Oracle) USER_PUBL PUBL_IND |
NO |
| Publish Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publish Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publish Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publish Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Unable to Publish Comment |
| Base Entity | User Publication |
| Attribute Name | Unable to Publish Comment |
| Logical Rolename | |
| ColumnName | PUBL_CMNT |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Unable to Publish Comment: The reason why the PI was not able to publish for the given experiment. |
| Note |
| Unable to Publish Comment Logical Attribute Properties |
| Logical Attribute Name | Unable to Publish Comment |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Unable to Publish Comment Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Unable to Publish Comment Security Types |
| Name | Current Value |
| Unable to Publish Comment Bound Attachments |
| Name | Current Value |
| Unable to Publish Comment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Unable to Publish Comment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Unable to Publish Comment |
NO | ||
| PRPSL (Oracle) USER_PUBL PUBL_CMNT |
NO |
| Unable to Publish Comment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Unable to Publish Comment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Unable to Publish Comment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Unable to Publish Comment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Identifier |
| Base Entity | User Publication |
| Attribute Name | Display Identifier |
| Logical Rolename | |
| ColumnName | DISP_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Display Identifier Logical Attribute Properties |
| Logical Attribute Name | Display Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Display Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Display Identifier Security Types |
| Name | Current Value |
| Display Identifier Bound Attachments |
| Name | Current Value |
| Display Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Display Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical User Publication Display Identifier |
NO | ||
| PRPSL (Oracle) USER_PUBL DISP_ID |
NO |
| Display Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Display Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |