export_nps_response

Each row represents one NPS survey response with resolved entity names pre-joined into a flat table.

Example Query

-- Incremental load: fetch new, updated, and deleted records since last sync
SELECT *
FROM export_nps_response
WHERE updated_at >= '2024-01-15T00:00:00Z'
   OR deleted_at >= '2024-01-15T00:00:00Z';

Fields

Core

Field	Type	Description
id	string	Response ID
score	number	NPS score (0–10)
category	string	NPS category: Promoter, Passive, or Detractor
status	string	Response status
comment	string	Free-text comment from the respondent
body_region	string	Body region associated with the response

Timestamps

Field	Type	Description
created_at	time	When the response was submitted
updated_at	time	When the response was last updated
deleted_at	time	When the response was soft-deleted

Display Names

Field	Type	Description
patient_first_name	string	Patient's first name
patient_last_name	string	Patient's last name
patient_full_name	string	Patient's full name
location_name	string	Location name
location_display_name	string	Location display name
provider_first_name	string	Provider's first name
provider_last_name	string	Provider's last name
payer_name	string	Payer name
nps_survey_name	string	Survey name

Internal IDs

Field	Type	Description
provider_organization_id	string	Organization ID
location_id	string	Location ID
provider_id	string	Provider ID
referring_provider_id	string	Referring provider ID
patient_id	string	Patient ID
payer_id	string	Payer ID
owner_id	string	Owner (user) ID
nps_survey_id	string	Survey ID

External EMR IDs

Field	Type	Description
external_patient_id	string	Patient ID in external EMR
external_location_id	string	Location ID in external EMR
external_provider_id	string	Provider ID in external EMR
external_payer_id	string	Payer ID in external EMR
external_referring_provider_id	string	Referring provider ID in external EMR