DOCUMENT:Q166138 11-DEC-1999 [foxpro] TITLE :INFO: Detailed Description of FTCODE Table in ATS PRODUCT :Microsoft FoxPro PROD/VER:WINDOWS:1.0 OPER/SYS: KEYWORDS:kbother ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Anomaly Tracking System, version 1.0, included with: - Microsoft Visual Studio ------------------------------------------------------------------------------- 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. Additional query words: ====================================================================== Keywords : kbother Technology : kbVSsearch kbAudDeveloper kbVS97Search Version : WINDOWS:1.0 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. Copyright Microsoft Corporation 1999.