]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:

• Report object type

Packages:

• intranet-reporting-indicators
  

 Modules:

• Busines Intelligence module