Cases Table

Title - A case with this name will be created. If a case with the same name already exists, the first found case will be updated with new fields, and if there are no fields, the old fields will be preserved.

Phone Found - Assigns a value to the case. Permissible values are "yes" and any other value for "no," including empty.

Notes - Assigns a value to the "notes" field for the case; any value is permissible.

Plaintiff Id - Must be the ID of an existing plaintiff. If the plaintiff cannot be found, the added case will have no plaintiff, and the "Plaintiff Attorney" field will be skipped.

Defendant Id - Must be the ID of an existing defendant. If the defendant cannot be found, the added case will have no defendant, and the "Defendant Attorney" field will be skipped.

Date - Any date.

Complaint Numbers - Numbers must be separated by commas. All extraneous characters will be removed from each identified number (if present), and if the length of the number does not match the standard (10 characters), the number will be skipped. If the identified numbers already exist in the TCPA table, the status for each number will be changed to "Listed in Complaint." If the number does not exist, a new one will be created and linked to a current case, with each number associated with the plaintiff (if the plaintiff was identified).

Plaintiff Attorney - Must be the name of the plaintiff's attorney. If the plaintiff is not identified from the "Plaintiff Id" field, this field will be skipped. If an attorney with the same name is not found, a new attorney will be created.

Defendant Attorney - Must be the name of the defendant's attorney. If the defendant is not identified from the "Defendant Id" field, this field will be skipped. If an attorney with the same name is not found, a new attorney will be created.

State Code - State code.