Instrument Unavailable |
EntityType | Dependent |
Logical Entity Name | Instrument Unavailable |
Default Table Name | INSTR_UNAVAIL |
Logical Only | NO |
Owner | XF_ADMIN |
Definition | Instrument Unavailable: Date when the the insturment is unvailable for use. This date is superseded by the Run Cycle date so an instrument is marked as unavailable here only if it during ther Run Cycle. |
Note |
Instrument Unavailable Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Instrument Identifier | VARCHAR(20) | NO | Instrument Identifier: Abbreviated identier for the instrument. |
|
Begin Date | Date | DATE | NO | Date: Date and time to seconds. |
End Date | Date | DATE | NO | Date: Date and time to seconds. |
Instrument Unavailable Keys |
Key Name | Key Type | Keys |
PK_INSTR_UNAVAIL | PrimaryKey | Instrument Identifier, Begin Date, End Date |
Instrument Unavailable Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Instrument | Identifying | One To Zero or More | Instrument Identifier | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Instrument Unavailable Check Constraints |
Check Constraint Name | CheckConstraint |
Instrument Unavailable Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Instrument Unavailable Security Types |
Name | Current Value |
Instrument Unavailable Bound Attachments |
Name | Current Value |
Instrument Unavailable Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical XF_ADMIN.Instrument Unavailable |
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.INSTR_UNAVAIL |
NO |
Instrument Unavailable Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Experimental Facilities Administration |
XF_ADMIN (Oracle) | Main Model |
Instrument Unavailable Data Movement Rules |
Name | Type | Rule Text/Value |