INFO: Detailed Description of FTCODE Table in ATS

 Last reviewed: April 3, 1997
Article ID: Q166138
The information in this article applies to:
  • Microsoft Anomaly Tracking System, version 1.0 included with: Microsoft Visual Studio 97

SUMMARY

The Anomaly Tracking System (ATS), contains several tables in the main database (Ft.dbc). Although all tables play a role, the ftcode table contains custom information such as User IDs, Products, Versions, and several others.

MORE INFORMATION

There are five fields in the ftcode table: 

   Field name  Purpose                       Notes
   ------------------------------------------------------------------------

   Co_id       Unique ID for record          Assigned by "fttpk.nextid"
   Co_ctid     Category ID of record         Further described below
   Co_order    Order of option within group  Order options appear in pop-up
   Co_name     Name of option                Option that shows in pop-up
   Co_proc     Name of validation procedure  What to run if option chosen
The Category field (Co_ctid) determines which group of options the record is associated with. The following Co_ctid are listed along with the names of the options they go with: 

   Co_ctid     Option group             Notes
   ------------------------------------------------------------------------
   01          Current users in database
   02          Keywords                 Choices available on Attributes tab
   03          Priority
   04          Platform                 Windows 95, Windows NT, MS-DOS
   05          Language                 English, French, and so forth
   06          Version number
   07          Product name
   08          Area                     Documentation, User interface, and
                                        so forth
   09          Sub-area
   10          Resolution type
   11          Found during what        Ad-hoc, beta testing, and so forth
   12          Issue type               Defect, suggestion, and so forth
   13          Issue sub-type
   14          Source                   Beta site, user education, and so
                                        forth
   15          Severity
   16          Status
   17          Assigned to
   18          Found by whom
   19          Environment             Choices available on Attributes tab
It is recommended that any changes, additions, or deletions to this table be made through the ATS interface. Specifically, the Property Options Maintenance option on the Tools menu provides the ability to maintain this table. One exception is category 01, which contains the users added to the system. This is maintained by User Maintenance option on the Tools menu.

Keywords : kbother msats
Version : 1.0
Platform : WINDOWS
Issue type : kbinfo

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.