| Device Physical Location |
| EntityType | Dependent |
| Logical Entity Name | Device Physical Location |
| Default Table Name | DVC_PHYS_LOC |
| Logical Only | NO |
| Owner | EPICS |
| Definition | Device Physical Location: The physical location for devices that are not associated to equipment. |
| Note |
| Device Physical Location Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Device Identifer |
Device Id | VARCHAR(50) | NO | Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
| Bldg Id | Building | VARCHAR(10) | NO | Building: The building number. |
| Area Id | Default Text | VARCHAR(50) | YES | Area Id: Generic area within a building. |
| Rm | VARCHAR(10) | YES | Room: Room number within a building. |
|
| Cab Row | VARCHAR(5) | YES | Cabinet Row: The row number is the device is a cabinet. |
|
| Cab Pos | VARCHAR(5) | YES | Cabinet Position: If the device is a cabinet this will the the positon of the cabinet within the row. |
| Device Physical Location Keys |
| Key Name | Key Type | Keys |
| DVC_PHYS_LOC_PK | PrimaryKey | Device Identifer |
| Device Physical Location Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Device | Identifying | One To Zero or More | Device Identifer | YES |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| Device Physical Location Check Constraints |
| Check Constraint Name | CheckConstraint |
| Device Physical Location Object Permissions |
| User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
| Device Physical Location Security Types |
| Name | Current Value |
| Device Physical Location Bound Attachments |
| Name | Current Value |
| Device Physical Location Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical EPICS.Device Physical Location |
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) EPICS.DVC_PHYS_LOC |
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 |
| Device Physical Location Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | EPICS |
| EPICS (Oracle) | Main Model |
| Device Physical Location Data Movement Rules |
| Name | Type | Rule Text/Value |