Field Length Analysis: BDS C:\ACT\DATABASE\BDS.DBF Field Field Data Needed Extra Records Number Name Type Len Dec Length Bytes Used 1 UNIQUE_ID C 12 0 12 0 4371 2 CTIME C 6 0 6 0 4371 3 ETIME C 6 0 6 0 4371 4 MTIME C 6 0 6 0 81 5 PUB_STATUS N 1 0 1 0 4371 6 USER C 12 0 12 0 4371 7 COMPANY C 50 0 50 0 4365 8 NAME C 50 0 39 11 2555 9 ADDR1 C 50 0 43 7 4000 10 ADDR2 C 30 0 30 0 1861 11 ADDR3 C 30 0 30 0 353 12 CITY C 30 0 24 6 4014 13 STATE C 20 0 14 6 4247 14 ZIP C 10 0 10 0 2536 15 COUNTRY C 25 0 13 12 10 16 IDSTATUS C 25 0 22 3 736 17 PHONE C 42 0 32 10 2897 18 FAX C 42 0 32 10 2 19 HOME_PHONE C 42 0 32 10 18 20 MOBILPHONE C 42 0 32 10 199 21 PAGER C 42 0 5 37 1 22 SALUTATION C 30 0 12 18 2538 23 LAST_MEET C 8 0 8 0 4 24 LAST_REACH C 8 0 8 0 186 25 LAST_ATMPT C 8 0 8 0 179 26 LTTR_DATE C 8 0 8 0 11 27 TITLE C 50 0 30 20 2346 28 ASSISTANT C 50 0 30 20 2012 29 LAST_RSLTS C 75 0 75 0 3114 30 REFER_BY C 30 0 30 0 1544 31 USER1 C 50 0 9 41 3449 32 USER2 C 50 0 29 21 2916 33 USER3 N 10 0 7 3 1008 34 USER4 C 50 0 19 31 3506 35 USER5 C 50 0 12 38 2881 36 USER6 C 50 0 50 0 2284 37 USER7 C 75 0 57 18 1536 38 USER8 C 75 0 30 45 90 39 USER9 C 75 0 75 0 893 40 USER10 C 50 0 23 27 292 41 USER11 C 50 0 50 0 395 42 USER12 C 50 0 20 30 492 43 USER13 C 50 0 50 0 135 44 USER14 C 50 0 50 0 556 45 USER15 C 50 0 50 0 302 46 ALTADDR1 C 50 0 25 25 28 47 ALTADDR2 C 30 0 30 0 1297 48 ALTCITY C 30 0 25 5 1142 49 ALTSTATE C 25 0 0 25 0 50 ALTZIP C 25 0 12 13 372 51 ALTCOUNTRY C 25 0 10 15 1 52 ALTPHONE C 42 0 8 34 1 53 NAME2 C 50 0 25 25 1065 54 TITLE2 C 50 0 26 24 32 55 PHONE2 C 42 0 32 10 13 56 NAME3 C 50 0 25 25 24 57 TITLE3 C 50 0 29 21 200 58 PHONE3 C 42 0 32 10 5 59 FNAME C 50 0 12 38 2537 60 LNAME C 50 0 17 33 2555 61 EXT C 8 0 3 5 500 62 FAX_EXT C 8 0 7 1 29 63 ALTEXT C 8 0 6 2 4 64 PHONE2_EXT N 19 5 4 15 2 65 PHONE3_EXT N 19 5 1 18 0 66 ASST_TITLE C 50 0 14 36 3 67 ASST_PHONE C 42 0 32 10 2 68 ASST_EXT C 8 0 8 0 1 69 DEPARTMENT C 50 0 10 40 1 70 SPOUSE C 50 0 6 44 1 71 CREATOR C 50 0 18 32 4362 72 OWNER C 50 0 15 35 4298 73 ALT1REACH C 8 0 8 0 1 74 ALT2REACH C 8 0 8 0 1 75 URL C 75 0 22 53 10 76 TICKERSYM C 12 0 9 3 1 77 CONT_TYPE N 1 0 1 0 11 78 USR1000 C 10 0 10 0 184 79 USR1001 C 10 0 8 2 184 80 USR1002 C 10 0 8 2 177 81 USR1003 C 20 0 12 8 1530 82 USR1004 C 10 0 10 0 4233 83 USR1005 C 50 0 7 43 1 84 USR1006 C 20 0 12 8 6 85 USR1007 C 75 0 7 68 1 86 USR1008 C 10 0 7 3 1 87 USR1009 C 75 0 7 68 1 88 USR1010 C 25 0 13 12 4 89 USR1011 C 10 0 7 3 1 90 USR1012 C 25 0 12 13 4 91 USR1013 C 10 0 7 3 1 92 USR1014 C 75 0 7 68 1 93 USR1015 C 10 0 0 10 0 94 USR1016 C 20 0 6 14 1 95 USR1017 C 50 0 34 16 953 96 USR1018 C 42 0 32 10 136 97 USR1019 C 50 0 27 23 6 98 USR1020 C 40 0 25 15 2 99 USR1021 C 25 0 7 18 1 100 USR1022 C 42 0 32 10 332 101 USR1023 C 50 0 25 25 1611 102 USR1024 C 40 0 25 15 1603 103 USR1025 C 25 0 0 25 0 104 USR1026 C 25 0 0 25 0 105 USR1027 C 25 0 0 25 0 106 USR1028 C 25 0 0 25 0 107 USR1029 C 25 0 0 25 0 108 USR1030 C 25 0 7 18 1 109 USR1031 C 25 0 7 18 1 110 USR1032 C 25 0 7 18 1 111 USR1033 C 25 0 7 18 1 112 USR1034 C 25 0 7 18 1 113 USR1035 C 75 0 7 68 1 114 USR1036 C 25 0 7 18 1 115 USR1037 C 25 0 7 18 1 116 USR1038 C 25 0 7 18 1 117 USR1039 C 25 0 7 18 1 118 USR1040 C 25 0 7 18 1 119 USR1041 C 25 0 7 18 1 120 USR1042 C 25 0 12 13 3 121 USR1043 C 25 0 0 25 0 122 USR1044 C 25 0 7 18 1 123 USR1045 C 75 0 7 68 1 124 USR1046 C 25 0 7 18 1 125 USR1047 C 25 0 7 18 1 126 USR1048 C 25 0 3 22 2 127 USR1049 C 20 0 20 0 3 128 USR1050 C 25 0 13 12 1324 129 USR1051 C 20 0 12 8 712 **TOTAL** 4271 2190 2081