Side Navigation

From Emprise Wiki
Jump to: navigation, search

SAMM 1.0 Navigations

Vessel - Vessel

Samm-universal-hf-nav panel options-vessel-description sub description-20192111-an.png

Nav. Type

Vessel


Hierarchy

Vessel

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Leaf Vessel USNS Big Horn
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.


Vessel - Class

Samm-universal-hf-nav panel options-class-vessel-description sub description-20192111-an.png

Nav. Type

Vessel


Hierarchy

Class

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Class TAO 187
Leaf Vessel USNS Diehl
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Vessel - PM

Samm-universal-hf-nav panel options-pm-vessel-description sub description-20192111-an.png

Nav. Type

Vessel


Hierarchy

PM

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 PM PM1
Leaf Vessel USNS Kaiser
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Vessel - Hull

Samm-universal-hf-nav panel options-hull-vessel-description sub description-20192111-an.png

Nav. Type

Vessel


Hierarchy

Hull

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Leaf Hull - Vessel T-AO 187 - USNS Kaiser
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

SAMM 2.0 Navigations

Navigation Options

Samm-universal-hf-nav panel options-20190520-sg.png


Navigation Type: Vessel Equipment

Hierarchy: System/ Description

Vessel Class PM
Nav - Vessel Equipment - System - Description.png Nav - Vessel Equipment - System - Description - Class.png Nav - Vessel Equipment - System - Description - PM.png
  • Root Node
  • Example
  • Qualifier
  • All
  • All Vessels
  • (null)
  • All
  • All Vessels
  • (null)
  • All
  • All Vessels
  • (null)
  • Node 1
  • Example
  • Qualifier
  • Vessel (Vessels.VesselName)
  • USNS Big Horn
  • -
  • Class (-)
  • TAO 187
  • -
  • PM (-)
  • PM1
  • -
  • Node 2
  • Example
  • Qualifier
  • System (SAMM.VesselsEquipmentSystems)
  • Compressed Air
  • VesselId=#,EquipmentSystemId=#
  • Vessel (Vessels.VesselName)
  • USNS Big Horn
  • -
  • Vessel (Vessels.VesselName)
  • USNS Big Horn
  • -
  • Node 3
  • Example
  • Qualifier
  • Description ((SAMM.VesselsEquipmentSystems)
  • Compressors
  • VesselId=#,EquipmentSystemId=#, EquipmentClassificationId=#
  • System (SAMM.VesselsEquipmentSystems)
  • Compressed Air
  • VesselId=#,EquipmentSystemId=#
  • System (SAMM.VesselsEquipmentSystems)
  • Compressed Air
  • VesselId=#,EquipmentSystemId=#
  • Node 4
  • Example
  • Qualifier
  • N/A
  • Description (SAMM.VesselsEquipmentSystems)
  • Compressors
  • VesselId=#,EquipmentSystemId=#, EquipmentClassificationId=#
  • Description (SAMM.VesselsEquipmentSystems)
  • Compressors
  • VesselId=#,EquipmentSystemId=#, EquipmentClassificationId=#
  • Leaf
  • Example
  • Qualifier
  • Equipment (VesselsEquipment.VesselEquipmentDesc)
  • Control Air Compressor
  • VesselId=#,EquipmentSystemId=#, EquipmentClassificationId=#,EquipmentId=#
  • Equipment (VesselsEquipment.VesselEquipmentDesc)
  • Control Air Compressor
  • VesselId=#,EquipmentSystemId=#, EquipmentClassificationId=#,EquipmentId=#
  • Equipment (VesselsEquipment.VesselEquipmentDesc)
  • Control Air Compressor
  • VesselId=#,EquipmentSystemId=#, EquipmentClassificationId=#,EquipmentId=#


Notes

  • Tree is pulling from the table: SAMM.VesselsEquipmentSystems
  • Empty Nodes are Not Displayed
  • My Items node shall be added in the Feedback module. Click here for documentation.


Example SQL to build Navigation Tree Conceptually

SELECT

       'ALL Vessels' as "Root Node",
       Vessels.VesselName as "Node 1", 
       EquipmentSystems.EquipmentSystemDescription as "Node 2", 
       EquipmentClassifications.EquipmentClassificationDescription as "Node 3", 
       VesselEquipmentDesc as Leaf, 
       SUM(VesselEquipmentIsActive) as NumberofSourceEquipmentforMainGridRecords 

FROM

       SAMM.Vessels JOIN 
       SAMM.VesselsEquipment JOIN 
       SAMM.VesselsEquipmentSystems JOIN -- Note this limits the Displayed Systems and Descriptions to what is on the vessel(s) 
       SAMM.EquipmentSystems JOIN 
       SAMM.EquipmentClassifications JOIN 
       SAMM.VesselsEquipmentLocations -- This Join limits the equipment that has Locations to ensure we are not just displaying HSC Placeholders 

WHERE

       VesselEquipmentIsActive = 1 AND 
       VesselsEquipment.OperationalStatusId is not null -- This Join limits the equipment that has OperationStatusId to ensure we are not just displaying HSC Placeholders 

GROUP BY

       Vessels.VesselName, 
       SAMM.EquipmentSystems.EquipmentSystemDescription, 
       SAMM.EquipmentClassifications.EquipmentClassificationDescription, 
       VesselEquipmentDesc 
       WITH ROLLUP 

ORDER BY

       Vessels.VesselName, 
       EquipmentSystems.EquipmentSystemDescription, 
       EquipmentClassifications.EquipmentClassificationDescription, 
       VesselEquipmentDesc 

Hierarchy: Description

Nav - Vessel Equipment - Description.png

Nav. Type

Vessel Equipment


Hierarchy

Description

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Vessel (Vessels.VesselName) Darnell Vessel=#
Node 2 Description (EquipmentClassifications.EquipmentClassificationDescription) Compressors VesselId=#,EquipmentClassificationId=#
Leaf Equipment (VesselsEquipment.VesselEquipmentDesc) CONTROL AIR COMPRESSOR VesselId=#,EquipmentClassificationId=#,EquipmentId=#
Main Grid Data SMH.HistoryItems Qualified as above with the Qualifier Note: ensure Classification ID in SMH.HistoryItems comes from VesselsEquipmentSystems

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

SELECT

       'ALL Vessels' as "Root Node",
       Vessels.VesselName as "Node 1", 
       EquipmentClassifications.EquipmentClassificationDescription as "Node 2", 
       VesselEquipmentDesc as Leaf, 
       SUM(VesselEquipmentIsActive) as NumberofSourceEquipmentforMainGridRecords 

FROM

       SAMM.Vessels JOIN 
       SAMM.VesselsEquipment JOIN 
       SAMM.VesselsEquipmentSystems JOIN -- Note this limits the Displayed Systems and Descriptions to what is on the vessel(s) 
       SAMM.EquipmentSystems JOIN 
       SAMM.EquipmentClassifications JOIN 
       SAMM.VesselsEquipmentLocations -- This Join limits the equipment that has Locations to ensure we are not just displaying HSC Placeholders 

WHERE

       VesselEquipmentIsActive = 1 AND 
       VesselsEquipment.OperationalStatusId is not null -- This Join limits the equipment that has OperationStatusId to ensure we are not just displaying HSC Placeholders 

GROUP BY

       Vessels.VesselName, 
       SAMM.EquipmentClassifications.EquipmentClassificationDescription, 
       VesselEquipmentDesc 
       WITH ROLLUP 

ORDER BY

       Vessels.VesselName, 
       EquipmentClassifications.EquipmentClassificationDescription, 
       VesselEquipmentDesc 

Hierarchy: Equipment HSC

Nav - Vessel Equipment - Equipment HSC.png

Nav. Type

Vessel Equipment


Hierarchy

Equipment HSC

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Vessel (Vessels.VesselName) USNS Diehl Vessel=#
Node 2 Equipment (VesselsEquipment.VesselEquipmentDesc) || (HSC) Hull Structure, General (10000) VesselId=#,HSC=# and Lower HSCs
Node 3 Equipment (VesselsEquipment.VesselEquipmentDesc) || (HSC) Hull (11000) VesselId=#,HSC=# and Lower HSCs
Leaf Equipment (VesselsEquipment.VesselEquipmentDesc) VesselId=#, HSC=#,EquipmentId=#
Main Grid Data SMH.HistoryItems Limited to WHERE Note: ensure SystemID and Classification ID in SMH.HistoryItems comes from VesselsEquipmentSystems

Notes

  • Node Level 2 is based upon the Left Most Digit of a 5 digit HSC and Zeros or Null to the right
  • Node Level 3 is based upon the Left Most TWO Digit of a 5 digit HSC and Zeros or Null to the right
  • If the HSC chain is broken we shouldn't show anything after the break
  • Have a query that is run regularly (monthly) to identify these breaks and to submit a feedback to have the equipment added to fix the chain

Example SQL to build Navigation Tree Conceptually

Further Explanation

       ALL HSCs need to be a minimum of 5 digits, if less padd right with Zeros
       Top HSCs are 10000, 20000, 30000, etc
       Under 10000  would be 1?000
       Under 11000  would be 11?00
       Under 11100  would be 111?0
       Under 11110  would be 1111?
       Under 11111  would be 11111?
       Under 111111 would be 111111?

Hierarchy: Location

Nav - Vessel Equipment - Location.png

Nav. Type

Vessel Equipment


Hierarchy

Location

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Vessel (Vessels.VesselName) USNS Able Vessel=#
Node 2 Deck 04
Node 3 Deck-Frame-Side 04-2-6
Leaf Equipment (VesselsEquipment.VesselEquipmentDesc) CONTROL AIR COMPRESSOR
Main Grid Data

Notes

  • Empty Nodes are Not Displayed
  • Deck values can be any of the following values, 04, 03, 02, 01, 1, 2, 3, 4, 5, 6. A zero precedes the deck number for levels that are above the main deck.
  • Frame Values range from 1–20 and side values range from 0–6

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Test Type

Nav - Vessel Equipment - Test Type.png

Nav. Type

Vessel Equipment


Hierarchy

Test Type

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Vessel USNS Able
Node 2 Test Type Fuel Oil
Lube Oil
Recip. Analysis
Special Test
Thermography
Vibration
Water Chemistry
Node 3 Equipment System (SAMM.VesselsEquipmentSystems) Cooling Water
Node 4 Description (SAMM.VesselsEquipmentSystems) Pump
Leaf CM Item
Main Grid Data

Notes

  • Tree is based on Equipment in SAMM.VesselsEquipmentSystems
  • Nav. Type shall default to Equipment and is the only selection option.
  • All Test Types shall be present, even if the ship has no records for that Test Type.
  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Navigation Type: Equipment

Hierarchy: System/ Description

Nav - Equipment - System - Description.png

Nav. Type

Equipment


Hierarchy

System / Description

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 System ( EquipmentSystems.EquipmentSystemDescription) COMPRESSED AIR
Node 2 Description (EquipmentClassifications.EquipmentClassificationDescription) Compressors
Leaf Equipment (VesselsEquipment.VesselEquipmentDesc) CONTROL AIR COMPRESSOR
Main Grid Data SMH.HistoryItems Qualified as above with the Qualifier

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Description

Nav - Equipment - Description.png

Nav. Type

Equipment


Hierarchy

Description

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Description (EquipmentClassifications.EquipmentClassificationDescription) Compressors VesselId=#,EquipmentClassificationId=#
Leaf Equipment (VesselsEquipment.VesselEquipmentDesc) CONTROL AIR COMPRESSOR VesselId=#,EquipmentClassificationId=#,EquipmentId=#
Main Grid Data SMH.HistoryItems Qualified as above with the Qualifier Note: ensure Classification ID in SMH.HistoryItems comes from VesselsEquipmentSystems

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Equipment HSC

Nav - Equipment - Equipment HSC.png

Nav. Type

Equipment


Hierarchy

Equipment HSC

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Equipment (VesselsEquipment.VesselEquipmentDesc) || (HSC) Hull Structure, General (10000) VesselId=#,HSC=# and Lower HSCs
Node 2 Equipment (VesselsEquipment.VesselEquipmentDesc) || (HSC) Hull (11000) VesselId=#,HSC=# and Lower HSCs
Leaf Equipment (VesselsEquipment.VesselEquipmentDesc) VesselId=#, HSC=#,EquipmentId=#
Main Grid Data SMH.HistoryItems Limited to WHERE Note: ensure SystemID and Classification ID in SMH.HistoryItems comes from VesselsEquipmentSystems

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.


Hierarchy: Description / Model

Nav. Type

Equipment


Hierarchy

Description / Model

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1
Node 2
Node 3
Leaf
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Manufacturer / Model

Samm-universal-hf-nav panel options-equipment-manufacturer model-20190520-sg.png

Nav. Type

Equipment


Hierarchy

Manufacturer / Model

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Manufacturer
Node 2 Model
Leaf Equipment
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Description / Sub-Description

Samm-universal-hf-nav panel options-equipment-description sub description-20190520-sg.png

Nav. Type

Equipment


Hierarchy

Description / Sub-Description

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1
Node 2
Node 3
Leaf
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Test Type

Nav - Vessel Equipment - Test Type.png

Nav. Type

Equipment


Hierarchy

Test Type

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Vessel USNS Able
Node 2 Test Type Fuel Oil
Lube Oil
Recip. Analysis
Shipboard Analysis
Special Test
Thermography
Vibration
Water Chemistry
Node 3 Equipment System (SAMM.VesselsEquipmentSystems) Cooling Water
Node 4 Description (SAMM.VesselsEquipmentSystems) Pump
Leaf CM Item
Main Grid Data

Notes

  • Tree is pulling from the table: SAMM.VesselsEquipmentSystems
  • Empty Nodes are Not Displayed
  • Nav. Type shall default to Equipment and is the only selection option.
  • All Test Types shall be present, even if the ship has no records for that Test Type.

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Navigation Type Personnel

Hierarchy: Billet

Nav - Personnel - Billet.png

Nav. Type

Personnel


Hierarchy

Billet

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1
Node 2
Node 3
Leaf
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Navigation Type: Findings

Hierarchy: Finding Against

Samm-universal-hf-nav panel options-findings-findings against-20190520-sg.png

Nav. Type

Findings


Hierarchy

Finding Against

Tree Definition
Node Example Qualifier
Root Node (All) Finding Against (null)
Node 1
Node 2
Node 3
Leaf
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Procedure by Name

Samm-universal-hf-nav panel options-findings-procedure by name-20190520-sg.png

Nav. Type

Findings


Hierarchy

Procedure by Name

Tree Definition
Node Example Qualifier
Root Node (All) All Procedures (null)
Node 1
Node 2
Node 3
Leaf
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Procedure by Number

Samm-universal-hf-nav panel options-findings-procedure by number-20190520-sg.png

Nav. Type

Findings


Hierarchy

Procedure by Number

Tree Definition
Node Example Qualifier
Root Node (All) All Procedures (null)
Node 1
Node 2
Node 3
Leaf
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: FORAC

Samm-universal-hf-nav panel options-findings-forac-20190520-sg.png

Nav. Type

Findings


Hierarchy

FORAC

Tree Definition
Node Example Qualifier
Root Node (All) All FORACs (null)
Node 1
Node 2
Node 3
Leaf
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.


Navigation Type: Vessel

Hierarchy: PM

Nav - Vessel - PM.png

Nav. Type

Vessel


Hierarchy

PM

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 PM PM1
Leaf Vessel USNS Maury
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Class

Samm-universal-hf-nav panel options-vessel-class-20190520-sg.png

Nav. Type

Vessel


Hierarchy

Class

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Class TAGS
Leaf Vessel USNS Maury
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: PM / Class

Nav - Vessel - PM Class.png

Nav. Type

Vessel


Hierarchy

PM / Class

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 PM PM4
Node 2 Class T-ARS
Leaf Vessel USNS Grapple
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: A–Z

Nav - Vessel - Department - A to Z.png

Nav. Type

Vessel


Hierarchy

A–Z

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Leaf Vessel USNS Maury
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Navigation Type: Test Type

Hierarchy: Vessel Equipment

Nav - Test Type - Equipment.png

Nav. Type

Test Type


Hierarchy

Vessel Equipment

Tree Definition
Node Example Qualifier
Root Node (All) All Vessels (null)
Node 1 Vessel USNS Able
Node 2 Test Type Fuel Oil
Lube Oil
Recip. Analysis
Shipboard Analysis
Special Test
Thermography
Vibration
Water Chemistry
Node 3 Equipment System (SAMM.VesselsEquipmentSystems) Cooling Water
Node 4 Description (SAMM.VesselsEquipmentSystems) Pump
Leaf CM Item
Main Grid Data

Notes

  • Empty Nodes are Not Displayed
  • Nav. Type shall default to Equipment and is the only selection option.
  • Functionality shall mimic that already found when using Nav. Type: Equipment, Hierarchy: Test Type. Except the System/Description should come from SAMM.VesselsEquipmentSystems and VesselEquipmentDesc should be used for Equipment name.
  • All Test Types shall be present, even if the ship has no records for that Test Type.

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Navigation Type: Roles

Hierarchy: Module

Navigation-Role-Module.png

Nav. Type

Roles


Hierarchy

Module / Model

Tree Definition
Node Example Qualifier
Root Node (All) All Modules (null)
Node 1 Module Admin
Node 2 Sub-Module Role Management
Leaf Role Administrator
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Submodule (Case Study)

Navigation-Role-Sub-Module.png

Nav. Type

Roles


Hierarchy

Module / Model

Tree Definition
Node Example Qualifier
Root Node (All) All Submodules (null)
Node 1 Submodule VTL
Leaf Role Admin
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Navigation Type: Certificate

Hierarchy: Vessel

Description Vessel Class PM
Example Image Nav - Certificate -Vessel.png Nav - Certificate -Vessel - Class.png Nav - Certificate -Vessel - PM.png
  • Parent Node 1
  • Example
  • Qualifier
  • Library
  • Library
  • -
  • Library
  • Library
  • -
  • Library
  • Library
  • -
  • Leaf 1
  • Example
  • Qualifier
  • Certificate Type
  • ABS Classification
  • -
  • Certificate Type
  • ABS Classification
  • -
  • Certificate Type
  • ABS Classification
  • -
  • Parent Node 2
  • Example
  • Qualifier
  • All
  • All Vessels
  • (null)
  • All
  • All Vessels
  • (null)
  • All
  • All Vessels
  • (null)
  • Child Node 2.1
  • Example
  • Qualifier
  • Vessel (Vessels.VesselName)
  • USNS Big Horn
  • -
  • Class (-)
  • TAO 187
  • -
  • PM (-)
  • PM1
  • -
  • Child Node 2.2
  • Example
  • Qualifier
  • Certificate Type (-)
  • ABS Certification
  • -
  • Vessel (Vessels.VesselName)
  • USNS Big Horn
  • -
  • Vessel (Vessels.VesselName)
  • USNS Big Horn
  • -
  • Child Node 2.3
  • Example
  • Qualifier
  • N/A
  • Certificate Type (-)
  • ABS Certification
  • -
  • Certificate Type (-)
  • ABS Certification
  • -
  • Leaf 2
  • Example
  • Qualifier
  • Certificate (-)
  • Certificate of Classification
  • -
  • Certificate (-)
  • Certificate of Classification
  • -
  • Certificate (-)
  • Certificate of Classification
  • -


Notes

  • Empty Nodes are Not Displayed


Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Hierarchy: Certificate Type

Nav - Certificate - Certificate Type.png

Nav. Type

Certificate


Hierarchy

Certificate Type

Tree Definition
Node Example Qualifier
Parent Node 1 (Library) Library (null)
Child Leaf Node 1.1 Certificate Type ABS Classification
Parent Node 2 (All Certificates) All Certificates
Child Node 2.1 Certificate Type ABS Classification
Child Leaf Node 2.2 Certificate Certificate of Classification
Main Grid Data

Notes

  • Empty Nodes are Not Displayed

Example SQL to build Navigation Tree Conceptually

Insert Example Here

       Lorem ipsum dolor sit amet, consectetur adipiscing elit, 
       sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. 
       Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

Navigation Actions

Nav Options Button



U0001-2 02 Universal CaseStudy NavigationPanel 1280x1024 PropertiesMenu 20150515 LR.png

Nav Item Context Menu



U0001-2 02 Universal CaseStudy NavigationPanel 1280x1024 PropertiesMenu-RightClick 20150515 LR.png

Blank Template

Blank Template



Slide 12.png

Retrieved from "http://wiki.emprisecorporation.com/index.php?title=Side_Navigation&oldid=60356"