Tenant Information

tblProviderTypes

ProviderTypeCode

ProviderTypeCodeDesc

tblCaseMgrCommTypes

CaseMgrCommTypeCode

CaseMgrCommTypeDesc

tblCaseManagers

CaseMgrID

ProviderID

CaseMgrName

CaseMgrTitle

CaseMgrNotes

tblCaseMgrComms

CaseMgrComms

CaseMgrID

CaseMgrCommValue

CaseMgrCommTypeCode

tblTenants

TenantID

SMCID

FirstName

LastName

ProviderID

CaseMgrID

Residence

Unit

Address

ZipCode

StatusCode

MoveInDate

tblTenantContactLogType

LogTypeCode

LogTypeDesc

tblTenantContactLog

LogRef

LogDate

TenantID

r

index w/ no duplicates

LogTypeCode

LogLength

LogSumm

LogFollowUpDate

LogFollowUpMetDate

Primary Key

Relational Field

table

tblTenantComms

TenantComms

TenantID

TenantCommValue

r

phone number or email

TenantCommTypeCode

tblTenantCommTypes

TenantCommTypeCode

TenantCommTypeDesc

tblProviders

ProviderID

ProviderName

ProviderTypeCode

ProviderAddress

ProviderZipCode

ProviderWebsite

tblProviderComms

ProviderComms

ProviderID

ProviderCommValue

r

phone number or email

ProviderCommTypeCode

tblProviderCommTypes

ProviderCommTypeCode

ProviderCommTypeDesc

tblTenantStatusList

StatusCode

StatusDesc

tblTenantUpdateTracker

TenantUpdateRef

TenantID

TenantFormTypeCode

TenantFormUpdate

TenantFormUpdateMet

tblTenantFormTypes

TenantFormTypeCode

TenantFormTypeDesc

tblMoveOuts

MoveOutRef

TenantID

MoveOutDate

MoveOutTypeCode

tblMoveOutTypes

MoveOutTypeCode

MoveOutTypeCodeDesc

tblTenantHosp

TenantHospRef

TenantID

TenantHospDate

TenantHospTypeCode

tblTenantHospType

TenantHospTypeCode

TenantHospTypeCodeDesc

tblTenantArrests

TenantArrestRef

TenantID

TenantArrestDate

TenantArrestTypeCode

tblTenantArrestType

TenantArrestTypeCode

TenantArrestTypeCodeDesc