Cable:  A length of wire used to connect devices.

Cable Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
SNS Cable Nbr		VARCHAR(50)	NO	SNS Cable Number: The unique number assigned to the cable used for identification.
ID		NUMERIC(38, 0)	NO	Cable Identifier
Cable Type		VARCHAR(50)	YES	Cable Type
Lab Code		VARCHAR(4)	YES	Laboratory Code
Subproject		VARCHAR(50)	YES	Sub Project
WBS		VARCHAR(50)	YES	Work Breakdown Structure
System		VARCHAR(50)	YES	System
Subsystem		VARCHAR(50)	YES	Sub System
Responsible Group		VARCHAR(50)	YES	Responsible Group
Source		VARCHAR(50)	YES	Source
Destination		VARCHAR(50)	YES	Destination
Device From		VARCHAR(100)	YES	Device From
DevFrom Rack Elev		VARCHAR(20)	YES	Device From Rack Elevation
Devfrom Tunnel Pos		VARCHAR(20)	YES	Device From Tunnel Position
Devfrom Tray Segment Entry		VARCHAR(50)	YES	Device From Tray Segment Entry
Devfrom Term Device		VARCHAR(100)	YES	Device From Termination Device
Devfrom Term Date	Date	DATE	YES	Device From Termination Date: The date the cable was actually terminated to the the from device.
Devfrom Termtype		VARCHAR(50)	YES	Device From Termination Type
Devfrom Pinout Drwg Ref		VARCHAR(30)	YES	Device From Pinout Drawing Reference
Devfrom Label From		VARCHAR(50)	YES	Device From Label From
Device To		VARCHAR(100)	YES	Device To
Devto Rack Elev		VARCHAR(20)	YES	Device To Rack Elevation
Devto Tunnel Pos		VARCHAR(20)	YES	Device To Tunnel Position
Devto Tray Segment Exit		VARCHAR(50)	YES	Device To Tray Segment Exit
Devto Term Device		VARCHAR(100)	YES	Device To Termination Device
Devto Termtype		VARCHAR(50)	YES	Device To Termination Type
Devto Term Date	Date	DATE	YES	Device To Termination Date: The date the cable was actually terminated to the the to device.
Devto Pinout Drwg Ref		VARCHAR(30)	YES	Device To Pinout Drawing Reference
Devto Lable To		VARCHAR(50)	YES	Device To Label To
Tray Section		VARCHAR(50)	YES	Tray Section
Penetration Number		VARCHAR(50)	YES	Penetration Number
Z Position		VARCHAR(50)	YES	Z Position
Lngth		NUMERIC(38, 0)	YES	Length: The length of the cable by unit of measure.
Unit Of Measure		VARCHAR(50)	NO	Unit of Measure: A field used to define a unique unit of measure.
Function		VARCHAR(50)	YES	Function
Expected Current		NUMERIC(38, 0)	YES	Expected Current: Expected current for cable
Current Unit		VARCHAR(50)	YES	Current Unit: The current unit of measure
Fabricated By		VARCHAR(50)	YES	Fabrication By: The userid of the person who made the cable.
Installation By		VARCHAR(50)	YES	Installation By: The userid of the person who installed the cable.
Termination By		VARCHAR(50)	YES	Termination By: The userid of the person who terminated the cable
Comments		VARCHAR(100)	YES
Importfile		VARCHAR(100)	YES
Importdate		DATE	YES
Import Range		VARCHAR(50)	YES
Appr Dte		DATE	YES	Approved Date: Indicates the date when the cable was approved for use. This attribute is primarily used by the Diagnostics group.
Work Package		VARCHAR(20)	YES	Work Package: The work package in which the cable pull/installation resides.

Cable Keys

Key Name	Key Type	Keys
cable_pk	PrimaryKey	SNS Cable Nbr

Cable Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Unit of Measure	Non-Identifying	One To Zero or More				Unit Of Measure	NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Cable Check Constraints

Check Constraint Name

CheckConstraint

Cable Object Permissions

User/Role Name

Grantee Type

Permission Type

Action Type

Is Action Extended

Is System

Cable Security Types

Name	Current Value

Cable Bound Attachments

Name	Current Value

Cable Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical CABLE.Cable	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) Does Not Exist	NO

Cable Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	Cable

Cable Data Movement Rules

Name

Type

Rule Text/Value