| # | Name | Location | Type | Details | Index | Description |
|---|---|---|---|---|---|---|
| .01 | auto match value(+) | 0;1 | FREE TEXT | B | This field is the entered name for the insurance company. This value holds the 'incorrect' insurance company name which needs to get corrected and replaced with the valid insurance company name. Typical values in this field will include common spelling mistakes and incorrect insurance company names. Also allowed here is the "*" wildcard character. Any entry with a wildcard character must also contain at least 4 non-wildcard characters. Multiple asterisks are allowed here. | |
| .02 | insurance company name(+) | 0;2 | FREE TEXT | C | This is the name of a valid insurance company from the Insurance Company file (file# 36). The insurance company name entered here must be a currently valid company name meaning that the entry must be active and not scheduled for deletion. | |
| .03 | date/time entered(+) | 0;3 | DATE-TIME | This is the date and time that the auto match value was created. | ||
| .04 | entered by(+) | 0;4 | POINTER | 200 | This is the user who created the auto match value. | |
| .05 | date/time last edited(+) | 0;5 | DATE-TIME | This is the date and time that the auto match value was last edited. | ||
| .06 | last edited by(+) | 0;6 | POINTER | 200 | This is the user who last edited the auto match value. | |
| .07 | original entered value(+) | 0;7 | FREE TEXT | This is the original value of the 'entered by' field. The first time an entry is created, this value will get set and then no further updates to this field will be made. This will provide the original value to this entry. | ||
| .08 | original insurance company(+) | 0;8 | FREE TEXT | This is the original, valid, correct insurance company name at the time this entry was first created. This is for auditing and historical tracking purposes only. This field isn't updated after the original data entry. |
Not Referenced