Mecklenburg County Linked Database. Capability Achieved


The longitudinal, linked database consists of multiple components.  These components come mostly from state social services information systems.  Below is a table that shows these components, and their primary functions:


Work First Cases All cases since Jan 1995 — Determines when cases participated in WF, length of spell, recidivism, beginning, and end of spell.
Work First Individuals All beneficiaries of the WF grant (including child only recipients) since Jan 1995 — Determine individual’s role in case (parent, child, etc), demographics.
"In-Case" (Case Composition) Details about case composition such as number in the case; number of children; number children under 5, 2, or 1 year(s) old; and presence of adult male or pregnant teen.
Work First Employment Services Lists Employment Services participants — some incomplete information on education levels and literacy levels.
Activities & Employment For Employment Services participants only — shows type of employment-seeking activities and employment of individuals during WF employment services.  Also shows scheduled and completed hours of activities and employment.
Employment Security Commission Unemployment Insurance Database Allows tracking of quarterly earnings of WF participants and their families.  Also shows employer industries (SIC codes) for each quarter and employer zip code.
24- & 60-Month Time Limits Shows initiation of time limits for individuals, which months count against state and federal time limits for each individual, and total months against time limits.
Food Stamps Lists food stamp cases since March 1995 for Work First participants.  Gives amount of food stamps distributed and number of members in the case.
Child Only Cases Lists all child only cases.  Determines whether and when child only cases become non-child only cases, and vice versa.
Purchase of Care Lists subsidized childcare information for June 1997 - Dec 1997.  Describes type of facility, days per month of care, and cost of care.

Prior to the grant, none of the data were available in longitudinal form.  In addition to the capability of tracking TANF and Food Stamps recipients over time, we now have databases that were previously unavailable to us, even in cross-sectional form, such as the ESC database and the purchase of care file.  Also unavailable to us in longitudinal form before the grant were Employment Services activities and employment data, time limit data, and child-only case data.