Articles in this section

See more

Analytics Endpoint 'residents_assessment_outstanding' Metric Pool

  • Updated

Returns a list of patients with outstanding assessments - see Analytics Follow-up and Related Terminology for the definition of what a Patient with Outstanding Assessment means.

The metrics are calculated when residents_assessment_outstanding is included in the metric_pool list for Analytics Endpoint. They are calculated per partition, via an invoked procedure ss_residents_assessment_outstanding_metrics_for_partition.

Definitions are impacted by which residents are in the permissions of the license, user and site. Patient and mode are considered null. Currently, these metrics consider the start date metric to be null, and take into consideration all allowed data before the end date - so the date partition is (null, end date)

The logged-in user must have at least patient.read_only permission to view these metrics.

Metrics

Metric Key

Definition

Example

outstanding_assessment_table

A JSON list of outstanding_assessment objects (see definition below).

Each item in the list represents one Patient with Outstanding Assessment.

The list is ordered by:

  • assessment_date (of the last assessment, nulls last)

  • first_name

  • last_name

  • birth_date

 
[{
  "last_name": "Sanchez",
  "birth_date": "1902-05-05", 
  "first_name": "Nichole", 
  "resident_id": "4e14b432-a6fd-4407-88c4-1f59dd5ddb05", 
  "assessment_date": "2018-08-07T03:24:36.602+00:00", 
  "assessment_mode": "painchek", 
  "days_outstanding": 1301}, 
  ...
]

all_residents

The number of outstanding_assessment_table records

43

assessed_residents

The number of outstanding_assessment_table patients that have a non-null assessment_date (they have had an assessment)

23

never_assessed_residents

The number of outstanding_assessment_table patients that have a null assessment_date (they have never had an assessment).

Equals all_residents - assessed_residents

20

outstanding_assessment Object

The outstanding_assessment object has the following fields:

Field

Contents

Example

1

resident_id

patient uuid

4e14b432-a6fd-4407-88c4-1f59dd5ddb05

2

first_name

patient first_name

Nichole

3

last_name

patient last_name

Sanchez

4

birth_date

patient birth_date

1902-05-05

5

assessment_mode

last assessment assessment_mode

2018-08-07T03:24:36.602+00:00

6

assessment_date

last assessment assessment_date

painchek

7

days_outstanding

the number of days since the last assessment till the end date

1301

Example

{
  "outstanding_assessment_table": [{
    "resident_id": "4e14b432-a6fd-4407-88c4-1f59dd5ddb05",
    "first_name": "Nichole",
    "last_name": "Sanchez",
    "birth_date": "1902-05-05",
    "assessment_date": "2018-08-07T03:24:36.602+00:00",
    "assessment_mode": "painchek",
    "days_outstanding": 1301
    }, 
    {
    "resident_id": "bef34204-d0a0-432c-b243-37dc04a7eb40",
    "first_name": "Belle",
    "last_name": "Becker",
    "birth_date": "1948-07-01",
    "assessment_date": "2021-02-06T00:41:43.849+00:00",
    "assessment_mode": "painchek",
    "days_outstanding": 387
    },
    ...
  ],
  "all_residents": 43,
  "assessed_residents": 23,
  "never_assessed_residents": 20
}

Related articles