Foster Care Tracking Spreadsheet Example-MNP.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AR	AS	AT	AU
1	Out of Home Placement List *																											Current Month =		7/1/2021
2	July 26, 2021																																												Dates
3	NAME	MA?	IV-E Status	Date of IV-E Referral	Maxis Worker	Open Child Support	Date of CS RD	SSI or RSDI	Primary Worker	Worker Last Name	Workgroup Name	WG Type	Parental Status	Previous Placement	Current Placement	Prov. Type	Licensed	Beg Date	Exp Date	Source	Date of Birth	Age	ILP Needed	MNYTD Survey Due	Date of Plcmt	Entry Date in SSIS	Gap - # Days	Days in Plcmt	Initial Authority	Primary Perm Goal	OHPP Needed	Plcmt Ended	Entry Date in SSIS	Gap - # Days	Rule 5 - LA Update IMD-Pgm	Rule 5 or IMD? Do Not Claim CW-TCM	CW-TCM Claim for Jun'21	Beg of month	Entered	Exited	In Care	NOTES	PMI #	Next IV-E review is due	confirmed by IM are in bold.	Notes

4	One, DDChild		Denied			No		No	Alice	Alligator	Xxxxx Xxxxx DD Case Mgmt 01/01/2016	DD	No		Woods Care Home	ICFDD	Yes-HCBS	10/01/20	12/31/21	BusOrg	08/08/03	18.0	No	08/17/20	03/15/19	03/20/19	5	864	Voluntary	Reunification	No				N/A	NAR5F	no Elig E	1	0	0	1			--	non IV-E
5	Two, CorrChild		N/A			No		No	Corr-Waseca	Corr	Xxxxx Xxxxx CW Case Mgmt	Corr	Corr	East Central Regional Juv Ctr	West Central Regional Juv Ctr (7/12/21)	Corr	Yes - CRF	07/01/05	12/31/21	BusOrg	09/09/05	15.9	N/A		07/01/21	N/A		25	Corr	N/A	N/A				Corr-W	N/A	Yes	0	1	0	1			--	Waseca Corr
6	Three, CMHChild		Denied			No		Yes - RD	Bertha	Bear	Xxxxx Xxxxx CMH Case Mgmt 02/02/2019	CMH	No		Village Ranch (Rochester)	RTC	Yes - CRF	04/01/15	12/31/21	BusOrg	12/12/04	16.6	No		02/25/21	02/25/21	0	151	Voluntary	Reunification	No				CMH	NAR5F	CMH	1	0	0	1			--	non IV-E
7	Four, ALSChild		Eligible			Yes-RD	09/01/18	Yes - RD	Clara	Cat	Xxxxx Xxxxx ALS Case Mgmt 03/03/2018	ALS	No	Provider, Unlicensed Foster	supervised independent living (3/13/20)	SIL					11/11/00	20.7	No		02/27/18	03/13/18	14	1245	PH - 3	Trans to Adult	No				N/A		Yes	1	0	0	1		44444444	10/31/2021	RE to FIN PER 10/07/20
8	Five, CPChild1		Submitted	07/19/21		Yes		No	Doris	Dog	Xxxxx Xxxxx CP Case Mgmt 05/05/2021	CP	No		Five, Grandmother	REL	No				04/04/14	7.3			06/28/21	07/09/21	11	28	Crt Order	Reunification	Draft				N/A		Yes	1	0	0	1			--	pending
9	Five, CPChild2		Submitted	07/19/21		Yes		No	Doris	Dog	Xxxxx Xxxxx CP Case Mgmt 05/05/2021	CP	No		Five, Grandmother	REL	No				03/03/13	8.4			06/28/21	07/09/21	11	28	Crt Order	Reunification	Draft				N/A		Yes	1	0	0	1			--	pending
10	Six, CPChild		Denied			Yes		No	Ethel	Eagle	Xxxxx Xxxxx CP Case Mgmt 06/06/2021	CP	No		Six, Aunt & Uncle	REL	No				01/01/20	1.6			06/06/21	06/09/21	3	50	PH - 5	Reunification	Yes				N/A		Yes	1	0	0	1			--	non IV-E
11	Seven, CMHChild		Denied			Yes-RD	06/01/21	No	Francis	Fox	Xxxxx Xxxxx CMH Case Mgmt 04/04/2018		No		Gerard Treatment Programs		Yes - CRF	04/25/99	12/31/21	BusOrg	02/02/04	17.5	No	06/16/20	12/09/20	12/09/20	0	203	Voluntary	Reunification	Draft	06/30/21	07/01/21	1	CMH	IMD	CMH	1	0	1	0	straight MA; pgm returned to MA and LA to Community		--	non IV-E
12	Eight, CPChild		Eligible			No		No	Ethel	Eagle	Xxxxx Xxxxx CP Case Mgmt 05/05/2021	CP	No	Provider, Licensed Foster	trial home visit (7/1/21)	THV					09/14/19	1.9			05/05/21	05/10/21	5	82	PH - 4	Reunification	Draft				N/A		Yes	1	0	0	1		55555555	5/31/2022	Plcmt 5/8/21
13	Nine, AGChild1		Denied			No		No	Gretel	Goat	Xxxxx Xxxxx A/G Case Mgmt 12/12/2019	AG	Both		Providers, Adoptive Foster	Non-R	Yes - CFC	06/19/18	08/31/21	BusOrg	08/13/18	3.0			10/09/18	10/25/18	16	1021	PH - 2	Adoption	Yes				N/A		Yes	1	0	0	1			--	non IV-E
14	Nine, AGChild2		Eligible			No		No	Gretel	Goat	Xxxxx Xxxxx A/G Case Mgmt 12/12/2019	AG	Both		Providers, Adoptive Foster	Non-R	Yes - CFC	06/19/18	08/31/21	BusOrg	11/12/13	7.7			10/09/18	10/25/18	16	1021	PH - 2	Adoption	Yes				N/A		Yes	1	0	0	1		66666666	12/31/2021	last RE to FIN PER 12/09/2020
15	Ten, CMHChild		Denied			No		No	Francis	Fox	Xxxxx Xxxxx CMH Case Mgmt 08/08/2018	CMH	No		Nexus Mille Lacs	RTC	Yes - CRF	07/01/05	12/31/21	BusOrg	09/09/09	11.9			10/26/20	10/27/20	1	273	Voluntary	Reunification	Draft				CMH	R-5	CMH	1	0	0	1			--	non IV-E
16																																					8	11	1	1	11
17
18	Locations: (Agency retains custody)
19	Eleven, NCPChild1								Henry	Hare	Xxxxx Xxxxx CP Case Mgmt 11/11/2020				NCP (01/12/2021)	NCP
20	Eleven, NCPChild2								Henry	Hare	Xxxxx Xxxxx CP Case Mgmt 11/11/2020				NCP (01/12/2021)	NCP
21
22						All																							0	= NP (No Placement)
23	Average age of child in placement (years)					10.9																							0	= CFH (Corporate Foster Home)
24	Median age of child in placement (years)					10.1																							0	= GH (Group Home)
25	Average length of placement (days)					416																							1	= THV (Trial Home Visit)
26	Average length of placement (years)					1.14																							2	= Non-R (Non-Relative Placement)
27	Median length of placement (days)					177																							3	= REL (Relative Placement)
28	Median length of placement (years)					0.48																							2	= RTC (Residential Treatment Center)
29																													1	= SIL (Supervised independent living)
30																													1	= Corr (Corrections)
31	# in placement at beginning of mth =							11													2	= # of AG							0	= Hospital (Hosp)
32	Children entered during month =							1													1	= # of ALS							1	= ICF-DD
33	Children exited during month =							1													2	= # of CMH							11	= Total
34	Total number in care during month =							11													4	= # of CP
35																					0	= # of CW
36																					1	= # of Corr
37	*Information on this report is taken from SSIS.																				1	= # of DD							2	=Non-custodial parent
38	Areas requiring attention.																				11	= Total
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100