Data File Integrity Check Error Reports

PracticeMaster DFIC Error Report

CMDFIC.LOG

Tabs3 DFIC Error Report

T3DFIC.LOG

Tabs3 Archive File Integrity Check Error Report

T3AFIC.LOG

APS DFIC Error Report

A3DFIC.LOG

GLS DFIC Error Report

G5DFIC.LOG

TAS DFIC Error Report

T4DFIC.LOG

Tabs3 Remote DFIC Error Report

R3DFIC.LOG

Date: 11/15/2011         PracticeMaster Data File Integrity Check Error Report               Page: 1
                                      Burns, Jensen & Powers, P.C.

Error
Code  AOP Name  AOP Title       File Name  File Title   Field ID <Index>  Rec #  Client ID (Key)

  54  CMSYSTEM  System Files     CMJRNL     Journal      Client_ID          5     110.01 - N

____________________________________________
DFIC was started at:  09:48 AM  on  10/15/2011
DFIC ended at:        09:48 AM  on  11/15/2011
      1 error(s) were found

Column Name

Description

Error Code

The Error Code indicates what type of error has been found. The following KB Articles list each possible error code and its meaning:

• KB Article R11331 - Data File Integrity Check Errors (Version 16)
• KB Article R11245 - Data File Integrity Check Errors (Version 15)
• KB Article R11111 - Data File Integrity Check Errors (Version 14)
• KB Article R11000 - Data File Integrity Check Errors (Version 12)

In the example shown above, the Error Code is 54.

AOP Name

The AOP Name column shows the directory name of the Area of Practice associated with the file that has the error.
In the example shown above, the file containing the error 54 is located in the CMSYSTEM directory. For example, if the PracticeMaster program directory is F:\STI, then the file is located in F:\STI\CMSYSTEM.

AOP Title

The AOP Title column indicates the title of the Area of Practice associated with the file that has the error.
In the example shown above, the file containing the error 54 belongs to the System Files Area of Practice.

File Name

The File Name column shows the file name of the data file in which the error has been found.
In the example shown above, the file name of the file containing the error is CMJRNAL.

File Title

The File Title column provides the description of the data file in which the error has been found.
In the example shown above, the error is in the Journal file.

Field ID <Index>

The Field ID <Index> column indicates the field or index containing the error.
In the example shown above, the error is in the Client ID field.

Rec #

The Rec # column indicates the position of the record in the data file. This information can be used to access the record via the Load Record program, which allows editing of a specific record when the record number is the only information available. The Load Record program can be accessed by selecting Edit | Load Record from the List tab of any PracticeMaster data file.
In the example shown above, the error is in record 5.

Client ID (Key)

The Client ID (Key) column shows the Client ID or key field associated with the record that has the error.
Note:  Errors in the Journal, Calendar, or Tcode file will include a letter following the value shown in the Client ID (Key) column. This letter indicates the record type. Possible values include the following:

In the example shown above, the record containing the error is for Client ID 110.01, and it is a Note record.

Date: 11/15/2011            Tabs3 Data File Integrity Check Error Report                       Page: 1
                                     Burns, Jensen & Powers, P.C.

      Error
Count Code Error Description         File Name        Field                Client ID Key<Ref#>  Seq No

    1   11 Invalid Category          TK By Cat Prod   Category Number                 4  :8        278

Key for the 'Key<Ref#>' field.
Non-listed files and errors 55, 72, 73, and 74 cause this field to be blank.
Error 69 reports the index number in this field.

File                    Key represents
Billing Freq            Frequency ID
Budget                  Phase Task ID
Category                Category Number
Cat Prod                Category Number
Client Fund             Reference Number
Fee Rate                Timekeeper Number
Cost Rate               Tcode/Task Code
Ledger                  Reference Number
Ledger Detail           Reference Number
Location                Location ID
Pymt Alloc              Ledger Reference Number
Rect Alloc              Record Type
Stmt Code               Code ID
Stmt Note               Note ID
Task Code               ID
Timekeeper              Timekeeper Number
TK by Cat Prod          Timekeeper Number Category Number
TK by Tcode Prod        Timekeeper Number:Transaction Code Number
TK Prod                 Timekeeper Number
Fee                     Reference Number
Cost                    Reference Number
Pymt                    Reference Number
Tcode                   Transaction Code Number
Fee Verif               User ID
Cost Verif              User ID
Pymt Verif              User ID
Flat Fee Verif          User ID
Fund Verif              User ID
Split Fee Verif         User ID
Transf Verif            User ID
Upd Stmt Verif          User ID
Wrt Off Verif           User ID
Wrt UpDn Verif          User ID

____________________________________________
DFIC was started at:  09:52 AM  on  11/15/2011
DFIC ended at:        09:52 AM  on  11/15/2011

Totals:

       Error
Count  Code   Error Description
    1    11   Invalid Category
    1 error(s) were found

Tabs3 release date: 10/24/11

Column Name

Description

Count

The Data File Integrity Check keeps track of how many errors it has found, cumulatively. The Count column indicates when each error occurred in the sequence.
In the example shown above, there is only one error, so it is the first error.

Error Code

The Error Code indicates what type of error has been found. The following KB Articles list each possible error code and its meaning:

• KB Article R11331 - Data File Integrity Check Errors (Version 16)
• KB Article R11245 - Data File Integrity Check Errors (Version 15)
• KB Article R11111 - Data File Integrity Check Errors (Version 14)
• KB Article R11000 - Data File Integrity Check Errors (Version 12)

In the example shown above, the Error Code is 11.

Error Description

The Error Description column provides a description of the error that has been found.
In the example shown above, the error 11 indicates an Invalid Category.

File Name

The File Name indicates the file in which the error has been found.
In the example shown above, the error is in the TK By Cat Prod (Productivity by Category for Each Timekeeper) file.

Field

The Field column indicates which field in the affected file contains the error.
In the example shown above, the error is in the Category Number field.

Client ID

The Client ID column indicates which client the affected record belongs to, if any.
Records in the Productivity by Category for Each Timekeeper file are not stored by Client ID, so this column is blank for the error 11 in the example shown above.

Key<Ref#>

The meaning of the information in the Key<Ref#> column varies depending on the file in which the error was found.
The legend printed on the report explains the possible meanings of the information in this column. For the Productivity by Category for Each Timekeeper file, the Key<Ref#> column indicates the timekeeper number followed by the category number, separated by a colon. In the example shown above, the error in the example is for timekeeper 4, category 8.

Seq No

The Seq No column indicates the sequence number (i.e., the unique key value that identifies each record in a given file) for the record that contains the error. Note: The sequence number is not visible in any data entry window, and is provided for the use of our Technical Support Representatives only.
In the example shown above, the record containing the invalid category has a sequence number of 278.

Date: 11/15/2011          Tabs3 Archive File Integrity Check Error Report                      Page: 1
                                   Burns, Jensen & Powers, P.C.

      Error
Count Code Error Description         File Name        Field                Client ID F/C/P Type Seq No

    1   51 Invalid ID                Arch File        Client Id              123.sss F              11
____________________________________________
AFIC was started at:  04:47 PM  on  11/15/2011
AFIC ended at:        04:47 PM  on  11/15/2011
        1 error(s) were found

Column Name

Description

Count

The Archive Data Integrity Check program keeps track of how many errors it has found, cumulatively. The Count column indicates when each error occurred in the sequence.
In the example shown above, there is only one error, so it is the first error.

Error Code

The Error Code column indicates what type of error was found. KB Article R10771, "Archive File Integrity Check Errors," lists each possible error code and its meaning.
In the example shown above, the Error Code is 51.

Error Description

The Error Description column provides a description of the error that was found.
In the example shown above, the error indicates that an invalid ID was found.

File Name

The File Name column indicates the file in which the error was found.
For the Archive Data Integrity Check program, the value in this column will always be "Arch File", indicating the Tabs3 Archive file (T3ARCH).

Field

The Field column indicates which field in the Archive file contains the error.
In the example shown above, the error is in the Client ID field.

Client ID

The Client ID column indicates the client to which the affected record belongs.
In the example shown above, the archive record belongs to client 123.sss. This is also the actual error, since the Tabs3 system in which this error occurred is configured for a numeric Key Type. Because 123.sss is an invalid Client ID, this record has apparently become corrupt.

F/C/P Type

The F/C/P Type column indicates whether the archive transaction that contains the error is a (F)ee, (C)ost or (P)ayment transaction.
In the example shown above, the error is in a fee transaction.

Seq No

The Seq No column indicates the sequence number (i.e., the unique key value that identifies each record in a given file) for the record that contains the error. Note: The sequence number is not visible in any data entry window, and is provided for the use of our Technical Support Representatives only.
In the example shown above, the record containing the error 51 has a sequence number of 11.

Date: 11/15/2011              APS Data File Integrity Check Error Report                      Page: 1
                                     Burns, Jensen & Powers, P.C.

       Error
 Count Code  Error Description         File Name        Field              Vendor   Key<Ref#>  Seq No

     1    5  Missing Federal ID        Vendor           Federal ID         120.00    <120.00>       4

'Key<Ref#>' Legend.
Non-listed files and errors 55, 72, 73, and 74 cause this field to be blank.
Error 69 reports the index number in this field.

File                   Key Represents
----                   --------------
Vendor                 Vendor
Invoice                Reference Number
Bank                   Bank Account
Recurring Entry        Record Number
Verification           User ID
__________________________________________________
DFIC was started at:    03:35 PM   on  11/15/2011
DFIC ended at:          03:35 PM   on  11/15/2011
     1  error(s) were found

Column Name

Description

Count

The Data File Integrity Check program keeps track of how many errors it has found, cumulatively. The Count column indicates when each error occurred in the sequence.
In the example shown above, there is only one error, so it is the first error.

Error Code

The Error Code indicates what type of error has been found. The following KB Articles list each possible error code and its meaning:

• KB Article R11331 - Data File Integrity Check Errors (Version 16)
• KB Article R11245 - Data File Integrity Check Errors (Version 15)
• KB Article R11111 - Data File Integrity Check Errors (Version 14)
• KB Article R11000 - Data File Integrity Check Errors (Version 12)

In the example shown above, the Error Code is 5.

Error Description

The Error Description column provides a description of the error that was found.
In the example shown above, the error indicates that a vendor is missing its Federal ID number.

File Name

The File Name column indicates the file name of the file containing the error.
In the example shown above, the error is in the Vendor file.

Field

The Field column indicates which field in the affected file contains the error.
In the example shown above, the error is in the Federal ID field.

Vendor

The Vendor column indicates the vendor number associated with the record containing the error.
In the example shown above, the record missing its Federal ID number is for vendor number 120.00.

Key<Ref #>

The meaning of the information in the Key<Ref#> column varies depending on the file in which the error was found.
The legend printed on the report explains the possible meanings of the information in this column. For the Vendor file, the Key<Ref#> column indicates the vendor number of the vendor record that contains an error. In the example shown above, the vendor containing the error code 5 is vendor 120.00.

Seq No

The Seq No column indicates the sequence number (i.e., the unique key value that identifies each record in a given file) for the record that contains the error. Note: The sequence number is not visible in any data entry window, and is provided for the use of our Technical Support Representatives only.
In the example shown above, the vendor record containing the error code 5 has a sequence number of 4.

Date: 11/15/2011              GLS Data File Integrity Check Error Report                        Page: 1
                                     Burns, Jensen & Powers, P.C.

       Error
 Count  Code Error Description         File Name        Field                Acct #  Key<Ref#>   Seq No

     1    10 Invalid character         Journal          Desc                 110.05   <247   >      247

'Key<Ref#>' Legend.
Non-listed files and errors 55, 72, 73, and 74 cause this field to be blank.
Error 69 reports the index number in this field.

File                  Key represents
----                  --------------
Journal Entry         Record Number
Department            Department Number
Journal Name          Journal Number
Recurring Entry       Record Number
Client                Client Number
Verification          User ID

--------------------------------------------------
DFIC was started at:    04:49 PM   on  11/15/2011
DFIC ended at:          04:49 PM   on  11/15/2011
    1 error(s) were found

Column Name

Description

Count

The Data File Integrity Check program keeps track of how many errors it has found, cumulatively. The Count column indicates when each error occurred in the sequence.
In the example shown above, there is only one error, so it is the first error.

Error Code

The Error Code indicates what type of error has been found. The following KB Articles list each possible error code and its meaning:

• KB Article R11331 - Data File Integrity Check Errors (Version 16)
• KB Article R11245 - Data File Integrity Check Errors (Version 15)
• KB Article R11111 - Data File Integrity Check Errors (Version 14)
• KB Article R11000 - Data File Integrity Check Errors (Version 12)

In the example shown above, the Error Code is 10.

Error Description

The Error Description column provides a description of the error that was found.
In the example shown above, the error indicates that an invalid character was found.

File Name

The File Name column indicates the file name of the file containing the error.
In the example shown above, the error is in the Journal file.

Field

The Field column indicates which field in the affected file contains the error.
In the example shown above, the error is in the Description field.

Acct #

The Acct # column indicates the account number associated with the record containing the error.
In the example shown above, the record containing an invalid character is for account number 110.05.

Key<Ref#>

The meaning of the information in the Key<Ref#> column varies depending on the file in which the error was found.
The legend printed on the report explains the possible meanings of the information in this column. For the Journal Entry file, the Key<Ref#> column indicates the record number of the journal that contains an error. In the example shown above, the record number of the journal record containing the error code 10 is 247.

Seq No

The Seq No column indicates the sequence number (i.e., the unique key value that identifies each record in a given file) for the record that contains the error. Note: The sequence number is not visible in any data entry window, and is provided for the use of our Technical Support Representatives only.
In the example shown above, the vendor record containing the error code 10 has a sequence number of 247.

Date: 11/15/2011              TAS Data File Integrity Check Error Report                        Page: 1
                                     Burns, Jensen & Powers, P.C.

      Error
Count Code Error Description         File Name        Field                 Trust ID Key<Ref#>  Seq No

    1    6 Mismatched Fed ID         Master           Federal ID              200.03 <3              6


'Key<Ref#>' Legend.
Non-listed files and errors 55, 72, 73, and 74 cause this field to be blank.
Error 69 reports the index number in this field.

File                    Key represents
Master                  Trust Account and Bank Account
Transaction             Reference Number
Bank                    Bank Account
Payee                   Payee Name
Attorney                Attorney Number
Verification            User ID

____________________________________________
DFIC was started at:  09:11 AM  on  11/15/2011
DFIC ended at:        09:11 AM  on  11/15/2011
        1 error(s) were found

Column Name

Description

Count

The Data File Integrity Check program keeps track of how many errors it has found, cumulatively. The Count column indicates when each error occurred in the sequence.
In the example shown above, there is only one error, so it is the first error.

Error Code

The Error Code indicates what type of error has been found. The following KB Articles list each possible error code and its meaning:

• KB Article R11331 - Data File Integrity Check Errors (Version 16)
• KB Article R11245 - Data File Integrity Check Errors (Version 15)
• KB Article R11111 - Data File Integrity Check Errors (Version 14)
• KB Article R11000 - Data File Integrity Check Errors (Version 12)

In the example shown above, the Error Code is 6.

Error Description

The Error Description column provides a description of the error that has been found.
In the example shown above, the error 6 indicates mismatched Federal ID numbers (i.e., two or more accounts with the same Trust ID have different Federal ID numbers).

File Name

The File Name column indicates the file name of the file containing the error.
In the example shown above, the error is in the Master file, which stores trust account information and balances.

Field

The Field column indicates which field in the affected file contains the error.
In the example shown above, the error is in the Federal ID field.

Trust ID

The Trust ID column indicates the Trust ID associated with the record containing the error.
In the example shown above, the record containing the error is for Trust ID 200.03.

Key<Ref#>

The meaning of the information in the Key<Ref#> column varies depending on the file in which the error is found.
Using the legend on the report, we can see that because the error in the example shown above is in the Master file, the value in this column indicates that the error exists in a record for Trust ID 200.03, bank account 3.

Seq No

The Seq No column indicates the sequence number (i.e., the unique key value that identifies each record in a given file) for the record that contains the error. Note: The sequence number is not visible in any data entry window, and is provided for the use of our Technical Support Representatives only.
In the example shown above, the record containing the error has a sequence number of 6.

Date: 11/15/2011         Tabs3 Remote Data File Integrity Check Error Report                   Page: 1
                                     Burns, Jensen & Powers, P.C.

        Error
 Count  Code  File Name        Location                                    Description          Seq No

     1   10   Fee              Client      560.00  Ref       4 Fee         Hold/Print                9

____________________________________________
DFIC was started at:  12:24 PM  on  11/15/2011
DFIC ended at:        12:24 PM  on  11/15/2011
        1 error(s) were found

Column Name

Description

Count

The Data File Integrity Check program keeps track of how many errors it has found, cumulatively. The Count column indicates when each error occurred in the sequence.
In the example shown above, there is only one error, so it is the first error.

Error Code

The Error Code indicates what type of error has been found. The following KB Articles list each possible error code and its meaning:

• KB Article R11331 - Data File Integrity Check Errors (Version 16)
• KB Article R11245 - Data File Integrity Check Errors (Version 15)
• KB Article R11111 - Data File Integrity Check Errors (Version 14)
• KB Article R11000 - Data File Integrity Check Errors (Version 12)

In the example shown above, the Error Code is 10.

File Name

The File Name column provides a description of the file containing the error.
In the example shown above, the error is in the Fee file.

Location

The Location column indicates the client or record with which the error is associated.
In the example shown above, the error is in the fee record with reference number 4 for client 560.00.

Description

The Description column describes the field that contains the error.
In the example shown above, the error is in the Hold/Print field.

Seq No

The Seq No column indicates the sequence number (i.e., the unique key value that identifies each record in a given file) for the record that contains the error. Note: The sequence number is not visible in any data entry window, and is provided for the use of our Technical Support Representatives only.
In the example shown above, the record containing the error has a sequence number of 9.