TCM Access

More like this

KingNet

by Stephen Skinner

CMSA_2013

by danielle marshall

Conceps in HealthCare

by Duy Le ly

PR

by Beatrix Bencze

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