Cable_V |
Name | Cable_V |
Owner | |
Logical Only | NO |
Definition | |
Note | |
DDL Code | CREATE VIEW Cable_V AS SELECT Ca.ID, Ca."Device From" "Dvc From", Ca."DevFrom Rack Elev" "Dvc From Rack Elev", Ca."Device To" "Dvc To", Ca."Devto Rack Elev" "Dvc To Rack Elev", Ca.Function Func, Ca."Cable Type", Ca.WBS, Ca."Responsible Group" "Resp Grp", Ca.Source Src, Ca.Destination Dest, Ca."Devfrom Pinout Drwg Ref" "Dvc From Pinout Drwg Ref", Ca."Devfrom Label From" "Dvc From Lbl From", Ca."Devto Term Device" "Dvc To Term Dvc", Ca."Devto Pinout Drwg Ref" "Dvc To Pinout Drwng Ref", Ca."Devto Lable To" "Dvc To Lbl To", Ca."Tray Section" "Tray Sect", Ca.Lngth, Ca."Fabricated   By" "Fab By", Ca."Installation By" "Install By", Ca."Termination By" "Term By", Ca.Comments Cmnt, Ca.Importfile "Import File", Ca.Importdate "Import Dte", Ca."Import Range" "Import Rnge", Cab."Svc Req Ord", Cab."Dte Added", Cab."Post Inst Test Ind", Cab."Cable Test Ind", Cab."Start Mark Lngth", Cab."End Mark Length", Ca."Appr Dte", Ca."Devfrom Term Date", Ca."Devto Term Date", Ca."Work Package" FROM Cable Ca, "Cable Supplement" Cab |
Cable_V Columns |
Column Name / Expression | Alias Name | Parent Table Name |
ID | Cable | |
Device From | "Dvc From" | Cable |
DevFrom Rack Elev | "Dvc From Rack Elev" | Cable |
Device To | "Dvc To" | Cable |
Devto Rack Elev | "Dvc To Rack Elev" | Cable |
Function | Func | Cable |
Cable Type | Cable | |
WBS | Cable | |
Responsible Group | "Resp Grp" | Cable |
Source | Src | Cable |
Destination | Dest | Cable |
Devfrom Pinout Drwg Ref | "Dvc From Pinout Drwg Ref" | Cable |
Devfrom Label From | "Dvc From Lbl From" | Cable |
Devto Term Device | "Dvc To Term Dvc" | Cable |
Devto Pinout Drwg Ref | "Dvc To Pinout Drwng Ref" | Cable |
Devto Lable To | "Dvc To Lbl To" | Cable |
Tray Section | "Tray Sect" | Cable |
Lngth | Cable | |
Fabricated By | "Fab By" | Cable |
Installation By | "Install By" | Cable |
Termination By | "Term By" | Cable |
Comments | Cmnt | Cable |
Importfile | "Import File" | Cable |
Importdate | "Import Dte" | Cable |
Import Range | "Import Rnge" | Cable |
Svc Req Ord | Cable Supplement | |
Dte Added | Cable Supplement | |
Post Inst Test Ind | Cable Supplement | |
Cable Test Ind | Cable Supplement | |
Start Mark Lngth | Cable Supplement | |
End Mark Length | Cable Supplement | |
Appr Dte | Cable | |
Devfrom Term Date | Cable | |
Devto Term Date | Cable | |
Work Package | Cable |
Cable_V Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical Cable_V |
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_V Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Cable |
Cable_V Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Cable_V Security Types |
Name | Current Value |
Cable_V Bound Attachments |
Name | Current Value |