Author |
EntityType | Independent |
Logical Entity Name | Author |
Default Table Name | AUTHOR |
Logical Only | NO |
Owner | PUBL |
Definition | Person: External and internal person using the ORNL ExperimentalFacilites systems. |
Note |
Author Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Author Identifier | Identifier | NUMERIC(38, 0) | NO | Person Identifier: Unique identifier for a person derived from XCAMS. |
Last Name | Name | VARCHAR(120) | YES | Last Name: person last name. |
First Initial | CHAR(1) | YES | ||
Middle Initial | CHAR(1) | YES | ||
Third Initial | CHAR(1) | YES | ||
First Name | VARCHAR(64) | YES | First Name: Person first name. |
|
Alias | Name | VARCHAR(120) | YES | Alias: Person sometimes publish under a name different than their legal name. |
Email Address | VARCHAR(100) | YES | Email Address: Person email address. |
|
Country Identifier | VARCHAR(10) | YES | Country Identifier: Abbreviated identrifier for a country. |
|
Institute Identifier | INTEGER | YES | Institute Identifer: Abbreviated identifier for a institute. |
|
Researcher Identifier | Identifier | VARCHAR(20) | YES | ResearcherID: A unique identifier assinged by Thomson Reuters to enable researchers to manage their publication lists, track their times cited counts and h-index, identify potential collaborators and avoid author misidentification. In addition, your ResearcherID information integrates with the Web of Science and is ORCID compliant, allowing you to claim and showcase your publications from a single one account. |
ORCID Identitifer | URI | VARCHAR(255) | YES | ORCID Id: The ORCID iD is a URI with a 16-digit number that is compatible with the ISO Standard (ISO 27729), also known as the International Standard Name Identifier (ISNI). Initially ORCID iDs will be randomly assigned by the ORCID Registry from a block of numbers that will not conflict with ISNI-formatted numbers assigned in other ways. ORCID iDs always need all 16-digits; they can not be shortened to remove leading zeros if they exist. |
Person Identifier | VARCHAR(10) | YES | Person Identifier: Unique identifier for a person derived from XCAMS. |
|
Comment | Comment | VARCHAR(2000) | YES | Comment: General comments. |
HFIR Indicator | Indicator | CHAR(1) | NO | |
SNS Indicator | Indicator | CHAR(1) | NO | |
NSCD Division Identifier | Identifier | VARCHAR(10) | YES |
Author Keys |
Key Name | Key Type | Keys |
PK_AUTHOR | PrimaryKey | Author Identifier |
Author Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Person | Non-Identifying | Zero or One to Zero or More | Person Identifier | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Publication Author Association | Identifying | One To Zero or More | NO |
Author Check Constraints |
Check Constraint Name | CheckConstraint |
Author Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Author Security Types |
Name | Current Value |
Author Bound Attachments |
Name | Current Value |
Author Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical PUBL.Author |
NO | |||
ALARM_MYSQL (MySQL) Does Not Exist |
NO | |||
ALARM_ORACLE (Oracle) Does Not Exist |
NO | |||
BICS (Oracle) Does Not Exist |
NO | |||
BLM (Oracle) Does Not Exist |
NO | |||
BYPASS_REQ (Oracle) Does Not Exist |
NO | |||
CHAN_ARCH (Oracle) Does Not Exist |
NO | |||
CNMS_PRPSL (Oracle) Does Not Exist |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) Does Not Exist |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
NO | |||
ICS_SFTW_APPL (Oracle) Does Not Exist |
NO | |||
INSTR (Oracle) Does Not Exist |
NO | |||
Instrument Logbook (Oracle) Does Not Exist |
NO | |||
INVT (Oracle) Does Not Exist |
NO | |||
IONSRC (Oracle) Does Not Exist |
NO | |||
IONSRC1 (Oracle) Does Not Exist |
NO | |||
IPTSv5 (Oracle) Does Not Exist |
NO | |||
IRMISBase (Oracle) Does Not Exist |
NO | |||
Logbook (Oracle) Does Not Exist |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) Does Not Exist |
NO | |||
OPER (Oracle) Does Not Exist |
NO | |||
PART (Oracle) Does Not Exist |
NO | |||
PRINT (Oracle) Does Not Exist |
NO | |||
PROC (Oracle) Does Not Exist |
NO | |||
PRPSL (Oracle) Does Not Exist |
NO | |||
PUBL (Oracle) PUBL.AUTHOR |
NO | |||
PUBL_V1 (Oracle) Does Not Exist |
NO | |||
PV_LOGGER (Oracle) Does Not Exist |
NO | |||
SCORE (Oracle) Does Not Exist |
NO | |||
SICAT (Oracle) Does Not Exist |
NO | |||
SMPL (Oracle) Does Not Exist |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
Author Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Publication |
PUBL (Oracle) | Main Model |
Author Data Movement Rules |
Name | Type | Rule Text/Value |