NONVAL_INST |
Logical Entity Name | Nonvalidated Institute |
Default Table Name | NONVAL_INST |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | XF_ADMIN |
Definition | Nonvalidated Institue: Institues that a PI has entered into the "Other" field indicating that their institute is not in the offical list. The user office will validate that the institute does indead need to be added and if so will update the institute on the proposal once the institute is added. Otherwise they will update the proposal PI institute with the correct institute. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE XF_ADMIN.NONVAL_INST(      NONVAL_INST_ID     NUMBER(38, 0)     NOT NULL,      INST_NM            VARCHAR2(120)     NOT NULL,      PRPSL_ID           NUMBER(10, 0),      INST_ID            NUMBER(38, 0),      EMAIL_ADDR         VARCHAR2(75),      CONSTRAINT PK_NONVAL_INST PRIMARY KEY (NONVAL_INST_ID),      CONSTRAINT RefINST1344 FOREIGN KEY (INST_ID)      REFERENCES XF_ADMIN.INST(INST_ID) )ORGANIZATION INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE XF_OPER_TS NOPARALLEL STORAGE(INITIAL 256K          NEXT 256K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          FREELISTS 1          FREELIST GROUPS 1          ) LOGGING ; |
PostSQL |
NONVAL_INST Columns |
ColumnName | Domain | Datatype | NULL | Definition |
NONVAL_INST_ID | NUMBER(38, 0) | NO | Nonvalidated Institute Identifier: Unique database sequence based numeric identifier. |
|
INST_NM | Name | VARCHAR2(120) | NO | Name: A long description name usually accompanied by an abbreviated code. |
PRPSL_ID | NUMBER(10, 0) | YES | Proposal Identifier: Unique identifer assigned to the proposal. |
|
INST_ID | NUMBER(38, 0) | YES | Institute Identifer: Abbreviated identifier for a institute. |
|
EMAIL_ADDR | Email Addr | VARCHAR2(75) | YES | Email Address: |
NONVAL_INST Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_NONVAL_INST | PrimaryKey | NONVAL_INST_ID |
NONVAL_INST Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
INST | Non-Identifying | Zero or One to Zero or More | INST_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
NONVAL_INST Check Constraints |
Check Constraint Name | CheckConstraint |
NONVAL_INST Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | XF_OPER_TS |
PctFree | 10 |
PCTUSED | |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 256 |
Next | 256 |
PctIncrease | 0 |
InitTrans | 2 |
MaxTrans | 255 |
Organization | Index-Organized |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | 1 |
FREELIST GROUPS | 1 |
Buffer Pool | |
Table Compression | NO |
Compress Expression | |
Row Movement | Disabled |
NONVAL_INST Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
NONVAL_INST 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 |
NONVAL_INST Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
NONVAL_INST Security Types |
Name | Current Value |
NONVAL_INST Bound Attachments |
Name | Current Value |
NONVAL_INST Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical XF_ADMIN.Nonvalidated Institute |
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) Does Not Exist |
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) XF_ADMIN.NONVAL_INST |
NO |
NONVAL_INST Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Experimental Facilities Administration |
XF_ADMIN (Oracle) | Main Model |
NONVAL_INST Data Movement Rules |
Name | Type | Rule Text/Value |