| Group Leader View |
| Name | Group Leader View |
| Owner | CNMS_PRPSL |
| Logical Only | NO |
| Definition | |
| Note | |
| DDL Code | CREATE VIEW CNMS_PRPSL."Group Leader View" AS SELECT Pro."Person Identifier", Pe."First Name", Pe."Last Name", Pe.Username, Pe."Email Address", 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 CNMS_PRPSL."Proposal Role Person Association" Pro, XF_ADMIN.Person Pe WHERE Pro."Person Identifier" = Pe."Person Identifier" AND Pro."Role Identifier" = 'GRP_LEAD' |
| Group Leader 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 | |
| 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 |
| Group Leader View Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical Group Leader 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) Group Leader 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 |
| Group Leader View Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | CNMS Proposal |
| CNMS_PRPSL (Oracle) | Main Model |
| Group Leader View Object Permissions |
| User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
| Group Leader View Security Types |
| Name | Current Value |
| Group Leader View Bound Attachments |
| Name | Current Value |