TCM Access

Plus de détails

Worker Autonomy

par McAllister McAllister

taylork.young@ttu.edu

par Taylor Young

CustomerExperience - Business Alignment

par Manoj Nair

Plan - 2024 March

par Korsal Chou

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