sp_ooh_pit_counts

Point-in-Time Counts of OOH Care Placements. Sample call below:

call sp_ooh_pit_counts(      
    '2000-01-01,2013-01-01',-- @date =
    '0',--  @age_grouping_cd =
    '0',--  @race_cd =
    '0',--  @gender_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 =
    '0',--  @cd_reporter_type =
    '0',--  @filter_access_type =
    '0',--  @filter_allegation =
    '0',--  @filter_findig =
    '0',--  @filter_service_category =
    '0',--  @budget_cd
    '0' --  @dependency_cd
); 

Filter columns are qry_type_poc1 (0, 1, 2) and date_type (0, 2). Only one value column is returned, Total In Care First Day.