Person |
EntityType | Independent |
Logical Entity Name | Person |
Default Table Name | PERSON |
Logical Only | NO |
Owner | XF_ADMIN |
Definition | Person: External and internal person using the NScD Experimental Facilites systems. |
Note |
Person Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Person Identifier | VARCHAR(10) | NO | Person Identifier: Unique identifier for a person derived from XCAMS. |
|
Badge Number | Badge Number | VARCHAR(10) | YES | |
First Name | VARCHAR(64) | NO | First Name: Person first name. |
|
Last Name | VARCHAR(64) | NO | Last Name: person last name. |
|
Username | VARCHAR(64) | YES | Username: XCAMS computer username. |
|
Email Address | VARCHAR(100) | NO | Email Address: Person email address. |
|
Street Address | VARCHAR(128) | NO | Street Address: |
|
City | VARCHAR(100) | NO | City: |
|
State | VARCHAR(100) | NO | State: US state or country province. |
|
Postal Code | VARCHAR(20) | NO | Postal Code: |
|
Country Identifier | VARCHAR(10) | NO | Country Identifier: Abbreviated identrifier for a country. |
|
Phone Number | VARCHAR(20) | NO | Phone Number: Numeric text and separator characters possibly including country code. |
|
Cell Number | Phone | VARCHAR(20) | YES | |
Institute Identifier | INTEGER | NO | Institute Identifer: Abbreviated identifier for a institute. |
|
Institute Department | VARCHAR(100) | YES | ||
Notification Read Indicator | Indicator | CHAR(1) | NO | |
Personnel Access System Start Date | Date | DATE | NO | Date: Date and time to seconds. |
Personnel Access System End Date | Date | DATE | NO | Date: Date and time to seconds. |
Standard Access Training Expiration Date | Date | DATE | NO | Date: Date and time to seconds. |
SNS Access Expiration Date | Date | DATE | NO | Date: Date and time to seconds. |
HFIR Access Expiration Date | Date | DATE | NO | Date: Date and time to seconds. |
Radiological Worker Training Expiration Date | Date | DATE | NO | Date: Date and time to seconds. |
Organization Approval Date | Date | DATE | NO | Organization Approval Date: Date the request was sent for PAS approval by the instrument organization. (? ) |
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. |
Neutron School Student Indicator | Indicator | CHAR(1) | YES |
Person Keys |
Key Name | Key Type | Keys |
PK_PERSON | PrimaryKey | Person Identifier |
idx_username | Alternate Key | Username |
Person Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Country | Non-Identifying | One To Zero or More | Country Identifier | NO | |||
Institute | Non-Identifying | One To Zero or More | Institute Identifier | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Proposal Suggested Reviewer | Identifying | One To Zero or More | NO | ||||
Proposal Instrument | Non-Identifying | One To Zero or More | NO | ||||
Author | Non-Identifying | One To Zero or More | NO | ||||
Can Substrate Cell Usage | Non-Identifying | One To Zero or More | NO | ||||
Discretionary TIme Review | Non-Identifying | One To Zero or More | NO | ||||
ESH Administrator | Identifying | One To Zero or More | NO | ||||
Proposal Feasibility Review | Identifying | One To Zero or More | NO | ||||
Feedback | Identifying | One To Zero or More | NO | ||||
Group Leader Research Capability Association | Identifying | One To Zero or More | NO | ||||
Instrument Development Team Review | Identifying | One To Zero or More | NO | ||||
Instrument Development Team | Identifying | One To Zero or More | NO | ||||
Instrument Group Chair | Identifying | One To Zero or More | NO | ||||
Laboratory Training | Identifying | One To Zero or More | NO | ||||
Proposal Instrument | Non-Identifying | One To Zero or More | NO | ||||
Proposal Instrument | Non-Identifying | One To Zero or More | NO | ||||
Participant | Non-Identifying | One To Zero or More | NO | ||||
Proposal ESS Approval | Non-Identifying | One To Zero or More | NO | ||||
Proposal ESH Clarification | Identifying | One To Zero or More | NO | ||||
Proposal Feasibility Review History | Non-Identifying | One To Zero or More | NO | ||||
Proposal Operation Review Clarification | Identifying | One To Zero or More | NO | ||||
Proposal Review Committee | Non-Identifying | One To Zero or More | NO | ||||
Proposal | Non-Identifying | One To Zero or More | NO | ||||
Proposal Role Person Association | Identifying | One To Zero or More | NO | ||||
Proposal Role Person Association | Identifying | One To Zero or More | NO | ||||
Proposal Clarification | Identifying | One To Zero or More | NO | ||||
Proposal Review Committee | Identifying | One To Zero or More | NO | ||||
Proposal Science Review | Identifying | One To Zero or More | NO | ||||
Proposal Science Review | Identifying | One To Zero or More | NO | ||||
Proposal Science Review Committee Review | Identifying | One To Zero or More | NO | ||||
Proposal Staff Contact | Identifying | One To Zero or More | NO | ||||
Proposal Technical Contact | Identifying | One To Zero or More | NO | ||||
Proposal | Non-Identifying | One To Zero or More | NO | ||||
Proposal Team Member Onsite Access | Identifying | One To Zero or More | NO | ||||
Proposal Team Member Onsite Experiment Schedule Association | Identifying | One To Zero or More | NO | ||||
Review Subcommittee Person Association | Identifying | One To Zero or More | NO | ||||
Review Subcommittee Scribe | Identifying | One To Zero or More | NO | ||||
Sample | Non-Identifying | One To Zero or More | NO | ||||
Training Person | Identifying | One To Zero or More | NO | ||||
User Profile | Non-Identifying | One To Zero or More | NO | ||||
User Profile | Identifying | One To Zero or More | NO | ||||
User Publication | Identifying | One To Zero or More | NO | ||||
Validated Experiment Team Member | Identifying | One To Zero or More | NO |
Person Check Constraints |
Check Constraint Name | CheckConstraint |
Person Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
XF_ADMIN | Role | ALTER | Revoke | NO | NO |
XF_ADMIN | Role | DELETE | Grant | NO | NO |
XF_ADMIN | Role | INSERT | Grant | NO | NO |
XF_ADMIN | Role | REFERENCES | Revoke | NO | NO |
XF_ADMIN | Role | SELECT | Grant | NO | NO |
XF_ADMIN | Role | UPDATE | Grant | NO | NO |
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 |