]po[ Indicator

Performance Indicators are a sub-type of report that are used to track a numeric value over time.

 

Object Fields

 

Fields in table "im_indicators"

  • indicator_id:
    The object_id of the indicator. im_indicators.indicator_id = im_reports.report_id = acs_objects.object_id for accessing the super-types of im_indicator.

  • indicator_section_id:
    Reference to an menu item defining sections in the IndicatorListPage.

  • indicator_object_type:
    not used currently.

  • indicator_widget_min:
    lower limit for the indicator values shown in the indicator widgets.

  • indicator_widget_max:
    maximum limit for the indicator values shown in the indicator widgets.

  • indicator_widget_bins:
    not used currently.

  • indicator_low_warn:
    warning low watermark - values below this limit are shown in yellow

  • indicator_low_critical:
    critical low watermark - values below this limit are shown in red

  • indicator_high_warn:
    warning high watermark - values above this limit are shown in yellow

  • indicator_high_critical:
    critical high watermark - values above this limit are shown in red.

 

For fields in table im_reports please see the report object type.

 

Database Definition


Table im_indicators

         Column          |          Type
-------------------------+------------------------
 indicator_id            | integer
 indicator_section_id    | integer
 indicator_object_type   | character varying(100)
 indicator_widget_min    | double precision
 indicator_widget_max    | double precision
 indicator_widget_bins   | integer
 indicator_low_warn      | double precision
 indicator_low_critical  | double precision
 indicator_high_warn     | double precision
 indicator_high_critical | double precision

Table im_reports

       Column       |          Type
--------------------+-------------------------
 report_id          | integer
 report_code        | character varying(100)
 report_name        | character varying(1000)
 report_status_id   | integer
 report_type_id     | integer
 report_menu_id     | integer
 report_sql         | text
 report_sort_order  | integer
 report_description | text     

 

References

Object Types:

 

Packages:

 

 Modules:

 

  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

08902 Hospitalet de Llobregat (Barcelona)

Spain

 Tel Europe: +34 609 953 751
 Tel US: +1 415 200 2465
 Mail: info@project-open.com