Person (Soc Security, HouseHoldID(FK), First Name, Last Name, Middle

Document Sample
scope of work template
							Person (POID, HOID(FK), Soc Security, First Name, Last Name, Middle Name, Nick
Name, Gender, Birthday, Race, Home Phone, Cell Phone, Work Phone, Ext, Address,
City, State, Zip, Email)

Client (COID, Health Insurance Company, Policy Number, Subsidized)

ClientRecServices (CRSOID, Marital Status, Referral Company, Referral Person)

ExpensesDue (EDOID, Rent, LotRent, Food, SchoolLunch, Eatingout, Toiletries,
HouseGas, Heating/Fuel, Electricity, Water, Sewer, Trash, Telephone, DayCare,
Childsupport, AutoIns, HealthIns, LifeIns, OtherIns, Car, Loan, CreditCard, AutoGas,
Clothing, Diapers, Laundromat, Furniture, CableTV, Entertainment, Pets, Postage,
Newspaper, Haircuts, ChurchDonations, Cigaretts, Alcohol, Medical, CellPhone,
Perscriptions, Taxes, Internet)

ExpensesBehind (EBOID, Rent, LotRent, Food, SchoolLunch, Eatingout, Toiletries,
HouseGas, Heating/Fuel, Electricity, Water, Sewer, Trash, Telephone, DayCare,
Childsupport, AutoIns, HealthIns, LifeIns, OtherIns, Car, Loan, CreditCard, AutoGas,
Clothing, Diapers, Laundromat, Furniture, CableTV, Entertainment, Pets, Postage,
Newspaper, Haircuts, ChurchDonations, Cigaretts, Alcohol, Medical, CellPhone,
Perscriptions, Taxes, Internet)

ClientServices (CSOID, CRSOID(FK), C_Date)

ClientServiceType (CSTOID, ClientServiceName, ClientServiceDes)

Children & Youth (CYOID, Lives With, School, Township, Medical Condition,
Medicine, Allergies, Other Health Concerns, CYIncome)

C&YServices (CYSOID, CYOID(FK), CY_Date)

CYServiceType (CYSTOID, CYServiceName, CYServiceDes)

Volunteer (VOID, Units of Service, Hours of Service)

HouseHold (HOID, HouseHoldID, HouseName)

ClientIncome (CIOID, TotalIncome)

Job (JOID, CIOID(FK), Employer, HourlyWage, HoursWorked, CheckDate)

ChildSupport (CHSOID, CIOID(FK), SupportCheck, CS_DateRecorded)

OtherIncome (OIOID, CIOID(FK), OtherInc, OI_DateRecorded, SourceOfIncome)

VolunteerServices (VSOID, VOID(FK), V_Date)
VolServiceType (VSTOID, VolServiceName, VolServiceDes)

Is_Volunteer (POID, HOID(FK), VOID)

Is_Client (POID, HOID(FK), COID)

Is_ClientRecServices (COID, CRSOID)

Is_Children&Youth (COID, CYOID)

Is_VolServiceType (VSOID(FK), VOID(FK), VSTOID(FK))

Is_ClientServiceType (CRSOID(FK), CSOID(FK), CSTOID(FK))

Is_CYServiceType (CYSOID(FK), CYOID(FK), CYSTOID(FK))

Has_ExpensesDue (CRSOID, EDOID)

Has_ExpensesBehind (CRSOID, EBOID)

Has_Income (COID, CIOID)

						
Related docs