Insurance Tracking [U1002]

The Insurance Tracking update [U1002] is used in conjunction with the Collateral module [U12], a separately purchased module of LeasePak . The Insurance Tracking update [U1002] is used to create an insurance activity file for vehicle leases. The vehicle leases reported are active (neither matured nor paid off) and have an insurance type other than NTRQ (not required).

This insurance activity file may be moved by the system manager to a tape and sent to an outside insurance tracking agency. The information on the file is used by the insurance tracking agency to ensure leased vehicles are adequately insured.

The file is an sequential ASCII file. The file is STREAM format with no record separators; that is, it is one large record. One record is created for each insurance policy entered for the lease. The insurance tracking file, DIT_P??.DAT, where ?? is the portfolio number, is created in the LeasePak data directory [xxLEASEPK.DATA]. All fields are converted to a string format before they are written to the file.

The format is as follows:

Field Name	Size (bytes)	Type	Description
Tape code	4	Alpha	Identifies tape recipient
Portfolio number	2	Alphanumeric
Company number	2	Alphanumeric
Region number	2	Alphanumeric
Office number	3	Alphanumeric
Lease number	10	Alphanumeric
Vendor	6	Alphanumeric
Last name	15	Alphanumeric	The first 15 characters of the lessee short name on the Master Financial (RLS) file
First name	10	Alphanumeric	The first 10 characters of the bill name on the Lessee (RAL) file
Name type	1	Numeric	0 if individual lease; 2 if group type lease
Address 1	25	Alphanumeric
Address 1 type	1	Numeric	Not used
Address 2	25	Alphanumeric
Address 3	25	Alphanumeric
State	2	Alpha
Zip code	5	Alphanumeric
Lease term	3	Numeric
Collateral year	2	Numeric	Year of vehicle
Collateral make	7	Alphanumeric	Manufacturer of vehicle
Collateral id	20	Alphanumeric	Serial number of vehicle
Asset classification	4	Alphanumeric
Lease balance	7	Numeric	Principal outstanding
Lease effective date	6	Numeric	Commencement date of lease
Lease maturity date	6	Numeric
Next payment date	6	Numeric
Home phone	12	Numeric
Business phone	12	Numeric
Insurance carrier	4	Alphanumeric
Policy number	16	Alphanumeric
Policy effective date	6	Numeric
Policy expiration date	6	Numeric
Agent phone	12	Numeric
FILL (blanks)	13
Total	569

 

When creation of the insurance tracking file is complete, a MAIL message is automatically sent to the OPERATOR USER NAME as designated in the Miscellaneous Customizations option of the Custom General update [U0712]. The purpose of this MAIL message is to tell the operator that file creation is finished and the file may now be put to tape.

Executing the Insurance Tracking update [U1002] also creates an Insurance Tracking Summary report [U1002A] showing the total number of assets whose information is put on the insurance tracking file.

The Insurance Tracking update [U1002] may be executed automatically through End of Period [U04] processing. It may also be executed interactively by selecting it from the Updates and External Data Sets menus.

 

When the program is executed interactively, this screen is used to select the portfolio for which the insurance activity file and the Insurance Tracking Summary report are to be created.

• PORT
  A portfolio number must be entered. The insurance activity file and the Insurance Tracking Summary report for the portfolio entered are created when RETURN is pressed.

  If the user is restricted to a portfolio through the Security update [U0706], the value for this portfolio is defaulted and may not be changed. The message "Press Return or Cancel to continue" appears on the screen, indicating that the user may press RETURN to execute the Insurance Tracking update [U1002] for this portfolio, or press CANCEL to return to the External Data Sets menu without executing the update.

 

Insurance Tracking Summary

The Insurance Tracking Summary report [U1002A] reports at the portfolio level and provides the following insurance information for the portfolio selected:

• ACCOUNT STATUS
  The insurance status is displayed.

• TOTAL NUMBER
  The number of assets in each ACCOUNT STATUS is displayed.

• GRAND TOTAL
  The total number of assets tracked for this portfolio is displayed.

 

LeasePak  Reference Guide

©  by McCue Systems Incorporated. All rights reserved.

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.