Public Sector Child Welfare

The Child Welfare feature addresses the intake and case management needs of social service agencies working to provide child welfare services. Intake, Screening Decision, Assessment Management, Court Processing Interface, and Service Plan Creation functions are included. As the ERD (see the following figure) depicts, a Case can have one or more Incidents and one or more Benefit Plans. An Incident can have multiple Assessments, can be approved by one or more Positions, can have one or more Contacts and uses an Approval Template. An Incident can also have one or more Allegations that can be allegations on one or more Contacts associated with the Incident. A Benefit Plan can have one or more Court Hearings and a Court Hearing can have one or more Court Decisions.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Allegation	S_ALLEGATION
Approval Template	S_APPR_TEMPLATE
Assessment	S_ASSESS
Benefit Plan	S_CASE_BNFTPLAN
Case	S_CASE, S_CASE_PSX
Contact	S_CONTACT, S_PARTY
Court Decision	S_COURT_DECISN
Court Hearing	S_EVT_ACT
Incident	S_INCIDENT
Position	S_POSTN, S_PARTY
Service Plan	S_CASE_BNFTPLAN
Time Sheet	S_TMSHT
Time Sheet Item	S_TMSHT_ITEM
Time Sheet Line	S_TMSHT_LN