PERSON_ID |
Base Object | USER_PUBL |
Attribute Name | Person Identifier |
ColumnName | PERSON_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
Note |
PERSON_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PERSON_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
PERSON_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PERSON_ID Security Types |
Name | Current Value |
PERSON_ID Bound Attachments |
Name | Current Value |
PERSON_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PERSON_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical User Publication Person Identifier |
NO | ||
PRPSL (Oracle) USER_PUBL PERSON_ID |
NO |
PERSON_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PERSON_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PERSON_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PERSON_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PRPSL_ID |
Base Object | USER_PUBL |
Attribute Name | Proposal Identifier |
ColumnName | PRPSL_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PRPSL_ID Column Properties |
Datatype | NUMBER(10, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PRPSL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 0 |
PRPSL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PRPSL_ID Security Types |
Name | Current Value |
PRPSL_ID Bound Attachments |
Name | Current Value |
PRPSL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PRPSL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical User Publication Proposal Identifier |
NO | ||
PRPSL (Oracle) USER_PUBL PRPSL_ID |
NO |
PRPSL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PRPSL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PRPSL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PRPSL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DIG_OBJ_ID |
Base Object | USER_PUBL |
Attribute Name | Digital Object Identifier |
ColumnName | DIG_OBJ_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
DIG_OBJ_ID Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DIG_OBJ_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
DIG_OBJ_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DIG_OBJ_ID Security Types |
Name | Current Value |
DIG_OBJ_ID Bound Attachments |
Name | Current Value |
DIG_OBJ_ID Data Movement Rules |
Name | Type | Rule Text/Value |
DIG_OBJ_ID 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 |
DIG_OBJ_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DIG_OBJ_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DIG_OBJ_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DIG_OBJ_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TITLE |
Base Object | USER_PUBL |
Attribute Name | Title |
ColumnName | TITLE |
Logical Rolename | |
RoleName | |
Domain | Title |
Physical Only | NO |
Definition | |
Note |
TITLE Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TITLE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
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 |
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 |
PUB_YEAR |
Base Object | USER_PUBL |
Attribute Name | Publication Year |
ColumnName | PUB_YEAR |
Logical Rolename | |
RoleName | |
Domain | Year |
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 |
Logical User Publication Publication Year |
NO | ||
PRPSL (Oracle) USER_PUBL 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_DAY |
Base Object | USER_PUBL |
Attribute Name | Publication Month Day |
ColumnName | PUB_MONTH_DAY |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Publication Month Day: In mm/dd format |
Note |
PUB_MONTH_DAY Column Properties |
Datatype | VARCHAR2(6) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUB_MONTH_DAY Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 0 |
PUB_MONTH_DAY Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUB_MONTH_DAY Security Types |
Name | Current Value |
PUB_MONTH_DAY Bound Attachments |
Name | Current Value |
PUB_MONTH_DAY Data Movement Rules |
Name | Type | Rule Text/Value |
PUB_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 |
PUB_MONTH_DAY Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_MONTH_DAY Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_MONTH_DAY Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUB_MONTH_DAY Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SOURCE |
Base Object | USER_PUBL |
Attribute Name | Source |
ColumnName | SOURCE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SOURCE Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SOURCE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
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 Object | USER_PUBL |
Attribute Name | Author |
ColumnName | AUTHOR |
Logical Rolename | |
RoleName | |
Domain | AUTHORS |
Physical Only | NO |
Definition | |
Note |
AUTHOR Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
AUTHOR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
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 Object | USER_PUBL |
Attribute Name | Volume |
ColumnName | VOLUME |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
VOLUME Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
VOLUME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
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 Object | USER_PUBL |
Attribute Name | Issue |
ColumnName | ISSUE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ISSUE Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ISSUE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
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 Object | USER_PUBL |
Attribute Name | Page |
ColumnName | PAGE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PAGE Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PAGE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
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 |
CUR_DTE |
Base Object | USER_PUBL |
Attribute Name | Current Date |
ColumnName | CUR_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | |
Note |
CUR_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CUR_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
CUR_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CUR_DTE Security Types |
Name | Current Value |
CUR_DTE Bound Attachments |
Name | Current Value |
CUR_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
CUR_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical User Publication Current Date |
NO | ||
PRPSL (Oracle) USER_PUBL CUR_DTE |
NO |
CUR_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CUR_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CUR_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CUR_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_IND |
Base Object | USER_PUBL |
Attribute Name | Publish Indicator |
ColumnName | PUBL_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical Only | NO |
Definition | Publish Indicator: Indicates the PI was not able to publish for the given experiment. |
Note |
PUBL_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUBL_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
PUBL_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
PUBL_IND 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 |
PUBL_IND Security Types |
Name | Current Value |
PUBL_IND Bound Attachments |
Name | Current Value |
PUBL_IND Data Movement Rules |
Name | Type | Rule Text/Value |
PUBL_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical User Publication Publish Indicator |
NO | ||
PRPSL (Oracle) USER_PUBL PUBL_IND |
NO |
PUBL_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_CMNT |
Base Object | USER_PUBL |
Attribute Name | Unable to Publish Comment |
ColumnName | PUBL_CMNT |
Logical Rolename | |
RoleName | |
Domain | Comment |
Physical Only | NO |
Definition | Unable to Publish Comment: The reason why the PI was not able to publish for the given experiment. |
Note |
PUBL_CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUBL_CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
PUBL_CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUBL_CMNT Security Types |
Name | Current Value |
PUBL_CMNT Bound Attachments |
Name | Current Value |
PUBL_CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
PUBL_CMNT 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 |
PUBL_CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DISP_ID |
Base Object | USER_PUBL |
Attribute Name | Display Identifier |
ColumnName | DISP_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
DISP_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DISP_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
DISP_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DISP_ID Security Types |
Name | Current Value |
DISP_ID Bound Attachments |
Name | Current Value |
DISP_ID Data Movement Rules |
Name | Type | Rule Text/Value |
DISP_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical User Publication Display Identifier |
NO | ||
PRPSL (Oracle) USER_PUBL DISP_ID |
NO |
DISP_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DISP_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DISP_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DISP_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |