OOH Outcomes - Cut Points

[erikadeal]

Create three new measurements showing outcomes at 3 months, 12 months, and 24 months.

[erikadeal]

SQL Workbench calls:

call `sp_ooh_outcomes_24m`(
          '0',--  @age_grouping_cd =

         '0', -- race_cd =
         '0',--  @ender_cd =
         '0',--  @init_cd_plcm_setg = 
         '0',--  @long_cd_plcm_setg =
         '0',--  county_cd
         '0',--  @bin_los_cd 
         '0',--  @bin_placemet_cd =
         '0',--  @bin_ihs_svc_cd =xits
         '0',--  @cd_reporter_type = 
         '0',--  @filter_access_type =
         '0',--  @filter_allegation =  select * From ref_Filter_access_type
         '0',--  @filter_findig = 
         '0',--  @filter_service_category =
         '0',--  @filter_service_budget   
         '0'  -- bin_dep_cd
); 

call `sp_ooh_outcomes_12m`(
          '0',--  @age_grouping_cd =

         '0', -- race_cd =
         '0',--  @ender_cd =
         '0',--  @init_cd_plcm_setg = 
         '0',--  @long_cd_plcm_setg =
         '0',--  county_cd
         '0',--  @bin_los_cd 
         '0',--  @bin_placemet_cd =
         '0',--  @bin_ihs_svc_cd =xits
         '0',--  @cd_reporter_type = 
         '0',--  @filter_access_type =
         '0',--  @filter_allegation =  select * From ref_Filter_access_type
         '0',--  @filter_findig = 
         '0',--  @filter_service_category =
         '0',--  @filter_service_budget   
         '0'  -- bin_dep_cd
); 

call `sp_ooh_outcomes_3m`(
          '0',--  @age_grouping_cd =

         '0', -- race_cd =
         '0',--  @ender_cd =
         '0',--  @init_cd_plcm_setg = 
         '0',--  @long_cd_plcm_setg =
         '0',--  county_cd
         '0',--  @bin_los_cd 
         '0',--  @bin_placemet_cd =
         '0',--  @bin_ihs_svc_cd =xits
         '0',--  @cd_reporter_type = 
         '0',--  @filter_access_type =
         '0',--  @filter_allegation =  select * From ref_Filter_access_type
         '0',--  @filter_findig = 
         '0',--  @filter_service_category =
         '0',--  @filter_service_budget   
         '0'  -- bin_dep_cd
);

Output:

Cohort Period <datetime>
qry_type_poc1_first_unique  <integer>
age_grouping_cd <integer>
Age Grouping <varchar(200)>
ethnicity_cd <integer>
Race/Ethnicity <varchar(200)>
gender_cd <integer>
Gender <varchar(200)>
init_cd_plcm_setng <integer>
Initial Placement <varchar(200)>
long_cd_plcm_setng <integer>
Longest Placement <varchar(200)>
county_cd <integer>
County <varchar(200)>
dependency_cd <integer>
Dependency <varchar(200)>
bin_los_cd <integer>
Length of Service Desc <varchar(200)>
bin_placement_cd <integer>
Placement Count Desc <varchar(200)>
bin_ihs_svc_cd <integer>
In-Home Service Desc <varchar(200)>
cd_reporter_type <integer>
Reporter Desc <varchar(200)>
cd_access_type <integer>
Access type desc <varchar(200)>
cd_allegation <integer>
Allegation <varchar(200)>
cd_finding <integer>
Finding <varchar(200)>
service_type_cd <integer>
Service Type <varchar(200)>
budget_cd <integer>
Budget <varchar(200)>
cd_discharge_type <integer>
Discharge <varchar(200)>
Percent decimal(9,2)

[mienkoja]

Joe has agreed to develop a config file for one of these new measures and then hand off to Erika to replicate at the various cut-points.

[mienkoja]

Transferring to Gregor now that he is back!

[gregorp]

I'm putting this off until we copy to production.

[gregorp]

We have stored procedures. Next step on this is making a config file and a space on the portal. I'm going to once again suggest putting this off until the Measurement Configurator is ready for a test drive.

[mienkoja]

Sounds good

On Mon, Sep 8, 2014 at 2:23 PM, Gregor Passolt notifications@github.com wrote:

We have stored procedures. Next step on this is making a config file and a space on the portal. I'm going to once again suggest putting this off until the Measurement Configurator is ready for a test drive.

— Reply to this email directly or view it on GitHub https://github.com/pocdata/annie-config/issues/15#issuecomment-54889485.

Joe Mienko

Policy Research Scientist

Partners for Our Children | University of Washington School of Social Work

Box 359476 | Seattle, WA 98195-9476

T: 206-221-8725 | F: 206-221-3155

www.partnersforourchildren.org http://www.partnersforourchildren.org/

• http://www.facebook.com/partnersforourchildrenuniversityofwashington http://www.twitter.com/POCtweets*