Field Use Analysis Utility

Which fields are being used?  How often?

How wide do we really need for the field?

Are some fields too wide?  Can we trim some bytes off some fields?

 

These are questions that the Field Use Analysis Report can answer.

 

Here is an example of a report it generates

C:\ACT\DATABASE\BDSLM.DBF

User Defined Field Use Analysis:
* Field count does not count record 1
- 1 UNIQUE_ID C 12/ 12 4951 T$'; ""QV ! ============
- 2 CTIME C 6/ 6 4949 ! VQ"" ======
- 3 ETIME C 6/ 6 4951 !!8KQ2 ======
- 4 MTIME C 6/ 6 4645 Mtime: ======
- 5 PUB_STATUS N 10/ 10 4951 1 ==========
- 6 USER C 12/ 12 4950 :12 ============
- 7 COMPANY C 50/ 50 4945 Company:50 ==================================================
- 8 NAME C 40/ 40 3105 NAME:40 ACT Admin ========================================
  9 ADDR1 C 43/ 50 4507 Addr1:50 ===========================================-------
- 10 ADDR2 C 30/ 30 2044 Addr2:30 ==============================
- 11 ADDR3 C 30/ 30 373 Addr3:30 ==============================
  12 CITY C 24/ 30 4485 City:30 ========================------
  13 STATE C 14/ 20 4704 State:20 ==============------
- 14 ZIP C 10/ 10 3049 Zip:10 ==========
  15 COUNTRY C 13/ 25 12 Country:25 =============------------
  16 IDSTATUS C 14/ 25 4 Idstatus:25 ==============-----------
  17 PHONE C 34/ 42 3497 Phone:42 ==================================--------
  18 FAX C 32/ 42 6 Fax:42 ================================----------
  19 HOME_PHONE C 32/ 42 17 Home_phone:42 ================================----------
  20 MOBILPHONE C 32/ 42 182 Mobilphone:42 ================================----------
  21 PAGER C 8/ 42 0 Pager:42 ========----------------------------------
  22 SALUTATION C 13/ 30 3081 Salutation:30 =============-----------------
- 23 LAST_MEET C 8/ 8 2 Last_mee ========
- 24 LAST_REACH C 8/ 8 180 Last_rea ========
- 25 LAST_ATMPT C 8/ 8 171 Last_atm ========
- 26 LTTR_DATE C 8/ 8 10 Lttr_dat ========
- 27 TITLE C 40/ 40 2848 Title:40 ========================================
  28 ASSISTANT C 31/ 40 2501 Assistant:40 ===============================---------
* 29 LAST_RSLTS C 75/ 75 2998 Last_rslts:75 ===========================================================================
- 30 REFER_BY C 30/ 30 1924 Refer_by:30 ==============================
  31 USER1 C 14/ 15 3918 001:15 ==============-
  32 USER2 C 29/ 30 3240 002:30 =============================-
- 33 USER3 N 10/ 10 1092 3 ==========
  34 USER4 C 20/ 25 3777 004:25 ====================-----
- 35 USER5 C 15/ 15 2859 005:15 ===============
- 36 USER6 C 50/ 50 2729 006:50 ==================================================
* 37 USER7 C 57/ 75 2070 007:75 =========================================================------------------
  38 USER8 C 30/ 75 77 008:75 ==============================---------------------------------------------
  39 USER9 C 35/ 75 3033 009:75 ===================================----------------------------------------
  40 USER10 C 12/ 15 10 010:15 ============---
  41 USER11 C 35/ 40 1365 011:40 ===================================-----
  42 USER12 C 35/ 45 275 012:45 ===================================----------
  43 USER13 C 34/ 42 337 013:42 ==================================--------
  44 USER14 C 34/ 35 80 014:35 ==================================-
  45 USER15 C 18/ 75 28 015:75 ==================---------------------------------------------------------
  46 ALTADDR1 C 25/ 50 25 Altaddr1:50 =========================-------------------------
- 47 ALTADDR2 C 30/ 30 1277 Altaddr2:30 ==============================
  48 ALTCITY C 25/ 30 1121 Altcity:30 =========================-----
  49 ALTSTATE C 13/ 25 53 Altstate:25 =============------------
  50 ALTZIP C 12/ 15 428 Altzip:15 ============---
  51 ALTCOUNTRY C 13/ 25 0 Altcountry:25 =============------------
  52 ALTPHONE C 32/ 42 2 Altphone:42 ================================----------
- 53 NAME2 C 30/ 30 771 Name2:30 ==============================
- 54 TITLE2 C 30/ 30 737 Title2:30 ==============================
  55 PHONE2 C 32/ 42 134 Phone2:42 ================================----------
  56 NAME3 C 28/ 30 332 Name3:30 ============================--
- 57 TITLE3 C 30/ 30 441 Title3:30 ==============================
  58 PHONE3 C 32/ 42 64 Phone3:42 ================================----------
  59 FNAME C 12/ 50 3082 NAME:40 ============--------------------------------------
  60 LNAME C 17/ 50 3103 Admin =================---------------------------------
  61 EXT C 6/ 8 511 Ext:8 ======--
- 62 FAX_EXT C 8/ 8 29 Fax_ext: ========
- 63 ALTEXT C 8/ 8 5 Altext:8 ========
- 64 PHONE2_EXT C 10/ 10 55 Phone2_ext ==========
- 65 PHONE3_EXT C 10/ 10 22 Phone3_ext ==========
- 66 ASST_TITLE C 30/ 30 750 Asst_title:30 ==============================
  67 ASST_PHONE C 32/ 42 86 Asst_phone:42 ================================----------
- 68 ASST_EXT C 8/ 8 61 Asst_ext ========
- 69 DEPARTMENT C 30/ 30 25 Department:30 ==============================
  70 SPOUSE C 9/ 20 0 Spouse:20 =========-----------
  71 CREATOR C 18/ 50 4939 Creator:50 ==================--------------------------------
- 72 OWNER C 50/ 50 2383 Owner:50 ==================================================
- 73 ALT1REACH N 10/ 10 1183 73 ==========
- 74 ALT2REACH N 10/ 10 156 74 ==========
  75 URL C 31/ 50 804 Url:50 ===============================-------------------
- 76 TICKERSYM C 12/ 12 0 Tickersym:12 ============
- 77 CONT_TYPE N 10/ 10 15 2 ==========
- 78 USR1000 C 35/ 35 2073 1000:35 ===================================
  79 USR1001 C 34/ 42 666 1001:42 ==================================--------
  80 USR1002 C 10/ 75 109 1002:75 ==========-----------------------------------------------------------------
- 81 USR1003 C 20/ 20 259 1003:20 ====================
  82 USR1004 C 7/ 15 0 1004:15 =======--------
- 83 USR1005 C 15/ 15 365 1005:15 ===============
  84 USR1006 C 12/ 15 140 1006:15 ============---
* 85 USR1007 C 75/ 75 748 1007:75 ===========================================================================
  86 USR1008 C 7/ 10 0 1008:10 =======---
  87 USR1009 C 7/ 75 0 1009:75 =======--------------------------------------------------------------------
  88 USR1010 C 13/ 15 28 1010:15 =============--
  89 USR1011 C 7/ 10 0 1011:10 =======---
  90 USR1012 C 7/ 75 0 1012:75 =======--------------------------------------------------------------------
  91 USR1013 C 7/ 15 0 1013:15 =======--------
  92 USR1014 C 7/ 15 0 1014:15 =======--------
- 93 USR1015 C 15/ 15 710 1015:15 ===============
  94 USR1016 C 7/ 15 0 1016:15 =======--------
  95 USR1017 C 7/ 75 0 1017:75 =======--------------------------------------------------------------------
  96 USR1018 C 7/ 15 0 1018:15 =======--------
  97 USR1019 C 7/ 15 0 1019:15 =======--------
- 98 USR1020 C 15/ 15 640 1020:15 ===============
  99 USR1021 C 7/ 10 0 1021:10 =======---
*100 USR1022 C 51/ 75 353 1022:75 ===================================================------------------------
 101 USR1023 C 7/ 15 0 1023:15 =======--------
-102 USR1024 C 15/ 15 692 1024:15 ===============
-103 USR1025 C 15/ 15 610 1025:15 ===============
 104 USR1026 C 7/ 15 0 1026:15 =======--------
 105 USR1027 C 50/ 75 225 1027:75 ==================================================-------------------------
 106 USR1028 C 7/ 15 0 1028:15 =======--------
-107 USR1029 C 15/ 15 4 1029:15 ===============
-108 USR1030 C 15/ 15 603 1030:15 ===============
 109 USR1031 C 9/ 15 9 1031:15 =========------
 *110 USR1032 C 75/ 75 22 1032:75 ==========================================================================
 111 USR1033 C 7/ 15 0 1033:15 =======--------
 112 USR1034 C 10/ 15 20 1034:15 ==========-----
-113 USR1035 C 15/ 15 97 1035:15 ===============
 114 USR1036 C 10/ 15 3477 1036:15 ==========-----
*115 USR1037 C 75/ 75 3 1037:75 ===========================================================================
 116 USR1038 C 7/ 15 0 1038:15 =======--------
 117 USR1039 C 7/ 15 0 1039:15 =======--------
-118 USR1040 C 15/ 15 713 1040:15 ===============
 119 USR1041 C 7/ 10 0 1041:10 =======---
 120 USR1042 C 12/ 75 2 1042:75 ============---------------------------------------------------------------
 121 USR1043 C 7/ 50 0 1043:50 =======-------------------------------------------
 122 USR1044 C 7/ 15 2 1044:15 =======--------
 123 USR1045 C 7/ 15 0 1045:15 =======--------
 124 USR1046 C 7/ 15 0 1046:15 =======--------
 125 USR1047 C 7/ 75 0 1047:75 =======--------------------------------------------------------------------
 126 USR1048 C 7/ 75 0 1048:75 =======--------------------------------------------------------------------
 127 USR1049 C 7/ 15 0 1049:15 =======--------
-128 USR1050 C 15/ 15 251 1050:15 ===============
 129 USR1051 C 8/ 15 117 1051:15 ========-------
 130 USR1052 C 50/ 75 98 1052:75 ==================================================-------------------------
 131 USR1053 C 7/ 15 0 1053:15 =======--------
 132 USR1054 C 13/ 15 1 1054:15 =============--
 133 USR1055 C 8/ 15 2 1055:15 ========-------
-134 USR1056 C 10/ 10 1 1056:10 ==========
*135 USR1057 C 70/ 75 1 1057:75 ======================================================================-----
 136 USR1058 C 7/ 10 0 1058:10 =======---
-137 USR1059 C 15/ 15 1 1059:15 ===============
 138 USR1060 C 13/ 15 148 1060:15 =============--
 139 USR1061 C 7/ 10 0 1061:10 =======---
 140 USR1062 C 7/ 75 0 1062:75 =======--------------------------------------------------------------------
 141 USR1063 C 7/ 10 0 1063:10 =======---
 142 USR1064 C 7/ 15 0 1064:15 =======--------
-143 USR1065 C 15/ 15 297 1065:15 ===============
 144 USR1066 C 8/ 10 147 1066:10 ========--
*145 USR1067 C 72/ 75 461 1067:75 ========================================================================---
 146 USR1068 C 7/ 10 0 1068:10 =======---
 147 USR1069 C 7/ 15 0 1069:15 =======--------
 148 USR1070 C 7/ 15 0 1070:15 =======--------
 149 USR1071 C 7/ 10 0 1071:10 =======---
 150 USR1072 C 7/ 75 0 1072:75 =======--------------------------------------------------------------------
 151 USR1073 C 7/ 10 0 1073:10 =======---
 152 USR1074 C 7/ 15 0 1074:15 =======--------
Totals 2956/2956 Max: 75
 


Order

C I Corporation
800-DATA1-OK

Return

.