contact
Core TablePeople & Organizations
Stores all people including employees, contractors, visitors and key contact information.
Primary Key
contact_code
Record Type
Operational
Log Tables
contact_log, contact_location_log
Summary Views
daily_contact_summary
Last Updated
May 20, 2026
AI Usefulness
4.7
/ 5.0
High value for AI analytics, prediction and automation.
All (7)Key (1)Calculated (2)
| Field Code | Caption | Data Type | Length | PK | Calculated | Description |
|---|---|---|---|---|---|---|
| contact_code | Contact Code | Varchar | 50 | — | Unique code for each contact. | |
| first_name | First Name | Varchar | 100 | — | — | First name of the contact. |
| last_name | Last Name | Varchar | 100 | — | — | Last name of the contact. |
| Varchar | 255 | — | — | Email address. | ||
| phone | Phone | Varchar | 50 | — | — | Primary phone number. |
| organization_code | Organization Code | Varchar | 50 | — | — | Organization the contact belongs to. |
| role_code | Role Code | Varchar | 50 | — | — | Role of the contact. |
Showing 7 of 7 (38 total in schema)
Relationships (Links to)
- organization N:1Contact belongs to an organization.
- role N:NContact has roles via mapping.
- task 1:NTasks assigned to a contact.
Operational Meaning
Contacts power assignment, certification, access and accountability across work orders, EHS tasks and visitor management.
AI Opportunities
- Workforce availability and skills matching
- Workload balancing across teams
- Certification expiry alerts
- Anomaly detection on access patterns
Suggested Queries
- "List all contacts with valid certifications expiring in the next 30 days."
- "Which contractors completed the most work orders last month?"
- "Show workload distribution across the HVAC trade."