sp_rate_referral_scrn_in

Jump to bottom Edit New page

clancyjane edited this page Oct 9, 2014 · 2 revisions

This retrieves rate_referrals SCREENED IN by month.
The procedure takes parameters:

p_county_cd county code values 0-39 from ref_lookup_county_all
p_entry_point includes
0=ALL,
1 Child Protective Services (CPS),
2 Alternative Response System (ARS) ,
3 Family Reconciliation Services (FRS),
4 Risk Only,
5 Child Family Welfare Services (CFWS),
6 Family Assessment Response (FAR))

call sp_rate_referral_scrn_in('0' -- county 1-39
	,'1,2,3,4,5,6,0' -- entry point  1-6
)