sp_rate_referral

Jump to bottom Edit New page

clancyjane edited this page Oct 9, 2014 · 6 revisions

This retrieves rate_referrals 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('0' -- county 1-39
	,'0' -- entry point  1-6
)