Proposal Email Preview: Email header and body information for emails generated by User email templates.

CNMS_PRPSL.Email Preview Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Template Identifier		NUMERIC(3, 0)	NO	Template Identiifer: Unique identifier for the email template.
Sequence Identifer	Sequence	INTEGER	NO	Sequence: A numerical primary key value derived from a Sequence.
Recipient Email Address	Email Addr	VARCHAR(75)	NO	Email Address:
Proposal Identifier		NUMERIC(10, 0)	YES	Proposal Identifier: Unique identifer assigned to the proposal.
Proposal Identifier		VARCHAR(10)	YES	Proposal Identifier: Unique identifer assigned to the proposal.
From Email Address	Email Addr	VARCHAR(200)	YES	Email Address:
Email Subject		VARCHAR(500)	NO	Email Subject: The subject of the email.
Email Text		VARCHAR(4000)	NO	Email Text: The body of the email.
Carbon Copy Email Address	Email Addr	VARCHAR(4000)	YES	Email Address:
Current Date	Date	DATE	NO	Date: Date and time to seconds.

CNMS_PRPSL.Email Preview Keys

Key Name	Key Type	Keys
PK_EMAIL_PREV	PrimaryKey	Template Identifier, Sequence Identifer

CNMS_PRPSL.Email Preview Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Proposal	Non-Identifying	Zero or One to Zero or More				Proposal Identifier	NO
Proposal	Non-Identifying	Zero or One to Zero or More				Proposal Identifier	NO
Email Template	Identifying	One To Zero or More				Template Identifier	NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

CNMS_PRPSL.Email Preview Check Constraints

Check Constraint Name

CheckConstraint

CNMS_PRPSL.Email Preview Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

CNMS_PRPSL.Email Preview Security Types

Name	Current Value

CNMS_PRPSL.Email Preview Bound Attachments

Name	Current Value

CNMS_PRPSL.Email Preview Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical CNMS_PRPSL.Email Preview	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) CNMS_PRPSL.EMAIL_PREV	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) Does Not Exist	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) XF_ADMIN.EMAIL_PREV	NO

CNMS_PRPSL.Email Preview Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	CNMS Proposal
CNMS_PRPSL (Oracle)	Main Model
XF_ADMIN (Oracle)	Main Model

CNMS_PRPSL.Email Preview Data Movement Rules

Name

Type

Rule Text/Value