Family

Introduction

This data comes from View QueryFamilyView. View name is View_FamilyUDF. You can use View directly, and if you have access to the database, you can also access the data through the API.

QueryFamilyView includes ViewParent (View_ParentUDF) and ViewChild(View_ChildUDF)

CC4 Standard

Family

Code	Name	Description	Type	Tags	ChildEntity	IsSystem	Disable
Address	Home Address	Address	string	Family	QueryFamilyView	True	False
B001	Lock User Group	Lock User Group	boolean	Family	QueryFamilyView	True	False
CashAid	Cash Aid Status Code	Cash Aid Status	string	Family	QueryFamilyView	True	False
CashAidName	Cash Aid Status Name	Display in result only	string	Family	QueryFamilyView	True	False
Cell	Cell	Cell Phone	string	Family	QueryFamilyView	True	False
City	Home City	City	string	Family	QueryFamilyView	True	False
Comment	Comment	Comment	string	Family	QueryFamilyView	True	False
County	Home County	County	string	Family	QueryFamilyView	True	False
CountyNumber	County ID	County ID	string	Family	QueryFamilyView	True	False
CreateTime	Create Time	Create Time	datetime	Family	QueryFamilyView	True	False
CreateUserId	Create User ID	Create User ID	number	Family	QueryFamilyView	True	False
Disable	Disable	Voided	boolean	Family	QueryFamilyView	True	False
DisplayAsName	Family Display Name	Display in result only, the format is Family “LastName, FirstName“	string	Family	QueryFamilyView	True	False
Email	Email	Parent A Email	string	Family	QueryFamilyView	True	False
FamilyId	Family ID	Family ID	number	Family	QueryFamilyView	True	False
FamilyName	Family Name	Format is Family “FirstName LastName”	string	Family	QueryFamilyView	True	False
FamilySize	Family Size	Family Size	number	Family	QueryFamilyView	True	False
FamilyType	Family Type	Family Type	string	Family	QueryFamilyView	True	False
FirstName	Family First Name	Family First Name	string	Family	QueryFamilyView	True	False
FullAddress	Full Home Address	include address, zip, state, city, county	string	Family	QueryFamilyView	True	False
Homeless	Is Homeless	Homeless checkbox (True: Checked, False: Unchecked)	boolean	Family	QueryFamilyView	True	False
HomePhone	Home Phone	Parent A Home Phone	string	Family	QueryFamilyView	True	False
IsSingleParent	Is Single Parent	Whether this parent is Single Parent. Display in result only (True: Yes False: No)	boolean	Family	QueryFamilyView	True	False
Language	Family Language ID	Report Language	number	Family	QueryFamilyView	True	False
LanguageName	Family Language Name	Display in result only	string	Family	QueryFamilyView	True	False
LastName	Family Last Name	Family Last Name	string	Family	QueryFamilyView	True	False
MailAddress	Mail Address	Mailing Address	string	Family	QueryFamilyView	True	False
MailCity	Mail City	Mailing City	string	Family	QueryFamilyView	True	False
MailCounty	Mail County	Mail County	string	Family	QueryFamilyView	True	False
MailState	Mail State	Mail State	string	Family	QueryFamilyView	True	False
MailUnit	Mail Unit	Mail Unit	string	Family	QueryFamilyView	True	False
MailZip	Mail Zip	Mailing Zip	string	Family	QueryFamilyView	True	False
MailZip5D	MailZip5D	MailZip5D	string	Family	QueryFamilyView	False	False
MiddleInitial	Family Middle Initial	Family Middle Initial	string	Family	QueryFamilyView	True	False
Parent__BestCallNum	Parent Best Call Number	Member detail hidden field	string	Parent	QueryParent	False	False
Parent__BestCallTime	Parent Best Time to Call	Member Detail hidden field	string	Parent	QueryParent	False	False
Parent__Cell	Parent Cell	Cell	string	Parent	QueryParent	False	False
Parent__CommunicationMethod	Parent Com. Methood Opt. Out	Member Detail hidden field	string	Parent	QueryParent	False	False
Parent__DateOfBirth	Parent Member DOB	Member DOB	datetime	Parent	QueryParent	False	False
Parent__Disable	Parent Disable	default check data of Disable=False	boolean	Parent	QueryParent	False	False
Parent__Email	Parent Email	Email	string	Parent	QueryParent	False	False
Parent__Ethnicity	Parent Member Ethnicity	Member Ethnicity	number	Parent	QueryParent	False	False
Parent__EthnicityName	Parent Ethnicity Name	Ethnicity Name	string	Parent	QueryParent	False	False
Parent__FamilyId	Parent Family ID	Family ID	number	Parent	QueryParent	False	False
Parent__FamilyID	Parent Family ID	Family ID	number	Parent	QueryParent	False	False
Parent__FamilyName	Parent Family Name	Family Name	string	Parent	QueryParent	False	False
Parent__FirstName	Parent First Name	First Name	string	Parent	QueryParent	False	False
Parent__Gender	Parent Gender	Gender	string	Parent	QueryParent	False	False
Parent__HomePhone	Parent Home Phone	Home Phone	string	Parent	QueryParent	False	False
Parent__IncludeInSize	Parent Include In Family Size	Include In Family Size Checkbox (True: checked, False: Unchecked)	boolean	Parent	QueryParent	False	False
Parent__Language	Parent Member Language	Member Language	number	Parent	QueryParent	False	False
Parent__LanguageName	Parent Language Name	Language Name	string	Parent	QueryParent	False	False
Parent__LastName	Parent Last Name	Last Name	string	Parent	QueryParent	False	False
Parent__LimitedEnglish	Parent Ltd.English	hidden field	boolean	Parent	QueryParent	False	False
Parent__MaritalStatus	Parent Marital Status	Married or Single	string	Parent	QueryParent	False	False
Parent__MiddleInitial	Parent Middle Initial	Middle Initial	string	Parent	QueryParent	False	False
Parent__MultipleRace	Parent Member Race	Member Race	string	Parent	QueryParent	False	False
Parent__O001	Parent Family App	Family App	object	Parent	QueryParent	False	False
Parent__ParentID	Parent Member ID	Member ID	number	Parent	QueryParent	False	False
Parent__ParentName	Parent Member Name	Member Name	string	Parent	QueryParent	False	False
Parent__PID	Parent PID	PID field in Member detail	string	Parent	QueryParent	False	False
Parent__Relationship	Parent Member Relationship ID	Member Relationship ID	number	Parent	QueryParent	False	False
Parent__RelationshipName	Parent Relationship Name	Relationship Name	string	Parent	QueryParent	False	False
Parent__Responsibility	Parent Member Type Code	Code of Member Type	string	Parent	QueryParent	False	False
Parent__ResponsibilityName	Parent Member Type Name	Parent A/B/Other	string	Parent	QueryParent	False	False
Parent__S030	Parent Child Plus ID	Child Plus ID	string	Parent	QueryParent	False	False
Parent__Status	Parent Member Status	Status	number	Parent	QueryParent	False	False
Parent__TrainingEndDate	Parent Training End Date	Training End Date	datetime	Parent	QueryParent	False	False
Parent__TrainingStartDate	Parent Training Start Date	Training Start Date	datetime	Parent	QueryParent	False	False
Parent__WorkPhone	Parent Work Phone	Work Phone	string	Parent	QueryParent	False	False
ParentB__BestCallNum	ParentB Best Call Number	Member detail hidden field	string	Parent B	QueryParent	False	False
ParentB__BestCallTime	ParentB Best Time to Call	Member Detail hidden field	string	Parent B	QueryParent	False	False
ParentB__Cell	ParentB Cell	Cell	string	Parent B	QueryParent	False	False
ParentB__CommunicationMethod	ParentB Com. Methood Opt. Out	Member Detail hidden field	string	Parent B	QueryParent	False	False
ParentB__DateOfBirth	ParentB Member DOB	Member DOB	datetime	Parent B	QueryParent	False	False
ParentB__Disable	ParentB Disable	default check data of Disable=False	boolean	Parent B	QueryParent	False	False
ParentB__Email	ParentB Email	Email	string	Parent B	QueryParent	False	False
ParentB__Ethnicity	ParentB Member Ethnicity	Member Ethnicity	number	Parent B	QueryParent	False	False
ParentB__EthnicityName	ParentB Ethnicity Name	Ethnicity Name	string	Parent B	QueryParent	False	False
ParentB__FamilyId	ParentB Family ID	Family ID	number	Parent B	QueryParent	False	False
ParentB__FamilyID	ParentB Family ID	Family ID	number	Parent B	QueryParent	False	False
ParentB__FamilyName	ParentB Family Name	Family Name	string	Parent B	QueryParent	False	False
ParentB__FirstName	ParentB First Name	First Name	string	Parent B	QueryParent	False	False
ParentB__Gender	ParentB Gender	Gender	string	Parent B	QueryParent	False	False
ParentB__HomePhone	ParentB Home Phone	Home Phone	string	Parent B	QueryParent	False	False
ParentB__IncludeInSize	ParentB Include In Family Size	Include In Family Size Checkbox (True: checked, False: Unchecked)	boolean	Parent B	QueryParent	False	False
ParentB__Language	ParentB Member Language	Member Language	number	Parent B	QueryParent	False	False
ParentB__LanguageName	ParentB Language Name	Language Name	string	Parent B	QueryParent	False	False
ParentB__LastName	ParentB Last Name	Last Name	string	Parent B	QueryParent	False	False
ParentB__LimitedEnglish	ParentB Ltd.English	hidden field	boolean	Parent B	QueryParent	False	False
ParentB__MaritalStatus	ParentB Marital Status	Married or Single	string	Parent B	QueryParent	False	False
ParentB__MiddleInitial	ParentB Middle Initial	Middle Initial	string	Parent B	QueryParent	False	False
ParentB__MultipleRace	ParentB Member Race	Member Race	string	Parent B	QueryParent	False	False
ParentB__O001	ParentB Family App	Family App	object	Parent B	QueryParent	False	False
ParentB__ParentID	ParentB Member ID	Member ID	number	Parent B	QueryParent	False	False
ParentB__ParentName	ParentB Member Name	Member Name	string	Parent B	QueryParent	False	False
ParentB__PID	ParentB PID	PID field in Member detail	string	Parent B	QueryParent	False	False
ParentB__Relationship	ParentB Member Relationship ID	Member Relationship ID	number	Parent B	QueryParent	False	False
ParentB__RelationshipName	ParentB Relationship Name	Relationship Name	string	Parent B	QueryParent	False	False
ParentB__Responsibility	ParentB Member Type Code	Code of Member Type	string	Parent B	QueryParent	False	False
ParentB__ResponsibilityName	ParentB Member Type Name	Parent A/B/Other	string	Parent B	QueryParent	False	False
ParentB__S030	ParentB Child Plus ID	Child Plus ID	string	Parent B	QueryParent	False	False
ParentB__Status	ParentB Member Status	Status	number	Parent B	QueryParent	False	False
ParentB__TrainingEndDate	ParentB Training End Date	Training End Date	datetime	Parent B	QueryParent	False	False
ParentB__TrainingStartDate	ParentB Training Start Date	Training Start Date	datetime	Parent B	QueryParent	False	False
ParentB__WorkPhone	ParentB Work Phone	Work Phone	string	Parent B	QueryParent	False	False
ParentFirstName	Parent First Name	Parent First Name	string	Family	QueryFamilyView	True	False
ParentLastName	Parent Last Name	Parent Last Name	string	Family	QueryFamilyView	True	False
ParentMiddleInitial	Parent Middle Initial	Parent Middle Initial	string	Family	QueryFamilyView	True	False
ParentSize	Parent Size	The count of parents, maximum value is 2	string	Family	QueryFamilyView	True	False
ParentSizeName	Parent Size Name	Single Parent or 2-Parent Family; Display in result only	string	Family	QueryFamilyView	True	False
Prohibit	Is Prohibit	Prohibit; Checkbox (True: checked, False: Unchecked)	boolean	Family	QueryFamilyView	True	False
ProhibitName	Prohibit Name	Yes or No; Display in result only	string	Family	QueryFamilyView	True	False
ProhibitReson	Prohibit Reason	Prohibit Reason	string	Family	QueryFamilyView	True	False
ProhibitResonName	Prohibit Reson Name	Display in result only	string	Family	QueryFamilyView	True	False
S015	FIPS	FIPS	string	Family	QueryFamilyView	True	False
S016	Mail FIPS	Mail FIPS	string	Family	QueryFamilyView	True	False
S020	HSA Worker Name	HSA Worker Name	string	Family	QueryFamilyView	True	False
S021	HSA Worker Number	HSA Worker Number	string	Family	QueryFamilyView	True	False
S022	HSA Worker Telephone	HSA Worker Telephone	string	Family	QueryFamilyView	True	False
S030	HSA Worker Address	HSA Worker Address	string	Family	QueryFamilyView	True	False
S080	Application ID	Application ID	string	Family	QueryFamilyView	True	False
SameAddress	Same as Home Address	Same as Home Address Checkbox (True: checked, False: Unchecked)	boolean	Family	QueryFamilyView	True	False
State	Home State	State	string	Family	QueryFamilyView	True	False
TermDate	Term Date	Cash Aid Term Date	datetime	Family	QueryFamilyView	True	False
Unit	Home Unit	Unit	string	Family	QueryFamilyView	True	False
UpdateTime	Update Time	Update Time	datetime	Family	QueryFamilyView	True	False
UpdateUserId	Update User ID	Update User ID	number	Family	QueryFamilyView	True	False
WorkPhone	Work Phone	Family Work Phone, pull from Parent A Work Phone	string	Family	QueryFamilyView	True	False
Zip	Home Zip	Zip	string	Family	QueryFamilyView	True	False
Zip5D	Zip5D	Zip5D	string	Family	QueryFamilyView	False	False

Child

Code	Name	Description	Type	Tags	ChildEntity	IsSystem	Disable
CaseIDs	Case ID	All cases that the child linked	string	Child	QueryChildren	True	False
ChildAge	Age	Age	string	Child	QueryChildren	True	False
ChildID	Child ID	ID	number	Child	QueryChildren	True	False
ChildName	Child Name	Child Name	string	Child	QueryChildren	True	False
CID	CID	CID	string	Child	QueryChildren	True	False
Comments	Comments	Comments	string	Child	QueryChildren	True	False
CreateTime	Create Time	Create Time	datetime	Child	QueryChildren	True	False
CreateUserId	Create User ID	User ID of the person who created the child, it can be used for Query and Result list	number	Child	QueryChildren	True	False
DateOfBirth	DOB	DOB	datetime	Child	QueryChildren	True	False
Disable	Disable	Disable	boolean	Child	QueryChildren	True	False
DT001	School Update Time	Update time of child school include school calendar	datetime	Child	QueryChildren	True	False
EndDate	End Date	EndDate	datetime	Child	QueryChildren	True	False
Ethnicity	Ethnicity	Ethnicity	number	Child	QueryChildren	True	False
FamilyID	Family ID	Family ID	number	Child	QueryChildren	True	False
FamilyName	Family Name	Family Name	string	Child	QueryChildren	True	False
FirstName	First Name	First Name	string	Child	QueryChildren	True	False
Gender	Gender	Gender	string	Child	QueryChildren	True	False
Grade	Grade ID	Grade	string	Child	QueryChildren	True	False
GradeName	GradeName	GradeName	string	Child	QueryChildren	True	False
IncludeInSize	Include in Family Size	Include in Family Size	boolean	Child	QueryChildren	True	False
IS001	Calendar Template GUID	The Calendar Template GUID that the child followed	string	Child	QueryChildren	True	False
IsProtectiveService	Protective Service	Protective Service	boolean	Child	QueryChildren	True	False
Language	Language ID	Language	number	Child	QueryChildren	True	False
LastName	Last Name	Last Name	string	Child	QueryChildren	True	False
LimitedEnglish	Limited English	Limited English	boolean	Child	QueryChildren	True	False
MiddleInitial	MI	Middle Initial	string	Child	QueryChildren	True	False
MultipleRace	Race	Race	string	Child	QueryChildren	True	False
Relationship	Relationship	Relationship	number	Child	QueryChildren	True	False
S001	School Name	School Name	string	Child	QueryChildren	True	False
S003	District	District	string	Child	QueryChildren	True	False
S004	Track	Track	string	Child	QueryChildren	True	False
S005	School Start Date	School Start Date	string	Child	QueryChildren	True	False
S006	School Comment	School Comment	string	Child	QueryChildren	True	False
S011	Target Population	Target Population	string	Child	QueryChildren	True	False
S030	Child Plus ID	Reserved for Child Plus when agency has EHS/HS	string	Child	QueryChildren	True	False
S080	CareWait Child ID	CareWait Child ID	string	Child	QueryChildren	True	False
SpecialNeedIDs	Special Needs ID	Special Needs Id	string	Child	QueryChildren	True	False
SpecialNeeds	Special Needs Name	Special Needs Name	string	Child	QueryChildren	True	False
SsNumber	SSN	SSN	string	Child	QueryChildren	True	False
StartDate	Start Date	StartDate	datetime	Child	QueryChildren	True	False
Status	Child Status	Status	number	Child	QueryChildren	True	False
UpdateTime	Update Time	Update Time	datetime	Child	QueryChildren	True	False
UpdateUserId	Update User Id	The user ID of the person who updated the child, it can be used for Query and Result list	number	Child	QueryChildren	True	False

Parent

Code	Name	Description	Type	Tags	ChildEntity	IsSystem	Disable
BestCallNum	Best Call Number	Member detail hidden field	string	Parent	QueryParent	True	False
BestCallTime	Best Time to Call	Member Detail hidden field	string	Parent	QueryParent	True	False
Cell	Cell	Cell	string	Parent	QueryParent	True	False
CommunicationMethod	Com. Methood Opt. Out	Member Detail hidden field	string	Parent	QueryParent	True	False
DateOfBirth	Member DOB	Member DOB	datetime	Parent	QueryParent	True	False
Disable	Disable	default check data of Disable=False	boolean	Parent	QueryParent	True	False
Email	Email	Email	string	Parent	QueryParent	True	False
Ethnicity	Member Ethnicity	Member Ethnicity	number	Parent	QueryParent	True	False
EthnicityName	Ethnicity Name	Ethnicity Name	string	Parent	QueryParent	True	False
FamilyId	Family ID	Family ID	number	Parent	QueryParent	True	False
FamilyName	Family Name	Family Name	string	Parent	QueryParent	True	False
FirstName	First Name	First Name	string	Parent	QueryParent	True	False
Gender	Gender	Gender	string	Parent	QueryParent	True	False
HomePhone	Home Phone	Home Phone	string	Parent	QueryParent	True	False
IncludeInSize	Include In Family Size	Include In Family Size Checkbox (True: checked, False: Unchecked)	boolean	Parent	QueryParent	True	False
Language	Member Language	Member Language	number	Parent	QueryParent	True	False
LanguageName	Language Name	Language Name	string	Parent	QueryParent	True	False
LastName	Last Name	Last Name	string	Parent	QueryParent	True	False
LimitedEnglish	Ltd.English	hidden field	boolean	Parent	QueryParent	True	False
MaritalStatus	Marital Status	Married or Single	string	Parent	QueryParent	True	False
MiddleInitial	Middle Initial	Middle Initial	string	Parent	QueryParent	True	False
MultipleRace	Member Race	Member Race	string	Parent	QueryParent	True	False
O001	Family App	Family App	object	Parent	QueryParent	True	False
ParentID	Member ID	Member ID	number	Parent	QueryParent	True	False
ParentName	Member Name	Member Name	string	Parent	QueryParent	True	False
PID	PID	PID field in Member detail	string	Parent	QueryParent	True	False
Relationship	Member Relationship ID	Member Relationship ID	number	Parent	QueryParent	True	False
RelationshipName	Relationship Name	Relationship Name	string	Parent	QueryParent	True	False
Responsibility	Member Type Code	Code of Member Type	string	Parent	QueryParent	True	False
ResponsibilityName	Member Type Name	Parent A/B/Other	string	Parent	QueryParent	True	False
S030	Child Plus ID	Child Plus ID	string	Parent	QueryParent	True	False
Status	Member Status	Status	number	Parent	QueryParent	True	False
TrainingEndDate	Training End Date	Training End Date	datetime	Parent	QueryParent	True	False
TrainingStartDate	Training Start Date	Training Start Date	datetime	Parent	QueryParent	True	False
WorkPhone	Work Phone	Work Phone	string	Parent	QueryParent	True	False