Publication Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Publication Identifer	Identifier	NUMERIC(38, 0)	NO
Title	Title	VARCHAR(1000)	NO
Status Identifier		VARCHAR(20)	YES	Status Identifer: Abbreviated idenfifer for the given status.
Publication Type Identifer		VARCHAR(20)	NO	Category Identifier: Abbreviated identifier for the user category.
Publication Volume		VARCHAR(256)	YES
Publication Page		VARCHAR(256)	YES
Publication Issue		VARCHAR(256)	YES
Publication Year		CHAR(4)	NO
Publication Month		VARCHAR(3)	YES
Digital Object Identifier	URL	VARCHAR(2048)	YES	Universal Resource Locator: The global address of documents and other resources on the web.
Journal Identifier	Identifier	NUMERIC(38, 0)	YES
Conference Identifier	Identifier	NUMERIC(38, 0)	YES
Proceeding Identifier	Identifier	NUMERIC(38, 0)	YES
Book Name	Name	VARCHAR(256)	YES	Name: A long description name usually accompanied by an abbreviated code.
Book Publisher Name	Name	VARCHAR(256)	YES	Name: A long description name usually accompanied by an abbreviated code.
Report Number		VARCHAR(120)	YES
Institute Identifier		INTEGER	YES	Institute Identifer: Abbreviated identifier for a institute.
Institute Name	Name	VARCHAR(120)	YES	Name: A long description name usually accompanied by an abbreviated code.
Dissertation Thesis Advisor		VARCHAR(120)	YES
Comment	Comment	VARCHAR(2000)	YES	Comment: General comments.
Create Date	Date	DATE	NO	Date: Date and time to seconds.
Modified By Userid	Mod By Uid	VARCHAR(64)	NO	Modified by Userid: The database userid of the person who inserted or update a record in the table.
Modify Date	Modify Date	DATE	NO	Modify Date: The date the entity values were were created or modified.
Submitted By Email Address	Email Addr	VARCHAR(75)	NO	Email Address:
Other Publication Name		VARCHAR(25)	YES
Other Publication Comment	Comment	VARCHAR(2000)	YES	Comment: General comments.
To Be Confimred Indicator	Indicator	CHAR(1)	NO	To Be Confimred Indicator: Used for some publications which are almost published, but the publisher does not allow citations or any reference before the paper is published officially ( like "Nature")

Publication Keys

Key Name	Key Type	Keys
PK_PUBL	PrimaryKey	Publication Identifer

Publication Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Conference	Non-Identifying	Zero or One to Zero or More				Conference Identifier	NO
Conference Proceeding	Non-Identifying	Zero or One to Zero or More				Conference Identifier, Proceeding Identifier	NO
Institute	Non-Identifying	Zero or One to Zero or More				Institute Identifier	NO
Journal	Non-Identifying	Zero or One to Zero or More				Journal Identifier	NO
Publication Type	Non-Identifying	One To Zero or More				Publication Type Identifer	NO
Status	Non-Identifying	Zero or One to Zero or More				Status Identifier	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Publication Facility Non_Instrument Association	Identifying	One To Zero or More					NO
Proposal Publication Association	Identifying	One To Zero or More					NO
Publication Instrument Assocation	Identifying	One To Zero or More					NO
Publication Log	Identifying	One To Zero or More					NO
Publication Proposal Instrument Association	Identifying	One To Zero or More					NO
Publication Research Area Association	Identifying	One To Zero or More					NO
Publication Special Recognition Association	Identifying	One To Zero or More					NO
Publication Author Association	Identifying	One To Zero or More					NO

Publication Check Constraints

Check Constraint Name

CheckConstraint

Publication Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Publication Security Types

Name	Current Value

Publication Bound Attachments

Name	Current Value

Publication Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical PUBL.Publication	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) PRPSL.PUBL	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) PUBL.PUBL	NO
PUBL (Oracle) PUBL.PUBL	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

Publication Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Integrated Proposal Tracking System
Logical	Publication
IPTSv5 (Oracle)	Main Model
PRPSL (Oracle)	Main Model
PUBL (Oracle)	Main Model

Publication Data Movement Rules

Name

Type

Rule Text/Value