Settlement house data management system

摘要

A method, social services data management system, and computer program product for managing data about social services. In response to receiving the data about the social services provided to a group of clients at a data collection application running on a computer system, the data collection application running on the computer system places the data into a first database in a first format using a content model identifying entities for the social services and relationships between the entities. The computer system changes the data in the first database from the first format to a second format used by a second database. The computer system moves the data in the second format to the second database. A report application running on the computer system generates a number of reports using the data in the second format in the second database.

主权项

1. A method for managing data associated with social services, the method comprising:
a computer receiving the data associated with social services; the computer dividing the data associated with the social services and classifying the divided data into a first plurality of entity types based on a first social services content model, the first plurality of entity types comprising:
client entity type identifying clients to whom social services are provided;service entity type identifying service to be provided to the clients;census entity type identifying census statistics corresponding to a social service organization, a social service program, and/or the service to be provided to said clients;volunteer entity type identifying one or more volunteers in the social service organization; andreview entity type identifying how close an organization is to reaching a number of goals based on cost per client, a year, a number of funding resources, a net income, income growth, and program performance ratings, and evaluation of the financial status of the organization based on cost per client, a year, a number of funding resources, a net income, income growth, and program performance ratings; responsive to identifying one or more correlations based on at least two of client entity type, service entity type, census entity type, volunteer entity type, and review entity type, the computer creating a first set of one or more relationships between entity types corresponding to the identified one or more correlations; the computer storing the first plurality of entity types and the first set of one or more relationships between entities in a first database; and the computer generating a first set of reports using the stored first plurality of entity types and the first set of one or more relationships in the first database.