Total Loss Care (TLC) - Operational Glossary
This glossary has two groups: Attributes and Measure. Each group contains categories, select any category to see the Attributes/ Metrics, Definitions, and Formulas (when available).
You can view this glossary as an alphabetized pdf and print it from your pdf viewer.
Attributes
| Attribute | Definition | Formula |
|---|---|---|
| Appraiser Hrchy Level 1 | Level 1 Hierarchy name of the Quick Estimate appraiser on the claim. | -- |
| Appraiser Hrchy Level 2 | Level 2 Hierarchy name of the Quick Estimate appraiser on the claim. | -- |
| Appraiser Hrchy Level 3 | Level 3 Hierarchy name of the Quick Estimate appraiser on the claim. | -- |
| Appraiser Hrchy Level 4 | Level 4 Hierarchy name of the Quick Estimate appraiser on the claim. | -- |
| Appraiser Hrchy Level 5 | Level 5 Hierarchy name of the Quick Estimate appraiser on the claim. | -- |
| Appraiser Hrchy Level 6 | Level 6 Hierarchy name of the Quick Estimate appraiser on the claim. | -- |
| Appraiser Hrchy Level 7 | Level 7 Hierarchy name of the Quick Estimate appraiser on the claim. | -- |
| Appraiser Name | Name of the appraiser assigned. | -- |
| Claim Number | Claim Number | -- |
| Claim Office Level 1 | Level 1 Hierarchy name of the Quick Estimate carrier on he claim. | -- |
| Claim Office Level 2 | Level 2 Hierarchy name of the Quick Estimate carrier on he claim. | -- |
| Claim Office Level 3 | Level 3 Hierarchy name of the Quick Estimate carrier on he claim. | -- |
| Claim Office Level 4 | Level 4 Hierarchy name of the Quick Estimate carrier on he claim. | -- |
| Claim Office Level 5 | Level 5 Hierarchy name of the Quick Estimate carrier on he claim. | -- |
| Claim Office Level 6 | Level 6 Hierarchy name of the Quick Estimate carrier on he claim. | -- |
| Equity | Equity in the vehicle. | -- |
| Lien Carrier Status | Status of the lien for the carrier. | -- |
| Lien Request Complete Datetime | Date and time the lien request was complete. | -- |
| Lien Request Sent Datetime | Date and time the lien request was sent. | -- |
| Lien Submitter Name | Name of the submitter assigned. | -- |
| Lien Vendor Status | Status of the lien for the vendor. | -- |
| Payoff Amount Received Datetime | Date and time the payoff amount was received. | -- |
| Primary Lien Lender Name | Primary Name of Lien Lender. | -- |
| Registered Lender Flag | Indicates if the Lender is registered. | -- |
| Secondary Lien Lender Name | Secondary Name of Lien Lender. | -- |
| Vehicle Owner State Description | State description of the vehicle owner. | -- |
Metrics
| Metric | Definition | Formula |
|---|---|---|
| % of Payoffs Returned Instantly | Whether or not the payoff amount was received within 60 seconds of the lien request being sent. | ROUND(100*SUM([Payoff Returned Instantly Flag])/COUNT([Payoff Returned Instantly Flag]), 1) |
| Claim Volume | Total Claim Count (There can be multiple records for 1 claim). | COUNTD([Claim Number]) |
| Lien Requests | Total Lien Requests. | SUM([Total Loss Lien Flag]) |
| LOG Cycle Time | Business Hours from Lien Request Sent to LOG Received. | ROUND(AVG([Lien Request Sent to LOG Received Business Seconds]/3600), 2) |
| Payoff Cycle Time | Business Hours from Lien Request Sent to Payoff Amount Received. | ROUND(AVG([Lien Request Sent to Payoff Received Business Seconds]/3600), 2) |
| Reg Lenders % of LOG Ret < 2 Days | % of Lenders that send Lien Request to LOG Received in less than 2 Days. | SUM([Reg Lenders LOG received in < 2 Days Flag])/COUNT([Reg Lenders LOG received in < 2 Days Flag]) |
| Valuation Count | Total Count of Valuation Requests. | COUNTD([Valuation Request Id]) |
