Analytics
Legal Lifecycle Report Fields

Field Column Description / Logic
General
Sender Id The account Sender’s vExchange identification code. It is typically a 2-character state code followed by a 1-3 digit number (for example NJ1). It may also end with a subaccount extension to distinguish accounts by type or portfolio (for example, NJ1.MED and NJ1.AUTO). This field is one of the 4 keys used to determine a unique account on vExchange.
Receiver Id This field is one of the 4 keys used with sender_int_file, creditor_fileno, and forwarder_id to determine if the account exists in vExchange. If the 4 key combination does not already exist in vExchange, the record will be rejected.
Claim Information
Claim $ Value Placement balance, based on value in 1001/2001 tables (see the Top Section of Account Details in the row for Placement Balance). The total placed value of accounts placed in the given year.
# Accounts Placed Total number of accounts in the system.
# Accounts Open Total number of open accounts in the system.
# Accounts Closed Total number of closed accounts in the system.
Counts and Percentages
Acknowledgment Count Total number of acknowledged accounts in the system.
Demand Count Total number of  accounts in the system with a demand filed.
Sued Count Total number of  accounts in the system with a suit filed.
Service Count Total number of  accounts in the system with service filed.
Judgment Count Total number of  accounts in the system with a judgment filed.
Lien Count Total number of  accounts in the system with a lien filed.
Garn Count Total number of  accounts in the system with a garnishment filed.
Suit % Percent of all accounts with a suit.
Served % of Sued Percent of sued accounts that have been served.
Judgment % of Sued Percent of sued accounts that have a judgment.
Open % Percent of all accounts that are in an open status.
Closed % Percent of all accounts that are closed.
Timespans (in days)
Avg Plcmnt to Demand Average duration in days between the placement date and the demand filed date (based on notes records 14xx/24xx or a record 1201/2201 suit date).
Avg Plcmnt to Suit Average duration in days between the placement date and the suit date (based on notes records 14xx/24xx or a record 1201/2201 suit date).
Avg Demand to Suit Average duration in days between the demand filed date and the suit date (based on notes records 14xx/24xx or a record 1201/2201 suit date).
Avg Suit to Service Average duration in days between the suit date and service date (based on notes records 14xx/24xx or a record 1201/2201 suit date).
Avg Suit to Jdgmnt Average duration in days between the suit date and judgment date (based on notes records 14xx/24xx or a record 1201/2201 suit date).
Avg Plcmnt to Jdgmnt Average duration in days between the placement date and the judgment date (based on notes records 14xx/24xx or a record 1201/2201 suit date).
Avg Service to Jdgmnt Average duration in days between the service date and the judgment date (based on notes records 14xx/24xx or a record 1201/2201 suit date).
Financials
Gross Dollars Collected Total Dollars collected
Gross Dollars Collected No Legal Activity Logic: Gross $ Collected for accounts that do not have a legal key event note (based on notes records 14xx/24xx) or a record 1201/2201 suit/judgment date.
Gross Dollars Collected Pre-Legal Logic: Gross $ Collected for accounts that do have a legal key event note but no demand, suit or judgment (based on notes records 14xx/24xx) or a record 1201/2201 suit/judgment date.
Gross Dollars Collected Post-Suit Pre-Judgment Logic: Gross $ Collected for accounts that do have a suit filed key event note but no judgment (based on notes records 14xx/24xx) or a record 1201/2201 suit/judgment date.
Gross Dollars Collected Post-Judgment Logic: Gross $ Collected for accounts that do have a judgment filed key event note (based on notes records 14xx/24xx) or a record 1201/2201 suit/judgment date.
Costs Dollars Expended Total costs expended
Costs Dollars Returned Total costs returned
Dollars Fees Total fees and commissions paid.
Costs Percent Returned Percentage of costs expended that were returned.
Average Cost Per Suit Costs $ Expended divided by Count of accounts with a key event note for suit filed, suit served, judgment, or post judgment (based on notes records 14xx/24xx) or a record 1201/2201 suit/judgment date.
Gross Liquidation Rate Percentage of total claim amount collected across all accounts.
Net Cost Liquidation Rate Percentage of total claim amount collected, less costs not returned, across all accounts.
Net Back Liquidation Rate Percentage of total claim amount collected, less costs not returned and fees paid, across all accounts.
Help Center > Self-Help Resources > Analytics > User Guide > Legal Lifecycle Report Fields