| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| stat_code |
One stat type code |
string | |
| sequence |
A way to order stat |
integer | |
| value_thisweek |
The value for that stat |
integer | |
| score_thisweek |
The score for that user |
integer | |
| displayvalue_thisweek |
The value in a view mode |
string | |
| position_thisweek |
The position for that user |
integer | |
| value_lastweek |
The value for that stat (last week) |
integer | |
| score_lastweek |
The score for that user (last week) |
integer | |
| displayvalue_lastweek |
The value in a view mode (last week) |
string | |
| position_lastweek |
The position for that user (last week) |
integer | |
| value_thismonth |
The value for that stat |
integer | |
| score_thismonth |
The score for that user |
integer | |
| displayvalue_thismonth |
The value in a view mode |
string | |
| position_thismonth |
The position for that user |
integer | |
| value_lastmonth |
The value for that stat (last month) |
integer | |
| score_lastmonth |
The score for that user (last month) |
integer | |
| displayvalue_lastmonth |
The value in a view mode (last month) |
string | |
| position_lastmonth |
The position for that user (last month) |
integer | |
| value_thisyear |
The value for that stat |
integer | |
| score_thisyear |
The score for that user |
integer | |
| displayvalue_thisyear |
The value in a view mode |
string | |
| position_thisyear |
The position for that user |
integer | |
| value_lastyear |
The value for that stat (last year) |
integer | |
| score_lastyear |
The score for that user (last year) |
integer | |
| displayvalue_lastyear |
The value in a view mode (last year) |
string | |
| position_lastyear |
The position for that user (last year) |
integer | |
| date_last_compute |
Date in utc last time it was computed |
string | |
| used_for_native_service |
To know if must be downloaded by FSA |
boolean | |
| used_for_native_app |
To know if must be downloaded by SA |
boolean | |
| stat_value_type |
Type/format of the metric's value (e.g. count, currency, percentage), used to control how it is displayed. |
string | |
| stat_name |
Display name of the metric, shown as the label for this row on the dashboard. |
string | |
| sys_logical_delete |
Soft-delete flag: when true, this metric row is considered deleted and should be excluded from the dashboard. |
boolean | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
string |