User Office View |
Name | User Office View |
Owner | CNMS_PRPSL |
Logical Only | NO |
Definition | |
Note | |
DDL Code | CREATE VIEW CNMS_PRPSL."User Office View" AS SELECT Pr."Person Identifier", Pe."First Name", Pe."Last Name", Pe.Username, Pe."Email Address", Pe."Badge Number", Pe."Personnel Access System Start Date", Pe."Personnel Access System End Date", Pe."Standard Access Training Expiration Date", Pe."SNS Access Expiration Date", Pe."HFIR Access Expiration Date", Pe."Radiological Worker Training Expiration Date", Pe."Organization Approval Date", Pe."Researcher Identifier", Pe."ORCID Identitifer", Pe."Neutron School Student Indicator" FROM XF_ADMIN.Person Pe, CNMS_PRPSL."Proposal Role Person Association" Pr WHERE Pr."Person Identifier" = Pe."Person Identifier" and Pr."Role Identifier" = 'USER_OFFICE' |
User Office View Columns |
Column Name / Expression | Alias Name | Parent Table Name |
Person Identifier | Proposal Role Person Association | |
First Name | Person | |
Last Name | Person | |
Username | Person | |
Email Address | Person | |
Badge Number | Person | |
Personnel Access System Start Date | Person | |
Personnel Access System End Date | Person | |
Standard Access Training Expiration Date | Person | |
SNS Access Expiration Date | Person | |
HFIR Access Expiration Date | Person | |
Radiological Worker Training Expiration Date | Person | |
Organization Approval Date | Person | |
Researcher Identifier | Person | |
ORCID Identitifer | Person | |
Neutron School Student Indicator | Person |
User Office View Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical User Office View |
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) User Office View |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) Does Not Exist |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
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) Does Not Exist |
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) Does Not Exist |
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) 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) Does Not Exist |
NO |
User Office View Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | CNMS Proposal |
CNMS_PRPSL (Oracle) | Main Model |
User Office View Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
User Office View Security Types |
Name | Current Value |
User Office View Bound Attachments |
Name | Current Value |