- TMCAMS
- Associations
- Task
- Services
| Assn ID | Pix | Community | Site Address | Board Size | Board Terms | Annual Date | Notes | EIN | DocNum | Documents | NumofResUnits | NumofComUnits | NumofOwners | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Assn ID | Pix | Community | Site Address | Board Size | Board Terms | Annual Date | Notes | EIN | DocNum | Documents | NumofResUnits | NumofComUnits | NumofOwners |
| BoardID | AssocID | Name | Office | TermEnd | Phone | Notes | Certified | ||
|---|---|---|---|---|---|---|---|---|---|
| BoardID | AssocID | Name | Office | TermEnd | Phone | Notes | Certified |
| OwnID | AssnID | SiteAddress | Names | OccStatus | Pet | ParkingStall | MailingAddress | Phone | ||
|---|---|---|---|---|---|---|---|---|---|---|
| OwnID | AssnID | SiteAddress | Names | OccStatus | Pet | ParkingStall | MailingAddress | Phone |
| BudID | AssnID | Service | GL | Description | LastBudget | CurrentBudget | CPercent | CPortion | RPercent | RPortion | Variance | YTDSpent | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BudID | AssnID | Service | GL | Description | LastBudget | CurrentBudget | CPercent | CPortion | RPercent | RPortion | Variance | YTDSpent | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| ResID | AssnID | GL | Description | ReplaceCost | LifeSpan | LifeLeft | CurrentBudget | Required | |
|---|---|---|---|---|---|---|---|---|---|
| ResID | AssnID | GL | Description | ReplaceCost | LifeSpan | LifeLeft | CurrentBudget | Required |
| Bankid | AssnID | Bank1 | Account1 | AccountType1 | Balance1 | Account2 | AccountType2 | Balance2 | |
|---|---|---|---|---|---|---|---|---|---|
| Bankid | AssnID | Bank1 | Account1 | AccountType1 | Balance1 | Account2 | AccountType2 | Balance2 |
| NotesID | Community | Action | StartDate | DoneDate | Status | TimeSpent | Notes | |
|---|---|---|---|---|---|---|---|---|
| NotesID | Community | Action | StartDate | DoneDate | Status | TimeSpent | Notes |
| CAMID | Community | Service | Company | Contact | Phone | Notes | AssnID | ||
|---|---|---|---|---|---|---|---|---|---|
| CAMID | Community | Service | Company | Contact | Phone | Notes | AssnID |
| CompID | AssnID | PID | SiteAddress | DeedRestriction | Violation | Comments | Docs | Pictures | Status | Action | Inspection1 | Notice1 | Inspection2 | Notice2 | Inspection3 | BoardFine | HearingNotice | RRTrackingNum | Hearing | PaymentDue | NOLASent | NOLA30day | AttCollection | LienClaim45day | RRTrackingNum2 | Lien | Foreclose45day | RRTrackingNum3 | Foreclose | Owner1 | Owner2 | MailAddress | City | State | Postal | Country | LegalDesc | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CompID | AssnID | PID | SiteAddress | DeedRestriction | Violation | Comments | Docs | Pictures | Status | Action | Inspection1 | Notice1 | Inspection2 | Notice2 | Inspection3 | BoardFine | HearingNotice | RRTrackingNum | Hearing | PaymentDue | NOLASent | NOLA30day | AttCollection | LienClaim45day | RRTrackingNum2 | Lien | Foreclose45day | RRTrackingNum3 | Foreclose | Owner1 | Owner2 | MailAddress | City | State | Postal | Country | LegalDesc |
| ServiceID | CAMID | Date | Task | Type | Status | Notes | Time | Time Notes | StartTime | EndTime | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ServiceID | CAMID | Date | Task | Type | Status | Notes | Time | Time Notes | StartTime | EndTime |
| CAMID | Community | Service | Company | Contact | Phone | Notes | AssnID | ||
|---|---|---|---|---|---|---|---|---|---|
| CAMID | Community | Service | Company | Contact | Phone | Notes | AssnID |
| ServiceID | CAMID | Date | Task | Type | Status | Notes | Time | Time Notes | StartTime | EndTime | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ServiceID | CAMID | Date | Task | Type | Status | Notes | Time | Time Notes | StartTime | EndTime |