Case

Introduction

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

CC4 Standard

Code	Name	Description	Type	Tags	ChildEntity	IsSystem	Disable
ActionComment	Reason Detail	Reason Detail	string	Case	Case	False	False
ActionReason	Status Reason Code	Status Reason Code	string	Case	Case	False	False
B001	Active duty in the us military	Active duty in the us military	boolean	Case	Case	True	False
B002	National Guard	National guard unit or military reserve member	boolean	Case	Case	True	False
B003	(Migration) Review Complete	Migration Review Complete	boolean	Case	Case	True	False
CAPPEndDate	CAPP End	CAPP End	datetime	Case	Case	True	False
CAPPStartDate	CAPP Start	CAPP Start	datetime	Case	Case	True	False
Caseid	Case ID	Case ID	number	Case	Case	True	False
CaseOwner	Case Owner Name	Case specialist name can be used in the result list	string	Case	Case	True	False
Cd9600EligibilityTypes	CCD 26 Eligibility Type	CCD 26 Eligibility Type	string	Case	Case	False	False
Cd9600IncomeSources	CCD 26 Income Source	Cd9600IncomeSources	string	Case	Case	False	False
Cd9600NeedTypes	CCD 26 Need Type PT A	CCD 26 Need Type PT A	string	Case	Case	False	False
Cd9600NeedTypes2	CCD 26 Need Type PT B	CCD 26 Need Type PT B	string	Case	Case	False	False
Cd9600SignDate	Recert Signed	Cd9600SignDate	datetime	Case	Case	True	False
CertifyDate	Service Start	Service Start Date	datetime	Case	Case	True	False
ContractCode	Program Code	Program Code, can be used for Query form	string	Case	Case	False	False
Contractid	Program ID	Program ID can be used for Query and Result list	number	Case	Case	True	False
ContractName	Program Name	Program Name can only be used for Result list	string	Case	Case	True	False
CountyID	Report County ID	Report County ID can be used for Query and Result list	number	Case	Case	True	False
CountyName	Report County Name	Report County Name can only be used for Result list	string	Case	Case	True	False
Cps	Fee Exemptions	Fee Exemptions	string	Case	Case	True	False
CreateTime	Create Time	Create Time	datetime	Case	Case	True	False
CreateUserId	Create User ID	User ID of the person who created the case, it can be used for Query and Result list	number	Case	Case	True	False
D001	Migration Completed Date	(Migration) Completed Date	datetime	Case	Case	True	False
Disable	Disable	Disable	boolean	Case	Case	True	False
DivisionNo	Division ID	Division ID	string	Case	Case	True	False
DT010	Case Assigned Time	Case Assigned Time	datetime	Case	Case	True	False
EndDate	Service End	Service End	datetime	Case	Case	True	False
Family__Address	Family Home Address	Address	string	Family	QueryFamilyView	False	False
Family__B001	Family Lock User Group	Lock User Group	boolean	Family	QueryFamilyView	False	False
Family__CashAid	Family Cash Aid Status Code	Cash Aid Status	string	Family	QueryFamilyView	False	False
Family__CashAidName	Family Cash Aid Status Name	Display in result only	string	Family	QueryFamilyView	False	False
Family__Cell	Family Cell	Cell Phone	string	Family	QueryFamilyView	False	False
Family__City	Family Home City	City	string	Family	QueryFamilyView	False	False
Family__Comment	Family Comment	Comment	string	Family	QueryFamilyView	False	False
Family__County	Family Home County	County	string	Family	QueryFamilyView	False	False
Family__CountyNumber	Family County ID	County ID	string	Family	QueryFamilyView	False	False
Family__CreateTime	Family Create Time	Create Time	datetime	Family	QueryFamilyView	False	False
Family__CreateUserId	Family Create User ID	Create User ID	number	Family	QueryFamilyView	False	False
Family__Disable	Family Disable	Voided	boolean	Family	QueryFamilyView	False	False
Family__DisplayAsName	Family Family Display Name	Display in result only, the format is Family “LastName, FirstName“	string	Family	QueryFamilyView	False	False
Family__Email	Family Email	Parent A Email	string	Family	QueryFamilyView	False	False
Family__FamilyId	Family Family ID	Family ID	number	Family	QueryFamilyView	False	False
Family__FamilyName	Family Family Name	Format is Family “FirstName LastName”	string	Family	QueryFamilyView	False	False
Family__FamilySize	Family Family Size	Family Size	number	Family	QueryFamilyView	False	False
Family__FamilyType	Family Family Type	Family Type	string	Family	QueryFamilyView	False	False
Family__FirstName	Family Family First Name	Family First Name	string	Family	QueryFamilyView	False	False
Family__FullAddress	Family Full Home Address	include address, zip, state, city, county	string	Family	QueryFamilyView	False	False
Family__Homeless	Family Is Homeless	Homeless checkbox (True: Checked, False: Unchecked)	boolean	Family	QueryFamilyView	False	False
Family__HomePhone	Family Home Phone	Parent A Home Phone	string	Family	QueryFamilyView	False	False
Family__Language	Family Family Language ID	Report Language	number	Family	QueryFamilyView	False	False
Family__LanguageName	Family Family Language Name	Display in result only	string	Family	QueryFamilyView	False	False
Family__LastName	Family Family Last Name	Family Last Name	string	Family	QueryFamilyView	False	False
Family__MailAddress	Family Mail Address	Mailing Address	string	Family	QueryFamilyView	False	False
Family__MailCity	Family Mail City	Mailing City	string	Family	QueryFamilyView	False	False
Family__MailCounty	Family Mail County	Mail County	string	Family	QueryFamilyView	False	False
Family__MailState	Family Mail State	Mail State	string	Family	QueryFamilyView	False	False
Family__MailUnit	Family Mail Unit	Mail Unit	string	Family	QueryFamilyView	False	False
Family__MailZip	Family Mail Zip	Mailing Zip	string	Family	QueryFamilyView	False	False
Family__MailZip5D	Family MailZip5D	MailZip5D	string	Family	QueryFamilyView	False	False
Family__MiddleInitial	Family Family Middle Initial	Family Middle Initial	string	Family	QueryFamilyView	False	False
Family__ParentSize	Family Parent Size	The count of parents, maximum value is 2	string	Family	QueryFamilyView	False	False
Family__ParentSizeName	Family Parent Size Name	Single Parent or 2-Parent Family; Display in result only	string	Family	QueryFamilyView	False	False
Family__Prohibit	Family Is Prohibit	Prohibit; Checkbox (True: checked, False: Unchecked)	boolean	Family	QueryFamilyView	False	False
Family__ProhibitName	Family Prohibit Name	Yes or No; Display in result only	string	Family	QueryFamilyView	False	False
Family__ProhibitReson	Family Prohibit Reason	Prohibit Reason	string	Family	QueryFamilyView	False	False
Family__ProhibitResonName	Family Prohibit Reson Name	Display in result only	string	Family	QueryFamilyView	False	False
Family__S015	Family FIPS	FIPS	string	Family	QueryFamilyView	False	False
Family__S016	Family Mail FIPS	Mail FIPS	string	Family	QueryFamilyView	False	False
Family__S020	Family HSA Worker Name	HSA Worker Name	string	Family	QueryFamilyView	False	False
Family__S021	Family HSA Worker Number	HSA Worker Number	string	Family	QueryFamilyView	False	False
Family__S022	Family HSA Worker Telephone	HSA Worker Telephone	string	Family	QueryFamilyView	False	False
Family__S030	Family HSA Worker Address	HSA Worker Address	string	Family	QueryFamilyView	False	False
Family__S080	Family Application ID	Application ID	string	Family	QueryFamilyView	False	False
Family__SameAddress	Family Same as Home Address	Same as Home Address Checkbox (True: checked, False: Unchecked)	boolean	Family	QueryFamilyView	False	False
Family__State	Family Home State	State	string	Family	QueryFamilyView	False	False
Family__TermDate	Family Term Date	Cash Aid Term Date	datetime	Family	QueryFamilyView	False	False
Family__Unit	Family Home Unit	Unit	string	Family	QueryFamilyView	False	False
Family__UpdateTime	Family Update Time	Update Time	datetime	Family	QueryFamilyView	False	False
Family__UpdateUserId	Family Update User ID	Update User ID	number	Family	QueryFamilyView	False	False
Family__WorkPhone	Family Work Phone	Family Work Phone, pull from Parent A Work Phone	string	Family	QueryFamilyView	False	False
Family__Zip	Family Home Zip	Zip	string	Family	QueryFamilyView	False	False
Family__Zip5D	Family Zip5D	Zip5D	string	Family	QueryFamilyView	False	False
FamilySize	Family Size	Family Size	number	Family	Case	True	False
FeeWaiver	Fee Waiver	Fee Waiver	boolean	Case	Case	True	False
FeeWaiverEndDate	Fee Waiver End	Fee Waiver End	datetime	Case	Case	True	False
FeeWaiverStartDate	Fee Waiver Start	Fee Waiver Start	datetime	Case	Case	True	False
FirstDateOfSubsidizedService	1st Subsidized	1st Subsidized	datetime	Case	Case	True	False
FundingSourceName	Funding Source Name	Funding Source Name	string	Case	Case	True	False
InitialSubsidy	Initial Subsidy	Initial Subsidy	datetime	Case	Case	True	False
MccrRequestDate	Child Care Request Date	Child Care Request Date	datetime	Case	Case	True	False
MccrStatus	Child Care Request Status Code	Child Care Request Status Code	string	Case	Case	True	False
MccrUserCode	Child Care Request User ID	Child Care Request User ID	string	Case	Case	True	False
MccrUserName	Child Care Request User Name	Child Care Request User Name	string	Case	Case	True	False
NoaEligibilityTypes	Eligibility Type	Eligibility Type	string	Case	Case	False	False
NoaNeedTypes	Needs Type	Needs Type	string	Case	Case	False	False
OwnerId	Case Owner ID	Case Specialist ID, can be used for Query and Result list	number	Case	Case	True	False
OwnerOrgId	Case Owner Org ID	The Organization ID of Case Specialist, it can be used for Query and Result list	number	Case	Case	True	False
OwnerOrgName	Case Owner Org Name	The Organization Name of the Case Specialist, it can be used for Result list	string	Case	Case	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
ReasonInSTG1	Remaining in Stage 1 Reason	Remaining in Stage 1 Reason	string	Case	Case	True	False
RecertifyDate	Re-Certification	Re-Certification	datetime	Case	Case	True	False
ReportCountyCode	Report County Code	Report County Code	string	Case	Case	False	False
RequestDate	Request Date	Request Date	datetime	Case	Case	True	False
S001	Employee ID	Employee ID	string	Case	Case	True	False
S002	Employer Name	Employer	string	Case	Case	True	False
S003	Migration Progress	Migration Progress	string	Case	Case	True	False
S004	Application Code	ApplicationCode	string	Case	Case	True	False
S005	Queue Name	Queue Name	string	Case	Case	True	False
S016	Change Note (tracking changes without changing Status)	Change Note (tracking changes without changing Status)	string	Case	Case	True	False
SignDate	Initial Signed	Initial Signed	datetime	Case	Case	True	False
Source	Referral Source	Referral Source	string	Case	Case	True	False
Stage1EndDate	Stage 1 End	Stage 1 End	datetime	Case	Case	True	False
Stage1StarDate	Stage 1 Start	Stage 1 Start	datetime	Case	Case	True	False
Stage2EndDate	Stage 2 End	Stage 2 End	datetime	Case	Case	True	False
Stage2StarDate	Stage 2 Start	Stage 2 Start	datetime	Case	Case	True	False
Stage3EndDate	Stage 3 End	Stage 3 End	datetime	Case	Case	True	False
Stage3StarDate	Stage 3 Start	Stage 3 Start	datetime	Case	Case	True	False
Status	Case Status Code	Case Status	number	Case	Case	True	False
StatusName	Case Status Name	Case Status Name	string	Case	Case	True	False
TerminateDate	Terminate Date	Terminate Date	datetime	Case	Case	True	False
TrustlinePending	Trustline Pending	Trustline Pending	boolean	Case	Case	True	False
UpdateTime	Update Time	Update Time	datetime	Case	Case	True	False
UpdateUserId	Update User Id	The user ID of the person who updated the case, it can be used for Query and Result list	number	Case	Case	True	False