IHSD
.IHS_2023
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
IHS_2023.PR_BATCH_UPDATE_IHS_DATA
Parameters
Name
Type
Mode
Definition
procedure pr_batch_update_IHS_data (program_start_date varchar2 := '2023-04-01') -- use AUTHID CURRENT_USER to execute with the privileges and -- schema context of the calling user AUTHID CURRENT_USER AS begin pr_populate_IHS_data(program_start_date); pr_populate_IHS_HEALTHKITSAMPLES_data(program_start_date); --4/18/2022: separated from pr_populate_IHS_data to handle unique constraint vaiolations pr_populate_IHS_AnalyticsEvents_data; --added on 4/5/2022 to handle 6 additional AnalyticsEvents data files, no input parameter pr_populate_IHS_AnalyticsEvents_Email; --added on 6/15/2022 to handle 6 additional detailed email AnalyticsEvents data files, no input parameter pr_FITBIT_intraday_activities(program_start_date); pr_INSERT_FITBIT_intraday_hrv(program_start_date); --added on 11/2/2022 pr_populate_IHS_Garmin_data; --added on 5/25/2023 pr_recent_Healthkit_dailydata; --program_start_date is not varchar2, instead it is DATE with default='01-APR-2023' pr_update_apple_watch_devices(program_start_date); pr_daily_wearable_datacounts(program_start_date); --4/25/2022: added to track daily wearable data counts (DAILY_WEARABLE_DATACOUNTS) PR_INSERT_SK_DATA; --new code for IHS 2023, turned on 6/15/2023 pr_update_LOAD_LOG; --new code for IHS 2023 pr_IHS_data_refresh_log(program_start_date); --new code for IHS 2023 end;