Unit table

A unit represents a business unit for the client, and is the lowest reporting level in the Medallia application. What specifically a unit is varies widely by industry. Examples are:

  • For a hotel chain, it would be an individual hotel
  • For a retail chain, it would be an individual retail store
  • For a call center, it could be an individual call agent, or it could be a team

Each unit has an ID, which is used for queries, as well as a name, which is used for displaying to the user. The unit also has an active/inactive state (e.g. a hotel or a store would become inactive after closing down).

Additionally, the unit may have any number of client-specific attributes. To discover which fields are available for a particular client, the following MQL query can be used:

Table description

DESCRIBE TABLE unit
 key    | name            | encoding   |
 unitid | Unit identifier | TEXT       |
 name   | Unit name       | TEXT       |
 active | Active          | ENUMERATED |

Sample query

SELECT unitid, name, active FROM unit

Result

 unitid                   | name               | active |
 Baltimore                | Baltimore          | yes    |
 Boston                   | Boston             | yes    |
 Buffalo                  | Buffalo            | yes    |
 Charleston               | Charleston         | yes    |
 Chicago                  | Chicago            | yes    |
 Dallas                   | Dallas             | yes    |
 Detroit                  | Detroit            | yes    |
 Houston                  | Houston            | yes    |
 Huntsville               | Huntsville         | yes    |
 Jacksonville             | Jacksonville       | yes    |
 Lake Havasu City         | Lake Havasu City   | yes    |
 Las Vegas                | Las Vegas          | yes    |
 Little Rock              | Little Rock        | yes    |
 Long Beach               | Long Beach         | yes    |
 Los Angeles              | Los Angeles        | yes    |
 Miami                    | Miami              | yes    |
 Minneapolis              | Minneapolis        | yes    |
 Myrtle Beach             | Myrtle Beach       | yes    |
 New York Chinatown       | New York Chinatown | yes    |
 New York Downtown        | New York Downtown  | yes    |
 New York Midtown         | New York Midtown   | yes    |
 New York Soho            | New York Soho      | yes    |
 New York Upper West Side | New York Upper     | yes    |
 New York Uptown          | New York Uptown    | yes    |
 Orlando                  | Orlando            | yes    |
 Pasadena                 | Pasadena           | yes    |
 Phoenix                  | Phoenix            | yes    |
 Portland                 | Portland           | yes    |
 Princeton                | Princeton          | yes    |
 Sacramento               | Sacramento         | yes    |
 San Diego                | San Diego          | yes    |
 San Francisco            | San Francisco      | yes    |
 San Jose                 | San Jose           | yes    |
 Savannah                 | Savannah           | yes    |
 Seattle                  | Seattle            | yes    |
 Syracuse                 | Syracuse           | yes    |
 Tampa                    | Tampa              | yes    |
 Trenton                  | Trenton            | yes    |
 Washington DC            | Washington DC      | yes    |