Categories: All - communications - providers - status

by Taylor Jones 10 years ago

342

TCM Access

The relational database structure focuses on managing tenant information and includes multiple tables to handle different aspects of tenant interactions. The main tables track tenant updates, basic tenant details, case manager communications, and tenant arrest records.

TCM Access

tblTenantArrestType

TenantArrestTypeCodeDesc

tblTenantArrests

TenantArrestTypeCode

TenantArrestDate

TenantArrestRef

tblTenantHospType

TenantHospTypeCodeDesc

tblTenantHosp

TenantHospTypeCode

TenantHospDate

TenantHospRef

tblMoveOutTypes

MoveOutTypeCodeDesc

tblMoveOuts

MoveOutTypeCode

MoveOutDate

MoveOutRef

tblTenantFormTypes

TenantFormTypeDesc

tblTenantUpdateTracker

TenantFormUpdateMet

TenantFormUpdate

TenantFormTypeCode

TenantUpdateRef

tblTenantStatusList

StatusDesc

tblProviderCommTypes

ProviderCommTypeDesc

tblProviderComms

ProviderCommTypeCode

ProviderCommValue

ProviderComms

tblProviders

ProviderWebsite

ProviderZipCode

ProviderAddress

ProviderName

tblTenantCommTypes

TenantCommTypeDesc

tblTenantComms

TenantCommTypeCode

TenantCommValue

phone number or email

TenantComms

table

Relational Field

Primary Key

tblTenantContactLog

LogFollowUpMetDate

LogFollowUpDate

LogSumm

LogLength

index w/ no duplicates

LogDate

LogRef

tblTenantContactLogType

LogTypeDesc

LogTypeCode

tblTenants

MoveInDate

StatusCode

ZipCode

Address

Unit

Residence

LastName

FirstName

SMCID

TenantID

tblCaseMgrComms

CaseMgrCommValue

CaseMgrComms

tblCaseManagers

CaseMgrNotes

CaseMgrTitle

CaseMgrName

ProviderID

CaseMgrID

tblCaseMgrCommTypes

CaseMgrCommTypeDesc

CaseMgrCommTypeCode

tblProviderTypes

ProviderTypeCodeDesc

ProviderTypeCode

Tenant Information