| Proposal Review Committee View |
| Name | Proposal Review Committee View |
| Owner | CNMS_PRPSL |
| Logical Only | NO |
| Definition | |
| Note | |
| DDL Code | CREATE VIEW CNMS_PRPSL."Proposal Review Committee View" AS SELECT 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 "Proposal Role Person Association" Pro, Person Pe |
| Proposal Review Committee View Columns |
| Column Name / Expression | Alias Name | Parent Table Name |
| Role Identifier | Proposal Role Person Association | |
| Person Identifier | Proposal Role Person Association | |
| First Name | Person | |
| Last Name | Person | |
| Username | Person | |
| Email Address | Person | |
| Exclude Indicator | Proposal Role Person Association | |
| 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 |
| Proposal Review Committee View Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical Proposal Review Committee 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) Proposal Review Committee 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 |
| Proposal Review Committee View Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | CNMS Proposal |
| CNMS_PRPSL (Oracle) | Main Model |
| Proposal Review Committee View Object Permissions |
| User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
| Proposal Review Committee View Security Types |
| Name | Current Value |
| Proposal Review Committee View Bound Attachments |
| Name | Current Value |