Microsoft KB Archive/166138

= INFO: Detailed Description of FTCODE Table in ATS =

Article ID: 166138

Article Last Modified on 8/11/2005

-

APPLIES TO


 * Microsoft Anomaly Tracking System 1.0, when used with:
 * Microsoft Visual Studio 6.0 Enterprise Edition

-



This article was previously published under Q166138



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: kbinfo kbother KB166138

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.