BooleanValue | Boolean Value | Boolean | | The answer to a Boolean question on record-page and claim checklists. Visit checklists save Boolean answers as text instead. |
BranchId | Branch | Lookup | | |
ChecklistTemplateId | Checklist Template | Lookup → ChecklistTemplate | | The template the answered question belongs to. Checklist screens read saved answers back by record and template. |
ChecklistTemplateLineId | Checklist Template Line | Lookup → ChecklistTemplateLine | | The question answered. Service recommendation rules are matched on this question, and checklist screens match saved answers to questions by it. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
CurrencyValue | Currency Value | Currency | | The answer to a Currency question. Starts at 0. Never read by number-bound recommendation rules. |
DataType | Data Type | Text | | The question's Data Type, copied when the answer is created. It decides which value column holds the answer. |
DateTimeValue | Date Time Value | DateAndTime | | The answer to a DateTime question. |
DateValue | Date Value | Date | | The answer to a Date question. |
DecimalValue | Decimal Value | Currency | | The answer to a Decimal question, and the reading on a health check. Starts at 0. Never read by number-bound recommendation rules. |
Email | Email | Text | | The answer to an Email question. |
Id | Id | Guid | Yes | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | | The answer's title, taken from the question. The record-page Checklist widget appends a short code so each answer's name is unique. |
NumericValue | Numeric Value | Currency | | The answer to a Numeric question. The web visit checklist also saves Decimal and Currency answers here. Number-bound service recommendation rules read only this column. Starts at 0, so 0 here is not an answer unless the question is Numeric. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
Phone | Phone | Text | | The answer to a Phone question. |
RAGValue | RAG Value | Text | | The answer to a RAG question (Red, Amber or Green), and the condition on a health check. Service recommendation rules with a RAG value compare against it. |
RecordTypeId | Record Type | Guid, hidden | | |
RelatedEntityType | Related Entity Type | Text | | The kind of record the answer belongs to, for example a visit activity, an account, a service order, a delivery order or a claim line. A visit activity can send its answers to the visit's service order or customer instead. |
RelatedGroupKey | Related Group Key | Text | | Keeps separate groups of answers on one record apart, for example when several visit activities answer onto the same service order. |
RelatedRecordId | Related Record | Lookup | | The record the answer belongs to, together with Related Entity Type. |
Remarks | Remarks | Text | | A free-text note on the answer. Written by health checks. |
ServiceRequestId | ServiceRequest | Guid | | Shown on the answer's record page but not stored. A value entered here is not saved. |
TextValue | Text Value | Text | | The answer to a Text, Picklist or Lookup question. A MultiPicklist answer is saved as one text with the choices separated by semicolons. Visit checklists also keep Boolean and RAG answers here. |
TimeValue | Time Value | TimeOnly | | The answer to a Time question. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
URL | URL | Text | | The answer to a URL question, or the reference to the photo for a Take Picture question. The picture itself is attached to the answer as a file. |
