Capability table

A Capability is a privilege assigned to the user which allows the user to do something or see something. Examples:

  • ALERT_CLOSE allows the user to close alerts
  • ALERT_ADD_NOTE allows the user to add a note to a survey

A Capability is identified by its id and has a description.

Table description

DESCRIBE TABLE capability
 key          | name                   | encoding |
 capabilityid | Capability id          | TEXT     |
 description  | Capability description | TEXT     |

Sample query

SELECT capabilityid, description FROM capability

Result

 capabilityid                           | description                                                |
 REPORTING                              | View Reporting Modules                                     |
 REPORTING_SATTRACKER                   | View Satisfaction                                          |
 REPORTING_SATTRACKER_TABLE             | View Satisfaction Table                                    |
 REPORTING_SATTRACKER_GRAPH             | View Satisfaction Graph                                    |
 REPORTING_SATTRACKER_DISTRIBUTION      | View Satisfaction Distribution                             |
 REPORTING_SATTRACKER_COMPARE           | View Satisfaction Compare                                  |
 REPORTING_SATTRACKER_SNAPSHOT          | View Satisfaction Snapshot                                 |
 REPORTING_RESPONSE_INVESTIGATOR        | View ResponseInvestigator                                  |
 REPORTING_RESPONSE_INVESTIGATOR_FILTER | View Only RI Filter                                        |
 REPORTING_PROBLEM_TRACKER              | View Problems                                              |
 REPORTING_PROBLEM_TRACKER_TABLE        | View Problems Table                                        |
 REPORTING_PROBLEM_TRACKER_COMPARE      | View Problems Compare                                      |
 REPORTING_PROBLEM_TRACKER_SNAPSHOT     | View Problems Snapshot                                     |
 REPORTING_GUEST_PROFILER               | View Profiler                                              |
 REPORTING_GUEST_PROFILER_TABLE         | View Profiler Table                                        |
 REPORTING_GUEST_PROFILER_GRAPH         | View Profiler Graph                                        |
 REPORTING_RANKER                       | View Ranker                                                |
 REPORTING_RANKER_PROPERTY              | View Only Ranker Property                                  |
 REPORTING_LOYALTY_TRACKER              | View LoyaltyTracker                                        |
 REPORTING_SATTRACKER_MULTICOMPARE      | View Satisfaction MultiCompare                             |
 REPORTING_ADDON_GUEST_VOICE            | View Guest Voices                                          |
 HOMEPAGE                               | View Homepage                                              |
 HOMEPAGE_BARGRAPH                      | Use Homepage BarGraph module                               |
 HOMEPAGE_PROPERTY_PERFORMANCE          | Use Homepage Property Performance module                   |
 HOMEPAGE_QUICKLINKS                    | Use Homepage QuickLinks module                             |
 HOMEPAGE_ALERTGRAPH                    | Use Homepage AlertGraph module                             |
 SEE_COMPLETED_SURVEYS                  | See completed surveys (only invited responses) (deprecated) |
 VIEW_TUTORIAL                          | View Tutorial link                                         |
 ALERT                                  | Alert rights                                               |
 ALERT_VIEW                             | View Alerts                                                |
 ALERT_RESOLVE                          | Resolve Alerts                                             |
 ALERT_CLOSE                            | Close Alerts                                               |
 ALERT_SEND_RAPID_RESPONSE              | Send Rapid Response Email                                  |
 ALERT_VIEW_LOG                         | View Log                                                   |
 ALERT_ADD_NOTE                         | Add a Note to Log                                          |
 ALERT_ASSIGN                           | Assign Alert                                               |
 RI_DATA_EXPORTS                        | RI Data Exports                                            |
 RANKER_DATA_EXPORT                     | Ranker All Question export                                 |