Nonvalidated Institute |
EntityType | Independent |
Logical Entity Name | Nonvalidated Institute |
Default Table Name | NONVAL_INST |
Logical Only | NO |
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 |
Nonvalidated Institute Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Nonvalidated Institute Identifier | INTEGER | NO | Nonvalidated Institute Identifier: Unique database sequence based numeric identifier. |
|
Institute Name | Name | VARCHAR(120) | NO | Name: A long description name usually accompanied by an abbreviated code. |
Proposal Identifier | NUMERIC(10, 0) | YES | Proposal Identifier: Unique identifer assigned to the proposal. |
|
Institute Identifier | INTEGER | YES | Institute Identifer: Abbreviated identifier for a institute. |
|
Email Addr | Email Addr | VARCHAR(75) | YES | Email Address: |
Nonvalidated Institute Keys |
Key Name | Key Type | Keys |
PK_NONVAL_INST | PrimaryKey | Nonvalidated Institute Identifier |
Nonvalidated Institute Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Institute | Non-Identifying | Zero or One to Zero or More | Institute Identifier | NO | |||
Proposal | Non-Identifying | Zero or One to Zero or More | Proposal Identifier | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Nonvalidated Institute Check Constraints |
Check Constraint Name | CheckConstraint |
Nonvalidated Institute Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Nonvalidated Institute Security Types |
Name | Current Value |
Nonvalidated Institute Bound Attachments |
Name | Current Value |
Nonvalidated Institute 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 |
Nonvalidated Institute Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Experimental Facilities Administration |
XF_ADMIN (Oracle) | Main Model |
Nonvalidated Institute Data Movement Rules |
Name | Type | Rule Text/Value |