WorkManager Model Schema

Introduction

This note describes the general schema for storing and ultimately searching documents stored in WorkManager for the Advanced Light Source.  The structure is based on the OSD 3-d Model and Document links with associated documents attached to the corresponding Master Data Records.  

This is a “living” document and will be updated as needs arise or change.  The most recent revision will be maintained on the ALS CAD website:  http://www-eng.lbl.gov/~als/WorkManager/

Schema

     OSD 3-d Model Documents

Each sector will have a top-level sector assembly (e.g. SECTOR_3_TOP_ASSY) that loads in ALS CAD coordinates and has a category code for itself and first level subassemblies of AL21-“sector number” (e.g. sector 3 category code = AL2103). This assembly will include, but not be limited to, the following sub-assemblies (examples are given for sector 3 and storage ring exit port 2):

•	BUILDING_ASSY in ALS CAD coordinates, containing building components (columns, walls, utility poles, floor, etc.).  Most components will have the sector level category code (e.g. AL2103).

•	EXPERIMENTAL_FLOOR_ASSY in ALS CAD coordinates containing beamline related experimental equipment not specific to an endstation assembly (workstations/racks, desks, partitions, etc.)  Most components will have the sector level category code (e.g. AL2103).

•	FRONT_END_ENVIRONMENT_ASSY in ALS CAD coordinates containing front-end components not specific to a particular front end (belly band, floor clips, cable trays, etc.)  Most components will have the sector level category code (e.g. AL2103).

•	STORAGE_RING_ASSY in ALS CAD coordinates containing storage ring components and associated hardware (Photon Stops, Magnets, etc.) with relevant items separated into the ARC_SECTOR_CHAMBER_ASSY and ID_STRAIGHT_ASSY.

•	SECTOR_3_WALL_ASSY in ALS CAD coordinates containing the sector storage ring shield walls.

•	PORT_3-2_ASSY - An assembly for the items connecting to each port of the storage ring in ALS CAD coordinates where “3” is the sector and “2” is the port number. The Master Data record for this document should be labeled with the MD Part type “PORT ASSY”.  If a user loads this assembly it will be located in its relative orientation around the storage ring. An example of common sub-assemblies, containers and their appropriate coordinate system are given below.  High-level sub-assemblies that are likely to be loaded alone should be located in the relevant parent assembly local coordinate system.  In all cases where a specific coordinate system is known for an assembly, it should be designated in the “Coord. Sys:” Work Manager Document field.

•	3-2_FRONT_END_ASSY in BL 3.2.1 coordinates
•	3-2_FAN_ASSY in BL 3.2.1 coordinates
•	3-2-1_CRITICAL_POINTS_ASSY in BL 3.2.1 coordinates
•	3-2-2_CRITICAL_POINTS_ASSY in BL 3.2.2 coordinates
•	3-2-1_BRANCHLINE_FRONT_END_ASSY in BL 3.2.1 coordinates
•	3-2-2_BRANCHLINE_FRONT_END_ASSY in BL 3.2.1 coordinates
•	3-2-1_BRANCHLINE_ASSY in BL 3.2.1 coordinates
•	3-2-2_BRANCHLINE_ASSY in BL 3.2.2 coordinates
•	3-2-1_HUTCH_ASSY in BL 3.2.1 coordinates
•	3-2-2_HUTCH_ASSY in BL 3.2.2 coordinates
•	3-2-1_ENDSTATION_ASSY in BL 3.2.1 coordinates
•	3-2-2_ENDSTATION_ASSY in BL 3.2.2 coordinates
•	SUPPLEMENTAL_DRAWINGS_ASSY – An assembly of containers that group sub-assemblies for specific drawing needs in the relevant local coordinate system (e.g. Bremsstrahlung Drawings, Installation Drawings, etc.)  View Sets refer to the assembly that is a child of the container of similar name (see below).

•	Container – SECTOR_3_COMPONENTS – Shared instances of sector parts/assemblies for lower level and Beamline Coordinate viewing.

•	An Alternate Parent Assembly for the items emanating from each port in Local Beam Line Coordinates. This assembly will be named as follows, BL_3-2-1_COORD_ASSY, and will be an alternate parent of PORT_3-2_ASSY that locates the PORT level assembly in the Beam Line Coordinate system designated by the assembly name.

o	Additionally, an Alternate Parent Assembly can be created by the same convention at any level.  For instance, it is often desirable to see neighboring beamline or experimental floor hardware in the Local Beam Line Coordinates of a different branchline.

     Associated Documents

Associated documents (2-d Drawings, Engineering Notes, Analysis, etc.) are stored in Work Manager and linked to the Master Data record for the relevant OSD 3-d Model Document.  2-d Annotation files should link automatically, however, additional documentation such as PDF, GIF, and eventually Word documents can be stored and attached to Master Data Records for archiving and revision control.