IMOS On-Prem - Data Dictionary

View IMOS Documentation in the Help Center.

Note: You must have the Data Dictionary Module Right selected, under Quick Links in the Data Center.

In the Data Dictionary, you can view all tables and elements (fields) used throughout IMOS, including custom elements.

In the Data Center , under Quick Links, click Data Dictionary. A list of all tables appears on the left.

To select a table, click its row. A list of its elements appears on the right.

To view the properties of an element, click View in its row.

Adding and Editing Custom Elements

Note: You must have the Edit Data Dictionary Elements Module Right selected, under Actions in the Data Center.

You can create custom elements to be used in Task & Alert Rules and the Report Designer.

• To add a new element, select the table to which you want to add and then click .
• To edit an existing custom element, select its table and then click Edit in its row.

1. Enter an Element Name.
2. Select a Data Type.
3. Enter an Expression to define the value:
   1. Click in the field; the formula editor appears.
      
      
      Note: The formula editor is case sensitive. For example, VoyageStatus=="commenced" is different from VoyageStatus=="Commenced"
   2. Create a formula for the value, following the example formula. You can include:
      • Other custom columns
      • Selections from the Column, Color, and Font lists at the bottom of the formula box
        The Column list includes the following functions, which must be in UPPERCASE:
        • ABS(FieldID)
        • AVG(FieldID)
        • COALESCE(FieldID1, FieldID2, ...)
        • CONCAT(FieldID)
        • CONTAINS(FieldID, SearchString)
        • COUNT(FieldID)
        • COUNTDISTINCT(FieldID)
        • COUNTIF(FieldID, TestExpr)
        • DATE(Year, Month, Day)
        • DATERANGE(DateFieldID1, DateFieldID2)
        • DATETIME(Year, Month, Day, Hours, Minutes, Seconds)
        • DATETIME RANGE(DateFieldID1, DateFieldID2)
        • DAY(DateFieldID)
        • DISPLAYVALUE(EnumLiteral)
        • ENDSWITH(FieldID, SearchString)
        • HOUR(DateFieldID)
        • IF(Condition, true, false)
        • INDEX(FieldID, Num)
        • INLIST(Value, Target1, Target2, ...)
        • JOIN(“,”, FieldID)
        • JOINDISTINCT(",", FieldID)
        • LEN(FieldID)
        • MAX(FieldID)
        • MIN(FieldID)
        • MINUTE(DateFieldID)
        • MONTH(DateFieldID)
        • NOW()
        • NOWGMT()
        • ROWOFFSET(n, ORDERBY(FieldA, FieldB)).FieldID
        • SECOND(DateFieldID)
        • SPLIT(FieldID, Delimiter, Index)
        • SQRT(FieldID)
        • STARTSWITH(FieldID, SearchString)
        • SUBSTRING(FieldID, StartIndex, length(optional))
        • SUM(FieldID)
        • TIME(Hours (0-23), Minutes (0-59), Seconds (optional, 0-59), Milliseconds (optional, 0-999)))
        • TODAY()
        • TODAYGMT()
        • TOINT(FieldID)
        • TOLOCALESTRING(FieldID)
        • TOSTRING(FieldID)
        • YEAR(DateFieldID)
4. Click Save.

List Functions

The Data Dictionary List is a standard IMOS list, so you can sort it, filter it, do a Quick Search, and create custom Views for it.