This glossary has two groups: Attributes and Metrics. Each group contains categories. Select any category to see the Measures, Definitions, and Formulas.
You can view the glossary as an alphabetized pdf and print it from your pdf viewer.
Attributes Group
Appraiser Attributes
| Measure | Definition |
Formula |
|---|---|---|
|
Appraiser State
|
The geographical state location of the appraiser. The Appraiser State is based on the address maintained for that repair facility or independent appraisal company, by the claim office to which the staff appraiser’s Pathways license is tied, or the claim office where the non-Pathways appraiser received the appraisal assignment. (Folder Path in CCC® Analytics: Attributes > Appraiser > Audit File Level ) |
-- |
| Appraiser Type |
Identifies the ‘type’ of appraiser that generated the appraisal. Types include:
(Folder Path in CCC® Analytics: Attributes > Appraiser > Audit File Level ) |
-- |
| Avg Total Guideline Exceptions per File |
This measure represents the total count of guidelines violated (# of exceptions) divided by the total count of files (where a file is an estimate or a supplement). The CCC® Analytics Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Attributes > Appraiser > Audit File Level ) |
Total Guideline Exception Cnt / File Violated Cnt |
| File Appraiser |
The Appraiser folder includes all staff appraisers, repair facilities, or independent appraisal companies that generated estimates or supplements for a given insurance company. The list will display the concatenated appraiser name and appraiser Login ID for staff appraisers. For repair facilities and independent appraiser companies, the list will display the companies’ names and will provide the sum total of all individual estimators’ work at each company. File Appraiser denotes the individual appraiser that generated the estimate or supplement file, while the value of “Appraiser” in Collision Estimating denotes the appraiser that generated the original estimate of record. (Folder Path in CCC® Analytics: Attributes > Appraiser > Audit File Level ) |
-- |
Audit Attributes
| Measure | Definition |
|---|---|
| Audit Type |
Identifies the source of an audit completed. Audits can be run during any point of the life cycle of a file, either pre-lock or post-lock. Values include:
An audit result can be generated pre-lock directly from CCC® Estimatingunit, via CCC® EstimatingAdvisor or post-lock via CCC® Workflow Audit. Please note for CCC® EstimatingAdvisor audits, only audits for staff appraisers (Appraiser Type = ‘Staff Appraiser’) will be reported in CCC® Analytics. (Folder Path in CCC® Analytics: Attributes > Audit) |
Audit Detail Attributes
| Measure | Definition |
|---|---|
| Actual |
Actual is the value represented in dollars per hour, dollars, days, or hours as reflected in the line or total of a file (estimate or supplement). The Actual is the value the audit guideline checks to determine if a guideline is triggered. (Folder Path in CCC® Analytics: Attributes > IMG > Audit > Detail) |
| Allowable |
Allowable is the set threshold value represented in dollars per hour, dollars, days, or hours as determined by the business audit guideline. Allowable is the value used to check against the Actual value in the estimate or supplement. (Folder Path in CCC® Analytics: Attributes > IMG > Audit > Detail) |
| Guideline Description |
This attribute identifies the name of the guideline that appears in the audit report. (Folder Path in CCC® Analytics: Attributes > Audit > Detail) |
| Guideline Type |
This attribute identifies the type of guideline – i.e. does the guideline measure a dollar exception, look at a text string, compare percentages, etc. (Folder Path in CCC® Analytics: Attributes > Audit > Detail) |
Claim Attributes
| Measure | Definition |
|---|---|
| Air Bag Deployed Code |
Identifies whether a file included replacement of a driver and/or passenger-side air bag. Values include:
(Folder Path in CCC® Analytics: Attributes > Claim) |
| Appraisal Source |
Appraisal Sources facilitates the filtering of information to include only those files generated by Insurance Staff Appraisers (Internal) or only those files generated by External Appraisers (includes files generated by repair facilities and independent appraisal companies). (Folder Path in CCC® Analytics: Attributes > Claim) |
| Data Source |
The estimating platform used to generate the vehicle appraisal: CCC (designates Pathways data uploaded through the Autoverse portal only), Pathways (designates Pathways data uploaded through EZNet), ADP or Mitchell). (Folder Path in CCC® Analytics: Attributes > Claim) |
| File Type |
The file type identifies whether the audit was run against the vehicle appraisal with just an estimate versus the vehicle appraisal with one or more supplement(s). (Folder Path in CCC® Analytics: Attributes > Claim) |
| Inspection Location |
The Inspection Location Type corresponds to the Site Type in the Admin tab within Pathways and is used to indicate the location where the vehicle was inspected for appraisal. This attribute applies only to Collision Estimating data. With the release of Pathways 4.1, functionality shall be added to identify the type of assignment being sent to repair facilities. This assignment type shall be incorporated into the “Inspection Locations” values to further define the method/location of inspection. Categories include the following:
(Folder Path in CCC® Analytics: Attributes > Claim) |
| Loss Category |
Loss Category is the type of coverage for a particular claim. Valid loss categories include:
(Folder Path in CCC® Analytics: Attributes > Claim) |
Claim Type Attributes
| Measure | Definition | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Claim Category |
Claim Category is a grouping of Claim Type into Structural, Vehicle, Other or Unknown. (Folder Path in CCC® Analytics: Attributes > Claim Type) |
|||||||||||||||
| Claim Type |
Claim Type is an attribute that reflects the type of claim appraised. Values include:
(Folder Path in CCC® Analytics: Attributes > Claim Type) |
|||||||||||||||
| Claim Type Detail |
Claim Type Detail is an attribute that gives more detail to the Claim Type. Values for "Vehicle" Claim Type include:
(Folder Path in CCC® Analytics: Attributes > Claim Type) |
Company Attributes
| Measure | Description |
|---|---|
| Claim Office Branch Code |
The alphanumeric value assigned to claim office by the insurance company to identify that office with a code identifiable within their company. (Folder Path in CCC® Analytics: Attributes > Company) |
| Lowest Level Location |
The name given to the insurance office location to which the data for a given appraisal/claim is tied. (Folder Path in CCC® Analytics: Attributes > Company) |
Condition Attributes
| Measure |
Description |
|||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Odometer Range |
Condition attribute defined by the vehicle odometer specified for the loss vehicle in the appraisal. Values include:
(Folder Path in CCC® Analytics: Attributes > Condition) |
|||||||||||||||||||||||||||||||||
| Primary Impact |
For these attributes, primary points of impact have been grouped in these major groupings:
(Folder Path in CCC® Analytics: Attributes > Condition) |
|||||||||||||||||||||||||||||||||
| Primary Impact Point |
A selection option when creating your own report that provides specific detail on claims/appraisals broken out by primary point of impact. This attribute is based from the primary impact point in the estimate or supplement audited. Subcategories include:
(Folder Path in CCC® Analytics: Attributes >Condition) |
|||||||||||||||||||||||||||||||||
| Secondary Impact Point |
A selection option when creating your own report that provides specific detail on claims/appraisals broken out by secondary impact point. Subcategories include:
(Folder Path in CCC® Analytics: Attributes > Condition) |
|||||||||||||||||||||||||||||||||
| Vehicle Age |
Vehicle Age is the age of the loss vehicle in years. For Collision Estimating data, vehicle age is based on the estimate start date minus vehicle model year. (Folder Path in CCC® Analytics: Attributes > Condition) |
|||||||||||||||||||||||||||||||||
| Vehicle Condition |
Vehicle condition is a Condition folder attribute that reflects whether the vehicle is considered repairable or not. For Audit reporting, the vehicle condition is determined based on the primary point of impact flagged on a vehicle appraisal. (where primary point of impact is flagged as “Total Loss” or “Total Burn”). (Folder Path in CCC® Analytics: Attributes > Condition) |
|||||||||||||||||||||||||||||||||
| Vehicle Driveable Flag |
The Vehicle Driveable Flag reflects the driveable status of the vehicle as captured on the Vehicle Tab within Pathways. Values include: Values include:
(Folder Path in CCC® Analytics: Attributes > Condition) |
IMG Audit Attributes
| Measure | Definition |
|---|---|
| Claim Number |
The alphanumeric value assigned as the claim number for the vehicle appraisal. (Folder Path in CCC® Analytics: Attributes > IMG > Audit) |
| File Complete Date |
The date the estimate of record or supplement of record was locked. For CCC® EstimatingAdvisor data (pre-lock audits), audits will be tied to corresponding estimates or supplements that are received up to 30 days after the Advisor record. (Folder Path in CCC® Analytics: Attributes > IMG > Audit) |
| File Suffix |
Denotes the file within the overall appraisal at which point the audit was completed (i.e. E01, S01, S02, etc.). (Folder Path in CCC® Analytics: Attributes > IMG > Audit) |
IMG Audit Summary Attributes
| Measure | Definition |
|---|---|
| Date of Loss |
The date of loss for a given claim. (Folder Path in CCC® Analytics: Attributes > IMG > Audit > Summary) |
Management Hierarchy Attributes
| Measure | Description |
|---|---|
| Mgmt 1 Level 1 Desc |
A hierarchical attribute within the Manager hierarchy that indicates the top level of the manager hierarchy set up for a customer. Also included are Mgmt 1 Levels 2 through 7. (Folder Path in CCC® Analytics: Attributes > Management Hierarchy) |
| Mgmt 1 Lowest Level Desc |
A hierarchical attribute within the Manager hierarchy that indicates the lowest level of the manager hierarchy set up for a customer. (Folder Path in CCC® Analytics: Attributes > Management Hierarchy) |
MOI Attributes
| Measure | Definition | Formula |
|---|---|---|
| MOI Appraiser Type | Appraiser type of the last assignment before the estimate if that record exists, if it does not exist the data is taken from the estimate of record. This is used to help calculate the Method of Inspection. | -- |
| MOI Inspection Location | Inspection location of the last assignment before the estimate if that record exists, if it does not exist the data is taken from the estimate of record. This is used to help calculate the Method of Inspection. | -- |
| Inspection Type | Inspection type of the last assignment before the estimate if that record exists, if it does not exist the data is taken from the estimate of record. This is used to help calculate the Method of Inspection. | -- |
| Method of Inspection | Method of inspection is a mapped value from MOI Appraiser Type, MOI Inspection Location, and Inspection Type. Because the base attributes are pulled from the last assignment before the estimate (if it exists, if not values are mapped from the estimate of record) this value is also comes from the last assignment before the estimate if available. | -- |
Underwriting Company Attributes
| Measure | Description |
|---|---|
| Underwriting Company |
The assigned insurance company populated by the claim assignment. Commonly referred to Secondary Company. When populated the Underwriting Company is the insurance company on the estimate. When not populated, an assigned insurance company was not selected on the assignment. (Folder Path in CCC® Analytics: Attributes > Underwriting Company) |
Vehicle Attributes
| Measure | Description | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Body Category |
Body Category drills to Type to Body Style. Categories include:
(Folder Path in CCC® Analytics: Attributes > Vehicle) |
|||||||||||||||
| Body Style |
Vehicle Body Style is the categorization of vehicles across all manufacturers and makes based on their body style. Categories include:
(Folder Path in CCC® Analytics: Attributes > Vehicle) |
|||||||||||||||
| Door Style |
The count of doors on the loss vehicle as specified in the vehicle appraisal. (Folder Path in CCC® Analytics: Attributes > Vehicle) |
|||||||||||||||
| Engine Code |
The engine code as specified for the loss vehicle on the appraisal. (Folder Path in CCC® Analytics: Attributes > Vehicle) |
|||||||||||||||
| Make |
Vehicle Make is the make as entered in the CCC® Estimatingunit. (Folder Path in CCC® Analytics: Attributes > Vehicle) |
|||||||||||||||
| Manufacturer |
Vehicle Manufacturer groups together different vehicle makes based on the global manufacturer. For example: GM as a manufacturer would drill to vehicle makes such as Pontiac, Chevrolet, etc. (Folder Path in CCC® Analytics: Attributes > Vehicle) |
|||||||||||||||
| Model |
The vehicle model name as specified the vehicle appraisal. (Folder Path in CCC® Analytics: Attributes > Vehicle) |
|||||||||||||||
| Source |
Vehicle Source are global regions, based on the Manufacturer's Corporate Office Country of origin. Categories include Asian, Domestic, European, and Other. For example, a Honda vehicle source is considered Asian, regardless of whether the car was actually manufactured in the U.S. or in Japan. All vehicle source drills down to Manufacturers then to Makes. (Folder Path in CCC® Analytics: Attributes > Vehicle) |
|||||||||||||||
| Type |
Vehicle Type is the categorization of vehicles based on body style groupings.
(Folder Path in CCC® Analytics: Attributes > Vehicle) |
|||||||||||||||
| Vehicle Style |
The vehicle style as specified on the appraisal for the loss vehicle. (Folder Path in CCC® Analytics: Attributes > Vehicle) |
|||||||||||||||
| Vehicle Year |
The vehicle model year for the loss vehicle as specified on the appraisal. (Folder Path in CCC® Analytics: Attributes > Vehicle) |
Metrics Group
Audit - Summary Metrics
| Measure | Description |
|---|---|
| File Cnt |
The total count of audited estimates and supplements. File Cnt in the Audit subject area reflects the count of files audited, while File Cnt in the Collision Estimating subject area reflects the count of uploaded estimates and supplements. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
| File Cnt w/Exception |
The total count of audited estimates and supplements that have one or more exceptions. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
| File Cnt w/o Exception |
The total count of audited estimates and supplements where zero guideline exceptions have occurred. The measure shows zero deviation to guideline compliance. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
| Last Supplement Amt |
The total dollars for supplemental changes at the point of the last supplement on file submitted. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
Audit Detail Metrics
| Measure | Description |
Formula |
|---|---|---|
| Guideline Avg Exception Amt |
This measure is a guideline specific measure, and is used to identify the average variance (dollar or other) for that specific guideline when a violation of that guideline was identified. (Folder Path in CCC® Analytics: Metrics > Audit > Detail) |
Guideline Exception Amt / Guideline Exception Cnt |
| Guideline Avg Score |
This measure is a guideline specific measure, and is used to identify the average score for that specific guideline when a violation of that guideline was identified. (Folder Path in CCC® Analytics: Metrics > Audit > Detail) |
Score / Guideline Exception Cnt |
| Guideline Exception Amt |
This measure is a guideline specific measure, and is used to identify the total variance (dollar or other) for that specific guideline when a violation of that guideline was identified. The variance is the difference between the Actual and Allowable. (Folder Path in CCC® Analytics: Metrics > Audit > Detail) |
-- |
| Guideline Exception Cnt |
This measure is a guideline specific measure, and is used to identify the total number of times an exception to the specified guideline was found. (Folder Path in CCC® Analytics: Metrics > Audit > Detail) |
-- |
| Score |
The numeric value associated with any given guideline. (Folder Path in CCC® Analytics: Metrics > Audit > Detail) |
-- |
Audit Summary Metrics
| Measure | Definition |
Formula |
|---|---|---|
| Avg Guideline Score |
This measure is the sum of all score values associated with a guideline violation (exception) divided by the total count of guidelines violated (# of exceptions). When applied to all guidelines, this measure essentially identifies the average score value associated with the guideline set. The Intellisphere Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
Total Score / Total Guideline Exception Cnt |
| Avg Repair Cost per Estimate |
The sum of all dollars for estimates divided by the count of estimates. The CCC® Workflow Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
Estimate Amt / Estimate Cnt |
| Avg Repair Cost per Estimate w/Exception |
The sum of all dollars for estimates that included one or more guideline exceptions divided by the count of estimates that included one or more guideline exceptions. The CCC® Analytics Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
(Estimate Amt w/Exception) / (Estimate Cnt w/Exception) |
| Avg Repair Cost per Estimate w/o Exception |
The sum of all dollars for estimates that did NOT include one or more guideline exceptions divided by the count of estimates that did NOT include one or more guideline exceptions. The CCC® Analytics Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
(Estimate Amt w/o Exception) / (Estimate Cnt w/o Exception) |
| Avg Repair Cost per Supplement |
The sum of all dollars for supplements divided by the count of supplements. The CCC® Analytics Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
Supplement Amt / Supplement Cnt |
| Avg Repair Cost per Supplement w/ Exception |
The sum of all dollars for supplements that included one or more guideline exceptions divided by the count of supplements that included one or more guideline exceptions. The CCC® Analytics Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: None) |
(Supplement Amt w/Exception) / (Supplement Cnt w/Exception) |
| Avg Repair Cost per Supplement w/o Exception |
The sum of all dollars for supplements that did NOT include one or more guideline exceptions divided by the count of supplements that did NOT include one or more guideline exceptions. The CCC® Analytics Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
(Supplement Amt w/o Exception) / (Supplement Cnt w/o Exception) |
| Avg Total Cost of Repairs |
This measure is the sum of all dollars across estimates and supplements divided by the count of estimates. The CCC® Analytics Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
File Amt / Estimate Cnt |
| Avg Total Cost of Repairs w/Exception |
This measure is the sum of all dollars across estimates and supplements that include one or more guideline exceptions divided by the count of estimates that includes one or more guideline exceptions. The CCC® Analytics Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
(File Amt w/Exception) / (Estimate Cnt w/Exception) |
| Avg Total Cost of Repairs w/o Exception |
This measure is the sum of all dollars across estimates and supplements that did NOT include one or more guideline exceptions divided by the count of estimates that did NOT include one or more guideline exceptions. The CCC® Analytics Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
(File Amt w/o Exception) / (Estimate Cnt w/o Exception) |
| Avg Total Guideline Exception Amt |
This measure represents the total variance dollar amount divided by the total count of guidelines violated (# of exceptions). This count of exceptions includes all exceptions - those with and without a dollar value associated with the exception. When applied to a single guideline, this measure identifies the total variance amount divided by the total number of times that guideline had been violated. The CCC® Analytics Audit subject area reports on audited files only. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
Total Guideline Exception Amt / Total Guideline Exception Cnt |
| Estimate Amt |
This measure represents the sum of all dollars for audited estimates. (Folder Path in CCC® Analytics: Metrics > Collision Estimating > Severity) |
-- |
| Estimate Amt w/Exception |
This measure represents the sum of all dollars for audited estimates that have a guideline violation. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Estimate Amt w/o Exception |
This measure represents the sum of all dollars for audited estimates where zero guideline exceptions have occurred. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Estimate Cnt |
The total count of audited estimates. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Estimate Cnt w/Exception |
The total count of audited estimates that include one or more guideline violations. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Estimate Cnt w/o Exception |
The total count of audited estimates where zero guideline exceptions have occurred. The measure shows zero deviation to guideline compliance. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Net Amt |
The Net Amt is equivalent to the sum of the total dollars of an audited file (estimate or supplement). (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Supplement Amt |
This is the supplementary dollar amount of all audited supplements. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Supplement Amt w/Exception |
This is the supplementary dollar amount of all audited supplements where one or more guideline violations has taken place. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Supplement Amt w/o Exception |
This is the supplementary dollar amount of all audited supplements where no guideline violations have been identified. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Supplement Cnt |
Total number of audited supplements generated by the appraiser either on his/ her own original estimates or on other appraisers’ original estimates. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Supplement Cnt w/Exception |
Total number of audited supplements where one or more guideline violations has taken place. Supplement counts will reflect supplements that have been audited rather than uploaded supplements. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Supplement Cnt w/o Exception |
Total number of audited supplements where no guideline violation has taken place. Supplement counts will reflect supplements that have been audited rather than uploaded supplements. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Total Cost of Repairs |
This is the total appraised dollar amount across all estimates and supplements. For CCC® EstimatingAdvisor audits, the total cost of repairs will reflect the appraised dollars at the time of the audit, and not the appraiser dollar at the time the file was locked and uploaded. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Total Cost of Repairs w/Exception |
This is the total appraised dollar amount across all estimates and supplements where one or more guideline violations has taken place. For CCC® EstimatingAdvisor audits, the total cost of repairs will reflect the appraised dollars at the time of the audit, and not the appraiser dollar at the time the file was locked and uploaded. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Total Cost of Repairs w/o Exception |
This is the total appraised dollar amount across all estimates and supplements where one or more guideline violations has taken place. For CCC® EstimatingAdvisor audits, the total cost of repairs will reflect the appraised dollars at the time of the audit, and not the appraiser dollar at the time the file was locked and uploaded. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Total Guideline Exception Amt |
This measure identifies the total variance amount across all dollar guidelines where an exception was found. A dollar guideline exception is defined by the variance dollar amount audit report. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Total Guideline Exception Cnt |
This measure identifies the total count of guidelines where an exception was found. This count includes all guideline types: dollar, percentage, or a non-numerical value. (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
| Total Score |
This is a guideline specific measure. The sum of all score values associated with an individual guideline violation (exception). (Folder Path in CCC® Analytics: Metrics > Audit > Summary) |
-- |
