EQUIP |
Logical Entity Name | Equipment |
Default Table Name | EQUIP |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | |
Definition | Equipment: The list of equipment currently at the SNS site. Equipment includes items than may or may not be used in Devices (i.e. beam line). |
Note | |
PreSQL | |
DDL Code | CREATE TABLE EQUIP(      "Equip Id"              VARCHAR2(30)       NOT NULL,      "Equip Nm"              VARCHAR2(120),      "Parent Equipment ID"   VARCHAR2(30),      "ORNL Prop Nbr"         VARCHAR2(7),      "Drw Nbr"               VARCHAR2(50),      "Ser Nbr"               VARCHAR2(50)       NOT NULL,      "Mnfctr Dte"            DATE               DEFAULT sysdate,      "Calib Rqd Ind"         CHAR(1)            DEFAULT 'N' NOT NULL,      "Last Calib Dte"        DATE               DEFAULT sysdate NOT NULL,      "Qual Grade Lvl"        CHAR(1),      NOTE                    VARCHAR2(4000),      MOD_DATE                DATE               NOT NULL,      "Mod By Uid"            VARCHAR2(64)       NOT NULL,      CONSTRAINT equip_pk PRIMARY KEY ("Equip Id")      USING INDEX          LOGGING,      CONSTRAINT parent_equip_rf FOREIGN KEY ("Parent Equipment ID")      REFERENCES EQUIP("Equip Id") ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
EQUIP Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Equip Id | Asset Identifier | VARCHAR2(30) | NO | Equipment Identifier: The SNS barcode number used to uniquely identify equipment. |
Equip Nm | Name | VARCHAR2(120) | YES | Equipment Name: The name associated with the piece of equipment. If a manufacturer model name is available this field will automatically be populated with the model name. The user may select a "standard" equipment name from the "equipment name" table. |
Parent Equipment ID | Asset Identifier | VARCHAR2(30) | YES | Parent Equipment Identifier: If the current piece of equipment is a component of another piece of equipment, this field will contain the parent equipment identifier. |
ORNL Prop Nbr | VARCHAR2(7) | YES | Oak Ridge National Laboratory Property Number: A unique number assigned by ORNL to the equipment for tracking and inventory purposes. |
|
Drw Nbr | Default Text | VARCHAR2(50) | YES | Drawing Number: The number assigned to the drawing depicting the configuration of the equipment. |
Ser Nbr | Default Text | VARCHAR2(50) | NO | Serial Number: The manufacturer serial number of the equipment. |
Mnfctr Dte | Date | DATE | YES | Manufacture Date: The day the item was created by the manufacturer. |
Calib Rqd Ind | Indicator | CHAR(1) | NO | Calibration Required Indicator: When set to "Y" indicated the equipment requires calibration. Default is "N" |
Last Calib Dte | Date | DATE | NO | Last Calibration Date: The date when the equipment was last calibrated. |
Qual Grade Lvl | CHAR(1) | YES | Quality Grade Level: The quality grade level as defined in the Spallation Neutron Source Quality Assurance Plan: SNS-QA-P01 |
|
NOTE | Note | VARCHAR2(4000) | YES | Notes: A free form text field used to describe a piece of equipment. |
MOD_DATE | Modify Date | DATE | NO | Modify Date: The day and time the Equipment record was modified. |
Mod By Uid | Mod By Uid | VARCHAR2(64) | NO | Modified By Userid: The userid of the person who modified the equipment record. |
EQUIP Primary and Unique Keys |
Key Name | Key Type | Keys |
equip_pk | PrimaryKey | Equip Id |
EQUIP Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
EQUIP | Non-Identifying | Zero or One to Zero or More | parent_equip_rf | Parent Equipment ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
Equip_Dvc_Asgn | Identifying | One To Zero or More | equip_dvc_asgn2_rf | is involved in | uses | NO | NO | NO | |
EQUIP | Non-Identifying | One To Zero or More | parent_equip_rf | NO | NO | NO |
EQUIP Check Constraints |
Check Constraint Name | CheckConstraint |
EQUIP Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
PCTUSED | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Compress Expression | |
Row Movement | Disabled |
EQUIP Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
EQUIP 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 |
EQUIP Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
EQUIP Security Types |
Name | Current Value |
EQUIP Bound Attachments |
Name | Current Value |
EQUIP Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EQUIP.Equipment |
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) EQUIP |
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) EQUIP |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
EQUIP Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Equipment |
Logical | Equipment - Equip Rcpt |
Logical | Power Supply |
Logical | XAL Optics |
EQUIP (Oracle) | Main Model |
XAL_OPTICS (Oracle) | Main Model |
EQUIP Data Movement Rules |
Name | Type | Rule Text/Value |