Application

Data Model

Code	Name	Description	Type
entityId	Application ID		string
status	Status	cw-family-application-status	string
requestDate	Request Date		datetime
name	Family Name		string
data.paymentType	Application Payment Type	cw-family-application-option-applicationPaymentType	string
data.referralSource	Referral Source		string
data.referralSourceOther	Other Referral Source		string
data.findCareZipCode	Need Child Care Zip Code		string
data.findCareZipCodeReason	Location Reason		string
data.findCareZipCodeReasonOther	Other Location Reason		string
data.needCareServiceCountycw-family-application-option-county	Need Child Care Service County	cw-family-application-option-county	string
data.preferredProviderType	Preferred Provider Type	cw-family-application-option-preferredProviderType	string
data.familyType	Family Type	cw-family-application-option-familyType	string
data.isSingleParent	Single Parent		bool
data.isHomeless	Homeless		bool
data.isSiblingEnrolled	Sibling Enrolled		bool
data.siblingEnrolledProvider	Sibling Enrolled Provider		string
data.siblingNote	Sibling Note		string
data.address.address1	Address1		string
data.address.address2	Apt #, Floor #, etc		string
data.address.longitude	Longitude		number
data.address.latitude	Latitude		number
data.address.zip	Zip Code		string
data.address.city	City		string
data.address.state	State	cw-family-application-option-state	string
data.address.county	County	cw-family-application-option-county	string
data.isSameMailing	Has Same Mailing Address		bool
data.mailingAddres.address	Mailing Address		string
data.mailingAddres.address2	Mailing Apt #, Floor #, etc		string
data.mailingAddres.zip	Mailing Zip Code		string
data.mailingAddres.city	Mailing City		string
data.mailingAddres.state	Mailing State		string
data.mailingAddres.county	Mailing County	cw-family-application-option-county	string
data.FIPS	FIPS		string
data.familySize	Family Size		number
data.familyIncome	Family Monthly Income		number
data.CPSAtRisk	CPS/At Risk	cw-family-application-option-CPSAtRisk	string
data.meansTested	Means Tested Government Program	cw-family-application-option-meansTested	string
data.meansTestedOther	Other Means Tested Government Program		string
data.exceptionalNeeds	Exceptional Needs		bool
data.englishLanguageLearner	Dual Language Learner		bool
data.cashAid	Cash Aid Status	cw-family-application-option-cashAid	string
data.cashAidTerminationDate	Cash Aid Term Date		string
data.cashAidFrom	Cash Aid From		string
data.CalWORKsId	CalWORKs ID		string
data.familyFee.fullTime	Family Fee (FT)		number
data.familyFee.partTime	Family Fee (PT)		number
data.CDSSRanking	CDSS Rank		number
data.CDSSEligible	CDSS Eligible		bool
data.CDSSProgram	CDSS Program		array
data.CDERanking	CDE Rank		number
data.CDEEligible	CDE Eligible		bool
data.CDEProgram	CDE Program		array
data.headStartRanking	Head Start Rank		number
data.head StartEligible	Head Start Eligible		bool
data.head StartProgram	Head Start Program		array
data.needProviderReferral	Need Provider Referral		bool
data.hasSubsidyApplication	Subsidy Applied		bool
data.existingProvider	Existing Provider		bool
data.disclaimer	Disclaimer		bool
data.parentSigunature.image	Parent Sigunature		string
data.parentSigunature.date	Parent Sigunature Date		datetime
data.parentConsentProvider	Parent Consents Provider to View Eligibility​		bool
data.team	Team	cw-family-application-option-team	string
data.programs	Programs	cw-family-application-option-programs	string
data.outreachStatus	Outreach Status	cw-family-application-option-outreachStatus	string
data.enrollmentStartDate	Outreach Start Date		string
data.enrolledDate	Enrolled Date		string
data.tags	Tag	cw-family-application-option-familyTags	string
data.enrollmentTags	Enrollment Tags	cw-family-application-option-enrollmentTags	string
data.comment	Comment		string
data.email	System Communication Email		string
data.needSMSReminder	Text Reminder		bool
data.phone	Mobile Phone		string
data.preferedLanguage	Preferred Language	cw-family-application-option-parentPreferedLanguage	string
data.preferedLanguageOther	Other Language		string
data.familyNeedsType	Needs Type	cw-family-application-option-needsType	string
created	Created Time		datetime
createdBy	Created By		string
createdFrom	Created From		string
modified	Modified Time		datetime
modifiedBy	Modified By		string
modifiedFrom	Modified From		string
submitDate	Submit Date		datetime
updateDate	Update Application Date		datetime
updateBy	Update Application By		string
lastChangeStatusTime	Last Change Status Time		datetime
lastChangeStatusBy	Last Change Status By		string
data.parenta.firstName	Parent A First Name		string
data.parenta.middleName	Parent A Middle Name		string
data.parenta.lastName	Parent A Last Name		string
data.parenta.gender	Parent A Gender		string
data.parenta.DOB	Parent A DOB		string
data.parenta.relationshipToChild	Parent A Relationship To Child		string
data.parenta.relationshipToChildOther	Parent A Other Relationship		string
data.parenta.email	Parent A Email		string
data.parenta.phone	Parent A Cell Phone		string
data.parenta.workPhone	Parent A Work Phone		string
data.parenta.additionalNumber	Parent A Additional Number		string
data.parenta.preferedLanguage	Parent A Contact Language	cw-family-application-option-parentPreferedLanguage	string
data.parenta.preferedLanguageOther	Parent A Other Language		string
data.parenta.nativeLanguage	Parent A Native Language		string
data.parenta.needsType	Parent A Needs Type	cw-family-application-option-needsType	string
data.parenta.needsTypeOther	Parent A Other Needs Type		string
data.parenta.company.name	Parent A Company Name		string
data.parenta.company.email	Parent A Company Email		string
data.parenta.company.phone	Parent A Company Phone Number		string
data.parenta.company.address.address1	Parent A Company Address		string
data.parenta.company.address.address2	Parent A Company Apt #, Floor #, etc		string
data.parenta.company.address.zip	Parent A Company Zip		string
data.parenta.company.address.city	Parent A Company City		string
data.parenta.company.address.state	Parent A Company State	cw-family-application-option-state	string
data.parenta.company.address.county	Parent A Company County	cw-family-application-option-county	string
data.parenta.hourlyRate	Parent A Hourly Rate		number
data.parenta.incapacityTime	Parent A Incapacity Time		string
data.parenta.attendingSchool	Parent A Name Of School Attending		string
data.parenta.attendingSchoolUnits	Parent A School Units		number
data.parenta.maritalStatus	Parent A Marital Status		string
data.parenta.race	Parent A Race		string
data.parenta.ethnicity	Parent A Ethnicity		string
data.parenta.incomeSource.sourceType	Parent A Income Source Type		string
data.parenta.incomeSource.calculateType	Parent A Income Calculate Type		string
data.parenta.incomeSource.amount	Parent A Income Amount		number
data.parenta.incomeSource.description	Parent A Income Description		string
data.hasParentB	Has Parent B		bool
data.parentb.firstName	Parent B First Name		string
data.parentb.middleName	Parent B Middle Name		string
data.parentb.lastName	Parent B Last Name		string
data.parentb.gender	Parent B Gender		string
data.parentb.DOB	Parent B DOB		string
data.parentb.relationshipToChild	Parent B Relationship To Child		string
data.parentb.relationshipToChildOther	Parent B Other Relationship		string
data.parentb.email	Parent B Email		string
data.parentb.phone	Parent B Cell Phone		string
data.parentb.workPhone	Parent B Work Phone		string
data.parentb.additionalNumber	Parent B Additional Number		string
data.parentb.preferedLanguage	Parent B Contact Language	cw-family-application-option-parentPreferedLanguage	string
data.parentb.preferedLanguageOther	Parent B Other Language		string
data.parentb.nativeLanguage	Parent B Native Language		string
data.parentb.needsType	Parent B Needs Type	cw-family-application-option-needsType	string
data.parentb.needsTypeOther	Parent B Other Needs Type		string
data.parentb.company.name	Parent B Company Name		string
data.parentb.company.email	Parent B Company Email		string
data.parentb.company.phone	Parent B Company Phone Number		string
data.parentb.company.address.address1	Parent B Company Address		string
data.parentb.company.address.address2	Parent B Company Apt #, Floor #, etc		string
data.parentb.company.address.zip	Parent B Company Zip		string
data.parentb.company.address.city	Parent B Company City		string
data.parentb.company.address.state	Parent B Company State		string
data.parentb.company.address.county	Parent B Company County		string
data.parentb.hourlyRate	Parent B Hourly Rate		number
data.parentb.incapacityTime	Parent B Incapacity Time		string
data.parentb.attendingSchool	Parent B Name Of School Attending		string
data.parentb.attendingSchoolUnits	Parent B School Units		number
data.parentb.maritalStatus	Parent B Marital Status		string
data.parentb.race	Parent B Race		string
data.parentb.ethnicity	Parent B Ethnicity		string
data.parentb.incomeSource.sourceType	Parent B Income Source Type		string
data.parentb.incomeSource.calculateType	Parent B Income Calculate Type		string
data.parentb.incomeSource.amount	Parent B Income Amount		number
data.parentb.incomeSource.description	Parent B Income Description		string
data.child.entityId	Child ID		string
data.child.firstName	Child First Name		string
data.child.middleName	Child Middle Name		string
data.child.lastName	Child Last Name		string
data.child.gender	Child Gender		string
data.child.DOB	Child DOB		string
data.child.relationshipToParent	Child Relationship to Parent		string
data.child.specialNeeds	Child Special Needs		string
data.child.specialNeedsOther	Child Other Special Needs		string
data.child.race	Child Race		string
data.child.ethnicity	Child Ethnicity		string
data.child.language	Child Language		string
data.child.languageOther	Child Other Language		string
data.child.primaryHomeLanguage	Child Non-English Primary Language		string
data.child.englishLanguageLearner	Child English Language Learner		bool
data.child.grade	Child Grade		string
data.child.enrolledDate	Child Enrolled Date		string
data.child.tags	Child Tag		string
data.child.comment	Child Comment		string
data.child.CDSSEligible	Child CDSS Eligible		bool
data.child.CDSSProgram	Child CDSS Program		array
data.child.CDEEligible	Child CDE Eligible		bool
data.child.CDEProgram	Child CDE Program		array
data.child.headStartEligible	Child Head Start  Eligible		bool
data.child.headStartProgram	Child Head Start  Program		array
data.child.criteria.preferredProviderType	Preferred Provider Types		string
data.child.criteria.preferredProviderLanguage	Preferred Provider Language		string
data.child.criteria.preferredStartDate	Preferred Start Date		string
data.child.criteria.preferredCareSchedule	Preferred Care Schedule		array
data.child.criteria.specificCareHours	Specific Hours		array
data.child.criteria.calendar	Yearly Schedule		array
data.child.criteria.careHours	Child Care Hours		string
data.child.criteria.setSchedule.sun	Schedule Sunday		bool
data.child.criteria.setSchedule.sunIn	Schedule Sun In		string
data.child.criteria.setSchedule.sunOut	Schedule Sun Out		string
data.child.criteria.setSchedule.fri	Schedule Friday		bool
data.child.criteria.setSchedule.friIn	Schedule Fri In		string
data.child.criteria.setSchedule.friOut	Schedule Fri Out		string
data.child.criteria.setSchedule.mon	Schedule Monday		bool
data.child.criteria.setSchedule.monIn	Schedule Mon In		string
data.child.criteria.setSchedule.monOut	Schedule Mon Out		string
data.child.criteria.setSchedule.tue	Schedule Tuesday		bool
data.child.criteria.setSchedule.tueIn	Schedule Tue In		string
data.child.criteria.setSchedule.tueOut	Schedule Tue Out		string
data.child.criteria.setSchedule.thu	Schedule Thursday		bool
data.child.criteria.setSchedule.thuIn	Schedule Thu In		string
data.child.criteria.setSchedule.thuOut	Schedule Thu Out		string
data.child.criteria.setSchedule.wed	Schedule Wednesday		bool
data.child.criteria.setSchedule.wedIn	Schedule Wed In		string
data.child.criteria.setSchedule.wedOut	Schedule Wed Out		string
data.child.criteria.setSchedule.sat	Schedule Saturday		bool
data.child.criteria.setSchedule.satIn	Schedule Sat In		string
data.child.criteria.setSchedule.satOut	Schedule Sat Out		string
data.child.criteria.variableSchedule	Variable Schedule		string
data.child.criteria.preferredProvider.provider1	Preferred Provider1		string
data.child.criteria.preferredProvider.provider2	Preferred Provider2		string
data.child.criteria.preferredProvider.provider3	Preferred Provider3		string
data.child.criteria.preferredProvider.provider4	Preferred Provider4		string
data.child.criteria.preferredProvider.provider5	Preferred Provider5		string
data.child.criteria.referralNote	Referral Note		string
data.child.criteria.referralDisclaimer	Referral Disclaimer Check		bool
caseOwner	Case Owner		string
assignBy	Assign By		string
assignTime	Assign Time		datetime
account	User Account		string
accountActivity.linkTime	Link Account Time		datetime
accountActivity.linkBy	Link Account By		string
accountActivity.unlinkTime	Unlink Account Time		datetime
accountActivity.unlinkBy	Unlink Account By		string
accountActivity.firstActivityTime	User First Activity Time		datetime
accountActivity.lastActivityTime	User Last Activity Time		datetime
link.careConnect.familyId	CCN Family ID		string
link.careControl3.familyId	CC3 Family ID		string
link.careControl4.hadEnrolled	CC4 Had Enrolled		bool
link.careControl4.enroll.carewaitChildEntityId	CC4 CareWaitChildEntityId		string
link.careControl4.enroll.enrollmentOrganization	CC4 EnrollmentOrganization		string
link.careControl4.enroll.enrollmentUser	CC4 EnrollmentUser		string
link.careControl4.enroll.enrollmentDate	CC4 EnrollmentDate		datetime
link.careControl4.enroll.caseId	CC4 CaseId		string
link.careControl4.enroll.familyId	CC4 FamilyId		string
link.careControl4.enroll.childId	CC4 ChildId		string
link.careControl4.enroll.subsidy	CC4 Subsidy		string
link.careControl4.enroll.customerCode	CC4 CustomerCode		string
linkInternal.datasource_code	Internal Link Entity Type	cw-family	string
linkInternal.id	Internal Link Id		string
linkInternal.linkTime	Internal Link Time		datetime
linkInternal.linkBy	Internal Link By		string
data.tracking.swichPaymentType.from	Swich Payment Type From	cw-family-application-option-applicationPaymentType	string
data.tracking.swichPaymentType.to	Swich Payment Type To	cw-family-application-option-applicationPaymentType	string

Options

referralSource

Code	Name	Description
email	Email
friendRelative	Friend/Relative
childCareProvider	Child Care Provider
advertisementFlyer	Advertisement/Flyer
socialServiceAgency	Child Welfare/Other Social Service Agency
internet	Internet
onSiteReferral	On Site Referral
website	Website
other	Other

findCareLocationReason

Code	Name	Description
iWorkHere	I work here
iLiveHere	I live here
iGoToSchoolHere	I go to school here
other	Other

familyType - cw-family-application-option-familyType

Code	Name	Description
guardianship	Guardianship
biologicalAdoptive	Biological/Adoptive
foster	Foster

relationshipToChild

Code	Name	Description
father	Father
mother	Mother
grandparent	Grandparent
fosterParent	Foster Parent
guardian	Legal Guardian
familyMember	Family Member
other	Other

parentPreferedLanguage - cw-family-application-option-parentPreferedLanguage

Code	Name	Description
english	English
spanish	Spanish
cantonese	Cantonese
vietnamese	Vietnamese
mandarin	Mandarin
arabic	Arabic
other	Other

nativeLanguage

Code	Name	Description
ASL	American Sign Language (ASL)
arabic	Arabic
armenian	Armenian
assyrian	Assyrian
burmese	Burmese
cantonese	Cantonese
cebuano	Cebuano (Visayan)
chalden	Chalden
chamarro	Chamarro (Guamanian)
chaozhao	Chaozhao (Chaochow)
croation	Croation
dutch	Dutch
english	English
farsi	Farsi
french	French
german	German
greek	Greek
gujarati	Gujarati
hebrew	Hebrew
hindi	Hindi
hmong	Hmong
hungarian	Hungarian
ilocano	Ilocano
indonesian	Indonesian
italian	Italian
japanese	Japanese
khmer	Khmer (Cambodian)
korean	Korean
kurdish	Kurdish
lao	Lao
mandarin	Mandarin(Puntonghua)
marchallese	Marchallese
mien	Mien
mixteco	Mixteco
NAL	Native American Languages
OLOC	Other Languages of China
OLOTP	Other Languages of the Philippines
ONE	Other non-English
pashto	Pashto
pilipino	Pilipino (Taglog)
polish	Polish
portuguese	Portuguese
punjabi	Punjabi
rumanian	Rumanian
russian	Russian
samoan	Samoan
spanish	Spanish
serbian	Serbian
serbocroation	Serbo-Croation
taiwanese	Taiwanese
thai	Thai
tongan	Tongan
turkish	Turkish
ukrainian	Ukrainian
urdu	Urdu
vietnamese	Vietnamese
other	Other

maritalStatus

Code	Name	Description
single	Single
divorced	Divorced
married	Married
separated	Separated
widowed	Widowed

parentPreferedContact

Code	Name	Description
email	Email
sms	SMS

gender

Code	Name	Description
M	Male
F	Female
X	Prefer Not to Identify/Unknown

specialNeeds

Code	Name	Description
IEP	IEP
IFSP	IFSP
RSSI	Receives SSI
DC	Developmental Concerns
other	Other

childPrimaryHomeLanguage

Code	Name	Description
Y	Yes
N	No

childLanguage

Code	Name	Description
english	English
spanish	Spanish
cantonese	Cantonese
mandarin	Mandarin
other	Other

race

Code	Name	Description
AIAN	American Indian or Alaskan Native
asian	Asian
BAA	Black or African American
NHPI	Native Hawaiian or Other Pacific islander
white	White
DTS	Decline to state
caucasian	CAUCASIAN (NON-HISPANIC)
HOL	Hispanic or Latino
other	Other

ethnicity

Code	Name	Description
NH	Not Hispanic or Latino
H	Hispanic or Latino
DTS	Decline to state
other	Other

needsType - cw-family-application-option-needsType

Code	Name	Description
working	Working
incapacity	Incapacity
seekingEmployment	Seeking Employment
training	Attending School or Vocational Training
homeless	Currently experiencing homeless or seeking permanent housing
emergencyNeed	Emergency Need for Child Care
bySocialWorker	Referred to Child Care by a Social Worker
seekingPartDay	Seeking Part-Day Educational Pre-School for Child
neighborhoodSchool	Neighborhood School Eligibility
NA	None Applicable
other	Other Childcare Reason

CPSAtRisk - cw-family-application-option-CPSAtRisk

Code	Name	Description
CPS	Child Protective Services
AR	At Risk
DCFS	Working with the Department of Children and Family Services

meansTested - cw-family-application-option-meansTested

Code	Name	Description
MediCal	Medi-Cal
CalFresh	CalFresh
CFAP	California Food Assistance Program
WIC	WIC (WOMEN, INFANTS & CHILDREN)
FFDPI	The Federal Food Distribution Program on Indian Reservations
HeadStart	Head Start
EarlyHeadStart	Early Head Start
CalWORKs	CalWORKs
cashAid	Cash Aid
other	Other Means-Tested Government Program

cashAid - cw-family-application-option-cashAid

Code	Name	Description
receiving	Currently Receiving Cash Aid
termed	Termed from Cash Aid; no longer receiving Cash Aid
never	Never Received Cash Aid

programs - cw-family-application-option-program

Code	Name	Description
stateSubsidy	Alternative Payment Program
CSPP	CSPP
CCTR	CCTR
HS	HS
EHS	EHS
privatePay	Private Pay
other	Other

CDSSProgram - cw-family-application-option-csssprogram

Code	Name	Description
capp	CAPP
c2ap	C2AP
stage1	Stage 1

team - ccrc-cw-family-application-option-team

Code	Name	Description
AV	AV
HQ	HQ
SB	SB
VV	VV

outreachStatus - cw-family-application-option-outreachStatus

Code	Name	Description
firstContact	First Contact
followUp1	Follow Up 1
followUp2	Follow Up 2
followUp3	Follow Up 3
providerAgreement	Provider Agreement
enrollmentReady	Enrollment Ready
nonResponsive	Non-responsive
waitingOnParentResponse	Waiting on Parent response
docRequest	Doc Request
enrollmentFileReview	Enrollment File Review
providerSiteSelection	Provider/Site Selection

criteriaProviderType

Code	Name	Description
LFCC	Licensed Family Childcare Home
LC	Licensed Center
FFN	Family, Friend or Neighbor Care

criteriaPreferredProviderLanguage

Code	Name	Description
english	English
spanish	Spanish
cantonese	Cantonese
mandarin	Mandarin
japanese	Japanese
korean	Korean
pilipino	Pilipino (Tagalog)
vietnamese	Vietnamese
OLOCN	Other Languages of China
other	Other

preferredCareHours

Code	Name	Description
FT	Full Time
PT	Part Time
EVE	Evening
WE	Weekend
ON	Overnight

childCareHours

Code	Name	Description
setSchedule	Set Schedule - Days of care are the same week to week
variableSchedule	Variable Schedule - Days of care changes week to week

preferredProviderType - cw-family-application-option-preferredProviderType

Code	Name	Description
sub	I am only interested in Subsidized Providers.
fcchen	I am interested in Family Child Care Home Education Network Providers.
both	I am interested in both.
notsure	I am not sure.

fcchenInterest - cw-family-application-option-fcchenInterest

Code	Name	Description
fcchen	Yes, I am interested in FCCHEN providers
both	I am interested in both

relationshipToParent

Code	Name	Description
son	Son
daughter	Daughter
foster	Foster
other	Other

grade

Code	Name	Description
1stGrade	1st Grade
2ndGrade	2nd Grade
3rdGrade	3rd Grade
4rdGrade	4rd Grade
5thGrade	5th Grade
6thGrade	6th Grade
7thGrade	7th Grade
8thGrade	8th Grade
9thGrade	9th Grade
kindergarten	Kindergarten
preschool	Preschool
TK	TK

applicationPaymentType

Code	Name	Description
subsidy	Subsidy
privatePay	Private Pay