Table Index

Sr	Table	Sr	Table	Sr	Table	Sr	Table
1	AbuserAlertImages	2	AbuserAlerts	3	AbuserIntakes	4	Abusers
5	Aliases	6	AssessmentItems	7	Assessments	8	Beds
9	Calls	10	CallServices	11	Campuses	12	ChildAbsences
13	ChildAliases	14	ChildIntakes	15	Children	16	ClientSessions
17	CommunityMembers	18	Credentials	19	DomainStatus	20	EmerContacts
21	Focus	22	Goals	23	Grantors	24	GrantorServices
25	Grants	26	GrantSurveys	27	GrantTargets	28	HotlineReferrals
29	InfoEntities	30	InfoReleases	31	IntakeBeds	32	IntakeCalls
33	IntakePhase	34	Intakes	35	IntakeStaff	36	IntakeTasks
37	IntakeVictimType	38	Interventions	39	LinkedIntakes	40	MatrixDomains
41	MatrixStatus	42	NarrativeResponses	43	Notes	44	ParticipantFiles
45	ParticipantReturnIssue	46	Participants	47	Pets	48	Phases
49	Presentations	50	PresentationTopics	51	Programs	52	ProgramServices
53	Questionnaires	54	QuestionResponses	55	Questions	56	Referrals
57	ReleaseEntities	58	ReleaseTypes	59	ReportNarratives	60	RHBA
61	RoomBedAssignments	62	Rooms	63	ServiceFocus	64	ServiceMap
65	Services	66	SessionNotes	67	Sessions	68	ShelterRequests
69	Shelters	70	Staff	71	StaffCallService	72	StaffExt
73	StaffPresentations	74	StaffReferrals	75	StaffRequirements	76	StaffSessions
77	StaffTraining	78	SurveyNarratives	79	SurveyQuestions	80	Surveys
81	TANF	82	TangibleGoods	83	Tasks	84	TrainingSessions
85	TribalAffiliation	86	Trips	87	Vehicles	88	VolunteerActivities
89	VolunteerActivity	90	xAbuserRelationship	91	xCallSubject	92	xCallType
93	xCitizenship	94	xClientType	95	xCounselingResult	96	xCounselingStatus
97	xCounty	98	xCourtOutcome	99	xEmployment	100	xEthnicity
101	xExitDestination	102	xExitHousing	103	xExitReason	104	xGoodType
105	xHotlineReferral	106	xHousingType	107	xIntakeType	108	xLanguage
109	xLawEnforcementAgency	110	xLocation	111	xMaritalStatus	112	xPetType
113	xPriorResidence	114	xReasonDenied	115	xReferralSource	116	xReferralType
117	xReligion	118	xRequestOutcome	119	xReservation	120	xReturnStatus
121	xServiceLocation	122	xShelterType	123	xSubstanceProblem	124	xTask
125	xTopic	126	xTribe	127	xTripPurpose	128	zShelterData
129	zsSettings

Index
Table: AbuserAlertImages

Description

Contains image file of abuser; linked 1:1 with AbuserAlerts

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	AlertID	INT	N
2	Image	VARBINARY	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_AbuserAlertImages_AlertID	Nonclustered	AlertID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_AbuserAlertImages_AbuserAlerts_AlertID	AlertID	[AbuserAlerts].[AlertID]

Index
Table: AbuserAlerts

Description

Contains information about potentially dangerous abusers; entries related to specific participant.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	AlertID	INT	N
2	ParticipantID	INT	N
3	FirstName	VARCHAR(50)	N
4	LastName	VARCHAR(50)	N
5	MI	CHAR(1)	N
6	AbuserRelationshipID	INT	N
7	Address	VARCHAR(100)	N
8	City	VARCHAR(50)	N
9	State	VARCHAR(50)	N
10	Zip	VARCHAR(10)	N
11	Sex	CHAR(1)	N
12	Height	VARCHAR(10)	N
13	Weight	VARCHAR(3)	N
14	EyeColor	VARCHAR(15)	N
15	FacialHair	VARCHAR(15)	N
16	HairColor	VARCHAR(15)	N
17	HairLength	VARCHAR(15)	N
18	SkinTone	VARCHAR(15)	N
19	Marks	VARCHAR(500)	N
20	EthnicityID	INT	N
21	Vehicle	VARCHAR(50)	N
22	VehicleLicense	VARCHAR(15)	N
23	VehicleColor	VARCHAR(15)	N
24	CreatedDate	SMALLDATETIME	N
25	CreatedBy	VARCHAR(50)	N
26	ModifiedDate	SMALLDATETIME	N
27	ModifiedBy	VARCHAR(50)	N
28	DeletedDate	SMALLDATETIME	Y
29	DeletedBy	VARCHAR(50)	N
30	IsArmed	BIT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_AbuserAlerts_AlertID	Clustered	AlertID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Participants_AbuserAlerts_ParticipantID	ParticipantID	[Participants].[ParticipantID]
2	FK_xAbuserRelationship_AbuserAlerts_AbuserRelationShipID	AbuserRelationshipID	[xAbuserRelationship].[AbuserRelationshipID]
3	FK_xEthnicity_AbuserAlerts_EthnicityID	EthnicityID	[xEthnicity].[EthnicityID]

Default Constraints

Sr.	Name	Column	Value
1	DF__AbuserAle__Addre__2AA05119	Address	('')
2	DF__AbuserAle__Creat__3BCADD1B	CreatedBy	('')
3	DF__AbuserAle__Delet__3EA749C6	DeletedBy	('')
4	DF__AbuserAle__Ethni__37FA4C37	EthnicityID	((1))
5	DF__AbuserAle__EyeCo__324172E1	EyeColor	('')
6	DF__AbuserAle__Facia__3335971A	FacialHair	('')
7	DF__AbuserAle__First__27C3E46E	FirstName	('')
8	DF__AbuserAle__HairC__3429BB53	HairColor	('')
9	DF__AbuserAle__HairL__351DDF8C	HairLength	('')
10	DF__AbuserAle__Heigh__30592A6F	Height	('')
11	DF__AbuserAle__IsArm__53AD53A4	IsArmed	((0))
12	DF__AbuserAle__LastN__28B808A7	LastName	('')
13	DF__AbuserAle__Marks__370627FE	Marks	('')
14	DF__AbuserAle__Modif__3CBF0154	ModifiedDate	(getdate())
15	DF__AbuserAle__Modif__3DB3258D	ModifiedBy	('')
16	DF__AbuserAle__SkinT__361203C5	SkinTone	('')
17	DF__AbuserAle__State__2C88998B	State	('')
18	DF__AbuserAle__Vehic__38EE7070	Vehicle	('')
19	DF__AbuserAle__Vehic__39E294A9	VehicleLicense	('')
20	DF__AbuserAle__Vehic__3AD6B8E2	VehicleColor	('')
21	DF__AbuserAle__Weigh__314D4EA8	Weight	('')
22	DF__AbuserAler__City__2B947552	City	('')
23	DF__AbuserAlert__Sex__2F650636	Sex	('M')
24	DF__AbuserAlert__Zip__2D7CBDC4	Zip	('')
25	DF__AbuserAlerts__MI__29AC2CE0	MI	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__AbuserAlert__Sex__2E70E1FD	Sex	([Sex]='M' OR [Sex]='F')

Index
Table: AbuserIntakes

Description

Contains information of abusers receiving counseling, related to Abusers table.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	AbuserIntakeID	INT	N
2	AbuserID	INT	N
3	ProgramID	INT	N
4	SubstanceAbuseID	INT	N
5	SubstanceTreatmentID	INT	N
6	CounselingStatusID	INT	N
7	CounselingResultID	INT	N
8	TANF	BIT	N
9	WIC	BIT	N
10	SSI	BIT	N
11	SSDI	BIT	N
12	FoodStamps	BIT	N
13	LowIncomeHousing	BIT	N
14	AHCCCS	BIT	N
15	CashAssistance	BIT	N
16	Income	INT	Y
17	AbusePhysical	BIT	N
18	AbuseSexual	BIT	N
19	AbuseVerbalPsychological	BIT	N
20	AbuseEconomic	BIT	N
21	AbusedAsChild	BIT	N
22	AbuseWitness	BIT	N
23	CreatedDate	SMALLDATETIME	N
24	CreatedBy	VARCHAR(50)	N
25	ModifiedDate	SMALLDATETIME	N
26	ModifiedBy	VARCHAR(50)	N
27	DeletedDate	SMALLDATETIME	Y
28	DeletedBy	VARCHAR(50)	N
29	VictimRelationshipID	INT	N
30	EntryDate	DATE	N
31	ExitDate	DATE	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_AbuserIntakes_AbuserIntakeID	Nonclustered	AbuserIntakeID (Primary Key)
2	IDX_AbuserIntakes_EntryDate	Nonclustered	ExitDate

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Abusers_AbuserIntakes_AbuserID	AbuserID	[Abusers].[AbuserID]
2	FK_Programs_AbuserIntakes_ProgramID	ProgramID	[Programs].[ProgramID]
3	FK_xAbuserRelationship_AbuserIntakes_AbuserID	VictimRelationshipID	[xAbuserRelationship].[AbuserRelationshipID]

Default Constraints

Sr.	Name	Column	Value
1	DF__AbuserInt__Abuse__46D27B73	AbusePhysical	((0))
2	DF__AbuserInt__Abuse__47C69FAC	AbuseSexual	((0))
3	DF__AbuserInt__Abuse__48BAC3E5	AbuseVerbalPsychological	((0))
4	DF__AbuserInt__Abuse__49AEE81E	AbuseEconomic	((0))
5	DF__AbuserInt__Abuse__4AA30C57	AbusedAsChild	((0))
6	DF__AbuserInt__Abuse__4B973090	AbuseWitness	((0))
7	DF__AbuserInt__AHCCC__44EA3301	AHCCCS	((0))
8	DF__AbuserInt__CashA__45DE573A	CashAssistance	((0))
9	DF__AbuserInt__Couns__3B60C8C7	CounselingStatusID	((1))
10	DF__AbuserInt__Couns__3D491139	CounselingResultID	((1))
11	DF__AbuserInt__Creat__4C8B54C9	CreatedBy	('')
12	DF__AbuserInt__Delet__4F67C174	DeletedBy	('')
13	DF__AbuserInt__FoodS__4301EA8F	FoodStamps	((0))
14	DF__AbuserInt__LowIn__43F60EC8	LowIncomeHousing	((0))
15	DF__AbuserInt__Modif__4D7F7902	ModifiedDate	(getdate())
16	DF__AbuserInt__Modif__4E739D3B	ModifiedBy	('')
17	DF__AbuserInt__Subst__379037E3	SubstanceAbuseID	((1))
18	DF__AbuserInt__Subst__39788055	SubstanceTreatmentID	((1))
19	DF__AbuserInt__Victi__7BF04F28	VictimRelationshipID	((1))
20	DF__AbuserInta__SSDI__420DC656	SSDI	((0))
21	DF__AbuserInta__TANF__3F3159AB	TANF	((0))
22	DF__AbuserIntak__SSI__4119A21D	SSI	((0))
23	DF__AbuserIntak__WIC__40257DE4	WIC	((0))

Check Constraints

Sr.	Name	Column	Definition
1	CHK_AbuserIntakes_EntryDay_ExitDate		([ExitDate]>=[EntryDate])
2	CK__AbuserInt__Couns__3C54ED00	CounselingStatusID	([CounselingStatusID]=(2) OR [CounselingStatusID]=(1))
3	CK__AbuserInt__Subst__38845C1C	SubstanceAbuseID	([SubstanceAbuseID]>=(1) AND [SubstanceAbuseID]<=(4))
4	CK__AbuserInt__Subst__3A6CA48E	SubstanceTreatmentID	([SubstanceTreatmentID]>=(1) AND [SubstanceTreatmentID]<=(4))
5	CK_AbuserIntakes_CounselingResultID	CounselingResultID	([CounselingResultID]>=(1) AND [CounselingResultID]<=(6))

Index
Table: Abusers

Description

Basic information about abuser; may related to AbuserIntakes table.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	AbuserID	INT	N
2	EthnicityID	INT	N
3	FirstName	VARCHAR(50)	N
4	LastName	VARCHAR(50)	N
5	MI	CHAR(1)	N
6	Sex	CHAR(1)	N
7	CreatedDate	SMALLDATETIME	N
8	CreatedBy	VARCHAR(50)	N
9	ModifiedDate	SMALLDATETIME	N
10	ModifiedBy	VARCHAR(50)	N
11	DeletedDate	SMALLDATETIME	Y
12	DeletedBy	VARCHAR(50)	N
13	DOB	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Abusers_AbuserID	Clustered	AbuserID (Primary Key)
2	IDX_AbuserIntakes_AbuserID	Nonclustered	AbuserID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_xEthnicity_Abusers_EthnicityID	EthnicityID	[xEthnicity].[EthnicityID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Abusers__Created__30E33A54	CreatedBy	('')
2	DF__Abusers__Deleted__33BFA6FF	DeletedBy	('')
3	DF__Abusers__Ethnici__2D12A970	EthnicityID	((1))
4	DF__Abusers__MI__2E06CDA9	MI	('')
5	DF__Abusers__Modifie__31D75E8D	ModifiedDate	(getdate())
6	DF__Abusers__Modifie__32CB82C6	ModifiedBy	('')
7	DF__Abusers__Sex__2FEF161B	Sex	('M')

Check Constraints

Sr.	Name	Column	Definition
1	CK__Abusers__Sex__2EFAF1E2	Sex	([Sex]='M' OR [Sex]='F')

Index
Table: Aliases

Description

Captures aliases that may be used by clients in the Participants table.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	AliasID	INT	N
2	ParticipantID	INT	N
3	FirstName	VARCHAR(50)	N
4	LastName	VARCHAR(50)	N
5	MI	CHAR(1)	N
6	CreatedDate	SMALLDATETIME	N
7	CreatedBy	VARCHAR(50)	N
8	ModifiedDate	SMALLDATETIME	N
9	ModifiedBy	VARCHAR(50)	N
10	DeletedDate	SMALLDATETIME	Y
11	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Aliases_AliasID	Nonclustered	AliasID (Primary Key)
2	IDX_Aliases_ParticipantID	Clustered	ParticipantID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Participants_Aliases_PartcipantID	ParticipantID	[Participants].[ParticipantID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Aliases__Created__0A338187	CreatedBy	('')
2	DF__Aliases__Deleted__0D0FEE32	DeletedBy	('')
3	DF__Aliases__FirstNa__075714DC	FirstName	('')
4	DF__Aliases__LastNam__084B3915	LastName	('')
5	DF__Aliases__MI__093F5D4E	MI	('')
6	DF__Aliases__Modifie__0B27A5C0	ModifiedDate	(getdate())
7	DF__Aliases__Modifie__0C1BC9F9	ModifiedBy	('')

Index
Table: AssessmentItems

Description

Intersection table capturing values of items measured in a Self-Sufficiency Assessment.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	DomainID	INT	N
2	StatusID	INT	N
3	AssessmentID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_AssessmentItems_DomainID_AssessmentID	Clustered	DomainID (Primary Key) AssessmentID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Assessments_AssessmentItems_AssessmentID	AssessmentID	[Assessments].[AssessmentID]
2	FK_DomainStatus_AssessmentItems_DomainID_StatusID	DomainID	[DomainStatus].[DomainID]
3	FK_DomainStatus_AssessmentItems_DomainID_StatusID	StatusID	[DomainStatus].[StatusID]

Index
Table: Assessments

Description

Parent table for Self-Sufficiency Assessments.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IntakeID	INT	N
2	AssessmentID	INT	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N
9	AssessmentDate	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_Assessments_IntakeID_AssessmentDate	Clustered	IntakeID (Primary Key) AssessmentDate (Primary Key)
2	UNQ_Assessments_AssessmentID	Nonclustered	AssessmentID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Intakes_Assessments_IntakeID	IntakeID	[Intakes].[IntakeID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Assessmen__Creat__409A7F30	CreatedBy	('')
2	DF__Assessmen__Delet__4376EBDB	DeletedBy	('')
3	DF__Assessmen__Modif__418EA369	ModifiedDate	(getdate())
4	DF__Assessmen__Modif__4282C7A2	ModifiedBy	('')

Index
Table: Beds

Description

Basic information about beds employed by a shelter.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	BedID	INT	N
2	ShelterID	INT	N
3	Description	VARCHAR(50)	N
4	IsCrib	BIT	N
5	CreatedDate	SMALLDATETIME	N
6	CreatedBy	VARCHAR(50)	N
7	ModifiedDate	SMALLDATETIME	N
8	ModifiedBy	VARCHAR(50)	N
9	DeletedDate	SMALLDATETIME	Y
10	DeletedBy	VARCHAR(50)	N
11	ServiceStart	DATE	N
12	ServiceEnd	DATE	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_Beds_BedID	Nonclustered	BedID (Primary Key)
2	IDX_Beds_ShelterID	Clustered	ShelterID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Shelters_Beds_ShelterID	ShelterID	[Shelters].[ShelterID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Beds__CreatedBy__72910220	CreatedBy	('')
2	DF__Beds__DeletedBy__756D6ECB	DeletedBy	('')
3	DF__Beds__IsCrib__719CDDE7	IsCrib	((0))
4	DF__Beds__ModifiedBy__74794A92	ModifiedBy	('')
5	DF__Beds__ModifiedDa__73852659	ModifiedDate	(getdate())

Index
Table: Calls

Description

Contains data captured from calls, primarily hotline information.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CallID	INT	N
2	ShelterID	INT	N
3	CallTypeID	INT	N
4	CallSubjectID	INT	N
5	ReferralSourceID	INT	Y
6	LocationID	INT	Y
7	FirstName	VARCHAR(50)	N
8	LastName	VARCHAR(50)	N
9	MI	CHAR(1)	N
10	NumberChildren	INT	N
11	Note	VARCHAR(2000)	N
12	Initials	VARCHAR(25)	N
13	CreatedDate	SMALLDATETIME	N
14	CreatedBy	VARCHAR(50)	N
15	ModifiedDate	SMALLDATETIME	N
16	ModifiedBy	VARCHAR(50)	N
17	DeletedDate	SMALLDATETIME	Y
18	DeletedBy	VARCHAR(50)	N
19	WalkIn	BIT	N
20	Anonymous	BIT	N
21	Sex	CHAR(1)	N
22	CallDate	DATE	N
23	ContactType	INT	N
24	Turnaway	BIT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_Calls_CallID	Nonclustered	CallID (Primary Key)
2	IDX_Calls_CallDate	Clustered	CallDate
3	IDX_Calls_CallSubjectID	Nonclustered	CallSubjectID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Shelters_Calls_ShelterID	ShelterID	[Shelters].[ShelterID]
2	FK_xCallSubject_Calls_CallSubjectID	CallSubjectID	[xCallSubject].[CallSubjectID]
3	FK_xLocation_Calls_LocationID	LocationID	[xLocation].[LocationID]
4	FK_xReferralSource_Calls_ReferralSourceID	ReferralSourceID	[xReferralSource].[ReferralSourceID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Calls__Anonymous__67B44C51	Anonymous	((0))
2	DF__Calls__CallSubje__031C6FA4	CallSubjectID	((0))
3	DF__Calls__ContactTy__1328BA3B	ContactType	((0))
4	DF__Calls__CreatedBy__0BB1B5A5	CreatedBy	('')
5	DF__Calls__DeletedBy__0E8E2250	DeletedBy	('')
6	DF__Calls__FirstName__05F8DC4F	FirstName	('')
7	DF__Calls__Initials__0ABD916C	Initials	('')
8	DF__Calls__LastName__06ED0088	LastName	('')
9	DF__Calls__LocationI__0504B816	LocationID	((1))
10	DF__Calls__MI__07E124C1	MI	('')
11	DF__Calls__ModifiedB__0D99FE17	ModifiedBy	('')
12	DF__Calls__ModifiedD__0CA5D9DE	ModifiedDate	(getdate())
13	DF__Calls__Note__09C96D33	Note	('')
14	DF__Calls__NumberChi__08D548FA	NumberChildren	((0))
15	DF__Calls__ReferralS__041093DD	ReferralSourceID	((1))
16	DF__Calls__Sex__68A8708A	Sex	('U')
17	DF__Calls__ShelterID__01342732	ShelterID	((1))
18	DF__Calls__Turnaway__151102AD	Turnaway	((0))
19	DF__Calls__WalkIn__19B5BC39	WalkIn	((0))

Check Constraints

Sr.	Name	Column	Definition
1	CK__Calls__CallTypeI__02284B6B	CallTypeID	([CallTypeID]>=(1) AND [CallTypeID]<=(4))
2	CK__Calls__ContactTy__141CDE74	ContactType	([ContactType]>=(0) AND [ContactType]<=(2))
3	CK__Calls__Sex__699C94C3	Sex	([Sex]='U' OR [Sex]='M' OR [Sex]='F')

Index
Table: CallServices

Description

Child table of Calls; records services delivered via phone/hotline.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	SessionID	INT	N
2	CallID	INT	N
3	ProgramID	INT	N
4	ServiceID	INT	N
5	FocusID	INT	N
6	SessionHours	FLOAT	N
7	NumberStaff	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_CallServices_SessionID	Nonclustered	SessionID (Primary Key)
2	IDX_CallServices_CallID	Clustered	CallID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Focus_CallServices_FocusID	FocusID	[Focus].[FocusID]
2	FK_Programs_CallServices_ProgramID	ProgramID	[Programs].[ProgramID]
3	FK_Services_CallServices_ServiceID	ServiceID	[Services].[ServiceID]

Default Constraints

Sr.	Name	Column	Value
1	DF__CallServi__Numbe__6C79016E	NumberStaff	((1))
2	DF_CallServices_FocusID	FocusID	((0))

Index
Table: Campuses

Description

Location/Name of shelter(s) within the organization.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CampusID	INT	N
2	CampusName	VARCHAR(100)	N
3	IsCurrent	BIT	N
4	CreatedDate	SMALLDATETIME	N
5	CreatedBy	VARCHAR(50)	N
6	ModifiedDate	SMALLDATETIME	N
7	ModifiedBy	VARCHAR(50)	N
8	DeletedDate	SMALLDATETIME	Y
9	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Campuses_CampusID	Clustered	CampusID (Primary Key)
2	UQ__Campuses__CE3FCDE14D5F7D71	Nonclustered	CampusName

Default Constraints

Sr.	Name	Column	Value
1	DF__Campuses__Create__503BEA1C	CreatedBy	('')
2	DF__Campuses__Delete__531856C7	DeletedBy	('')
3	DF__Campuses__IsCurr__4F47C5E3	IsCurrent	((1))
4	DF__Campuses__Modifi__51300E55	ModifiedDate	(getdate())
5	DF__Campuses__Modifi__5224328E	ModifiedBy	('')

Index
Table: ChildAbsences

Description

Information on temporary absences of children during a residential intake.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ChildIntakeID	INT	N
2	DateReturn	DATE	Y
3	DateOut	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_ChildAbsences_ChildIntakeID_DateOut	Clustered	ChildIntakeID (Primary Key) DateOut (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_ChildIntakes_ChildAbsenses_ChildIntakeID	ChildIntakeID	[ChildIntakes].[ChildIntakeID]

Index
Table: ChildAliases

Description

Contains possible aliases applying to records in the Children table.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	AliasID	INT	N
2	ChildID	INT	N
3	FirstName	VARCHAR(50)	N
4	LastName	VARCHAR(50)	N
5	MI	CHAR(1)	N
6	CreatedDate	SMALLDATETIME	N
7	CreatedBy	VARCHAR(50)	N
8	ModifiedDate	SMALLDATETIME	N
9	ModifiedBy	VARCHAR(50)	N
10	DeletedDate	SMALLDATETIME	Y
11	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_ChildAliases_AliasID	Nonclustered	AliasID (Primary Key)
2	IDX_ChildAliases_ChildID	Clustered	ChildID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Children_Aliases_ChildID	ChildID	[Children].[ChildID]

Default Constraints

Sr.	Name	Column	Value
1	DF__ChildAlia__Creat__71A7CADF	CreatedBy	('')
2	DF__ChildAlia__Delet__7484378A	DeletedBy	('')
3	DF__ChildAlia__First__6ECB5E34	FirstName	('')
4	DF__ChildAlia__LastN__6FBF826D	LastName	('')
5	DF__ChildAlia__Modif__729BEF18	ModifiedDate	(getdate())
6	DF__ChildAlia__Modif__73901351	ModifiedBy	('')
7	DF__ChildAliases__MI__70B3A6A6	MI	('')

Index
Table: ChildIntakes

Description

Intersection table relating a child intake records to their parent's record.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IntakeID	INT	N
2	ChildID	INT	N
3	ChildIntakeID	INT	N
4	TanfEligible	BIT	N
5	SSI	BIT	N
6	SSDI	BIT	N
7	TANF	BIT	N
8	WIC	BIT	N
9	AHCCCS	BIT	N
10	LowIncomeHousing	BIT	N
11	KidsCare	BIT	N
12	FoodStamps	BIT	N
13	CashAssistance	BIT	N
14	AbusePhysical	BIT	N
15	AbuseSexual	BIT	N
16	AbuseVerbalPsychological	BIT	N
17	AbuseEconomic	BIT	N
18	AbuseWitness	BIT	N
19	CreatedDate	SMALLDATETIME	N
20	CreatedBy	VARCHAR(50)	N
21	ModifiedDate	SMALLDATETIME	N
22	ModifiedBy	VARCHAR(50)	N
23	DeletedDate	SMALLDATETIME	Y
24	DeletedBy	VARCHAR(50)	N
25	MentalIllness	BIT	N
26	PhysDisability	BIT	N
27	DevDisability	BIT	N
28	ChronicHealthCondition	BIT	N
29	HIVAIDS	BIT	N
30	SubstanceAbuseID	INT	N
31	EntryDate	DATE	N
32	ExitDate	DATE	Y
33	HealthPlanGoal	BIT	N
34	HealthImproved	BIT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_ChildIntakes_IntakeID_ChildID	Nonclustered	IntakeID (Primary Key) ChildID (Primary Key)
2	IDX_ChildIntakes_ChildIntakeID	Nonclustered	ChildIntakeID
3	IDX_ChildIntakes_ExitDate	Nonclustered	ExitDate
4	IDXC_ChildIntakes_EntryDate	Clustered	EntryDate

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Children_ChildIntakes_ChildID	ChildID	[Children].[ChildID]
2	FK_Intakes_ChildIntakes_IntakeID	IntakeID	[Intakes].[IntakeID]
3	FK_xSubstanceProblem_ChildIntakes_SubstanceAbuseID	SubstanceAbuseID	[xSubstanceProblem].[SubstanceProblemID]

Default Constraints

Sr.	Name	Column	Value
1	DF__ChildInta__Abuse__62AFA012	AbusePhysical	((0))
2	DF__ChildInta__Abuse__63A3C44B	AbuseSexual	((0))
3	DF__ChildInta__Abuse__6497E884	AbuseVerbalPsychological	((0))
4	DF__ChildInta__Abuse__658C0CBD	AbuseEconomic	((0))
5	DF__ChildInta__Abuse__668030F6	AbuseWitness	((0))
6	DF__ChildInta__AHCCC__5DEAEAF5	AHCCCS	((0))
7	DF__ChildInta__CashA__61BB7BD9	CashAssistance	((0))
8	DF__ChildInta__Chron__61FB72FB	ChronicHealthCondition	((0))
9	DF__ChildInta__Creat__6774552F	CreatedBy	('')
10	DF__ChildInta__Delet__6A50C1DA	DeletedBy	('')
11	DF__ChildInta__DevDi__61074EC2	DevDisability	((0))
12	DF__ChildInta__FoodS__60C757A0	FoodStamps	((0))
13	DF__ChildInta__Healt__48C5B0DD	HealthPlanGoal	((0))
14	DF__ChildInta__Healt__49B9D516	HealthImproved	((0))
15	DF__ChildInta__HIVAI__62EF9734	HIVAIDS	((0))
16	DF__ChildInta__KidsC__5FD33367	KidsCare	((0))
17	DF__ChildInta__LowIn__5EDF0F2E	LowIncomeHousing	((0))
18	DF__ChildInta__Menta__5F1F0650	MentalIllness	((0))
19	DF__ChildInta__Modif__68687968	ModifiedDate	(getdate())
20	DF__ChildInta__Modif__695C9DA1	ModifiedBy	('')
21	DF__ChildInta__PhysD__60132A89	PhysDisability	((0))
22	DF__ChildInta__Subst__63E3BB6D	SubstanceAbuseID	((0))
23	DF__ChildInta__TanfE__592635D8	TanfEligible	((0))
24	DF__ChildIntak__SSDI__5B0E7E4A	SSDI	((0))
25	DF__ChildIntak__TANF__5C02A283	TANF	((0))
26	DF__ChildIntake__SSI__5A1A5A11	SSI	((0))
27	DF__ChildIntake__WIC__5CF6C6BC	WIC	((0))

Check Constraints

Sr.	Name	Column	Definition
1	CHK_ChildIntakes_EntryDay_ExitDate		([ExitDate]>=[EntryDate])

Index
Table: Children

Description

Child table of Participants with data on individual participants' children.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ChildID	INT	N
2	ParticipantID	INT	Y
3	EthnicityID	INT	Y
4	FirstName	VARCHAR(50)	N
5	MI	VARCHAR(1)	N
6	LastName	VARCHAR(50)	N
7	Sex	CHAR(1)	N
8	CreatedDate	SMALLDATETIME	N
9	CreatedBy	VARCHAR(50)	N
10	ModifiedDate	SMALLDATETIME	N
11	ModifiedBy	VARCHAR(50)	N
12	DeletedDate	SMALLDATETIME	Y
13	DeletedBy	VARCHAR(50)	N
14	DOB	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Children_ChildID	Nonclustered	ChildID (Primary Key)
2	IDX_Children_ParticipantID	Clustered	ParticipantID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Participants_Children_ParticipantID	ParticipantID	[Participants].[ParticipantID]
2	FK_xEthnicity_Children_EthnicityID	EthnicityID	[xEthnicity].[EthnicityID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Children__Create__5772F790	CreatedBy	('')
2	DF__Children__Delete__5A4F643B	DeletedBy	('')
3	DF__Children__Ethnic__53A266AC	EthnicityID	((1))
4	DF__Children__LastNa__558AAF1E	LastName	('')
5	DF__Children__MI__54968AE5	MI	('')
6	DF__Children__Modifi__58671BC9	ModifiedDate	(getdate())
7	DF__Children__Modifi__595B4002	ModifiedBy	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__Children__Sex__567ED357	Sex	([Sex]='M' OR [Sex]='F')

Index
Table: ClientSessions

Description

Intersection table relating clients to service sessions. ClientID equates to ParticipantID if ClientTypeID = 1, ChildID if 2, AbuserID if 3, and MemberID if 4.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ClientID	INT	N
2	SessionID	INT	N
3	ClientTypeID	INT	N
4	IntakeID	INT	N
5	DeletedDate	SMALLDATETIME	Y
6	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_ClientSessions	Clustered	ClientID (Primary Key) SessionID (Primary Key) ClientTypeID (Primary Key)
2	IDXN_ClientSessions_IntakeID	Nonclustered	IntakeID
3	IDXN_ClientSessions_SessionID	Nonclustered	SessionID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Sessions_ClientSessions_SessionID	SessionID	[Sessions].[SessionID]

Default Constraints

Sr.	Name	Column	Value
1	DF__ClientSes__Delet__7F16D496	DeletedBy	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__ClientSes__Clien__1C281490	ClientTypeID	([ClientTypeID]>=(1) AND [ClientTypeID]<=(4))

Index
Table: CommunityMembers

Description

Data for clients served as Community Members; generally short-term clients for whom an intake record is not completed.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	MemberID	INT	N
2	IsCurrent	BIT	Y
3	EthnicityID	INT	Y
4	FirstName	VARCHAR(50)	N
5	MI	VARCHAR(1)	N
6	LastName	VARCHAR(50)	N
7	Sex	CHAR(1)	N
8	OptionalIdentifier	VARCHAR(50)	N
9	VictimTypeID	INT	N
10	CreatedDate	SMALLDATETIME	N
11	CreatedBy	VARCHAR(50)	N
12	ModifiedDate	SMALLDATETIME	N
13	ModifiedBy	VARCHAR(50)	N
14	DeletedDate	SMALLDATETIME	Y
15	DeletedBy	VARCHAR(50)	N
16	DOB	DATE	Y
17	IsYouth	BIT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_CommunityMembers_MemberID	Clustered	MemberID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_xEthnicity_CommunityMembers_EthnicityID	EthnicityID	[xEthnicity].[EthnicityID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Community__Creat__1486F2C8	CreatedBy	('')
2	DF__Community__Delet__17635F73	DeletedBy	('')
3	DF__Community__Ethni__0ECE1972	EthnicityID	((1))
4	DF__Community__IsCur__0DD9F539	IsCurrent	((1))
5	DF__Community__IsYou__16F94B1F	IsYouth	((0))
6	DF__Community__LastN__10B661E4	LastName	('')
7	DF__Community__Modif__157B1701	ModifiedDate	(getdate())
8	DF__Community__Modif__166F3B3A	ModifiedBy	('')
9	DF__Community__Optio__129EAA56	OptionalIdentifier	('')
10	DF__Community__Victi__1392CE8F	VictimTypeID	((0))
11	DF__CommunityMem__MI__0FC23DAB	MI	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__CommunityMe__Sex__11AA861D	Sex	([Sex]='M' OR [Sex]='F')

Index
Table: Credentials

Description

Used to establish requirements and/or staff training subjects.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CredentialID	INT	N
2	Credential	VARCHAR(50)	N
3	Frequency	INT	N
4	IsSubject	BIT	N
5	IsCurrent	BIT	N
6	CreatedDate	SMALLDATETIME	N
7	CreatedBy	VARCHAR(50)	N
8	ModifiedDate	SMALLDATETIME	N
9	ModifiedBy	VARCHAR(50)	N
10	DeletedDate	SMALLDATETIME	Y
11	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Credentials_CredentialID	Clustered	CredentialID (Primary Key)

Default Constraints

Sr.	Name	Column	Value
1	DF__Credentia__Creat__51EF2864	CreatedBy	('')
2	DF__Credentia__Delet__54CB950F	DeletedBy	('')
3	DF__Credentia__Frequ__4E1E9780	Frequency	((-2))
4	DF__Credentia__IsCur__50FB042B	IsCurrent	((1))
5	DF__Credentia__IsSub__5006DFF2	IsSubject	((0))
6	DF__Credentia__Modif__52E34C9D	ModifiedDate	(getdate())
7	DF__Credentia__Modif__53D770D6	ModifiedBy	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__Credentia__Frequ__4F12BBB9	Frequency	([Frequency]>(-3))

Index
Table: DomainStatus

Description

Intersection table to show assessment item criterion when entering Self-Sufficiency Assessments.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	DomainID	INT	N
2	StatusID	INT	N
3	Criterion	VARCHAR(250)	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_DomainStatus_DomainID_StatusID	Clustered	DomainID (Primary Key) StatusID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_MatrixDomains_DomainStatus_DomainID	DomainID	[MatrixDomains].[DomainID]
2	FK_MatrixStatus_DomainStatus_StatusID	StatusID	[MatrixStatus].[StatusID]

Index
Table: EmerContacts

Description

Contact information for person(s) known to participant.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	EmerContactID	INT	N
2	ParticipantID	INT	N
3	Relationship	VARCHAR(50)	N
4	ContactName	VARCHAR(100)	N
5	Address	VARCHAR(100)	N
6	City	VARCHAR(50)	N
7	State	VARCHAR(50)	N
8	Zip	VARCHAR(10)	N
9	Phone	VARCHAR(15)	N
10	CreatedDate	SMALLDATETIME	N
11	CreatedBy	VARCHAR(50)	N
12	ModifiedDate	SMALLDATETIME	N
13	ModifiedBy	VARCHAR(50)	N
14	DeletedDate	SMALLDATETIME	Y
15	DeletedBy	VARCHAR(50)	N
16	SafeToCall	BIT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_EmerContacts_EmerContactID	Clustered	EmerContactID (Primary Key)
2	IDX_EmerContacts_ParticipantID	Nonclustered	ParticipantID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Participants_EmerContacts_ParticipantID	ParticipantID	[Participants].[ParticipantID]

Default Constraints

Sr.	Name	Column	Value
1	DF__EmerConta__Addre__1C5231C2	Address	('')
2	DF__EmerConta__Conta__1B5E0D89	ContactName	('')
3	DF__EmerConta__Creat__2116E6DF	CreatedBy	('')
4	DF__EmerConta__Delet__23F3538A	DeletedBy	('')
5	DF__EmerConta__Modif__220B0B18	ModifiedDate	(getdate())
6	DF__EmerConta__Modif__22FF2F51	ModifiedBy	('')
7	DF__EmerConta__Phone__2022C2A6	Phone	('')
8	DF__EmerConta__Relat__1A69E950	Relationship	('')
9	DF__EmerConta__SafeT__5D36BDDE	SafeToCall	((0))
10	DF__EmerConta__State__1E3A7A34	State	('')
11	DF__EmerContac__City__1D4655FB	City	('')
12	DF__EmerContact__Zip__1F2E9E6D	Zip	('')

Index
Table: Focus

Description

Sub-category of service type, may be associated with more than one type.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	FocusID	INT	N
2	Focus	VARCHAR(100)	N
3	IsCurrent	BIT	N
4	CreatedDate	SMALLDATETIME	N
5	CreatedBy	VARCHAR(50)	N
6	ModifiedDate	SMALLDATETIME	N
7	ModifiedBy	VARCHAR(50)	N
8	DeletedDate	SMALLDATETIME	Y
9	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_Focus_FocusID	Clustered	FocusID (Primary Key)
2	UQ__Focus__477ABE23636EBA21	Nonclustered	Focus

Default Constraints

Sr.	Name	Column	Value
1	DF__Focus__CreatedBy__664B26CC	CreatedBy	('')
2	DF__Focus__DeletedBy__69279377	DeletedBy	('')
3	DF__Focus__IsCurrent__65570293	IsCurrent	((1))
4	DF__Focus__ModifiedB__68336F3E	ModifiedBy	('')
5	DF__Focus__ModifiedD__673F4B05	ModifiedDate	(getdate())

Index
Table: Goals

Description

Parent table of Questions; includes specified values from VOCA reporting.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	GoalID	INT	N
2	Goal	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Goals_GoalID	Clustered	GoalID (Primary Key)
2	UQ__Goals__11388AB02354350C	Nonclustered	Goal

Default Constraints

Sr.	Name	Column	Value
1	DF__Goals__CreatedBy__253C7D7E	CreatedBy	('')
2	DF__Goals__DeletedBy__2818EA29	DeletedBy	('')
3	DF__Goals__ModifiedB__2724C5F0	ModifiedBy	('')
4	DF__Goals__ModifiedD__2630A1B7	ModifiedDate	(getdate())

Index
Table: Grantors

Description

Includes information on funding agencies; GrantorID below 100 is developer entered, greater than 100 is user-created.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	Grantor	VARCHAR(50)	N
2	CreatedDate	SMALLDATETIME	N
3	CreatedBy	VARCHAR(50)	N
4	ModifiedDate	SMALLDATETIME	N
5	ModifiedBy	VARCHAR(50)	N
6	DeletedDate	SMALLDATETIME	Y
7	DeletedBy	VARCHAR(50)	N
8	GrantorID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_Grantors_GrantorID	Clustered	GrantorID (Primary Key)
2	UQ__Grantors__E56F54BC0A688BB1	Nonclustered	Grantor

Default Constraints

Sr.	Name	Column	Value
1	DF__Grantors__Create__0C50D423	CreatedBy	('')
2	DF__Grantors__Delete__0F2D40CE	DeletedBy	('')
3	DF__Grantors__Modifi__0D44F85C	ModifiedDate	(getdate())
4	DF__Grantors__Modifi__0E391C95	ModifiedBy	('')

Index
Table: GrantorServices

Description

Contains service types that are reportable to the associated grantor.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	GrantorServiceID	INT	N
2	GrantorService	VARCHAR(50)	N
3	GrantorID	INT	N
4	CreatedDate	SMALLDATETIME	N
5	CreatedBy	VARCHAR(50)	N
6	ModifiedDate	SMALLDATETIME	N
7	ModifiedBy	VARCHAR(50)	N
8	DeletedDate	SMALLDATETIME	Y
9	DeletedBy	VARCHAR(50)	N
10	IsCurrent	BIT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_GrantorServices_GrantorServiceID	Nonclustered	GrantorServiceID (Primary Key)
2	IDX_GrantorServices_GrantorID	Clustered	GrantorID
3	UNQ_GrantorService_GrantorID	Nonclustered	GrantorService GrantorID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Grantors_GrantorServices_GrantorID	GrantorID	[Grantors].[GrantorID]

Default Constraints

Sr.	Name	Column	Value
1	DF__GrantorSe__Creat__03DB89B3	CreatedBy	('')
2	DF__GrantorSe__Delet__06B7F65E	DeletedBy	('')
3	DF__GrantorSe__IsCur__25B17ECA	IsCurrent	((1))
4	DF__GrantorSe__Modif__04CFADEC	ModifiedDate	(getdate())
5	DF__GrantorSe__Modif__05C3D225	ModifiedBy	('')

Index
Table: Grants

Description

Parent table for grant information.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	GrantID	INT	N
2	GrantorID	INT	N
3	ContractNumber	VARCHAR(50)	N
4	CreatedDate	SMALLDATETIME	N
5	CreatedBy	VARCHAR(50)	N
6	ModifiedDate	SMALLDATETIME	N
7	ModifiedBy	VARCHAR(50)	N
8	DeletedDate	SMALLDATETIME	Y
9	DeletedBy	VARCHAR(50)	N
10	Prorate	FLOAT	N
11	GrantStart	DATE	N
12	GrantEnd	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Grants_GrantID	Clustered	GrantID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Grantors_Grants_GrantorID	GrantorID	[Grantors].[GrantorID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Grants__Contract__1209AD79	ContractNumber	('')
2	DF__Grants__CreatedB__12FDD1B2	CreatedBy	('')
3	DF__Grants__DeletedB__15DA3E5D	DeletedBy	('')
4	DF__Grants__Modified__13F1F5EB	ModifiedDate	(getdate())
5	DF__Grants__Modified__14E61A24	ModifiedBy	('')
6	DF_Grants_Prorate	Prorate	((1))

Check Constraints

Sr.	Name	Column	Definition
1	CK_Grants_Prorate	Prorate	([Prorate]>=(0) AND [Prorate]<=(1))

Index
Table: GrantSurveys

Description

Intersection table connecting shelter survey(s) with specific grant(s).

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	GrantID	INT	N
2	SurveyID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_GrantorSurveys_GrantID_SurveyID	Clustered	GrantID (Primary Key) SurveyID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Grants_GrantorSurveys_GrantID	GrantID	[Grants].[GrantID]
2	FK_Surveys_GrantorSurveys_SurveyID	SurveyID	[Surveys].[SurveyID]

Index
Table: GrantTargets

Description

Used for certain types of grants, indicates whether grant applies to shelter(s), program(s), and/or staff member(s).

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	GrantID	INT	N
2	TargetID	INT	N
3	TargetTypeID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_GrantTargets_GrantID_TargetID_TargetTypeID	Clustered	GrantID (Primary Key) TargetID (Primary Key) TargetTypeID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Grants_GrantTargets_GrantID	GrantID	[Grants].[GrantID]

Check Constraints

Sr.	Name	Column	Definition
1	CK__GrantTarg__Targe__19AACF41	TargetTypeID	([TargetTypeID]>=(1) AND [TargetTypeID]<=(4))

Index
Table: HotlineReferrals

Description

Used to indicate agencies to which a hotline caller is referred.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CallID	INT	N
2	HotlineReferralID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_HotlineReferrals_CallID_HotlineReferralID	Clustered	CallID (Primary Key) HotlineReferralID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Calls_HotlineReferrals_CallID	CallID	[Calls].[CallID]
2	FK_xHotlineReferral_HotlineReferrals_HotlineReferralID	HotlineReferralID	[xHotlineReferral].[HotlineReferralID]

Index
Table: InfoEntities

Description

User-entered list of Entities/Agencies to which a participant may authorize an information release.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	EntityID	INT	N
2	Entity	VARCHAR(100)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_InfoEntities_EntityID	Clustered	EntityID (Primary Key)

Default Constraints

Sr.	Name	Column	Value
1	DF__InfoEntit__Creat__650CE9D0	CreatedBy	('')
2	DF__InfoEntit__Delet__67E9567B	DeletedBy	('')
3	DF__InfoEntit__Modif__66010E09	ModifiedDate	(getdate())
4	DF__InfoEntit__Modif__66F53242	ModifiedBy	('')

Index
Table: InfoReleases

Description

Records reflecting a participant's permission to release specific information to specified agencies.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReleaseID	INT	N
2	ParticipantID	INT	N
3	ReleaseTypeID	INT	N
4	CreatedDate	SMALLDATETIME	N
5	CreatedBy	VARCHAR(50)	N
6	ModifiedDate	SMALLDATETIME	N
7	ModifiedBy	VARCHAR(50)	N
8	DeletedDate	SMALLDATETIME	Y
9	DeletedBy	VARCHAR(50)	N
10	FromDate	DATE	N
11	ToDate	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_InfoReleases	Clustered	ReleaseID (Primary Key)
2	IDX_InfoReleases_FromDate	Nonclustered	FromDate
3	IDX_InfoReleases_ParticipantID	Nonclustered	ParticipantID
4	IDX_InfoReleases_ToDate	Nonclustered	ToDate

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Participants_InfoReleases_ParticipantID	ParticipantID	[Participants].[ParticipantID]
2	FK_ReleaseTypes_InfoReleases_ReleaseTypeID	ReleaseTypeID	[ReleaseTypes].[ReleaseTypeID]

Default Constraints

Sr.	Name	Column	Value
1	DF__InfoRelea__Creat__5D6BC808	CreatedBy	('')
2	DF__InfoRelea__Delet__604834B3	DeletedBy	('')
3	DF__InfoRelea__Modif__5E5FEC41	ModifiedDate	(getdate())
4	DF__InfoRelea__Modif__5F54107A	ModifiedBy	('')

Index
Table: IntakeBeds

Description

Intersection table indicating beds used by participants and children for specific date period during intakes.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IntakeID	INT	N
2	ClientTypeID	INT	N
3	BedID	INT	N
4	CreatedDate	SMALLDATETIME	N
5	CreatedBy	VARCHAR(50)	N
6	ModifiedDate	SMALLDATETIME	N
7	ModifiedBy	VARCHAR(50)	N
8	DeletedDate	SMALLDATETIME	Y
9	DeletedBy	VARCHAR(50)	N
10	DateIn	DATE	N
11	DateOut	DATE	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_IntakeBeds_IntakeID_ClientTypeID_DateIn	Clustered	IntakeID (Primary Key) ClientTypeID (Primary Key) DateIn (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Beds_IntakeBeds_BedID	BedID	[Beds].[BedID]

Default Constraints

Sr.	Name	Column	Value
1	DF__IntakeBed__Creat__5090EFD7	CreatedBy	('')
2	DF__IntakeBed__Delet__536D5C82	DeletedBy	('')
3	DF__IntakeBed__Modif__51851410	ModifiedDate	(getdate())
4	DF__IntakeBed__Modif__52793849	ModifiedBy	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__IntakeBed__Clien__4F9CCB9E	ClientTypeID	([ClientTypeID]>=(1) AND [ClientTypeID]<=(3))

Index
Table: IntakeCalls

Description

Intersection table relating a hotline call that results in an intake with that corresponding intake record.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CallID	INT	N
2	IntakeID	INT	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_IntakeCalls_IntakeID	Clustered	IntakeID (Primary Key)
2	IDX_IntakeCalls_CallID	Nonclustered	CallID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Calls_IntakeCall_CallID	CallID	[Calls].[CallID]
2	FK_Intakes_IntakeCall_IntakeID	IntakeID	[Intakes].[IntakeID]

Default Constraints

Sr.	Name	Column	Value
1	DF__IntakeCal__Creat__257187A8	CreatedBy	('')
2	DF__IntakeCal__Delet__284DF453	DeletedBy	('')
3	DF__IntakeCal__Modif__2665ABE1	ModifiedDate	(getdate())
4	DF__IntakeCal__Modif__2759D01A	ModifiedBy	('')

Index
Table: IntakePhase

Description

Intersection table of phases associated with participant intakes.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IntakeID	INT	N
2	PhaseID	INT	N
3	BeginDate	DATE	N
4	ProjectedEnd	DATE	Y
5	CompletedDate	DATE	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_iIntakePhase_IntakeID_PhaseID	Clustered	IntakeID (Primary Key) PhaseID (Primary Key)
2	IDX_IntakePhase_BeginDate	Nonclustered	BeginDate

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Intakes_IntakePhase_IntakeID	IntakeID	[Intakes].[IntakeID]
2	FK_Phases_IntakePhase_PhaseID	PhaseID	[Phases].[PhaseID]

Index
Table: Intakes

Description

Contains reportable and non-reportable data elements applicable to participant intakes.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IntakeID	INT	N
2	ParticipantID	INT	N
3	ShelterID	INT	N
4	IntakeTypeID	INT	N
5	AbuserRelationshipID	INT	Y
6	MaritalStatusID	INT	Y
7	LanguageID	INT	N
8	CitizenshipID	INT	N
9	CountyID	INT	N
10	ReservationID	INT	N
11	SubstanceAbuseID	INT	N
12	SubstanceTreatmentID	INT	N
13	LocationID	INT	N
14	CourtOutcomeID	INT	Y
15	ExitDestinationID	INT	Y
16	ExitReasonID	INT	Y
17	ExitHousingID	INT	Y
18	EmploymentID	INT	N
19	EmploymentExitID	INT	N
20	PriorResidenceID	INT	N
21	IsContinuation	BIT	N
22	PoliceReport	BIT	N
23	DVArrestClient	BIT	N
24	DVArrestBatterer	BIT	N
25	PreviousReport	BIT	N
26	PreviousArrestClient	BIT	N
27	PreviousArrestBatterer	BIT	N
28	CurrentProtectionOrder	BIT	N
29	PreviousProtectionOrder	BIT	N
30	EmergencyMedClient	BIT	N
31	EmergencyMedBatterer	BIT	N
32	CourtCase	BIT	N
33	ProtectionOrder	BIT	N
34	ExtensionWavier	BIT	N
35	TANF_Eligible	BIT	N
36	IncomeEntry	INT	Y
37	IncomeExit	INT	Y
38	SSI	BIT	N
39	SSDI	BIT	N
40	SS	BIT	N
41	GenPubAssistance	BIT	N
42	TANF	BIT	N
43	ChildSupport	BIT	N
44	VetBenefits	BIT	N
45	EmploymentIncome	BIT	N
46	UnemploymentBenefits	BIT	N
47	Medicare	BIT	N
48	Medicaid	BIT	N
49	FoodStamps	BIT	N
50	NoFinancialResources	BIT	N
51	WIC	BIT	N
52	LowIncomeHousing	BIT	N
53	KidsCare	BIT	N
54	AHCCCS	BIT	N
55	CashAssistance	BIT	N
56	SSIExit	BIT	N
57	SSDIExit	BIT	N
58	SSExit	BIT	N
59	GenPubAssistanceExit	BIT	N
60	TANFExit	BIT	N
61	ChildSupportExit	BIT	N
62	VetBenefitsExit	BIT	N
63	EmploymentIncomeExit	BIT	N
64	UnemploymentBenefitsExit	BIT	N
65	MedicareExit	BIT	N
66	MedicaidExit	BIT	N
67	FoodStampsExit	BIT	N
68	NoFinancialResourcesExit	BIT	N
69	WICExit	BIT	N
70	LowIncomeHousingExit	BIT	N
71	KidsCareExit	BIT	N
72	AHCCCSExit	BIT	N
73	CashAssistanceExit	BIT	N
74	HealthStatus	VARCHAR(50)	N
75	HealthComments	VARCHAR(150)	N
76	Medication	BIT	N
77	MentalIllness	BIT	N
78	PhysDisability	BIT	N
79	DevDisability	BIT	N
80	HIVAIDS	BIT	N
81	Allergies	BIT	N
82	PreviousMedDiscussion	BIT	N
83	PregnantDuringDV	BIT	N
84	MiscarriageDuringDV	BIT	N
85	AbusePhysical	BIT	N
86	AbuseSexual	BIT	N
87	AbuseVerbalPsychological	BIT	N
88	AbuseEconomic	BIT	N
89	AbusedAsChild	BIT	N
90	AbuseWitness	BIT	N
91	Address	VARCHAR(100)	N
92	City	VARCHAR(50)	N
93	State	VARCHAR(15)	N
94	Zip	VARCHAR(15)	N
95	Phone	VARCHAR(50)	N
96	YearsSchooling	INT	Y
97	NumberChildren	INT	Y
98	EntryDataComplete	BIT	N
99	ExitDataComplete	BIT	N
100	CreatedDate	SMALLDATETIME	N
101	CreatedBy	VARCHAR(50)	N
102	ModifiedDate	SMALLDATETIME	N
103	ModifiedBy	VARCHAR(50)	N
104	DeletedDate	SMALLDATETIME	Y
105	DeletedBy	VARCHAR(50)	N
106	ReligionID	INT	N
107	IncomeOther	VARCHAR(100)	N
108	IncomeOtherExit	VARCHAR(100)	N
109	Pregnant	BIT	N
110	ChronicHealthCondition	BIT	N
111	LastAbuseDate	SMALLDATETIME	Y
112	PermanentSafeHousing	BIT	Y
113	SafeToCall	BIT	N
114	ReferralSourceID	INT	N
115	StillInRelationship	BIT	N
116	EntryDate	DATE	N
117	ExitDate	DATE	Y
118	Deaf	BIT	N
119	IsAbuserVeteran	BIT	N
120	IncomeIncreased	BIT	N
121	EducationGoals	BIT	N
122	EducationImproved	BIT	N
123	HealthPlanGoals	BIT	N
124	HealthImproved	BIT	N
125	HasSafetyPlan	BIT	N
126	AccessResources	BIT	N
127	ServicesHelped	BIT	N
128	EmployedAfterExit	BIT	N
129	SafeHousing	BIT	N
130	ThreeMonthContact	BIT	N
131	ThreeMonthSafelyHoused	BIT	N
132	IsHighRisk	BIT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_Intakes_IntakeID	Nonclustered	IntakeID (Primary Key)
2	IDX_Intakes_EntryDate	Clustered	EntryDate
3	IDX_Intakes_ExitDate	Nonclustered	ExitDate
4	IDX_Intakes_ParticipantID	Nonclustered	ParticipantID
5	IDX_Intakes_ShelterID	Nonclustered	ShelterID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Participants_Intakes_ParticipantID	ParticipantID	[Participants].[ParticipantID]
2	FK_Shelters_Intakes_ShelterID	ShelterID	[Shelters].[ShelterID]
3	FK_xAbuserRelationship_Intakes_AbuserRelationShipID	AbuserRelationshipID	[xAbuserRelationship].[AbuserRelationshipID]
4	FK_xCitizenship_Intakes_CitizenshipID	CitizenshipID	[xCitizenship].[CitizenshipID]
5	FK_xCounty_Intakes_CountyID	CountyID	[xCounty].[CountyID]
6	FK_xCourtOutcome_Intakes_CourtOutcomeID	CourtOutcomeID	[xCourtOutcome].[CourtOutcomeID]
7	FK_xEmployment_Intakes_EmploymentID	EmploymentID	[xEmployment].[EmploymentID]
8	FK_xExitDestination_Intakes_ExitDestinationID	ExitDestinationID	[xExitDestination].[ExitDestinationID]
9	FK_xExitHousing_Intakes_ExitHousingID	ExitHousingID	[xExitHousing].[ExitHousingID]
10	FK_xExitReason_Intakes_ExitReasonID	ExitReasonID	[xExitReason].[ExitReasonID]
11	FK_xIntakeType_Intakes_IntakeTypeID	IntakeTypeID	[xIntakeType].[IntakeTypeID]
12	FK_xLanguage_Intakes_LanguageID	LanguageID	[xLanguage].[LanguageID]
13	FK_xLocation_Intakes_LocationID	LocationID	[xLocation].[LocationID]
14	FK_xMaritalStatus_Intakes_MaritalStatusID	MaritalStatusID	[xMaritalStatus].[MaritalStatusID]
15	FK_xPriorResidence_Intakes_PriorResidenceID	PriorResidenceID	[xPriorResidence].[PriorResidenceID]
16	FK_xReferralSource_Intakes_ReferralSourceID	ReferralSourceID	[xReferralSource].[ReferralSourceID]
17	FK_xReligion_Intakes_ReligionID	ReligionID	[xReligion].[ReligionID]
18	FK_xReservation_Intakes_ReservationID	ReservationID	[xReservation].[ReservationID]
19	FK_xSubstanceProblem_Intakes_SubstanceAbuseID	SubstanceAbuseID	[xSubstanceProblem].[SubstanceProblemID]
20	FK_xSubstanceProblem_Intakes_SubstanceTreatmentID	SubstanceTreatmentID	[xSubstanceProblem].[SubstanceProblemID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Intakes__AbusedA__2E3BD7D3	AbusedAsChild	((0))
2	DF__Intakes__AbuseEc__2D47B39A	AbuseEconomic	((0))
3	DF__Intakes__AbusePh__2A6B46EF	AbusePhysical	((0))
4	DF__Intakes__AbuseSe__2B5F6B28	AbuseSexual	((0))
5	DF__Intakes__AbuseVe__2C538F61	AbuseVerbalPsychological	((0))
6	DF__Intakes__AbuseWi__2F2FFC0C	AbuseWitness	((0))
7	DF__Intakes__AccessR__430CD787	AccessResources	((0))
8	DF__Intakes__Address__30242045	Address	('')
9	DF__Intakes__AHCCCS__0CDAE408	AHCCCS	((0))
10	DF__Intakes__AHCCCSE__1E05700A	AHCCCSExit	((0))
11	DF__Intakes__Allergi__269AB60B	Allergies	((0))
12	DF__Intakes__CashAss__0DCF0841	CashAssistance	((0))
13	DF__Intakes__CashAss__1EF99443	CashAssistanceExit	((0))
14	DF__Intakes__ChildSu__025D5595	ChildSupport	((0))
15	DF__Intakes__ChildSu__1387E197	ChildSupportExit	((0))
16	DF__Intakes__Chronic__468862B0	ChronicHealthCondition	((0))
17	DF__Intakes__Citizen__64CCF2AE	CitizenshipID	((1))
18	DF__Intakes__City__3118447E	City	('')
19	DF__Intakes__CountyI__65C116E7	CountyID	((1))
20	DF__Intakes__CourtCa__79C80F94	CourtCase	((0))
21	DF__Intakes__CourtOu__6A85CC04	CourtOutcomeID	((1))
22	DF__Intakes__Created__36D11DD4	CreatedBy	('')
23	DF__Intakes__Current__75F77EB0	CurrentProtectionOrder	((0))
24	DF__Intakes__Deaf__34BEB830	Deaf	((0))
25	DF__Intakes__Deleted__39AD8A7F	DeletedBy	('')
26	DF__Intakes__DevDisa__24B26D99	DevDisability	((0))
27	DF__Intakes__DVArres__7132C993	DVArrestClient	((0))
28	DF__Intakes__DVArres__7226EDCC	DVArrestBatterer	((0))
29	DF__Intakes__Educati__3E48226A	EducationGoals	((0))
30	DF__Intakes__Educati__3F3C46A3	EducationImproved	((0))
31	DF__Intakes__Emergen__77DFC722	EmergencyMedClient	((0))
32	DF__Intakes__Emergen__78D3EB5B	EmergencyMedBatterer	((0))
33	DF__Intakes__Employe__44F51FF9	EmployedAfterExit	((0))
34	DF__Intakes__Employm__04459E07	EmploymentIncome	((0))
35	DF__Intakes__Employm__15702A09	EmploymentIncomeExit	((0))
36	DF__Intakes__Employm__6B79F03D	EmploymentID	((1))
37	DF__Intakes__Employm__6D6238AF	EmploymentExitID	((1))
38	DF__Intakes__EntryDa__34E8D562	EntryDataComplete	((0))
39	DF__Intakes__ExitDat__35DCF99B	ExitDataComplete	((0))
40	DF__Intakes__Extensi__7BB05806	ExtensionWavier	((0))
41	DF__Intakes__FoodSta__08162EEB	FoodStamps	((0))
42	DF__Intakes__FoodSta__1940BAED	FoodStampsExit	((0))
43	DF__Intakes__GenPubA__00750D23	GenPubAssistance	((0))
44	DF__Intakes__GenPubA__119F9925	GenPubAssistanceExit	((0))
45	DF__Intakes__HasSafe__4218B34E	HasSafetyPlan	((0))
46	DF__Intakes__HealthC__20E1DCB5	HealthComments	('')
47	DF__Intakes__HealthI__41248F15	HealthImproved	((0))
48	DF__Intakes__HealthP__40306ADC	HealthPlanGoals	((0))
49	DF__Intakes__HealthS__1FEDB87C	HealthStatus	('')
50	DF__Intakes__HIVAIDS__25A691D2	HIVAIDS	((0))
51	DF__Intakes__IncomeI__3D53FE31	IncomeIncreased	((0))
52	DF__Intakes__IncomeO__33AA9866	IncomeOther	('')
53	DF__Intakes__IncomeO__349EBC9F	IncomeOtherExit	('')
54	DF__Intakes__IsAbuse__35B2DC69	IsAbuserVeteran	((0))
55	DF__Intakes__IsConti__6F4A8121	IsContinuation	((0))
56	DF__Intakes__IsHighR__12349602	IsHighRisk	((0))
57	DF__Intakes__KidsCar__0BE6BFCF	KidsCare	((0))
58	DF__Intakes__KidsCar__1D114BD1	KidsCareExit	((0))
59	DF__Intakes__Languag__63D8CE75	LanguageID	((1))
60	DF__Intakes__Locatio__6991A7CB	LocationID	((1))
61	DF__Intakes__LowInco__0AF29B96	LowIncomeHousing	((0))
62	DF__Intakes__LowInco__1C1D2798	LowIncomeHousingExit	((0))
63	DF__Intakes__Medicai__07220AB2	Medicaid	((0))
64	DF__Intakes__Medicai__184C96B4	MedicaidExit	((0))
65	DF__Intakes__Medicar__062DE679	Medicare	((0))
66	DF__Intakes__Medicar__1758727B	MedicareExit	((0))
67	DF__Intakes__Medicat__21D600EE	Medication	((0))
68	DF__Intakes__MentalI__22CA2527	MentalIllness	((0))
69	DF__Intakes__Miscarr__297722B6	MiscarriageDuringDV	((0))
70	DF__Intakes__Modifie__37C5420D	ModifiedDate	(getdate())
71	DF__Intakes__Modifie__38B96646	ModifiedBy	('')
72	DF__Intakes__NoFinan__090A5324	NoFinancialResources	((0))
73	DF__Intakes__NoFinan__1A34DF26	NoFinancialResourcesExit	((0))
74	DF__Intakes__Phone__33F4B129	Phone	('')
75	DF__Intakes__PhysDis__23BE4960	PhysDisability	((0))
76	DF__Intakes__PoliceR__703EA55A	PoliceReport	((0))
77	DF__Intakes__Pregnan__2882FE7D	PregnantDuringDV	((0))
78	DF__Intakes__Pregnan__45943E77	Pregnant	((0))
79	DF__Intakes__Previou__278EDA44	PreviousMedDiscussion	((0))
80	DF__Intakes__Previou__731B1205	PreviousReport	((0))
81	DF__Intakes__Previou__740F363E	PreviousArrestClient	((0))
82	DF__Intakes__Previou__75035A77	PreviousArrestBatterer	((0))
83	DF__Intakes__Previou__76EBA2E9	PreviousProtectionOrder	((0))
84	DF__Intakes__Protect__7ABC33CD	ProtectionOrder	((0))
85	DF__Intakes__Referra__5C0D8F7B	ReferralSourceID	((1))
86	DF__Intakes__Religio__1ADEEA9C	ReligionID	((1))
87	DF__Intakes__Reserva__66B53B20	ReservationID	((1))
88	DF__Intakes__SafeHou__45E94432	SafeHousing	((0))
89	DF__Intakes__SafeToC__5E2AE217	SafeToCall	((0))
90	DF__Intakes__Service__4400FBC0	ServicesHelped	((0))
91	DF__Intakes__SS__7F80E8EA	SS	((0))
92	DF__Intakes__SSDI__7E8CC4B1	SSDI	((0))
93	DF__Intakes__SSDIExi__0FB750B3	SSDIExit	((0))
94	DF__Intakes__SSExit__10AB74EC	SSExit	((0))
95	DF__Intakes__SSI__7D98A078	SSI	((0))
96	DF__Intakes__SSIExit__0EC32C7A	SSIExit	((0))
97	DF__Intakes__State__320C68B7	State	('')
98	DF__Intakes__StillIn__5D01B3B4	StillInRelationship	((0))
99	DF__Intakes__TANF__0169315C	TANF	((0))
100	DF__Intakes__TANF_El__7CA47C3F	TANF_Eligible	((0))
101	DF__Intakes__TANFExi__1293BD5E	TANFExit	((0))
102	DF__Intakes__ThreeMo__46DD686B	ThreeMonthContact	((0))
103	DF__Intakes__ThreeMo__47D18CA4	ThreeMonthSafelyHoused	((0))
104	DF__Intakes__Unemplo__0539C240	UnemploymentBenefits	((0))
105	DF__Intakes__Unemplo__16644E42	UnemploymentBenefitsExit	((0))
106	DF__Intakes__VetBene__035179CE	VetBenefits	((0))
107	DF__Intakes__VetBene__147C05D0	VetBenefitsExit	((0))
108	DF__Intakes__WIC__09FE775D	WIC	((0))
109	DF__Intakes__WICExit__1B29035F	WICExit	((0))
110	DF__Intakes__Zip__33008CF0	Zip	('')
111	DF__xPriorRes__Prior	PriorResidenceID	((0))
112	DF_Intakes_SubstanceAbuseID	SubstanceAbuseID	((0))
113	DF_Intakes_SubstanceTreatmentID	SubstanceTreatmentID	((0))

Check Constraints

Sr.	Name	Column	Definition
1	CHK_Intakes_EntryDay_ExitDate		([ExitDate]>=[EntryDate])
2	CK__Intakes__Employm__6C6E1476	EmploymentID	([EmploymentID]>=(1) AND [EmploymentID]<=(11))
3	CK__Intakes__Employm__6E565CE8	EmploymentExitID	([EmploymentExitID]>=(1) AND [EmploymentExitID]<=(11))

Index
Table: IntakeStaff

Description

Intersection table relating shelter staff members to intakes.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	StaffID	INT	N
2	IntakeID	INT	N
3	StaffRole	VARCHAR(50)	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_IntakeStaff_StaffID_IntakeID	Clustered	StaffID (Primary Key) IntakeID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Intakes_IntakeStaff_IntakeID	IntakeID	[Intakes].[IntakeID]
2	FK_Staff_IntakeStaff_StaffID	StaffID	[Staff].[StaffID]

Index
Table: IntakeTasks

Description

Intersection table relating tasks to be accomplished with the associated intake.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IntakeID	INT	N
2	TaskID	INT	N
3	ClientTypeID	INT	N
4	CompletedDate	DATE	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_IntakeTasks_IntakeID_TaskID	Clustered	IntakeID (Primary Key) TaskID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Intakes_IntakeTasks_IntakeID	IntakeID	[Intakes].[IntakeID]
2	FK_Tasks_IntakeTasks_TaskID	TaskID	[Tasks].[TaskID]

Default Constraints

Sr.	Name	Column	Value
1	DF__IntakeTas__Clien__56F3D4A3	ClientTypeID	((1))

Index
Table: IntakeVictimType

Description

Intersection table relating types of victimization experienced by participants for the associated intake.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IntakeID	INT	N
2	VictimTypeID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_IntakeVictimType_IntakeID_VictimTypeIDID	Clustered	IntakeID (Primary Key) VictimTypeID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_IntakeVictimType_Intakes_IntakeID	IntakeID	[Intakes].[IntakeID]
2	FK_IntakeVictimType_xCallSubject_VictimTypeID	VictimTypeID	[xCallSubject].[CallSubjectID]

Check Constraints

Sr.	Name	Column	Definition
1	CK__IntakeVic__Victi__388F4914	VictimTypeID	([VictimTypeID]>=(3) AND [VictimTypeID]<=(99))

Index
Table: Interventions

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	InterventionID	INT	N
2	ClientID	INT	N
3	ClientTypeID	INT	N
4	SessionID	INT	N
5	IntakeID	INT	N
6	PoliceReport	BIT	N
7	PreviousReport	BIT	N
8	DVArrestClient	BIT	N
9	DVArrestBatterer	BIT	N
10	PreviousArrestClient	BIT	N
11	PreviousArrestBatterer	BIT	N
12	CurrentProtectionOrder	BIT	N
13	PreviousProtectionOrder	BIT	N
14	EmergencyMedClient	BIT	N
15	EmergencyMedBatterer	BIT	N
16	LawAgencyID	INT	N
17	Abuser	VARCHAR(100)	N
18	AbuserRelationshipID	INT	N
19	CountyID	INT	N
20	ReservationID	INT	N
21	LocationID	INT	N
22	Address	VARCHAR(100)	N
23	City	VARCHAR(50)	N
24	State	VARCHAR(15)	N
25	Zip	VARCHAR(15)	N
26	Phone	VARCHAR(50)	N
27	Advocacy	VARCHAR(3000)	N
28	CreatedDate	SMALLDATETIME	N
29	CreatedBy	VARCHAR(50)	N
30	ModifiedDate	SMALLDATETIME	N
31	ModifiedBy	VARCHAR(50)	N
32	DeletedDate	SMALLDATETIME	Y
33	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Interventions_InterventionID	Clustered	InterventionID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Sessions_CrisisIntervention_SessionID	SessionID	[Sessions].[SessionID]
2	FK_xAbuserRelationship_CrisisIntervention_AbuserRelationShipID	AbuserRelationshipID	[xAbuserRelationship].[AbuserRelationshipID]
3	FK_xCounty_CrisisIntervention_CountyID	CountyID	[xCounty].[CountyID]
4	FK_xLawEnforcementAgency_CrisisIntervention_LawAgencyID	LawAgencyID	[xLawEnforcementAgency].[AgencyID]
5	FK_xLocation_CrisisIntervention_LocationID	LocationID	[xLocation].[LocationID]
6	FK_xReservation_CrisisIntervention_ReservationID	ReservationID	[xReservation].[ReservationID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Intervent__Abuse__78A9CE29	Abuser	('')
2	DF__Intervent__Abuse__799DF262	AbuserRelationshipID	((0))
3	DF__Intervent__Addre__7D6E8346	Address	('')
4	DF__Intervent__Advoc__02333863	Advocacy	('')
5	DF__Intervent__Count__7A92169B	CountyID	((1))
6	DF__Intervent__Creat__03275C9C	CreatedBy	('')
7	DF__Intervent__Curre__73E5190C	CurrentProtectionOrder	((0))
8	DF__Intervent__Delet__0603C947	DeletedBy	('')
9	DF__Intervent__DVArr__70148828	DVArrestClient	((0))
10	DF__Intervent__DVArr__7108AC61	DVArrestBatterer	((0))
11	DF__Intervent__Emerg__75CD617E	EmergencyMedClient	((0))
12	DF__Intervent__Emerg__76C185B7	EmergencyMedBatterer	((0))
13	DF__Intervent__Intak__6D381B7D	IntakeID	((0))
14	DF__Intervent__LawAg__77B5A9F0	LawAgencyID	((1))
15	DF__Intervent__Locat__7C7A5F0D	LocationID	((1))
16	DF__Intervent__Modif__041B80D5	ModifiedDate	(getdate())
17	DF__Intervent__Modif__050FA50E	ModifiedBy	('')
18	DF__Intervent__Phone__013F142A	Phone	('')
19	DF__Intervent__Polic__6E2C3FB6	PoliceReport	((0))
20	DF__Intervent__Previ__6F2063EF	PreviousReport	((0))
21	DF__Intervent__Previ__71FCD09A	PreviousArrestClient	((0))
22	DF__Intervent__Previ__72F0F4D3	PreviousArrestBatterer	((0))
23	DF__Intervent__Previ__74D93D45	PreviousProtectionOrder	((0))
24	DF__Intervent__Reser__7B863AD4	ReservationID	((1))
25	DF__Intervent__State__7F56CBB8	State	('')
26	DF__Interventi__City__7E62A77F	City	('')
27	DF__Interventio__Zip__004AEFF1	Zip	('')

Index
Table: LinkedIntakes

Description

Intersection table to relate two intakes of the same participant, with an origin intake linked to a subsequent intake.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	OriginIntakeID	INT	N
2	GainingIntakeID	INT	N
3	ParticipantID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_LinkedIntakes_OriginIntakeID_GainingIntakeID	Nonclustered	OriginIntakeID (Primary Key) GainingIntakeID (Primary Key)
2	IDX_LinkedIntakes_ParticipantID	Clustered	ParticipantID

Index
Table: MatrixDomains

Description

Contains fixed entries of "domains" of the Self-Sufficiency Assessment.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	DomainID	INT	N
2	Domain	VARCHAR(100)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_MatrixDomains_DomainID	Clustered	DomainID (Primary Key)

Index
Table: MatrixStatus

Description

Contains fixed entries of status levels for the Self-Sufficiency Assessment.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	StatusID	INT	N
2	Status	VARCHAR(50)	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_MatrixStatus_StatusID	Clustered	StatusID (Primary Key)

Check Constraints

Sr.	Name	Column	Definition
1	CK_MatrixStatus_StatusID	StatusID	([StatusID]<(6))

Index
Table: NarrativeResponses

Description

Contains narrative responses captured on questionnaires.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	NarrativeID	INT	N
2	QuestionnaireID	INT	N
3	Narrative	VARCHAR(1000)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_NarrativeResponses_NarrativeID_QuestionnaireID	Clustered	NarrativeID (Primary Key) QuestionnaireID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Questionnaires_NarrativeResponses_QuestionairreID	QuestionnaireID	[Questionnaires].[QuestionnaireID]
2	FK_SurveyNarratives_NarativeResponses_NarrativeID	NarrativeID	[SurveyNarratives].[NarrativeID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Narrative__Narra__4979DDF4	Narrative	('')

Index
Table: Notes

Description

Container for notes entered for clients.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	NoteID	INT	N
2	ClientID	INT	Y
3	ClientTypeID	INT	N
4	Subject	VARCHAR(50)	N
5	NoteText	VARCHAR(2000)	N
6	CreatedDate	SMALLDATETIME	N
7	CreatedBy	VARCHAR(50)	N
8	ModifiedDate	SMALLDATETIME	N
9	ModifiedBy	VARCHAR(50)	N
10	DeletedDate	SMALLDATETIME	Y
11	DeletedBy	VARCHAR(50)	N
12	NoteDate	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_Notes_NoteID	Clustered	NoteID (Primary Key)
2	IDX_Notes_ClientID	Nonclustered	ClientID
3	IDX_Notes_ClientTypeID	Nonclustered	ClientTypeID
4	IDX_Notes_NoteDate	Nonclustered	NoteDate

Default Constraints

Sr.	Name	Column	Value
1	DF__Notes__ClientTyp__10E07F16	ClientTypeID	((1))
2	DF__Notes__CreatedBy__14B10FFA	CreatedBy	('')
3	DF__Notes__DeletedBy__178D7CA5	DeletedBy	('')
4	DF__Notes__ModifiedB__1699586C	ModifiedBy	('')
5	DF__Notes__ModifiedD__15A53433	ModifiedDate	(getdate())
6	DF__Notes__Subject__13BCEBC1	Subject	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__Notes__ClientTyp__194BA7E5	ClientTypeID	([ClientTypeID]>=(1) AND [ClientTypeID]<=(4))

Index
Table: ParticipantFiles

Description

Used to capture disk files within the database for participants, e.g., pdf and jpg files.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	FileID	INT	N
2	ParticipantID	INT	N
3	FileData	VARBINARY	N
4	ShortFileName	VARCHAR(256)	N
5	Extension	VARCHAR(10)	N
6	FileSize	VARCHAR(50)	N
7	CreatedBy	VARCHAR(50)	N
8	CreatedDate	DATETIME	N
9	DeletedBy	VARCHAR(50)	N
10	DeletedDate	DATETIME	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_ParticipantFiles_FileID	Nonclustered	FileID (Primary Key)
2	IDX_ParticipantFiles_ParticipantID	Clustered	ParticipantID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Participants_ParticipantFiles_ParticipantID	ParticipantID	[Participants].[ParticipantID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Participa__Creat__18227982	CreatedBy	('')
2	DF__Participa__Creat__19169DBB	CreatedDate	(getdate())
3	DF__Participa__Delet__1A0AC1F4	DeletedBy	('')
4	DF__Participa__Exten__172E5549	Extension	('')

Index
Table: ParticipantReturnIssue

Description

Contains description of issues specifying why participants have been flagged as unsuitable for subsequent intakes.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ParticipantID	INT	N
2	ReturnIssue	VARCHAR(250)	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_ParticipantReturnIssue_ParticipantID	Nonclustered	ParticipantID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Participants_ParticipantReturnIssue_PartcipantID	ParticipantID	[Participants].[ParticipantID]

Index
Table: Participants

Description

Contains participant attributes that are not typically subject to change, e.g., date-of-birth.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ParticipantID	INT	N
2	EthnicityID	INT	Y
3	FirstName	VARCHAR(50)	N
4	LastName	VARCHAR(50)	N
5	MI	CHAR(1)	N
6	OptionalIdentifier	VARCHAR(50)	N
7	Sex	CHAR(1)	N
8	Veteran	BIT	N
9	SSN	CHAR(11)	N
10	NoReturn	BIT	N
11	ReturnStatusID	INT	N
12	CreatedDate	SMALLDATETIME	N
13	CreatedBy	VARCHAR(50)	N
14	ModifiedDate	SMALLDATETIME	N
15	ModifiedBy	VARCHAR(50)	N
16	DeletedDate	SMALLDATETIME	Y
17	DeletedBy	VARCHAR(50)	N
18	ChronicallyHomeless	BIT	N
19	LGBT	BIT	N
20	DOB	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Participants_ParticipantID	Clustered	ParticipantID (Primary Key)
2	IDX_Participants_EthnicityID	Nonclustered	EthnicityID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_xEthnicity_Participants_EthnicityID	EthnicityID	[xEthnicity].[EthnicityID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Participa__Chron__44A01A3E	ChronicallyHomeless	((0))
2	DF__Participa__Creat__00AA174D	CreatedBy	('')
3	DF__Participa__Delet__038683F8	DeletedBy	('')
4	DF__Participa__Ethni__753864A1	EthnicityID	((1))
5	DF__Participa__First__762C88DA	FirstName	('')
6	DF__Participa__LastN__7720AD13	LastName	('')
7	DF__Participa__Modif__019E3B86	ModifiedDate	(getdate())
8	DF__Participa__Modif__02925FBF	ModifiedBy	('')
9	DF__Participa__NoRet__7DCDAAA2	NoReturn	((0))
10	DF__Participa__Optio__7908F585	OptionalIdentifier	('')
11	DF__Participa__Retur__7EC1CEDB	ReturnStatusID	((1))
12	DF__Participa__Veter__7BE56230	Veteran	((0))
13	DF__Participan__LGBT__63AEB143	LGBT	((0))
14	DF__Participant__Sex__7AF13DF7	Sex	('F')
15	DF__Participant__SSN__7CD98669	SSN	('')
16	DF__Participants__MI__7814D14C	MI	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__Participa__Retur__7FB5F314	ReturnStatusID	([ReturnStatusID]>=(1) AND [ReturnStatusID]<=(4))
2	CK__Participant__Sex__79FD19BE	Sex	([Sex]='M' OR [Sex]='F')

Index
Table: Pets

Description

Contains records of pets sheltered during a participant intake.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PetID	INT	N
2	IntakeID	INT	N
3	Name	VARCHAR(100)	N
4	PetTypeID	INT	N
5	Breed	VARCHAR(100)	N
6	IsVaccinated	BIT	N
7	IsAbused	BIT	N
8	RetainedOnExit	BIT	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Pets_PetID	Clustered	PetID (Primary Key)
2	IDX_Pets_IntakeID	Nonclustered	IntakeID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Intakes_Pets_IntakeID	IntakeID	[Intakes].[IntakeID]
2	FK_xPetTypes_Pets_PetTypeID	PetTypeID	[xPetType].[PetTypeID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Pets__Breed__0E44098D	Breed	('')
2	DF__Pets__IsAbused__102C51FF	IsAbused	((0))
3	DF__Pets__IsVaccinat__0F382DC6	IsVaccinated	((0))
4	DF__Pets__Name__0D4FE554	Name	('')

Index
Table: Phases

Description

Description of phases of an intake defined by the shelter for various intake types.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PhaseID	INT	N
2	PhaseName	VARCHAR(50)	N
3	IntakeTypeID	INT	N
4	ProjectedLength	INT	N
5	CreatedDate	SMALLDATETIME	N
6	CreatedBy	VARCHAR(50)	N
7	ModifiedDate	SMALLDATETIME	N
8	ModifiedBy	VARCHAR(50)	N
9	DeletedDate	SMALLDATETIME	Y
10	DeletedBy	VARCHAR(50)	N
11	IsCurrent	BIT	N
12	Sequence	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Phases_PhaseID	Clustered	PhaseID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_xIntakeType_Phases_IntakeTypeID	IntakeTypeID	[xIntakeType].[IntakeTypeID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Phases__CreatedB__72E607DB	CreatedBy	('')
2	DF__Phases__DeletedB__75C27486	DeletedBy	('')
3	DF__Phases__IsCurren__2803DB90	IsCurrent	((1))
4	DF__Phases__Modified__73DA2C14	ModifiedDate	(getdate())
5	DF__Phases__Modified__74CE504D	ModifiedBy	('')
6	DF__Phases__Sequence__39B87777	Sequence	((0))

Index
Table: Presentations

Description

Presentation records of staff outreach activities.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PresentationID	INT	N
2	PresentationHours	FLOAT	Y
3	PrepHours	FLOAT	Y
4	NumberAttended	INT	N
5	Location	VARCHAR(50)	N
6	YouthTargeted	BIT	N
7	CreatedDate	SMALLDATETIME	N
8	CreatedBy	VARCHAR(50)	N
9	ModifiedDate	SMALLDATETIME	N
10	ModifiedBy	VARCHAR(50)	N
11	DeletedDate	SMALLDATETIME	Y
12	DeletedBy	VARCHAR(50)	N
13	IsPresentation	BIT	N
14	Note	VARCHAR(500)	N
15	PresentationDate	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_Presentations_PresentationID	Nonclustered	PresentationID (Primary Key)
2	IDX_Presentations_PresentationDate	Clustered	PresentationDate

Default Constraints

Sr.	Name	Column	Value
1	DF__Presentat__Creat__40C49C62	CreatedBy	('')
2	DF__Presentat__Delet__43A1090D	DeletedBy	('')
3	DF__Presentat__IsPre__1D864D1D	IsPresentation	((1))
4	DF__Presentat__Locat__3EDC53F0	Location	('')
5	DF__Presentat__Modif__41B8C09B	ModifiedDate	(getdate())
6	DF__Presentat__Modif__42ACE4D4	ModifiedBy	('')
7	DF__Presentat__Youth__3FD07829	YouthTargeted	((0))
8	DF__Presentati__Note__76F68FE1	Note	('')

Index
Table: PresentationTopics

Description

Topics associated with staff presentations.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TopicID	INT	N
2	PresentationID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_PresentationTopic	Clustered	TopicID (Primary Key) PresentationID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Presentations_PresentationTopic_PresentationID	PresentationID	[Presentations].[PresentationID]
2	FK_xTopicID_PresentationTopic_TopicID	TopicID	[xTopic].[TopicID]

Index
Table: Programs

Description

Programs administered by the organization, essentially a collection of shelter-defined services.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ProgramID	INT	N
2	Program	VARCHAR(100)	N
3	IsCurrent	BIT	N
4	CreatedDate	SMALLDATETIME	N
5	CreatedBy	VARCHAR(50)	N
6	ModifiedDate	SMALLDATETIME	N
7	ModifiedBy	VARCHAR(50)	N
8	DeletedDate	SMALLDATETIME	Y
9	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Programs_ProgramID	Clustered	ProgramID (Primary Key)
2	UQ__Programs__B20D7B4A00DF2177	Nonclustered	Program

Default Constraints

Sr.	Name	Column	Value
1	DF__Programs__Create__03BB8E22	CreatedBy	('')
2	DF__Programs__Delete__0697FACD	DeletedBy	('')
3	DF__Programs__IsCurr__02C769E9	IsCurrent	((1))
4	DF__Programs__Modifi__04AFB25B	ModifiedDate	(getdate())
5	DF__Programs__Modifi__05A3D694	ModifiedBy	('')

Index
Table: ProgramServices

Description

Intersection table relating programs to their associated services.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ProgramID	INT	N
2	ServiceID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_ProgramServices_ProgramID_ServiceID	Clustered	ProgramID (Primary Key) ServiceID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Programs_ProgramServices_ProgramID	ProgramID	[Programs].[ProgramID]
2	FK_Services_ProgramServices_ServiceID	ServiceID	[Services].[ServiceID]

Index
Table: Questionnaires

Description

Contains records of questionnaires used to survey clients.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	QuestionnaireID	INT	N
2	SurveyID	INT	N
3	IntakeID	INT	N
4	ControlNumber	VARCHAR(100)	N
5	CreatedDate	SMALLDATETIME	N
6	CreatedBy	VARCHAR(50)	N
7	ModifiedDate	SMALLDATETIME	N
8	ModifiedBy	VARCHAR(50)	N
9	DeletedDate	SMALLDATETIME	Y
10	DeletedBy	VARCHAR(50)	N
11	ClientTypeID	INT	N
12	CompletedDate	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Questionnaires_QuestionnaireID	Clustered	QuestionnaireID (Primary Key)
2	IDX_Questionnaires_CompletedDate	Nonclustered	CompletedDate
3	IDX_Questionnaires_IntakeID	Nonclustered	IntakeID
4	IDX_Questionnaires_SurveyID	Nonclustered	SurveyID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Surveys_Questionnaires_SurveyID	SurveyID	[Surveys].[SurveyID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Questionn__Clien__3651FAE7	ClientTypeID	((1))
2	DF__Questionn__Contr__3A379A64	ControlNumber	('')
3	DF__Questionn__Creat__3B2BBE9D	CreatedBy	('')
4	DF__Questionn__Delet__3E082B48	DeletedBy	('')
5	DF__Questionn__Intak__3943762B	IntakeID	((0))
6	DF__Questionn__Modif__3C1FE2D6	ModifiedDate	(getdate())
7	DF__Questionn__Modif__3D14070F	ModifiedBy	('')

Index
Table: QuestionResponses

Description

Contains the numeric responses of clients on questionnaires.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	QuestionID	INT	N
2	QuestionnaireID	INT	N
3	Response	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_QuestionnaireResponses_QuestionnaireID_QuestionID	Clustered	QuestionID (Primary Key) QuestionnaireID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Questionnaires_QuestionnaireResponses_QuestionnaireID	QuestionnaireID	[Questionnaires].[QuestionnaireID]
2	FK_Questions_QuestionnaireResponses_QuestionID	QuestionID	[Questions].[QuestionID]

Check Constraints

Sr.	Name	Column	Definition
1	CK__QuestionR__Respo__41D8BC2C	Response	([Response]>=(0) AND [Response]<=(20))

Index
Table: Questions

Description

Contains questions, and the outcomes they are used to measure, that may be included in a survey.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	QuestionID	INT	N
2	Question	VARCHAR(500)	N
3	Outcome	VARCHAR(500)	N
4	GoalID	INT	N
5	MaxRating	INT	N
6	IsCurrent	BIT	N
7	CreatedDate	SMALLDATETIME	N
8	CreatedBy	VARCHAR(50)	N
9	ModifiedDate	SMALLDATETIME	N
10	ModifiedBy	VARCHAR(50)	N
11	DeletedDate	SMALLDATETIME	Y
12	DeletedBy	VARCHAR(50)	N
13	IsResource	BIT	N
14	IsSafety	BIT	N
15	IsShelter	BIT	N
16	IsServices	BIT	N
17	IsCounseling	BIT	N
18	IsGroup	BIT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Questions_QuestionID	Clustered	QuestionID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Goals_Questions_GoalID	GoalID	[Goals].[GoalID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Questions__Creat__2DD1C37F	CreatedBy	('')
2	DF__Questions__Delet__30AE302A	DeletedBy	('')
3	DF__Questions__IsCou__4E7E8A33	IsCounseling	((0))
4	DF__Questions__IsCur__2CDD9F46	IsCurrent	((1))
5	DF__Questions__IsGro__4F72AE6C	IsGroup	((0))
6	DF__Questions__IsRes__4AADF94F	IsResource	((0))
7	DF__Questions__IsSaf__4BA21D88	IsSafety	((0))
8	DF__Questions__IsSer__4D8A65FA	IsServices	((0))
9	DF__Questions__IsShe__4C9641C1	IsShelter	((0))
10	DF__Questions__MaxRa__2BE97B0D	MaxRating	((1))
11	DF__Questions__Modif__2EC5E7B8	ModifiedDate	(getdate())
12	DF__Questions__Modif__2FBA0BF1	ModifiedBy	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__Questions__MaxRa__2AF556D4	MaxRating	([MaxRating]>=(1) AND [MaxRating]<=(20))

Index
Table: Referrals

Description

Contains records of referrals made for clients for services provided by other organizations.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReferralID	INT	N
2	ClientID	INT	N
3	ClientTypeID	INT	N
4	IntakeID	INT	N
5	ReferralTypeID	INT	N
6	NumberReferrals	INT	N
7	Agency	VARCHAR(50)	N
8	CreatedDate	SMALLDATETIME	N
9	CreatedBy	VARCHAR(50)	N
10	ModifiedDate	SMALLDATETIME	N
11	ModifiedBy	VARCHAR(50)	N
12	DeletedDate	SMALLDATETIME	Y
13	DeletedBy	VARCHAR(50)	N
14	ReferralDate	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_Referrals_ReferralID	Nonclustered	ReferralID (Primary Key)
2	IDX_Referrals_ClientID	Nonclustered	ClientID
3	IDX_Referrals_ReferralDate	Nonclustered	ReferralDate
4	IDX_Referrals_ReferralTypeID	Nonclustered	ReferralTypeID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_xReferralType_Referrals_ReferralTypeID	ReferralTypeID	[xReferralType].[ReferralTypeID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Referrals__Agenc__473C8FC7	Agency	('')
2	DF__Referrals__Clien__4460231C	ClientTypeID	((1))
3	DF__Referrals__Creat__4830B400	CreatedBy	('')
4	DF__Referrals__Delet__4B0D20AB	DeletedBy	('')
5	DF__Referrals__Modif__4924D839	ModifiedDate	(getdate())
6	DF__Referrals__Modif__4A18FC72	ModifiedBy	('')
7	DF__Referrals__Numbe__46486B8E	NumberReferrals	((1))

Check Constraints

Sr.	Name	Column	Definition
1	CK__Referrals__Clien__1A3FCC1E	ClientTypeID	([ClientTypeID]>=(1) AND [ClientTypeID]<=(4))

Index
Table: ReleaseEntities

Description

Lists all organizations/entities to whom the shelter may release specified client information.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReleaseID	INT	N
2	EntityID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_ReleaseEntities_ReleaseID_EntityID	Clustered	ReleaseID (Primary Key) EntityID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_InfoEntities_ReleaseEntities_EntityID	EntityID	[InfoEntities].[EntityID]
2	FK_InfoReleases_ReleaseEntities_ReleaseID	ReleaseID	[InfoReleases].[ReleaseID]

Index
Table: ReleaseTypes

Description

Lists the types of information that may be released to outside agencies.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReleaseTypeID	INT	N
2	ReleaseType	VARCHAR(100)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_ReleaseTypes	Clustered	ReleaseTypeID (Primary Key)

Default Constraints

Sr.	Name	Column	Value
1	DF__ReleaseTy__Creat__57B2EEB2	CreatedBy	('')
2	DF__ReleaseTy__Delet__5A8F5B5D	DeletedBy	('')
3	DF__ReleaseTy__Modif__58A712EB	ModifiedDate	(getdate())
4	DF__ReleaseTy__Modif__599B3724	ModifiedBy	('')

Index
Table: ReportNarratives

Description

Captures narrative items used for certain funder reports.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	NarrativeID	INT	N
2	ReportNumber	INT	N
3	Item	VARCHAR(10)	N
4	Narrative	VARCHAR(2000)	N
5	CreatedDate	SMALLDATETIME	N
6	CreatedBy	VARCHAR(50)	N
7	ModifiedDate	SMALLDATETIME	N
8	ModifiedBy	VARCHAR(50)	N
9	DeletedDate	SMALLDATETIME	Y
10	DeletedBy	VARCHAR(50)	N
11	ReportDate	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_ReportNarratives_ReportNumber_Item_ReportDate	Nonclustered	ReportNumber (Primary Key) Item (Primary Key) ReportDate (Primary Key)

Default Constraints

Sr.	Name	Column	Value
1	DF__ReportNar__Creat__4F32B74A	CreatedBy	('')
2	DF__ReportNar__Delet__520F23F5	DeletedBy	('')
3	DF__ReportNar__Modif__5026DB83	ModifiedDate	(getdate())
4	DF__ReportNar__Modif__511AFFBC	ModifiedBy	('')
5	DF__ReportNar__Narra__4E3E9311	Narrative	('')

Index
Table: RHBA

Description

Captures particiapnt information to be used by Regional Behavioral Health Authorities.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ParticipantID	INT	N
2	RhbaEligible	BIT	N
3	EnrollmentStatus	VARCHAR(50)	N
4	Title19Eligible	BIT	N
5	DiagnosticCode	VARCHAR(50)	N
6	Diagnosis	VARCHAR(10)	N
7	Comments	VARCHAR(250)	N
8	T19ApplicationStatus	VARCHAR(50)	N
9	T19ApplicationDate	SMALLDATETIME	Y
10	CisID	VARCHAR(15)	N
11	AhcccsID	VARCHAR(15)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_RHBA_ParticipantID	Clustered	ParticipantID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Participants_RHBA_ParticipantID	ParticipantID	[Participants].[ParticipantID]

Default Constraints

Sr.	Name	Column	Value
1	DF__RHBA__AhcccsID__4999D985	AhcccsID	('')
2	DF__RHBA__CisID__48A5B54C	CisID	('')
3	DF__RHBA__Comments__2A212E2C	Comments	('')
4	DF__RHBA__Diagnosis__292D09F3	Diagnosis	('')
5	DF__RHBA__Diagnostic__2838E5BA	DiagnosticCode	('')
6	DF__RHBA__Enrollment__26509D48	EnrollmentStatus	('')
7	DF__RHBA__RhbaEligib__255C790F	RhbaEligible	((0))
8	DF__RHBA__T19Applica__2B155265	T19ApplicationStatus	('')
9	DF__RHBA__Title19Eli__2744C181	Title19Eligible	((0))

Index
Table: RoomBedAssignments

Description

Intersection table with dates that beds were assigned/removed from rooms in the shelter.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	BedID	INT	N
2	RoomID	INT	N
3	RoomBedAssignmentID	INT	N
4	CreatedDate	SMALLDATETIME	N
5	CreatedBy	VARCHAR(50)	N
6	ModifiedDate	SMALLDATETIME	N
7	ModifiedBy	VARCHAR(50)	N
8	DateAssigned	DATE	N
9	DateMoved	DATE	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_RoomBedAssignments_BedID_RoomID_DateAssigned	Clustered	BedID (Primary Key) RoomID (Primary Key) DateAssigned (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Beds_RoomBedAssignments_BedID	BedID	[Beds].[BedID]
2	FK_Rooms_RoomBedAssignments_RoomID	RoomID	[Rooms].[RoomID]

Default Constraints

Sr.	Name	Column	Value
1	DF__RoomBedAs__Creat__793DFFAF	CreatedBy	('')
2	DF__RoomBedAs__Modif__7A3223E8	ModifiedDate	(getdate())
3	DF__RoomBedAs__Modif__7B264821	ModifiedBy	('')

Index
Table: Rooms

Description

Contains basic information of residential rooms within shelters.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	RoomID	INT	N
2	ShelterID	INT	N
3	RoomNumber	VARCHAR(50)	N
4	CreatedDate	SMALLDATETIME	N
5	CreatedBy	VARCHAR(50)	N
6	ModifiedDate	SMALLDATETIME	N
7	ModifiedBy	VARCHAR(50)	N
8	DeletedDate	SMALLDATETIME	Y
9	DeletedBy	VARCHAR(50)	N
10	ServiceStart	DATE	N
11	ServiceEnd	DATE	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Rooms_RoomID	Clustered	RoomID (Primary Key)
2	UQ__Rooms__AE10E07A690797E6	Nonclustered	RoomNumber

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Shelters_Rooms_ShelterID	ShelterID	[Shelters].[ShelterID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Rooms__CreatedBy__6AEFE058	CreatedBy	('')
2	DF__Rooms__DeletedBy__6DCC4D03	DeletedBy	('')
3	DF__Rooms__ModifiedB__6CD828CA	ModifiedBy	('')
4	DF__Rooms__ModifiedD__6BE40491	ModifiedDate	(getdate())

Index
Table: ServiceFocus

Description

Intersection table relating shelter service types with related sub-categories, i.e., "focus".

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ServiceID	INT	N
2	FocusID	INT	N
3	ServiceFocusID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_ServiceFocus_ServiceID_FocusID	Clustered	ServiceID (Primary Key) FocusID (Primary Key)
2	IDX_ServiceFocus_ServiceFocusID	Nonclustered	ServiceFocusID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Focus_ServiceFocus_FocusID	FocusID	[Focus].[FocusID]
2	FK_Services_ServiceFocus_ServiceID	ServiceID	[Services].[ServiceID]

Index
Table: ServiceMap

Description

Intersection table relating grantor service types to shelter service/focus catigories.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	GrantorServiceID	INT	N
2	GrantorID	INT	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N
9	ServiceFocusID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_ServiceMap_ServiceFocusID_GrantorID	Clustered	GrantorID (Primary Key) ServiceFocusID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Grantors_ServiceMap_GrantorID	GrantorID	[Grantors].[GrantorID]
2	FK_GrantorServices_ServiceMap_GrantorServiceID	GrantorServiceID	[GrantorServices].[GrantorServiceID]
3	FK_ServiceFocus_ServiceMap_ServiceFocusID	ServiceFocusID	[ServiceFocus].[ServiceFocusID]

Default Constraints

Sr.	Name	Column	Value
1	DF__ServiceMa__Creat__0A888742	CreatedBy	('')
2	DF__ServiceMa__Delet__0D64F3ED	DeletedBy	('')
3	DF__ServiceMa__Modif__0B7CAB7B	ModifiedDate	(getdate())
4	DF__ServiceMa__Modif__0C70CFB4	ModifiedBy	('')

Index
Table: Services

Description

Lists the basic services provided by the organization to clients.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ServiceID	INT	N
2	ServiceName	VARCHAR(50)	N
3	IsGroup	BIT	N
4	DiscontinuedDate	SMALLDATETIME	Y
5	CreatedDate	SMALLDATETIME	N
6	CreatedBy	VARCHAR(50)	N
7	ModifiedDate	SMALLDATETIME	N
8	ModifiedBy	VARCHAR(50)	N
9	DeletedDate	SMALLDATETIME	Y
10	DeletedBy	VARCHAR(50)	N
11	IsFamily	BIT	N
12	ByPhone	BIT	N
13	InPerson	BIT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Services_ServiceID	Clustered	ServiceID (Primary Key)
2	UQ__Services__A42B5F995614BF03	Nonclustered	ServiceName

Default Constraints

Sr.	Name	Column	Value
1	DF__Services__ByPhon__78DED853	ByPhone	((0))
2	DF__Services__Create__58F12BAE	CreatedBy	('')
3	DF__Services__Delete__5BCD9859	DeletedBy	('')
4	DF__Services__InPers__79D2FC8C	InPerson	((0))
5	DF__Services__IsFami__3DF31CAF	IsFamily	((0))
6	DF__Services__IsGrou__57FD0775	IsGroup	((0))
7	DF__Services__Modifi__59E54FE7	ModifiedDate	(getdate())
8	DF__Services__Modifi__5AD97420	ModifiedBy	('')

Index
Table: SessionNotes

Description

Contains notes associated with client service sessions.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	SessionID	INT	N
2	StartTime	VARCHAR(15)	N
3	EndTime	VARCHAR(15)	N
4	Note	VARCHAR(4000)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_SessionNotes_SessionID	Clustered	SessionID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Sessions_SessionNotes_SessionID	SessionID	[Sessions].[SessionID]

Default Constraints

Sr.	Name	Column	Value
1	DF__SessionNo__EndTi__2097C3F2	EndTime	('')
2	DF__SessionNo__Start__1FA39FB9	StartTime	('')

Index
Table: Sessions

Description

Contains records of service sessions provided to clients.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	SessionID	INT	N
2	ProgramID	INT	N
3	ServiceID	INT	N
4	FocusID	INT	N
5	SessionHours	FLOAT	N
6	NumberStaff	INT	N
7	CreatedDate	SMALLDATETIME	N
8	CreatedBy	VARCHAR(50)	N
9	ModifiedDate	SMALLDATETIME	N
10	ModifiedBy	VARCHAR(50)	N
11	DeletedDate	SMALLDATETIME	Y
12	DeletedBy	VARCHAR(50)	N
13	ByPhone	BIT	N
14	LocationID	INT	N
15	SessionDate	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_Sessions_SessionID	Nonclustered	SessionID (Primary Key)
2	IDX_Sessions_ServiceID	Nonclustered	ServiceID
3	IDX_Sessions_SessionDate	Clustered	SessionDate

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Focus_Sessions_FocusID	FocusID	[Focus].[FocusID]
2	FK_Programs_Sessions_ProgramID	ProgramID	[Programs].[ProgramID]
3	FK_Services_Sessions_ServiceID	ServiceID	[Services].[ServiceID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Sessions__ByPhon__5A254709	ByPhone	((0))
2	DF__Sessions__Create__70C8B53F	CreatedBy	('')
3	DF__Sessions__Delete__73A521EA	DeletedBy	('')
4	DF__Sessions__Locati__5B196B42	LocationID	((1))
5	DF__Sessions__Modifi__71BCD978	ModifiedDate	(getdate())
6	DF__Sessions__Modifi__72B0FDB1	ModifiedBy	('')
7	DF__Sessions__Number__6FD49106	NumberStaff	((1))
8	DF_Sessions_FocusID	FocusID	((0))

Index
Table: ShelterRequests

Description

Captures the outcomes of hotline calls or walk-ins that included a request for shelter.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CallID	INT	N
2	ReasonRequestedID	INT	Y
3	RequestOutcomeID	INT	Y
4	ReasonDeniedID	INT	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_ShelterRequests_CallID	Clustered	CallID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Calls_ShelterRequests_CallID	CallID	[Calls].[CallID]
2	FK_xReasonDenied_ShelterRequests_ReasonDeniedID	ReasonDeniedID	[xReasonDenied].[ReasonDeniedID]

Check Constraints

Sr.	Name	Column	Definition
1	CK__ShelterRe__Reque__153B1FDF	RequestOutcomeID	([RequestOutcomeID]>=(1) AND [RequestOutcomeID]<=(7))

Index
Table: Shelters

Description

Contains attributes of shelters maintained by the organization.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ShelterID	INT	N
2	ShelterName	VARCHAR(100)	N
3	CampusID	INT	N
4	ShelterTypeID	INT	N
5	HousingTypeID	INT	N
6	Hotline	BIT	N
7	Residential	BIT	N
8	NonResidential	BIT	N
9	IsLicensed	BIT	N
10	IsCurrent	BIT	N
11	CreatedDate	SMALLDATETIME	N
12	CreatedBy	VARCHAR(50)	N
13	ModifiedDate	SMALLDATETIME	N
14	ModifiedBy	VARCHAR(50)	N
15	DeletedDate	SMALLDATETIME	Y
16	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Shelters_ShelterID	Clustered	ShelterID (Primary Key)
2	UQ__Shelters__3582F72E56E8E7AB	Nonclustered	ShelterName

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Campuses_Shelters_CampusID	CampusID	[Campuses].[CampusID]
2	FK_xHousingType_Shelters_HousingTypeID	HousingTypeID	[xHousingType].[HousingTypeID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Shelters__Create__607251E5	CreatedBy	('')
2	DF__Shelters__Delete__634EBE90	DeletedBy	('')
3	DF__Shelters__Hotlin__5BAD9CC8	Hotline	((0))
4	DF__Shelters__Housin__5AB9788F	HousingTypeID	((1))
5	DF__Shelters__IsCurr__5F7E2DAC	IsCurrent	((1))
6	DF__Shelters__IsLice__5E8A0973	IsLicensed	((0))
7	DF__Shelters__Modifi__6166761E	ModifiedDate	(getdate())
8	DF__Shelters__Modifi__625A9A57	ModifiedBy	('')
9	DF__Shelters__NonRes__5D95E53A	NonResidential	((0))
10	DF__Shelters__Reside__5CA1C101	Residential	((0))
11	DF__Shelters__Shelte__58D1301D	ShelterTypeID	((1))

Check Constraints

Sr.	Name	Column	Definition
1	CK__Shelters__Shelte__59C55456	ShelterTypeID	([ShelterTypeID]>=(1) AND [ShelterTypeID]<=(3))

Index
Table: Staff

Description

Captures basic staff information for each member.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	StaffID	INT	N
2	FirstName	VARCHAR(50)	N
3	MI	CHAR(1)	N
4	LastName	VARCHAR(50)	N
5	Title	VARCHAR(50)	N
6	ServiceProvider	BIT	N
7	Status	INT	N
8	CreatedDate	SMALLDATETIME	N
9	CreatedBy	VARCHAR(50)	N
10	ModifiedDate	SMALLDATETIME	N
11	ModifiedBy	VARCHAR(50)	N
12	DeletedDate	SMALLDATETIME	Y
13	DeletedBy	VARCHAR(50)	N
14	DateLeft	DATE	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Staff_StaffID	Clustered	StaffID (Primary Key)

Default Constraints

Sr.	Name	Column	Value
1	DF__Staff__CreatedBy__2334397B	CreatedBy	('')
2	DF__Staff__DeletedBy__2610A626	DeletedBy	('')
3	DF__Staff__FirstName__1D7B6025	FirstName	('')
4	DF__Staff__MI__1E6F845E	MI	('')
5	DF__Staff__ModifiedB__251C81ED	ModifiedBy	('')
6	DF__Staff__ModifiedD__24285DB4	ModifiedDate	(getdate())
7	DF__Staff__ServicePr__2057CCD0	ServiceProvider	((0))
8	DF__Staff__Status__214BF109	Status	((0))
9	DF__Staff__Title__1F63A897	Title	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__Staff__Status__22401542	Status	([Status]>=(0) AND [Status]<=(2))

Index
Table: StaffCallService

Description

Intersection table relating staff members who provided services via hotline to the call records.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	SessionID	INT	N
2	StaffID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_StaffCallService	Clustered	SessionID (Primary Key) StaffID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_CallServices_StaffCallService_SessionID	SessionID	[CallServices].[SessionID]
2	FK_Staff_StaffCallService_StaffID	StaffID	[Staff].[StaffID]

Index
Table: StaffExt

Description

Contains additional staff information which may be confidential.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	StaffID	INT	N
2	Address	VARCHAR(100)	N
3	City	VARCHAR(50)	N
4	State	VARCHAR(50)	N
5	Zip	VARCHAR(10)	N
6	WorkPhone	VARCHAR(50)	N
7	Ext	VARCHAR(10)	N
8	MobilePhone	VARCHAR(50)	N
9	HomePhone	VARCHAR(50)	N
10	Email	VARCHAR(100)	N
11	DOB	SMALLDATETIME	Y
12	HireDate	SMALLDATETIME	Y
13	LastEvalDate	SMALLDATETIME	Y
14	CreatedDate	SMALLDATETIME	N
15	CreatedBy	VARCHAR(50)	N
16	ModifiedDate	SMALLDATETIME	N
17	ModifiedBy	VARCHAR(50)	N
18	Rehire	BIT	N
19	RehireComment	VARCHAR(100)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_StaffExt_StaffID	Clustered	StaffID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Staff_StaffExt_StaffID	StaffID	[Staff].[StaffID]

Default Constraints

Sr.	Name	Column	Value
1	DF__StaffExt__Addres__28ED12D1	Address	('')
2	DF__StaffExt__City__29E1370A	City	('')
3	DF__StaffExt__Create__318258D2	CreatedBy	('')
4	DF__StaffExt__Email__308E3499	Email	('')
5	DF__StaffExt__Ext__2DB1C7EE	Ext	('')
6	DF__StaffExt__HomePh__2F9A1060	HomePhone	('')
7	DF__StaffExt__Mobile__2EA5EC27	MobilePhone	('')
8	DF__StaffExt__Modifi__32767D0B	ModifiedDate	(getdate())
9	DF__StaffExt__Modifi__336AA144	ModifiedBy	('')
10	DF__StaffExt__Rehire__26A5A303	Rehire	((1))
11	DF__StaffExt__Rehire__2799C73C	RehireComment	('')
12	DF__StaffExt__State__2AD55B43	State	('')
13	DF__StaffExt__WorkPh__2CBDA3B5	WorkPhone	('')
14	DF__StaffExt__Zip__2BC97F7C	Zip	('')

Index
Table: StaffPresentations

Description

Intersection table of presentation records with staff that made the presentations.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	StaffID	INT	N
2	PresentationID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_StaffPresentations	Clustered	StaffID (Primary Key) PresentationID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Presentations_StaffPresentations_PresentationID	PresentationID	[Presentations].[PresentationID]
2	FK_Staff_StaffPresentations_StaffID	StaffID	[Staff].[StaffID]

Index
Table: StaffReferrals

Description

Intersection table of referral records with staff that made the referrals.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReferralID	INT	N
2	StaffID	INT	N
3	DeletedDate	SMALLDATETIME	Y
4	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_StaffReferrals	Clustered	ReferralID (Primary Key) StaffID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Sessions_StaffReferrals_ReferralID	ReferralID	[Referrals].[ReferralID]
2	FK_Staff_StaffReferrals_StaffID	StaffID	[Staff].[StaffID]

Default Constraints

Sr.	Name	Column	Value
1	DF__StaffRefe__Delet__4EDDB18F	DeletedBy	('')

Index
Table: StaffRequirements

Description

Intersection table connecting staff members to requirements in the Credentials table.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	StaffID	INT	N
2	RequirementID	INT	N
3	DueDate	DATE	Y
4	CompletedDate	DATE	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_StaffCredentials	Clustered	StaffID (Primary Key) RequirementID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Credentials_StaffRequirements_RequirementID	RequirementID	[Credentials].[CredentialID]
2	FK_Staff_StaffRequirements_StaffID	StaffID	[Staff].[StaffID]

Index
Table: StaffSessions

Description

Intersection table of staff providing the service to the Sessions table.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	SessionID	INT	N
2	StaffID	INT	N
3	DeletedDate	SMALLDATETIME	Y
4	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_StaffSessions	Clustered	SessionID (Primary Key) StaffID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Sessions_StaffSessions_SessionID	SessionID	[Sessions].[SessionID]
2	FK_Staff_StaffSessions_StaffID	StaffID	[Staff].[StaffID]

Default Constraints

Sr.	Name	Column	Value
1	DF__StaffSess__Delet__795DFB40	DeletedBy	('')

Index
Table: StaffTraining

Description

Intersection table of staff members attending the associated training event.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	StaffID	INT	N
2	SessionID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_StaffTraining	Clustered	StaffID (Primary Key) SessionID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Staff_StaffTraining_StaffID	StaffID	[Staff].[StaffID]
2	FK_TrainingSessions_StaffTraining_SessionID	SessionID	[TrainingSessions].[SessionID]

Index
Table: SurveyNarratives

Description

Lists narrative items associated with related surveys.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	NarrativeID	INT	N
2	SurveyID	INT	N
3	Description	VARCHAR(500)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_SurveyNarratives_NarrativeID	Nonclustered	NarrativeID (Primary Key)
2	IDX_SurveyNarratives_SurveyID	Clustered	SurveyID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Surveys_SurveyNarratives_SurveyID	SurveyID	[Surveys].[SurveyID]

Index
Table: SurveyQuestions

Description

Captures questions to be used with related surveys.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	QuestionID	INT	N
2	SurveyID	INT	N
3	QuestionNumber	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_SurveyQuestions_SurveyID_QuestionID	Clustered	QuestionID (Primary Key) SurveyID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Questions_SurveyQuestions_QuestionID	QuestionID	[Questions].[QuestionID]
2	FK_Surveys_SurveyQuestions_SurveyID	SurveyID	[Surveys].[SurveyID]

Default Constraints

Sr.	Name	Column	Value
1	DF__SurveyQue__Quest__347EC10E	QuestionNumber	((0))

Index
Table: Surveys

Description

Parent table for surveys, related to SurveyQuestions and SurveyNarratives.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	SurveyID	INT	N
2	SurveyName	VARCHAR(50)	N
3	Frequency	INT	N
4	IsAnonymous	BIT	N
5	IsCurrent	BIT	N
6	CreatedDate	SMALLDATETIME	N
7	CreatedBy	VARCHAR(50)	N
8	ModifiedDate	SMALLDATETIME	N
9	ModifiedBy	VARCHAR(50)	N
10	DeletedDate	SMALLDATETIME	Y
11	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Surveys_SurveyID	Clustered	SurveyID (Primary Key)
2	UQ__Surveys__A80131151411F17C	Nonclustered	SurveyName

Default Constraints

Sr.	Name	Column	Value
1	DF__Surveys__Created__18D6A699	CreatedBy	('')
2	DF__Surveys__Deleted__1BB31344	DeletedBy	('')
3	DF__Surveys__Frequen__15FA39EE	Frequency	((0))
4	DF__Surveys__IsAnony__16EE5E27	IsAnonymous	((1))
5	DF__Surveys__IsCurre__17E28260	IsCurrent	((1))
6	DF__Surveys__Modifie__19CACAD2	ModifiedDate	(getdate())
7	DF__Surveys__Modifie__1ABEEF0B	ModifiedBy	('')

Index
Table: TANF

Description

Contains the information to compute TANF eligibility requirements.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	LockID	INT	N
2	BaseLevel	INT	N
3	Increment	INT	N
4	PercentFPL	INT	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_TANF	Clustered	LockID (Primary Key)

Default Constraints

Sr.	Name	Column	Value
1	DF__TANF__ModifiedBy__642DD430	ModifiedBy	('')
2	DF__TANF__ModifiedDa__6339AFF7	ModifiedDate	(getdate())

Check Constraints

Sr.	Name	Column	Definition
1	CK__TANF__LockID__62458BBE	LockID	([LockID]=(1))

Index
Table: TangibleGoods

Description

Lists types of tangible goods that may be distributed to shelter clients in a service session.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	GoodTypeID	INT	N
2	SessionID	INT	N
3	Quantity	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	IDX_TangibleGoods_SessionID	Clustered	SessionID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Sessions_TangibleGoods_SessionID	SessionID	[Sessions].[SessionID]
2	FK_xGoodType_TangibleGoods_GoodTypeID	GoodTypeID	[xGoodType].[GoodTypeID]

Index
Table: Tasks

Description

Contains the tasks that may be assigned to participants during an intake.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TaskID	INT	N
2	Task	VARCHAR(100)	N
3	IntakeTypeID	INT	N
4	DaysToComplete	INT	N
5	IsCurrent	BIT	N
6	CreatedDate	SMALLDATETIME	N
7	CreatedBy	VARCHAR(50)	N
8	ModifiedDate	SMALLDATETIME	N
9	ModifiedBy	VARCHAR(50)	N
10	DeletedDate	SMALLDATETIME	Y
11	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Tasks_TaskID	Clustered	TaskID (Primary Key)
2	UQ__Tasks__8230764B2E46C4CB	Nonclustered	Task

Default Constraints

Sr.	Name	Column	Value
1	DF__Tasks__CreatedBy__31233176	CreatedBy	('')
2	DF__Tasks__DeletedBy__33FF9E21	DeletedBy	('')
3	DF__Tasks__IsCurrent__302F0D3D	IsCurrent	((0))
4	DF__Tasks__ModifiedB__330B79E8	ModifiedBy	('')
5	DF__Tasks__ModifiedD__321755AF	ModifiedDate	(getdate())

Index
Table: TrainingSessions

Description

Intersection table relating staff training sessions to the type of training conducted.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	SessionID	INT	N
2	SubjectID	INT	N
3	SessionHours	FLOAT	N
4	PrepHours	FLOAT	Y
5	OnSite	BIT	N
6	SessionNote	VARCHAR(255)	N
7	CreatedDate	SMALLDATETIME	N
8	CreatedBy	VARCHAR(50)	N
9	ModifiedDate	SMALLDATETIME	N
10	ModifiedBy	VARCHAR(50)	N
11	DeletedDate	SMALLDATETIME	Y
12	DeletedBy	VARCHAR(50)	N
13	Facilitators	VARCHAR(255)	N
14	SessionDate	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKN_TrainingSessions_SessionID	Nonclustered	SessionID (Primary Key)
2	IDX_TrainingSessions_SessionDate	Clustered	SessionDate
3	IDX_TrainingSessions_SubjectID	Nonclustered	SubjectID

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Credentials_CredentialID_TrainingSessions_SubjectID	SubjectID	[Credentials].[CredentialID]

Default Constraints

Sr.	Name	Column	Value
1	DF__TrainingS__Creat__6319B466	CreatedBy	('')
2	DF__TrainingS__Delet__65F62111	DeletedBy	('')
3	DF__TrainingS__Facil__60D24498	Facilitators	('')
4	DF__TrainingS__Modif__640DD89F	ModifiedDate	(getdate())
5	DF__TrainingS__Modif__6501FCD8	ModifiedBy	('')
6	DF__TrainingS__OnSit__61316BF4	OnSite	((0))
7	DF__TrainingS__Sessi__6225902D	SessionNote	('')

Index
Table: TribalAffiliation

Description

Intersection table linking clients to their associated Native American tribe, if any.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ClientID	INT	N
2	ClientTypeID	INT	N
3	TribeID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_TribalAffiliation	Clustered	ClientID (Primary Key) ClientTypeID (Primary Key) TribeID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_xTribe_TribalAffiliation_TribeID	TribeID	[xTribe].[TribeID]

Check Constraints

Sr.	Name	Column	Definition
1	CK__TribalAff__Clien__1B33F057	ClientTypeID	([ClientTypeID]>=(1) AND [ClientTypeID]<=(4))

Index
Table: Trips

Description

Captures data about trips associated with service sessions.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TripID	INT	N
2	Destination	VARCHAR(100)	N
3	OneWay	BIT	N
4	MilesOneWay	FLOAT	N
5	DestinationCountyID	INT	N
6	VehicleID	INT	Y
7	PurposeID	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Trips_TripID	Clustered	TripID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_Sessions_Trips_SessionID	TripID	[Sessions].[SessionID]
2	FK_xCounty_Trips_DestinationCountyID	DestinationCountyID	[xCounty].[CountyID]
3	FK_xTripPurpose_Trips_PurposeID	PurposeID	[xTripPurpose].[PurposeID]

Default Constraints

Sr.	Name	Column	Value
1	DF__Trips__Destinati__0B9CA70C	Destination	('')
2	DF__Trips__Destinati__0D84EF7E	DestinationCountyID	((1))
3	DF__Trips__OneWay__0C90CB45	OneWay	((0))
4	DF__Trips__PurposeID__66361833	PurposeID	((1))

Index
Table: Vehicles

Description

Lists vehicles that may be used for client transport.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	VehicleID	INT	N
2	Vehicle	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_Vehicles_VechileID	Clustered	VehicleID (Primary Key)
2	UQ__Vehicles__30B7149C0307610B	Nonclustered	Vehicle

Default Constraints

Sr.	Name	Column	Value
1	DF__Vehicles__Create__04EFA97D	CreatedBy	('')
2	DF__Vehicles__Delete__07CC1628	DeletedBy	('')
3	DF__Vehicles__Modifi__05E3CDB6	ModifiedDate	(getdate())
4	DF__Vehicles__Modifi__06D7F1EF	ModifiedBy	('')

Index
Table: VolunteerActivities

Description

Captures data for activities performed by volunteers.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ActivityID	INT	N
2	Activity	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N
9	OneTimeVolunteers	INT	N
10	OneTimeHours	FLOAT	N
11	ActivityDate	DATE	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_VolunteerHours_ActivityID	Nonclustered	ActivityID (Primary Key)
2	IDX_VolunteerActivities_ActivityDate	Clustered	ActivityDate

Default Constraints

Sr.	Name	Column	Value
1	DF__Volunteer__Activ__373B3228	Activity	('')
2	DF__Volunteer__Creat__382F5661	CreatedBy	('')
3	DF__Volunteer__Delet__3B0BC30C	DeletedBy	('')
4	DF__Volunteer__Modif__39237A9A	ModifiedDate	(getdate())
5	DF__Volunteer__Modif__3A179ED3	ModifiedBy	('')
6	DF__Volunteer__OneTi__288DEB75	OneTimeVolunteers	((0))
7	DF__Volunteer__OneTi__29820FAE	OneTimeHours	((0))

Index
Table: VolunteerActivity

Description

Intersection table linking staff to VolunteerActivities.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ActivityID	INT	N
2	StaffID	INT	N
3	Hours	FLOAT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_VolunteerActivity_ActivityID_StaffID	Clustered	ActivityID (Primary Key) StaffID (Primary Key)

Foreign Keys

Sr.	Name	Column	Reference To
1	FK_VolunteerActivity_ActivityID	ActivityID	[VolunteerActivities].[ActivityID]
2	FK_VolunteerActivity_StaffID	StaffID	[Staff].[StaffID]

Index
Table: xAbuserRelationship

Description

List of types of relationships applicable to abusers; may be augmented by users.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	AbuserRelationshipID	INT	N
2	AbuserRelationship	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xAbuserRelationship_AbuserRelationshipID	Clustered	AbuserRelationshipID (Primary Key)
2	UQ__xAbuserR__3266098A00551192	Nonclustered	AbuserRelationship

Default Constraints

Sr.	Name	Column	Value
1	DF__xAbuserRe__Creat__023D5A04	CreatedBy	('')
2	DF__xAbuserRe__Delet__0519C6AF	DeletedBy	('')
3	DF__xAbuserRe__Modif__03317E3D	ModifiedDate	(getdate())
4	DF__xAbuserRe__Modif__0425A276	ModifiedBy	('')

Index
Table: xCallSubject

Description

List of subjects associated with hotline calls; may be augmented by users. Subset of records is used for types of victimization.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CallSubjectID	INT	N
2	CallSubject	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xCallSubject_CallSubjectID	Clustered	CallSubjectID (Primary Key)
2	UQ__xCallSub__730964A008EA5793	Nonclustered	CallSubject

Default Constraints

Sr.	Name	Column	Value
1	DF__xCallSubj__Creat__0AD2A005	CreatedBy	('')
2	DF__xCallSubj__Delet__0DAF0CB0	DeletedBy	('')
3	DF__xCallSubj__Modif__0BC6C43E	ModifiedDate	(getdate())
4	DF__xCallSubj__Modif__0CBAE877	ModifiedBy	('')

Index
Table: xCallType

Description

Fixed list of types of hotline calls.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CallTypeID	INT	N
2	CallType	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xCallType_CallTypeID	Clustered	CallTypeID (Primary Key)
2	UQ__xCallTyp__B409CF1B5EBF139D	Nonclustered	CallType

Index
Table: xCitizenship

Description

Fixed list of citizenship status associated with participant intakes.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CitizenshipID	INT	N
2	Citizenship	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xCitizenship_CitizenshipID	Clustered	CitizenshipID (Primary Key)
2	UQ__xCitizen__5E2D06BF6383C8BA	Nonclustered	Citizenship

Index
Table: xClientType

Description

Fixed list of types of clients, e.g, participants, children....

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ClientTypeID	INT	N
2	ClientType	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xClientType_ClientTypeID	Clustered	ClientTypeID (Primary Key)
2	UQ__xClientT__D4A7D28A68487DD7	Nonclustered	ClientType

Index
Table: xCounselingResult

Description

Fixed list of results of abuser counseling.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CounselingResultID	INT	N
2	CounselingResult	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xCounselingResult_CounselingResultID	Clustered	CounselingResultID (Primary Key)
2	UQ__xCounsel__F18374206D0D32F4	Nonclustered	CounselingResult

Index
Table: xCounselingStatus

Description

Fixed list of abuser counseling status.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CounselingStatusID	INT	N
2	CounselingStatus	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xCounselingStatus_CounselingStatusID	Clustered	CounselingStatusID (Primary Key)
2	UQ__xCounsel__8D5BCAA071D1E811	Nonclustered	CounselingStatus

Index
Table: xCounty

Description

Fixed list of state couties.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CountyID	INT	N
2	County	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xCounty_CountyID	Clustered	CountyID (Primary Key)
2	UQ__xCounty__1B948F0E76969D2E	Nonclustered	County

Index
Table: xCourtOutcome

Description

Fixed list of court outcomes applicable to participant intakes.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	CourtOutcomeID	INT	N
2	CourtOutcome	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xCourtOutcome_CourtOutcomeID	Clustered	CourtOutcomeID (Primary Key)
2	UQ__xCourtOu__145F800B7B5B524B	Nonclustered	CourtOutcome

Index
Table: xEmployment

Description

Fixed list of employment status of participants at intake.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	EmploymentID	INT	N
2	Employment	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xEmployment_EmploymentID	Clustered	EmploymentID (Primary Key)
2	UQ__xEmploym__DEB7785700200768	Nonclustered	Employment

Index
Table: xEthnicity

Description

List of census ethnicites; can be augmented by users.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	EthnicityID	INT	N
2	Ethnicity	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xEthnicity_EthnicityID	Clustered	EthnicityID (Primary Key)
2	UQ__xEthnici__AC353395117F9D94	Nonclustered	Ethnicity

Default Constraints

Sr.	Name	Column	Value
1	DF__xEthnicit__Creat__1367E606	CreatedBy	('')
2	DF__xEthnicit__Delet__164452B1	DeletedBy	('')
3	DF__xEthnicit__Modif__145C0A3F	ModifiedDate	(getdate())
4	DF__xEthnicit__Modif__15502E78	ModifiedBy	('')

Index
Table: xExitDestination

Description

List of participants destinations after exiting shelter; can be augmented by users.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ExitDestinationID	INT	N
2	ExitDestination	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xExitDestination_ExitDestinationID	Clustered	ExitDestinationID (Primary Key)
2	UQ__xExitDes__CDE7D8431A14E395	Nonclustered	ExitDestination

Default Constraints

Sr.	Name	Column	Value
1	DF__xExitDest__Creat__1BFD2C07	CreatedBy	('')
2	DF__xExitDest__Delet__1ED998B2	DeletedBy	('')
3	DF__xExitDest__Modif__1CF15040	ModifiedDate	(getdate())
4	DF__xExitDest__Modif__1DE57479	ModifiedBy	('')

Index
Table: xExitHousing

Description

List of types of housing to which participants moved after exiting shelter; can be augmented by users.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ExitHousingID	INT	N
2	ExitHousing	VARCHAR(60)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N
9	DisplayOrder	INT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xExitHousing_ExitHousingID	Clustered	ExitHousingID (Primary Key)
2	UQ__xExitHou__F54B146F22AA2996	Nonclustered	ExitHousing

Default Constraints

Sr.	Name	Column	Value
1	DF__xExitHous__Creat__24927208	CreatedBy	('')
2	DF__xExitHous__Delet__276EDEB3	DeletedBy	('')
3	DF__xExitHous__Displ__03C67B1A	DisplayOrder	((0))
4	DF__xExitHous__Modif__25869641	ModifiedDate	(getdate())
5	DF__xExitHous__Modif__267ABA7A	ModifiedBy	('')

Index
Table: xExitReason

Description

List of reasons participant exited an intake; can be augmented by users.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ExitReasonID	INT	N
2	ExitReason	VARCHAR(60)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xExitReason_ExitReasonID	Clustered	ExitReasonID (Primary Key)
2	UQ__xExitRea__D929B58B2B3F6F97	Nonclustered	ExitReason

Default Constraints

Sr.	Name	Column	Value
1	DF__xExitReas__Creat__2D27B809	CreatedBy	('')
2	DF__xExitReas__Delet__300424B4	DeletedBy	('')
3	DF__xExitReas__Modif__2E1BDC42	ModifiedDate	(getdate())
4	DF__xExitReas__Modif__2F10007B	ModifiedBy	('')

Index
Table: xGoodType

Description

List of types of tangible goods that may be provided during service sessions.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	GoodTypeID	INT	N
2	GoodType	VARCHAR(100)	N
3	IsCurrent	BIT	N
4	CreatedDate	SMALLDATETIME	N
5	CreatedBy	VARCHAR(50)	N
6	ModifiedDate	SMALLDATETIME	N
7	ModifiedBy	VARCHAR(50)	N
8	DeletedDate	SMALLDATETIME	Y
9	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xGoodType_GoodTypeID	Clustered	GoodTypeID (Primary Key)
2	UQ__xGoodTyp__8AD6FF8B7E97B1A9	Nonclustered	GoodType

Default Constraints

Sr.	Name	Column	Value
1	DF__xGoodType__Creat__01741E54	CreatedBy	('')
2	DF__xGoodType__Delet__04508AFF	DeletedBy	('')
3	DF__xGoodType__IsCur__007FFA1B	IsCurrent	((1))
4	DF__xGoodType__Modif__0268428D	ModifiedDate	(getdate())
5	DF__xGoodType__Modif__035C66C6	ModifiedBy	('')

Index
Table: xHotlineReferral

Description

Lists agencies to whom a hotline caller may be referred; can be augmented by users.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	HotlineReferralID	INT	N
2	HotlineReferral	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xHotlineReferral_HotlineReferralID	Clustered	HotlineReferralID (Primary Key)
2	UQ__xHotline__21C32D7633D4B598	Nonclustered	HotlineReferral

Default Constraints

Sr.	Name	Column	Value
1	DF__xHotlineR__Creat__35BCFE0A	CreatedBy	('')
2	DF__xHotlineR__Delet__38996AB5	DeletedBy	('')
3	DF__xHotlineR__Modif__36B12243	ModifiedDate	(getdate())
4	DF__xHotlineR__Modif__37A5467C	ModifiedBy	('')

Index
Table: xHousingType

Description

Fixed list of the type of housing provided by a shelter.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	HousingTypeID	INT	N
2	HousingType	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xHousingType_HousingTypeID	Clustered	HousingTypeID (Primary Key)
2	UQ__xHousing__9805189004E4BC85	Nonclustered	HousingType

Index
Table: xIntakeType

Description

Fixed list of types of participant intakes.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	IntakeTypeID	INT	N
2	IntakeType	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xIntakeType_IntakeTypeID	Clustered	IntakeTypeID (Primary Key)
2	UQ__xIntakeT__883FECDA09A971A2	Nonclustered	IntakeType

Index
Table: xLanguage

Description

User created list of primary languages spoken by participants.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	LanguageID	INT	N
2	Language	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xLanguage_LanguageID	Clustered	LanguageID (Primary Key)
2	UQ__xLanguag__C3D592502B0A656D	Nonclustered	Language

Default Constraints

Sr.	Name	Column	Value
1	DF__xLanguage__Creat__2CF2ADDF	CreatedBy	('')
2	DF__xLanguage__Delet__2FCF1A8A	DeletedBy	('')
3	DF__xLanguage__Modif__2DE6D218	ModifiedDate	(getdate())
4	DF__xLanguage__Modif__2EDAF651	ModifiedBy	('')

Index
Table: xLawEnforcementAgency

Description

User created list of law enforcement agencies associated with an intervention.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	AgencyID	INT	N
2	Agency	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xLawEnforcementAgency_AgencyID	Clustered	AgencyID (Primary Key)
2	UQ__xLawEnfo__2E2343D841AC9118	Nonclustered	Agency

Default Constraints

Sr.	Name	Column	Value
1	DF__xLawEnfor__Creat__677F4227	CreatedBy	('')
2	DF__xLawEnfor__Delet__6A5BAED2	DeletedBy	('')
3	DF__xLawEnfor__Modif__68736660	ModifiedDate	(getdate())
4	DF__xLawEnfor__Modif__69678A99	ModifiedBy	('')

Index
Table: xLocation

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	LocationID	INT	N
2	Location	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xLocation_LocationID	Clustered	LocationID (Primary Key)
2	UQ__xLocatio__E55D3B10339FAB6E	Nonclustered	Location

Default Constraints

Sr.	Name	Column	Value
1	DF__xLocation__Creat__3587F3E0	CreatedBy	('')
2	DF__xLocation__Delet__3864608B	DeletedBy	('')
3	DF__xLocation__Modif__367C1819	ModifiedDate	(getdate())
4	DF__xLocation__Modif__37703C52	ModifiedBy	('')

Index
Table: xMaritalStatus

Description

Fixed list of participant marital status.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	MaritalStatusID	INT	N
2	MaritalStatus	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xMaritalStatus_MaritalStatusID	Clustered	MaritalStatusID (Primary Key)
2	UQ__xMarital__F50186AA0E6E26BF	Nonclustered	MaritalStatus

Index
Table: xPetType

Description

User created list of pet types that may be sheltered during a participant intake.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PetTypeID	INT	N
2	PetType	VARCHAR(100)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xPetType_PetTypeID	Clustered	PetTypeID (Primary Key)
2	UQ__xPetType__42B5C798097F5470	Nonclustered	PetType

Index
Table: xPriorResidence

Description

Contains list of residence types preceding intake; may be augmented by users.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PriorResidenceID	INT	N
2	PriorResidence	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xPriorResidence_PriorResidenceID	Clustered	PriorResidenceID (Primary Key)
2	UQ__xPriorRe__F11629335629CD9C	Nonclustered	PriorResidence

Default Constraints

Sr.	Name	Column	Value
1	DF__xPriorRes__Creat__5812160E	CreatedBy	('')
2	DF__xPriorRes__Delet__5AEE82B9	DeletedBy	('')
3	DF__xPriorRes__Modif__59063A47	ModifiedDate	(getdate())
4	DF__xPriorRes__Modif__59FA5E80	ModifiedBy	('')

Index
Table: xReasonDenied

Description

Contains list of reasons a shelter request was denied which can be augmented by users.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReasonDeniedID	INT	N
2	ReasonDenied	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xReasonDenied_ReasonDeniedID	Clustered	ReasonDeniedID (Primary Key)
2	UQ__xReasonD__A52F09253C69FB99	Nonclustered	ReasonDenied

Default Constraints

Sr.	Name	Column	Value
1	DF__xReasonDe__Creat__3E52440B	CreatedBy	('')
2	DF__xReasonDe__Delet__412EB0B6	DeletedBy	('')
3	DF__xReasonDe__Modif__3F466844	ModifiedDate	(getdate())
4	DF__xReasonDe__Modif__403A8C7D	ModifiedBy	('')

Index
Table: xReferralSource

Description

Contains basic list of referral sources for shelter services that can be augmented by users.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReferralSourceID	INT	N
2	ReferralSource	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xReferralSource_ReferralSourceID	Clustered	ReferralSourceID (Primary Key)
2	UQ__xReferra__89BDCB7344FF419A	Nonclustered	ReferralSource

Default Constraints

Sr.	Name	Column	Value
1	DF__xReferral__Creat__46E78A0C	CreatedBy	('')
2	DF__xReferral__Delet__49C3F6B7	DeletedBy	('')
3	DF__xReferral__Modif__47DBAE45	ModifiedDate	(getdate())
4	DF__xReferral__Modif__48CFD27E	ModifiedBy	('')

Index
Table: xReferralType

Description

Contains reportable referral types as well as user created entries.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReferralTypeID	INT	N
2	ReferralType	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xReferralType_ReferralTypeID	Clustered	ReferralTypeID (Primary Key)
2	UQ__xReferra__4CAA4DF94D94879B	Nonclustered	ReferralType

Default Constraints

Sr.	Name	Column	Value
1	DF__xReferral__Creat__4F7CD00D	CreatedBy	('')
2	DF__xReferral__Delet__52593CB8	DeletedBy	('')
3	DF__xReferral__Modif__5070F446	ModifiedDate	(getdate())
4	DF__xReferral__Modif__5165187F	ModifiedBy	('')

Index
Table: xReligion

Description

User created list of participant religion during an intake.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReligionID	INT	N
2	Religion	VARCHAR(100)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xReligion_ReligionID	Clustered	ReligionID (Primary Key)
2	UQ__xReligio__777477CF68536ACF	Nonclustered	Religion

Default Constraints

Sr.	Name	Column	Value
1	DF__xReligion__Creat__6A3BB341	CreatedBy	('')
2	DF__xReligion__Delet__6D181FEC	DeletedBy	('')
3	DF__xReligion__Modif__6B2FD77A	ModifiedDate	(getdate())
4	DF__xReligion__Modif__6C23FBB3	ModifiedBy	('')

Index
Table: xRequestOutcome

Description

Fixed list of outcomes of requests for shelter.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	RequestOutcomeID	INT	N
2	RequestOutcome	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xRequestOutcome	Clustered	RequestOutcomeID (Primary Key)
2	UQ__xRequest__21DD4C231332DBDC	Nonclustered	RequestOutcome

Index
Table: xReservation

Description

Fixed list of Native American Reservations in the state.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReservationID	INT	N
2	Reservation	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xReservation_ReservationID	Clustered	ReservationID (Primary Key)
2	UQ__xReserva__5C236C9317F790F9	Nonclustered	Reservation

Index
Table: xReturnStatus

Description

Fixed list of return status types applicable to participants.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ReturnStatusID	INT	N
2	ReturnStatus	VARCHAR(100)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xReturnStatus_ReturnStatusID	Clustered	ReturnStatusID (Primary Key)
2	UQ__xReturnS__31E0930B1CBC4616	Nonclustered	ReturnStatus

Index
Table: xServiceLocation

Description

User created list of locations that may be associated with service sessions.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	LocationID	INT	N
2	Location	VARCHAR(50)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xServiceLocation_LocationID	Clustered	LocationID (Primary Key)
2	UQ__xService__E55D3B1088E749A7	Nonclustered	Location

Default Constraints

Sr.	Name	Column	Value
1	DF__xServiceL__Creat__5654B625	CreatedBy	('')
2	DF__xServiceL__Delet__593122D0	DeletedBy	('')
3	DF__xServiceL__Modif__5748DA5E	ModifiedDate	(getdate())
4	DF__xServiceL__Modif__583CFE97	ModifiedBy	('')

Index
Table: xShelterType

Description

Fixed list of types of shelter that may be in the organization.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	ShelterTypeID	INT	N
2	ShelterType	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xShelterType_ShelterTypeID	Clustered	ShelterTypeID (Primary Key)
2	UQ__xShelter__9D60E2AD2180FB33	Nonclustered	ShelterType

Index
Table: xSubstanceProblem

Description

Fixed list of substance abuse and treatment types.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	SubstanceProblemID	INT	N
2	SubstanceProblem	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xSubstanceProblem_SubstanceProblemID	Clustered	SubstanceProblemID (Primary Key)
2	UQ__xSubstan__6EEB6B2A2645B050	Nonclustered	SubstanceProblem

Index
Table: xTask

Description

User created list of tasks that may be assigned to participants during an intake.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TaskID	INT	N
2	Task	VARCHAR(100)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xTask_TaskID	Clustered	TaskID (Primary Key)
2	UQ__xTask__8230764B3A5795F5	Nonclustered	Task

Default Constraints

Sr.	Name	Column	Value
1	DF__xTask__CreatedBy__3C3FDE67	CreatedBy	('')
2	DF__xTask__DeletedBy__3F1C4B12	DeletedBy	('')
3	DF__xTask__ModifiedB__3E2826D9	ModifiedBy	('')
4	DF__xTask__ModifiedD__3D3402A0	ModifiedDate	(getdate())

Index
Table: xTopic

Description

User created list of topics for staff presentations.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TopicID	INT	N
2	Topic	VARCHAR(100)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N
9	IsCurrent	BIT	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xTopic_TopicID	Clustered	TopicID (Primary Key)
2	UQ__xTopic__1CC389DF44CA3770	Nonclustered	Topic

Default Constraints

Sr.	Name	Column	Value
1	DF__xTopic__CreatedB__46B27FE2	CreatedBy	('')
2	DF__xTopic__DeletedB__498EEC8D	DeletedBy	('')
3	DF__xTopic__IsCurren__1C9228E4	IsCurrent	((1))
4	DF__xTopic__Modified__47A6A41B	ModifiedDate	(getdate())
5	DF__xTopic__Modified__489AC854	ModifiedBy	('')

Index
Table: xTribe

Description

User created list of Native American tribes served by the organization.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	TribeID	INT	N
2	Tribe	VARCHAR(100)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xTribalAffiliation_TribeID	Clustered	TribeID (Primary Key)
2	UQ__xTribe__EC1F6E2C3C34F16F	Nonclustered	Tribe

Default Constraints

Sr.	Name	Column	Value
1	DF__xTribe__CreatedB__3E1D39E1	CreatedBy	('')
2	DF__xTribe__DeletedB__40F9A68C	DeletedBy	('')
3	DF__xTribe__Modified__3F115E1A	ModifiedDate	(getdate())
4	DF__xTribe__Modified__40058253	ModifiedBy	('')

Index
Table: xTripPurpose

Description

User created list of purposes of trips provided by service sessions.

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	PurposeID	INT	N
2	Purpose	VARCHAR(100)	N
3	CreatedDate	SMALLDATETIME	N
4	CreatedBy	VARCHAR(50)	N
5	ModifiedDate	SMALLDATETIME	N
6	ModifiedBy	VARCHAR(50)	N
7	DeletedDate	SMALLDATETIME	Y
8	DeletedBy	VARCHAR(50)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_xTripPurpose_PurposeID	Clustered	PurposeID (Primary Key)
2	UQ__xTripPur__6EA87AE8607D3EDD	Nonclustered	Purpose

Default Constraints

Sr.	Name	Column	Value
1	DF__xTripPurp__Creat__6265874F	CreatedBy	('')
2	DF__xTripPurp__Delet__6541F3FA	DeletedBy	('')
3	DF__xTripPurp__Modif__6359AB88	ModifiedDate	(getdate())
4	DF__xTripPurp__Modif__644DCFC1	ModifiedBy	('')

Index
Table: zShelterData

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	Item	VARCHAR(50)	N
2	ItemValue	VARCHAR(100)	N

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PKC_zShelterData_Key	Clustered	Item (Primary Key)

Default Constraints

Sr.	Name	Column	Value
1	DF__zShelterD__ItemV__54EB90A0	ItemValue	('')

Index
Table: zsSettings

Description

Table Columns

Sr.	Name	Datatype	Nullable	Description
1	LockID	INT	N
2	BackupDate	SMALLDATETIME	Y
3	BackupPath	VARCHAR(500)	N
4	TempPath	VARCHAR(500)	N
5	BackupFrequency	INT	N
6	BackupAutomatic	BIT	N
7	BackupOnServer	BIT	N
8	MaxDaysToComplete	INT	N
9	MaxDaysInactive	INT	N
10	MaxDaysSinceCall	INT	N
11	LookupChange	SMALLDATETIME	N
12	CurrentVersion	VARCHAR(20)	Y
13	Revision	INT	Y

Primary Keys and Indexes

Sr.	Name	Type	Columns
1	PK_zsSettings	Clustered	LockID (Primary Key)

Default Constraints

Sr.	Name	Column	Value
1	DF__zsSetting__Backu__58BC2184	BackupPath	('')
2	DF__zsSetting__Backu__5AA469F6	BackupFrequency	((7))
3	DF__zsSetting__Backu__5B988E2F	BackupAutomatic	((1))
4	DF__zsSetting__Backu__5C8CB268	BackupOnServer	((1))
5	DF__zsSetting__MaxDa__5D80D6A1	MaxDaysToComplete	((3))
6	DF__zsSetting__MaxDa__5E74FADA	MaxDaysInactive	((90))
7	DF__zsSetting__MaxDa__5F691F13	MaxDaysSinceCall	((3))
8	DF__zsSetting__TempP__59B045BD	TempPath	('')

Check Constraints

Sr.	Name	Column	Definition
1	CK__zsSetting__LockI__57C7FD4B	LockID	([LockID]=(1))