によって Taylor Jones 10年前.
330
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.
開く
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
