PERSON |
Logical Entity Name | Person |
Default Table Name | PERSON |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | XF_ADMIN |
Definition | Person: External and internal person using the NScD Experimental Facilites systems. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE XF_ADMIN.PERSON(      PERSON_ID               VARCHAR2(10)      NOT NULL,      BN                      VARCHAR2(10),      FIRST_NM                VARCHAR2(64)      NOT NULL,      LAST_NM                 VARCHAR2(64)      NOT NULL,      USRNM                   VARCHAR2(64),      EMAIL_ADDR              VARCHAR2(100)     NOT NULL,      ST_ADDR                 VARCHAR2(128)     NOT NULL,      CITY                    VARCHAR2(100)     NOT NULL,      STATE                   VARCHAR2(100)     NOT NULL,      POST_CD                 VARCHAR2(20)      NOT NULL,      CNTRY_ID                VARCHAR2(10)      NOT NULL,      PHONE_NBR               VARCHAR2(20)      NOT NULL,      CELL_NBR                VARCHAR2(20),      INST_ID                 NUMBER(38, 0)     NOT NULL,      INST_DEPT               VARCHAR2(100),      NOTIF_READ_IND          CHAR(1)           DEFAULT 'N' NOT NULL,      PAS_START_DTE           DATE              DEFAULT sysdate NOT NULL,      PAS_END_DTE             DATE              DEFAULT sysdate NOT NULL,      SAT_EXP_DTE             DATE              DEFAULT sysdate NOT NULL,      SNS_ACC_EXP_DTE         DATE              DEFAULT sysdate NOT NULL,      HFIR_ACC_EXP_DTE        DATE              DEFAULT sysdate NOT NULL,      RWT_EXP_DTE             DATE              DEFAULT sysdate NOT NULL,      ORG_APPR_DTE            DATE              DEFAULT sysdate NOT NULL,      RESEARCH_ID             VARCHAR2(20),      ORCID_ID                VARCHAR2(255),      NEU_SCHOOL_STUD_IND     CHAR(1)           DEFAULT 'N',      CONSTRAINT PK_PERSON PRIMARY KEY (PERSON_ID)      USING INDEX          LOGGING ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; CREATE UNIQUE INDEX XF_ADMIN.idx_username ON XF_ADMIN.PERSON(USRNM)      LOGGING ; ALTER TABLE XF_ADMIN.PERSON ADD CONSTRAINT FK_PERSON_CNTRY_CNTRY      FOREIGN KEY (CNTRY_ID)      REFERENCES XF_ADMIN.CNTRY(CNTRY_ID) ; |
PostSQL |
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 | |
PAS_START_DTE | Date | DATE | NO | Date: Date and time to seconds. |
PAS_END_DTE | Date | DATE | NO | Date: Date and time to seconds. |
SAT_EXP_DTE | Date | DATE | NO | Date: Date and time to seconds. |
SNS_ACC_EXP_DTE | Date | DATE | NO | Date: Date and time to seconds. |
HFIR_ACC_EXP_DTE | Date | DATE | NO | Date: Date and time to seconds. |
RWT_EXP_DTE | Date | DATE | NO | Date: Date and time to seconds. |
ORG_APPR_DTE | Date | DATE | NO | Organization Approval Date: Date the request was sent for PAS approval by the instrument organization. (? ) |
RESEARCH_ID | Identifier | VARCHAR2(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_ID | URI | VARCHAR2(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. |
NEU_SCHOOL_STUD_IND | Indicator | CHAR(1) | YES |
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 |
CNTRY | Non-Identifying | One To Zero or More | FK_PERSON_CNTRY_CNTRY | CNTRY_ID | NO | NO | NO |
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 | ||||
DISCRET_TIME_REV | Non-Identifying | One To Zero or More | FK_DTR_TO_GL_PERSON | NO | NO | NO | |||
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 | |||
LAB_TRAIN | Identifying | One To Zero or More | FK_LAB_TRAIN_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_ESH_CLAR | Identifying | One To Zero or More | FK_PEC_TO_PERSON | NO | NO | NO | |||
PRPSL_FEAS_REV_HIST | Non-Identifying | One To Zero or More | fk_pfrh_to_person | NO | NO | NO | |||
PRPSL_OPN_REV_CLAR | Identifying | One To Zero or More | fk_porc_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 | |||
USER_PUBL | Identifying | One To Zero or More | fk_user_publ_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 |