Person: External and internal person using the NScD Experimental Facilites systems.

PERSON Columns

ColumnName	Domain	Datatype	NULL	Definition
PERSON_ID		VARCHAR2(10)	NO	Person Identifier: Unique identifier for a person derived from XCAMS.
BN	Badge Number	VARCHAR2(10)	YES
FIRST_NM		VARCHAR2(64)	NO	First Name: Person first name.
LAST_NM		VARCHAR2(64)	NO	Last Name: person last name.
USRNM		VARCHAR2(64)	YES	Username: XCAMS computer username.
EMAIL_ADDR		VARCHAR2(100)	NO	Email Address: Person email address.
ST_ADDR		VARCHAR2(128)	NO	Street Address:
CITY		VARCHAR2(100)	NO	City:
STATE		VARCHAR2(100)	NO	State: US state or country province.
POST_CD		VARCHAR2(20)	NO	Postal Code:
CNTRY_ID		VARCHAR2(10)	NO	Country Identifier: Abbreviated identrifier for a country.
PHONE_NBR		VARCHAR2(20)	NO	Phone Number: Numeric text and separator characters possibly including country code.
CELL_NBR	Phone	VARCHAR2(20)	YES
INST_ID		NUMBER(38, 0)	NO	Institute Identifer: Abbreviated identifier for a institute.
INST_DEPT		VARCHAR2(100)	YES
NOTIF_READ_IND	Indicator	CHAR(1)	NO

PERSON Primary and Unique Keys

Key Name	Key Type	Keys
idx_username	Index	USRNM
PK_PERSON	PrimaryKey	PERSON_ID

PERSON Foreign Keys

Parent Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Deferrable

Initially Deferred

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype	Deferrable	Initially Deferred
PRPSL_INSTR	Non-Identifying	One To Zero or More					NO	NO	YES
FEEDBACK	Identifying	One To Zero or More	FK_FEEDBACK_TO_PERSON				NO	NO	NO
IDT_REV	Identifying	One To Zero or More	FK_IDT_REV_TO_PERSON				NO	NO	NO
PRPSL_INSTR	Non-Identifying	One To Zero or More	FK_LOCAL_CONT_TO_PERSON				NO	NO	NO
PRPSL_INSTR	Non-Identifying	One To Zero or More	FK_OPER_FEAS_REV_TO_PERSON				NO	NO	NO
PRPSL_ESS_APPR	Non-Identifying	One To Zero or More	FK_PEA_TO_PERSON				NO	NO	NO
PRPSL_ROLE_PERS_ASSC	Identifying	One To Zero or More	FK_PRP_ASSC_TO_PERSON				NO	NO	NO
PRPSL_CLAR	Identifying	One To Zero or More	FK_PRPSL_CLAR_TO_PERSON				NO	NO	NO
PRPSL_SCI_REVIEW	Identifying	One To Zero or More	fk_prpsl_sci_rev_to_person_id				NO	NO	NO
PRPSL_SRC_REVIEW	Identifying	One To Zero or More	fk_prpsl_src_rev_to_person				NO	NO	NO
PROPOSAL	Non-Identifying	One To Zero or More	fk_prpsl_to_person				NO	NO	NO
PRPSL_TM_ONSITE_ACC	Identifying	One To Zero or More	FK_PTMOA_TO_PERSON				NO	NO	NO
PRPSL_TM_ONSITE_EXPT_SCH_ASSC	Identifying	One To Zero or More	FK_PTMOESA_TO_PERSON				NO	NO	NO
USER_PROFILE	Identifying	One To Zero or More	FK_USER_PROFILE_TO_PERSON				NO	NO	NO
VAL_EXPT_TEAM_MBR	Identifying	One To Zero or More	FK_VETM_TO_PERSON				NO	NO	NO

PERSON Check Constraints

Check Constraint Name

CheckConstraint

PERSON Storage

STORAGE OPTION	STORAGE VALUE
TABLESPACE
PctFree
PCTUSED
MinExtents
MaxExtents
Initial
Next
PctIncrease
InitTrans
MaxTrans
Organization	Heap
Cache	NO
Logging
Parallel	NO
Parallel Degrees
Parallel Instances
FREELISTS
FREELIST GROUPS
Buffer Pool
Table Compression	NO
Compress Expression
Row Movement	Disabled

PERSON Partitions

PARTITION PROPERTY

PARTITION PROPERTY VALUE

PERSON Growth Metrics

TABLE METRIC	TABLE METRIC VALUE
Current Row Count	0
Growth	Static
Growth Type	N/A
Growth Period	N/A
Maximum Rows	0
Average Row Size	0

PERSON Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

PERSON Security Types

Name	Current Value

PERSON Bound Attachments

Name	Current Value

PERSON Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical XF_ADMIN.Person	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) XF_ADMIN.PERSON	NO
DIAG (Oracle) Does Not Exist	NO
DIAG_MPS (Oracle) Does Not Exist	NO
ENGA (Oracle) XF_ADMIN.PERSON	NO
EPICS (Oracle) Does Not Exist	NO
EQUIP (Oracle) Does Not Exist	NO
EXPRESS (Oracle) XF_ADMIN.PERSON	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) XF_ADMIN.PERSON	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) XF_ADMIN.PERSON	NO
PUBL (Oracle) XF_ADMIN.PERSON	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.PERSON	NO

PERSON 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	Publication
CNMS_PRPSL (Oracle)	Main Model
ENGA (Oracle)	Main Model
EXPRESS (Oracle)	Main Model
IPTSv5 (Oracle)	Main Model
PRPSL (Oracle)	Main Model
PUBL (Oracle)	Main Model
XF_ADMIN (Oracle)	Main Model

PERSON Data Movement Rules

Name

Type

Rule Text/Value