Please enable JavaScript.
Coggle requires JavaScript to display documents.
SP: org_RiskFactorCalculation (deadline, chunksize) (org_calculated_risk…
SP: org_RiskFactorCalculation
(deadline, chunksize)
person_risk_level_calc view
person_riskmodel_calc_view
RS_NUMERATOR (the_org_id, the_group_id, the_person_id)
RS_setcache()
#
RS_DENOMINATOR(the_org_id, the_group_id, the_person_id)
RS_setcache()
#
org_risk_group_model
risk_group_person_history
org_risk_group_model
org_calculated_risk_variables_view
cur_org_aggregationcalc_risk_variable view
org_person_riskvariable view
risk_model_master
org_risk_group_model
risk_group_person_history
risk_model_weights
risk_variable
RISK_SCORE_AGGREGATED_RV
(the_org_id, the_person_id, the_RV_id,
agg_type, the_start_date, the_end_date)
if agg_type in (NULL, 'Sum', 'Count', 'Average')
org_person_riskvariable_datum view
survey_response survey_question
person_org_metadata org_metadata
person_factor_calculated
person_ebi_metadata ebi_metadata
org_person_riskvariable view
#
org_question_response org_question
if agg_type='Academic Update'
academic_update
org_person_riskvariable view
#
risk_variable
if agg_type='Most Recent'
org_academic_year
org_academic_terms
org_person_riskvariable_datum
#
else null
risk_variable_range
risk_variable_category
INSERT INTO person_risk_level_history
UPDATE person P with person_risk_level_history
INSERT INTO org_calculated_risk_variables_history
Risk Calculation
1 Event
1 Stored Procedure
6 Views
4 Functions
26 Tables
454 Lines of Code