# ATM Recovery & Executive Housing Integration Map

## Purpose

This package preserves the public website while allowing records to mirror into the existing ATM Command Center using Google Sheets and Apps Script.

## Data flow

Public Website → Local Browser Save → Apps Script Web App → ATM Command Center Tabs → Owner Review Queue

## New tabs created by `setupATMRecoveryExecutiveHousingTabs()`

1. `HOUSING_INQUIRIES`  
   Short contact and partnership inquiries.

2. `HOUSING_APPLICATIONS`  
   Full housing application records.

3. `HOUSING_PROPERTIES`  
   Property / housing track inventory records. Exact addresses are internal only.

4. `OWNER_REVIEW_QUEUE`  
   Owner-facing review queue with DBA source and next-action fields.

5. `HOUSING_SYNC_LOG`  
   Sync attempts, success records, and errors.

6. `HOUSING_SETTINGS`  
   Brand settings and the legal language lock.

## Recommended fields mirrored into ATM

- Submission ID
- Source DBA: `ATM_RECOVERY_EXECUTIVE_HOUSING`
- Full name
- Phone
- Email
- Inquiry/application type
- Stay track
- Desired move-in
- Length of stay
- Budget/payment method
- Referral source
- Recovery/transition context
- Support/accessibility notes
- Owner review status
- Quote status
- Invoice status
- Document status
- Sync status
- Legal language lock

## Owner approval workflow

Recommended statuses:

- New - Owner Review Needed
- Contacted
- More Information Needed
- Fit Approved
- Quote Sent
- Deposit Pending
- Accepted / Scheduled
- Waitlist
- Declined / Not a Fit
- Closed

## Legal Language Lock

Medical-adjacent support, post-operative assistance, companion care, and concierge services. No skilled nursing unless separately licensed and contracted.