Enquiry_Response_In_Business_Mins Tables
The enquiry_response_in_business_minutes_changelog and enquiry_response_in_business_minutes_latest tables stores the bid and authorisation response times that happened during an enquiry.
🔹 Standard Columns​
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| document_name | STRING | YES | Name of the document exported from Firestore |
| document_event_id | STRING | YES | Unique ID representing a change event in the document |
| document_timestamp | TIMESTAMP | YES | Timestamp when the document was created or updated |
| document_operation | STRING | YES | Type of operation performed on the document (e.g., INSERT, UPDATE, DELETE) |
| document_id | STRING | YES | Unique ID of the document in Firestore |
| leaseCompanyId | STRING | YES | Identifier of the lease company associated with the record |
| enquiryID | STRING | YES | ID of the enquiry linked to the service unit |
| accountID | STRING | YES | Account identifier associated with the transaction or event |
| serviceUnitID | STRING | YES | ID of the service unit involved |
| bidResponseTime | INT64 | YES | Time taken (in minutes) to respond to a bid |
| authorisationResponseTime | INT64 | YES | Time taken (in minutes) to respond to an authorisation request |