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) ) NOCOMPRESS ; COMMENT ON COLUMN XF_ADMIN.PERSON.PERSON_ID IS 'Person Identifier: Unique identifier for a person derived from XCAMS.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.FIRST_NM IS 'First Name: Person first name.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.LAST_NM IS 'Last Name: person last name.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.USRNM IS 'Username: XCAMS computer username.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.EMAIL_ADDR IS 'Email Address: Person email address.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.ST_ADDR IS 'Street Address:' ; COMMENT ON COLUMN XF_ADMIN.PERSON.CITY IS 'City:' ; COMMENT ON COLUMN XF_ADMIN.PERSON.STATE IS 'State: US state or country province.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.POST_CD IS 'Postal Code:' ; COMMENT ON COLUMN XF_ADMIN.PERSON.CNTRY_ID IS 'Country Identifier: Abbreviated identrifier for a country.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.PHONE_NBR IS 'Phone Number: Numeric text and separator characters possibly including country code.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.INST_ID IS 'Institute Identifer: Abbreviated identifier for a institute.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.PAS_START_DTE IS 'Date: Date and time to seconds.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.PAS_END_DTE IS 'Date: Date and time to seconds.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.SAT_EXP_DTE IS 'Date: Date and time to seconds.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.SNS_ACC_EXP_DTE IS 'Date: Date and time to seconds.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.HFIR_ACC_EXP_DTE IS 'Date: Date and time to seconds.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.RWT_EXP_DTE IS 'Date: Date and time to seconds.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.ORG_APPR_DTE IS 'Organization Approval Date: Date the request was sent for PAS approval by the instrument organization. (? )' ; COMMENT ON COLUMN XF_ADMIN.PERSON.RESEARCH_ID IS '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.' ; COMMENT ON COLUMN XF_ADMIN.PERSON.ORCID_ID IS '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. Expressing the ORCID iD The ORCID iD is expressed as a HTTP URI; the number is proceeded by "http://orcid.org/". A hyphen is inserted every 4 digits to aid readability. Storage of the ORCID iD in a database The ORCID iD should always be expressed and stored as a URI: http://orcid.org/xxxx-xxxx-xxxx-xxxx (with the protocol (http://), and with hyphens in the number xxxx-xxxx-xxxx-xxxx).' ; COMMENT ON TABLE XF_ADMIN.PERSON IS 'Person: External and internal person using the NScD Experimental Facilites systems.' ; CREATE UNIQUE INDEX XF_ADMIN.idx_username ON XF_ADMIN.PERSON(USRNM) ; |
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 |
PK_PERSON | PrimaryKey | PERSON_ID |
idx_username | Index | USRNM |
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 | NO | ||||
CASC_USAGE | Non-Identifying | One To Zero or More | FK_CASC_USAGE_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 | |||
PROPOSAL | Non-Identifying | One To Zero or More | fk_prpsl_to_person | NO | NO | NO | |||
SAMPLE | Non-Identifying | One To Zero or More | fk_smpl_to_person | NO | NO | NO | |||
USER_PROF | Non-Identifying | One To Zero or More | FK_USER_PROF_TO_PERSON | NO | NO | NO |
PERSON Check Constraints |
Check Constraint Name | CheckConstraint |
PERSON Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | express_TS |
PctFree | 0 |
PCTUSED | |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | |
Next | |
PctIncrease | 0 |
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 |
EXPRESS_USER | Role | SELECT | 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 |