Fitbit_DailyActivity

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ParticipantIdentifier

varchar

100

√

null

PatientID

uniqueidentifier

√

null

DeIDLookup_Patients_DForger.PatientID

Implied Constraint

Date

date

√

null

Steps

varchar

100

√

null

RestingHeartRate

varchar

100

√

null

HROutofRangeMinimum

varchar

100

√

null

HROutofRangeMax

varchar

100

√

null

HROutofRangeMinutes

varchar

100

√

null

FatBurn

varchar

100

√

null

Cardio

varchar

100

√

null

Peak

varchar

100

√

null

Floors

varchar

100

√

null

VeryActive

varchar

100

√

null

FairlyActive

varchar

100

√

null

LightlyActive

varchar

100

√

null

Sedentary

varchar

100

√

null

Relationships

Close relationships within degrees of separation

View Definition

-- ==============================================================================
-- Author:		G.Siciliano
-- Date: 		02/24/2023
-- Description:	PROMPT [Fitbit_DailyActivity]
-- ==============================================================================



CREATE VIEW [CareEv].[Fitbit_DailyActivity]
AS 

/*********
 * SMILE *
 *  - -  *
 *   ^   *
 *  \_/  *
 *********/

 SELECT DISTINCT a.[ParticipantIdentifier], b.PatientID
      ,CAST([Date] AS DATE) AS Date
	  ,[Tracker.Steps] AS Steps
	  ,[RestingHeartRate]
      ,[HeartRateZone.OutOfRangeMin] AS HROutofRangeMinimum
	  ,[HeartRateZone.OutOfRangeMax] AS HROutofRangeMax
	  ,[HeartRateZone.OutOfRangeMinutes] AS HROutofRangeMinutes
      ,[HeartRateZone.FatBurnMinutes] AS FatBurn
      ,[HeartRateZone.CardioMinutes] AS Cardio
      ,[HeartRateZone.PeakMinutes] AS Peak
      ,[Tracker.Floors] AS Floors
	  ,[Tracker.MinutesVeryActive] AS VeryActive
      ,[Tracker.MinutesFairlyActive] AS FairlyActive
      ,[Tracker.MinutesLightlyActive] AS LightlyActive
      ,[Tracker.MinutesSedentary] AS Sedentary
  FROM [PROMPT].[CareEv].[FitbitDailyData] a --5,980,302
  JOIN [PROMPT].[CareEv].[Metric_Lookup] b ON b.ParticipantIdentifier = a.ParticipantIdentifier
  WHERE a.[HeartRateZone.OutOfRangeMin] IS NOT NULL 
     OR a.[HeartRateZone.OutOfRangeMax] IS NOT NULL
     OR a.[HeartRateZone.FatBurnMinutes] IS NOT NULL
	 OR a.[HeartRateZone.OutOfRangeMinutes] IS NOT NULL
     OR a.[HeartRateZone.CardioMinutes] IS NOT NULL
	 OR a.[HeartRateZone.PeakMinutes] IS NOT NULL
     OR a.[Tracker.Floors] IS NOT NULL
     OR a.[Tracker.MinutesVeryActive] IS NOT NULL
     OR a.[Tracker.MinutesFairlyActive] IS NOT NULL
     OR a.[Tracker.MinutesLightlyActive] IS NOT NULL
     OR a.[Tracker.MinutesSedentary] IS NOT NULL
	 OR (a.[Tracker.Steps] IS NOT NULL AND a.[Tracker.Steps] > 0)
     OR a.[RestingHeartRate] IS NOT NULL

Possibly Referenced Tables/Views

Fitbit_DailyActivity