TCM Access

Plus de détails

PLE-INCA HUATUCO

par LUIS ANDRES JAHNSENS DIAZ MARTINEZ

SOP For FB Ready Pages

par Robert Grant

CustomerExperience - Business Alignment

par Manoj Nair

Comms and PR

par Nicola Gordon

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