XF_ADMIN.Employee Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Badge Number		VARCHAR(10)	NO
User Identifier		VARCHAR(9)	YES
Employee Code		VARCHAR(9)	YES
Active Employee Indicator		VARCHAR(3)	YES
First Name	Name	VARCHAR(120)	YES	Name: A long description name usually accompanied by an abbreviated code.
Middle Name		VARCHAR(120)	YES	Name: A long description name usually accompanied by an abbreviated code.
Last Name	Name	VARCHAR(120)	YES	Name: A long description name usually accompanied by an abbreviated code.
Preferred First Name	Name	VARCHAR(120)	YES	Name: A long description name usually accompanied by an abbreviated code.
Preferred Middle Name	Name	VARCHAR(120)	YES	Name: A long description name usually accompanied by an abbreviated code.
Preferred Last Name	Name	VARCHAR(120)	YES	Name: A long description name usually accompanied by an abbreviated code.
Building	Building	VARCHAR(10)	YES	Building: The building number.
Room		VARCHAR(24)	YES
Mail Stop		VARCHAR(12)	YES
Work Phone Number		VARCHAR(30)	YES
Cell Number		VARCHAR(30)	YES
Email Address	Email Addr	VARCHAR(75)	YES	Email Address:

XF_ADMIN.Employee Keys

Key Name	Key Type	Keys
PK_EMPLOYEE	PrimaryKey	Badge Number

XF_ADMIN.Employee Relationships

Parent Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Access Request	Identifying	One To Zero or More					NO
Control Area Custodian	Identifying	One To Zero or More					NO
Control Area Inventory	Non-Identifying	One To Zero or More					NO
Dialog	Non-Identifying	One To Zero or More					NO
Experiment Laboratory Schedule	Non-Identifying	One To Zero or More					NO
Express Role Person Association	Non-Identifying	One To Zero or More					NO
Experiment Resource Personnel Training	Identifying	One To Zero or More					NO
Experiment Schedule Local Contact Association	Identifying	One To Zero or More					NO
Experiment Resource Schedule	Non-Identifying	One To Zero or More					NO
Experiment Resource Personnel Absence	Identifying	One To Zero or More					NO
Experiment Resource Personnel Association	Identifying	One To Zero or More					NO
Experiment Schedule	Non-Identifying	One To Zero or More					NO
Instrument	Non-Identifying	One To Zero or More					NO
Instrument Scientist	Identifying	One To Zero or More					NO
Instrument Support	Identifying	One To Zero or More					NO
Sample Shipment	Non-Identifying	One To Zero or More					NO
Proposal Review Committee	Non-Identifying	One To Zero or More					NO
Experiment Resource Personnel Resource	Identifying	One To Zero or More					NO
Sample Delivery Request	Non-Identifying	Zero or One to Zero or More					NO
Sample Role Employee Association	Identifying	One To Zero or More					NO
Sample Shipment	Non-Identifying	One To Zero or More					NO
Training Person	Non-Identifying	Zero or One to Zero or More					NO
User Email Template Association	Identifying	One To Zero or More					NO
User Profile	Identifying	One To Zero or More					NO
User Profile	Non-Identifying	Zero or One to Zero or More					NO
User Profile	Identifying	One To Zero or More					NO
Validated Experiment Team Member	Non-Identifying	One To Zero or More					NO

XF_ADMIN.Employee Check Constraints

Check Constraint Name

CheckConstraint

XF_ADMIN.Employee Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

XF_ADMIN.Employee Security Types

Name	Current Value

XF_ADMIN.Employee Bound Attachments

Name	Current Value

XF_ADMIN.Employee Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical XF_ADMIN.Employee	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) OPER.EMPLOYEE	NO
CHAN_ARCH (Oracle) Does Not Exist	NO
CNMS_PRPSL (Oracle) XF_ADMIN.EMPLOYEE	NO
DIAG (Oracle) Does Not Exist	NO
DIAG_MPS (Oracle) Does Not Exist	NO
ENGA (Oracle) XF_ADMIN.EMPLOYEE	NO
EPICS (Oracle) Does Not Exist	NO
EQUIP (Oracle) Does Not Exist	NO
EXPRESS (Oracle) XF_ADMIN.EMPLOYEE	NO
ICS_SFTW_APPL (Oracle) EMPLOYEE	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) XF_ADMIN.EMPLOYEE	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) OPER.EMPLOYEE	NO
PART (Oracle) Does Not Exist	NO
PRINT (Oracle) Does Not Exist	NO
PROC (Oracle) Does Not Exist	NO
PRPSL (Oracle) XF_ADMIN.EMPLOYEE	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) XF_ADMIN.EMPLOYEE	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.EMPLOYEE	NO

XF_ADMIN.Employee Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	CNMS Proposal
Logical	Engagement Tracking
Logical	Experimental Facilities Administration
Logical	Express
Logical	Integrated Proposal Tracking System
Logical	Sample
BYPASS_REQ (Oracle)	Main Model
CNMS_PRPSL (Oracle)	Main Model
ENGA (Oracle)	Main Model
EXPRESS (Oracle)	Main Model
ICS_SFTW_APPL (Oracle)	Main Model
IPTSv5 (Oracle)	Main Model
OPER (Oracle)	Main Model
OPER (Oracle)	OPM
PRPSL (Oracle)	Main Model
SMPL (Oracle)	Main Model
XF_ADMIN (Oracle)	Main Model

XF_ADMIN.Employee Data Movement Rules

Name

Type

Rule Text/Value