{ "fields": { "name": { "type": "varchar", "required": true, "trim": true, "maxLength": 255, "audited": false, "readOnly": false, "tooltip": false }, "description": { "type": "text" }, "createdAt": { "type": "datetime", "readOnly": true }, "modifiedAt": { "type": "datetime", "readOnly": true }, "createdBy": { "type": "link", "readOnly": true, "view": "views/fields/user" }, "modifiedBy": { "type": "link", "readOnly": true, "view": "views/fields/user" }, "assignedUser": { "type": "link", "required": false, "view": "views/fields/assigned-user", "audited": false, "readOnly": false, "tooltip": false }, "teams": { "type": "linkMultiple", "view": "views/fields/teams" }, "claimNumber": { "type": "varchar", "required": false, "audited": true, "isCustom": true, "trim": false }, "claimDateofLoss": { "notNull": false, "type": "date", "required": false, "audited": false, "isCustom": true }, "existClaim": { "type": "enum", "options": [ "new", "existing" ], "default": "new", "audited": true, "isCustom": true }, "claimInsuranceType": { "type": "enum", "required": false, "options": [ "none", "home_owners", "renters", "Condominium", "commercial" ], "default": "none", "isSorted": true, "audited": true, "isCustom": true }, "claimInsuranceCompany": { "type": "varchar", "required": false, "trim": true, "maxLength": 255, "audited": false, "isCustom": true, "readOnly": false, "tooltip": false }, "claimPolicyNumber": { "type": "varchar", "required": false, "trim": true, "maxLength": 255, "audited": false, "isCustom": true }, "limits": { "type": "varchar", "required": false, "trim": true, "maxLength": 255, "audited": false, "isCustom": true }, "claimInsuranceCompanyPhone": { "type": "varchar", "required": false, "trim": true, "maxLength": 25, "audited": false, "isCustom": true }, "claimInsuranceCompanyFax": { "type": "varchar", "required": false, "trim": true, "maxLength": 25, "audited": false, "isCustom": true }, "claimInsuranceCompanyEmail": { "type": "varchar", "required": false, "trim": true, "maxLength": 255, "audited": false, "isCustom": true }, "claimEngagement": { "type": "enum", "required": false, "options": [ "no", "yes", "send_now" ], "isSorted": false, "audited": false, "isCustom": true, "default": "no", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "PA" } ], "readOnly": false, "tooltip": false }, "claimLEOSent": { "notNull": false, "type": "date", "required": false, "audited": false, "isCustom": true }, "claimLEODetails": { "type": "text", "required": false, "rows": 4, "lengthOfCut": 400, "maxLength": 512, "seeMoreDisabled": false, "isCustom": true }, "hasMortgage": { "type": "bool", "default": false, "audited": false, "isCustom": true }, "hasSecondMortgage": { "type": "bool", "default": false, "audited": false, "isCustom": true }, "claimNotes": { "type": "wysiwyg", "required": false, "height": 50, "minHeight": 100, "seeMoreDisabled": false, "isCustom": true }, "claimPresentInsurance": { "type": "enum", "required": false, "options": [ "Less than a Year", "1 - 2 Years", "2 - 5 Years", "5+ Years" ], "isSorted": false, "audited": false, "isCustom": true }, "claimHadPresentInsuranceCompany": { "type": "bool", "default": false, "audited": false, "isCustom": true }, "claimPresentInsuranceCompanyDate": { "notNull": false, "type": "date", "required": false, "audited": false, "isCustom": true }, "claimPresentInsuranceDetails": { "type": "text", "required": false, "rows": 4, "lengthOfCut": 400, "seeMoreDisabled": false, "isCustom": true }, "claimPreviousCarrier": { "type": "varchar", "required": false, "trim": true, "audited": false, "isCustom": true }, "claimPreviousInsuranceCompany": { "type": "bool", "default": false, "audited": false, "isCustom": true }, "claimPreviousInsuranceCompanyDetails": { "type": "text", "required": false, "rows": 4, "lengthOfCut": 400, "seeMoreDisabled": false, "isCustom": true }, "claimPreviousInsuranceCompanyDate": { "notNull": false, "type": "date", "required": false, "audited": false, "isCustom": true }, "contactParent": { "type": "link", "required": false, "audited": false }, "claimMortgageeName1": { "type": "varchar", "required": false, "trim": true, "maxLength": 255, "audited": false, "isCustom": true }, "claimMortgageePhone1": { "type": "varchar", "required": false, "trim": true, "maxLength": 255, "audited": false, "isCustom": true }, "claimMortgageeLoanNumber": { "type": "varchar", "required": false, "trim": true, "maxLength": 255, "audited": false, "isCustom": true }, "claimMortgageeName2": { "type": "varchar", "required": false, "trim": true, "maxLength": 255, "audited": false, "isCustom": true }, "claimMortgageePhone2": { "type": "varchar", "required": false, "trim": true, "maxLength": 255, "audited": false, "isCustom": true }, "claimMortgageeLoanNumber2": { "type": "varchar", "required": false, "trim": true, "maxLength": 255, "audited": false, "isCustom": true }, "contacts": { "type": "link" }, "accounts": { "type": "linkMultiple", "noLoad": false, "isCustom": true, "layoutDetailDisabled": false, "layoutListDisabled": true, "layoutMassUpdateDisabled": false, "importDisabled": false }, "contactsClaimLastSNN": { "readOnly": true, "type": "foreign", "link": "contacts", "field": "claimLastSNN", "view": "views/fields/foreign-varchar", "isCustom": true }, "claimStatus": { "type": "enum", "required": false, "options": [ "*", "Assigned", "Assigned/IP", "Awaiting Pmt", "Call Daily", "Cancelled", "Check On Way", "Check to Insured", "Check to TPA", "Collections", "Complete", "Due from HO", "Estimate Awt", "Hancock", "More Services Needed", "Needs Revise/Supp", "New", "New/Contacted", "On Hold", "Other", "Paid", "Partially Paid", "Self Pay", "Senior Review", "Settlement", "WA Received", "WA Sent", "Write-off" ], "default": "active", "isSorted": false, "audited": false, "isCustom": true, "readOnly": false, "tooltip": false }, "type": { "type": "multiEnum", "required": false, "options": [ "water", "wind", "fire", "hail", "Flood", "Roof", "Drain Backup", "Tree", "Freeze", "Interior", "Hail", "Hurricane", "Ice", "Lightning", "Rain", "Sewage", "Smoke", "Theft", "Tornado", "Vandalism", "Vehicle", "Electrical Surge" ], "audited": false, "isCustom": true, "readOnly": false, "tooltip": false }, "pa_fee": { "type": "enum", "required": false, "isSorted": true, "options": [], "view": "custom:views/claims/fields/pa-fee", "audited": false, "isCustom": true, "default": null, "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "PA" } ], "readOnly": false, "tooltip": false }, "adjustersForm": { "skipOrmDefs": true, "view": "custom:views/claims/fields/adjuster", "isCustom": true }, "adjusters": { "type": "linkMultiple", "noLoad": true, "isCustom": true }, "campaign": { "type": "link" }, "emailAddress": { "type": "email", "notStorable": true, "required": false, "tooltip": false }, "stages": { "type": "linkMultiple", "layoutDetailDisabled": false, "layoutListDisabled": true, "layoutMassUpdateDisabled": false, "importDisabled": false, "noLoad": false, "isCustom": true }, "expenses": { "type": "linkMultiple", "layoutDetailDisabled": false, "layoutListDisabled": true, "layoutMassUpdateDisabled": false, "importDisabled": false, "noLoad": false, "isCustom": true }, "inventories": { "type": "linkMultiple", "layoutDetailDisabled": false, "layoutListDisabled": false, "layoutMassUpdateDisabled": false, "importDisabled": true, "noLoad": true, "isCustom": true }, "deductible": { "type": "varchar", "required": false, "trim": true, "audited": false, "isCustom": true, "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "COC" } ], "readOnly": false, "tooltip": false }, "checks": { "type": "linkMultiple", "layoutDetailDisabled": false, "layoutListDisabled": true, "layoutMassUpdateDisabled": false, "importDisabled": false, "noLoad": false, "isCustom": true }, "payables": { "type": "linkMultiple", "layoutDetailDisabled": false, "layoutListDisabled": true, "layoutMassUpdateDisabled": false, "noLoad": false, "importDisabled": false, "isCustom": true }, "account": { "type": "link" }, "depreciation": { "type": "currency", "required": false, "audited": false, "isCustom": true }, "documents": { "type": "linkMultiple", "layoutDetailDisabled": true, "layoutListDisabled": true, "layoutMassUpdateDisabled": true, "noLoad": true, "importDisabled": true, "isCustom": true }, "clientNumber": { "readOnly": true, "type": "foreign", "link": "contacts", "field": "voipLine", "view": "views/fields/foreign-varchar", "isCustom": true }, "document": { "type": "linkMultiple", "layoutDetailDisabled": false, "layoutListDisabled": true, "layoutMassUpdateDisabled": false, "noLoad": false, "importDisabled": false, "isCustom": true }, "label": { "type": "multiEnum", "required": false, "options": [ "Signature Required", "Deductible", "Proof of Loss", "Certified Policy", "Need Adjuster Appointment", "Engineer Report", "Fire Report", "Estimate Required", "Mitigation Estimate", "Mold Estimate", "Roof Estimate", "Build Back Required", "Restoration Agreement", "Waiting for Insurance Estimate", "Recoverable Depreciation", "Certificate of Completion", "Missing Claim Number", "Need LOE", "Packout", "Asbestos Test", "Abatement", "Mold Test", "Electronic Cleaning", "Fabric Cleaning", "Mitigation Payment", "Dwelling Payment", "Contents Payment", "ALE Payment", "Other Payment", "PA Release" ], "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "services": { "type": "multiEnum", "required": false, "audited": true, "options": [ "*", "Arborist Report", "Board Up", "Crane Only", "Debris Removal", "Ice Dam Removal", "Rootball", "Stump Grinding", "Tarp Only", "Tree & Tarp", "Tree Only", "Other" ], "readOnly": false, "tooltip": false, "isCustom": true }, "currentAdjusterAppointment": { "notNull": false, "type": "datetime", "required": false, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "mITRec": { "type": "currency", "required": false, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true, "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "MIT" } ] }, "dwelRec": { "type": "currency", "required": false, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "contRec": { "type": "currency", "required": false, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true, "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "CONT" } ] }, "pAAmount": { "type": "currency", "required": false, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true, "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "PA" } ] }, "aLERec": { "type": "currency", "required": false, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true, "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "PA" } ] }, "custOwed": { "type": "currency", "required": false, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "vendorOwed": { "type": "currency", "required": false, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "totExp": { "type": "currency", "required": false, "tooltipText": "(dumpster, pods, estimator, out of pocket expenses, etc)", "audited": true, "readOnly": false, "tooltip": true, "isCustom": true }, "dedRec": { "type": "enum", "required": false, "options": [ "Yes", "No", "Pending", "Waived", "Not Collected", "Deducted", "Other" ], "default": "Pending", "audited": true, "isSorted": false, "readOnly": false, "tooltip": false, "isCustom": true, "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "COC" } ] }, "check": { "type": "linkMultiple", "layoutDetailDisabled": false, "layoutListDisabled": true, "layoutMassUpdateDisabled": false, "noLoad": false, "importDisabled": false, "isCustom": true }, "rcvacv": { "type": "currency", "required": false, "audited": true, "tooltipText": "Actual Cash Value/Replacement Cost Value", "readOnly": false, "tooltip": true, "isCustom": true }, "pAAgreement": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "PA" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "mITAgreement": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "MIT" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "contractorAgreement": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "COC" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "asbestosReport": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "ABS" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "hYGReport": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "HYG" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "mOLDEstimate": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "MOLD" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "mITEstimate": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "MIT" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "repairEstimate": { "notNull": true, "type": "bool", "dynamicLogicVisible": null, "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "certOfCompletion": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "COC" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "contentEstimate": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "CONT" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "pARelease": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "PA" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "certCopyPolicy": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "PA" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "proofOfLoss": { "notNull": true, "type": "bool", "dynamicLogicVisible": [ { "type": "has", "attribute": "services", "value": "PA" } ], "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "repairEstimateNeeded": { "notNull": true, "type": "bool", "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "mITEstimateNeeded": { "notNull": true, "type": "bool", "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "contentsEstimateNeeded": { "notNull": true, "type": "bool", "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "supplementEstimateNeeded": { "notNull": true, "type": "bool", "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "accountManager": { "type": "enum", "required": false, "options": [ "Need Manager", "NA" ], "default": "Need Manager", "audited": true, "isSorted": false, "readOnly": false, "tooltip": false, "isCustom": true }, "deductibleNotes": { "type": "varchar", "required": false, "trim": true, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "deductibleAmount": { "type": "currency", "required": false, "audited": true, "readOnly": false, "tooltip": false, "isCustom": true }, "insuranceCompany": { "type": "enum", "required": false, "options": [ "", "AAA", "ACE Private Risk Services", "Acuity", "Affirmative Insurance Services", "AIG - American International Group", "Allegany Coop Insurance", "Allied Insurance", "Allstate", "American Claims Management", "American Country", "American Family Insurance", "American Heartland", "American Integrity", "American National Insurance Company", "American Strategic Insurance", "American Traditions", "Ameriprise", "Amica Mutual Insurance", "ANPAC", "Arbella Insurance Group", "Assurant", "Auto Owners", "Badger Mutual", "Bay Area DKI", "Berkshire Hathaway", "Brotherhood Mutual", "California Casualty", "Capitol Preferred", "Central Insurance Company", "Central Mutual Insurance", "Chubb Corp.", "Cincinnati Insurance Company", "CNA", "Code Blue", "Country Financial", "Crawford & Company", "CSAA", "Cumberland Mutual Fire Insurance Company", "Cypress Insurance", "Dunham & Chemung Mutual", "Edison Insurance", "Electric Insurance Company", "Elfor USA Group, Inc.", "EMC Insurance Company", "Encompass Insurance Company", "Erie Insurance Group", "Esurance", "Excalibur National", "Farm Bureau", "Farmers Insurance Group", "Federated Mutual Insurance", "Federated National", "Fidelity", "Fireman’s Fund Insurance Companies", "First Insurance Company of Hawaii", "Florida Peninsula Insurance", "Frontline", "Geico Insurance", "General Casualty Companies", "Geovera Advantage Insurance Services Inc.", "Germania Insurance", "Grange Mutual Casualty Company", "Guide One Insurance", "Gulfstream", "Hanover Insurance", "Hartford", "Hawkeye Insurance", "Heritage", "HOAIC", "Homeowners Choice", "HomeOwners of America", "Homesite Insurance", "Horace Mann", "Indiana Insurance", "Iowa Mutual", "Kemper Insurance", "Kentucky Farm Bureau", "Lexington Insurance Company", "Liberty Mutual", "Lighthouse Insurance", "Madison Mutual Ins. Co.", "Maison", "Mariposa", "Meemic", "Mercury Insurance Group", "Met Life Auto & Home", "Modern USA", "Mount Carroll Mutual", "Narragansett Bay Insurance Company (NBIC)", "Nationwide", "New Jersey Manufacturers Insurance Company", "Norfolk & Dedham", "North American Risk", "Ohio Causality", "Ohio Mutual Insurance Group", "Olympus Insurance Company", "Other", "Pekin Insurance", "Peoples Trust", "Pharmacists Mutual Insurance", "Philadelphia Insurance", "Prepared Insurance", "Pure", "QBE", "Rockford Mutual Insurance", "Safeco", "Safepoint", "Safety", "Sawgrass Mutual", "Secura Insurance", "Security First", "SEIBELS", "Selective Insurance", "Self Pay", "SFPC", "Shelter Insurance", "Society Insurance", "Southern Fidelity Ins", "Southern Fidelity P & C", "State farm", "St. Johns", "Standard Mutual Insurance Company", "State Farm Insurance", "StPaul/Travelers", "Texas Windstorm", "The Hartford", "Tower Hill Prime Ins. Co.", "Travelers", "United States Liability Insurance", "Universal North America", "Universal Property and Casualty", "Unknown", "UPC Insurance", "USAA", "Velocity", "West Bend Mutual Insurance", "Western Mutual Insurance Group", "Westfield Insurance", "Weston", "Westpoint Insurance", "Zurich-American Insurance Group" ], "default": "", "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "vendor": { "readOnly": true, "type": "foreign", "link": "account", "field": "name", "tooltipText": "Vendor Name for claims view", "view": "views/fields/foreign-varchar", "tooltip": true, "isCustom": true }, "source": { "type": "enum", "required": false, "options": [ "Advertisement", "Alacrity", "Bay Area DKI", "Belfor", "BrightServ", "Code Blue", "Direct", "DPLS", "First Choice", "IPN", "Job Sight", "Jon Wayne Construction", "Liberty Mutual", "Lionsbridge", "Nationwide", "Nexxus", "Other", "Paul Davis", "PMAINS", "Policyholder", "Rapid Response", "Rytech", "Safeco", "Special Touch Disaster Restoration", "SynergyOne", "TW Website", "Unknown", "Vericlaims" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true, "default": "Unknown" }, "lossLevel": { "type": "enum", "required": false, "options": [ "1-Low", "2-Med", "3-High" ], "audited": false, "default": "1-Low", "isSorted": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wASent": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wAReceived": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "surveySent": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "surveyReceived": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "surveyRating": { "type": "enum", "required": false, "options": [ "1", "1.5", "2", "2.5", "3", "3.5", "4", "4.5", "5", "" ], "default": "", "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "beforePhotosTaken": { "notNull": true, "type": "bool", "audited": true, "default": false, "readOnly": false, "tooltip": false, "isCustom": true }, "jobOver6Hours": { "notNull": true, "type": "bool", "default": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "tarpAssistance": { "notNull": true, "type": "bool", "default": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "afterPhotosTaken": { "notNull": true, "type": "bool", "default": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "xactimateComplete": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "xactimateAmount": { "type": "currency", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "xactimateSentToClient": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "xactimateSentToAdjuster": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "balanceDueFrom": { "type": "enum", "required": false, "options": [ "", "Carrier", "Homeowner", "TPA", "Write Off" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "phoneNumber": { "type": "phone", "typeList": [ "Mobile", "Office", "Home", "Fax", "Other" ], "defaultType": "Mobile", "notStorable": true, "required": false, "tooltip": false }, "address": { "type": "address" }, "addressStreet": { "type": "text", "maxLength": 255, "dbType": "varchar" }, "addressCity": { "type": "varchar", "trim": true }, "addressState": { "type": "varchar", "trim": true }, "addressCountry": { "type": "varchar", "trim": true }, "addressPostalCode": { "type": "varchar", "trim": true }, "beforePhoto": { "type": "image", "required": false, "previewSize": "small", "audited": true, "tooltip": false, "isCustom": true }, "afterPhoto": { "type": "image", "required": false, "previewSize": "small", "audited": true, "tooltip": false, "isCustom": true }, "receivables": { "type": "linkMultiple", "layoutDetailDisabled": true, "layoutListDisabled": true, "layoutMassUpdateDisabled": true, "noLoad": true, "importDisabled": true, "isCustom": true }, "cancelReason": { "type": "enum", "required": false, "options": [ "Found Another Contractor", "Ins. Coverage/Deductible Concern", "Other (See Notes)", "Response Time", "Svc not needed", "Unresponsive", "Wants Estimate", "" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "population": { "type": "enum", "required": false, "options": [ "High", "Medium", "Remote", "Very Remote", "" ], "isSorted": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "latitude": { "type": "varchar", "required": false, "trim": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "longitude": { "type": "varchar", "required": false, "trim": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "jobInspected": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "orgJobID": { "type": "varchar", "required": false, "trim": true, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "jobCompleted": { "notNull": false, "type": "date", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "jobID": { "type": "autoincrement", "autoincrement": true, "unique": true, "tooltip": false, "isCustom": true }, "assignments": { "type": "linkMultiple", "layoutDetailDisabled": false, "layoutListDisabled": true, "layoutMassUpdateDisabled": false, "noLoad": false, "importDisabled": false, "isCustom": true }, "eTA": { "notNull": false, "type": "datetime", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "timeArrived": { "notNull": false, "type": "datetime", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "timeLeft": { "notNull": false, "type": "datetime", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "xactimates": { "type": "linkMultiple", "layoutDetailDisabled": true, "layoutListDisabled": true, "layoutMassUpdateDisabled": true, "noLoad": true, "importDisabled": true, "isCustom": true }, "times": { "type": "linkMultiple", "layoutDetailDisabled": true, "layoutListDisabled": true, "layoutMassUpdateDisabled": true, "noLoad": true, "importDisabled": true, "isCustom": true }, "customerContacted2": { "notNull": false, "type": "datetime", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "jobInspected2": { "notNull": false, "type": "datetime", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "received2": { "notNull": false, "type": "datetime", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "active": { "notNull": true, "type": "bool", "default": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "wAReceived2": { "notNull": false, "type": "datetime", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "jobStatusChanged": { "notNull": false, "type": "datetime", "required": false, "audited": false, "readOnly": true, "tooltip": false, "isCustom": true }, "jobCompleted2": { "notNull": false, "type": "datetime", "required": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "timeBetween": { "type": "varchar", "required": false, "trim": true, "readOnly": true, "audited": false, "tooltip": false, "isCustom": true }, "eDC": { "notNull": false, "type": "datetime", "required": false, "tooltipText": "Estimated Date of Completion", "audited": false, "readOnly": false, "tooltip": true, "isCustom": true }, "eTC": { "type": "varchar", "required": false, "trim": true, "tooltipText": "Estimated Time of Completion. How many hours will this job take?", "audited": false, "readOnly": false, "tooltip": true, "isCustom": true }, "duringPhotosTaken": { "notNull": true, "type": "bool", "default": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true }, "specialEquipment": { "notNull": true, "type": "bool", "default": false, "audited": false, "readOnly": false, "tooltip": false, "isCustom": true } }, "links": { "createdBy": { "type": "belongsTo", "entity": "User" }, "modifiedBy": { "type": "belongsTo", "entity": "User" }, "assignedUser": { "type": "belongsTo", "entity": "User" }, "teams": { "type": "hasMany", "entity": "Team", "relationName": "EntityTeam", "layoutRelationshipsDisabled": true }, "contacts": { "type": "belongsTo", "foreign": "claims", "entity": "Contact", "isCustom": true }, "accounts": { "type": "hasMany", "relationName": "claimsAccount", "foreign": "claims", "entity": "Account", "isCustom": true, "audited": false }, "adjusters": { "type": "hasMany", "relationName": "claimsAdjuster", "foreign": "claims", "entity": "Adjuster", "isCustom": true }, "meetings": { "type": "hasMany", "entity": "Meeting", "foreign": "parent", "layoutRelationshipsDisabled": true }, "calls": { "type": "hasMany", "entity": "Call", "foreign": "parent", "layoutRelationshipsDisabled": true }, "campaign": { "type": "belongsTo", "foreign": "claims", "entity": "Campaign", "isCustom": true }, "emails": { "type": "hasChildren", "entity": "Email", "foreign": "parent", "layoutRelationshipsDisabled": true }, "campaignLogRecords": { "type": "hasChildren", "entity": "CampaignLogRecord", "foreign": "parent" }, "tasks": { "type": "hasChildren", "entity": "Task", "foreign": "parent", "layoutRelationshipsDisabled": true }, "targetLists": { "type": "hasMany", "entity": "TargetList", "foreign": "contacts" }, "stages": { "type": "hasMany", "relationName": "stagesClaims", "foreign": "claims", "entity": "Stages", "isCustom": true }, "expenses": { "type": "hasMany", "relationName": "claimsExpense", "foreign": "claims", "entity": "Expense", "isCustom": true }, "inventories": { "type": "hasMany", "relationName": "claimsInventory", "foreign": "claims", "entity": "Inventory", "isCustom": true }, "checks": { "type": "hasMany", "relationName": "checksClaims", "foreign": "claims", "entity": "Checks", "isCustom": true, "audited": false }, "payables": { "type": "hasMany", "foreign": "claims", "entity": "Payables", "isCustom": true }, "account": { "type": "belongsTo", "foreign": "claimsPrimary", "entity": "Account", "isCustom": true }, "documents": { "type": "hasMany", "foreign": "claims", "entity": "Document", "isCustom": true }, "document": { "type": "hasMany", "foreign": "claims", "entity": "Document", "isCustom": true }, "check": { "type": "hasMany", "foreign": "claim", "entity": "Checks", "audited": false, "isCustom": true }, "beforePhoto": { "type": "belongsTo", "entity": "Attachment", "skipOrmDefs": true }, "afterPhoto": { "type": "belongsTo", "entity": "Attachment", "skipOrmDefs": true }, "test": { "type": "hasChildren", "entity": "Attachment", "foreign": "parent", "layoutRelationshipsDisabled": true, "relationName": "attachments" }, "receivables": { "type": "hasMany", "foreign": "claims", "entity": "Opportunity", "audited": false, "isCustom": true }, "assignments": { "type": "hasMany", "foreign": "job", "entity": "Case", "audited": false, "isCustom": true }, "xactimates": { "type": "hasMany", "foreign": "claims", "entity": "Xactimate", "audited": false, "isCustom": true }, "times": { "type": "hasMany", "foreign": "claims", "entity": "Time", "audited": false, "isCustom": true } }, "collection": { "sortBy": "createdAt", "asc": false, "textFilterFields": [ "name", "claimNumber" ] }, "indexes": { "name": { "columns": [ "name", "deleted" ] }, "assignedUser": { "columns": [ "assignedUserId", "deleted" ] } } }