TCM Access

Mehr dazu

CRM order processing For DBU Order

von Nik Pais

Sonia

von Ricardo Ceja

PLE-INCA HUATUCO

von LUIS ANDRES JAHNSENS DIAZ MARTINEZ

Mindomo Huna

von Shaun Villafana

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