Animal Licensing Support Document
Open as: PDF or Word Document
Data Dictionary
Table of Contents
DGSYST : DOG LICENSE SYSTEM FILE
DGBRED : BREED SELECTION FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 B_BREED C 20 0 BREED TO CHOOSE FROM 2 B_DELFLAG C 1 0 DELETE FLAG ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 2 FIELDS = 21 Related Indexes DGBRED : B_DELFLAG+B_BREED
DGCOLR : COLOR SELECTION FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 C_COLOR C 20 0 COLOR TO CHOOSE 2 C_DELFLAG C 1 0 DELETE FLAG ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 2 FIELDS = 21 Related Indexes DGCOLR : C_DELFLAG+C_COLOR
DGDOGS : DOG LICENSE FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 TAG C 6 0 ANIMAL TAG NUMBER 2 TAG_LSTYR C 6 0 LAST YEARS TAG NUMBER 3 ISSUE_DATE D 8 0 LICENSE ISSUE DATE 4 EXP_DATE D 8 0 LICENSE EXPIRATION DATE 5 LASTNAME C 25 0 OWNER: LAST NAME 6 FIRSTNAME C 20 0 OWNER: FIRST NAME 7 ADDR_A C 30 0 ADDRESS A 8 ADDR_B C 30 0 ADDRESS B 9 HOUSE N 4 0 HOUSE # 10 APT C 4 0 APT 11 SUFFIX C 3 0 SUFFIX 12 STCODE C 6 0 STREET CODE 13 TOWN C 25 0 CITY 14 STATE C 10 0 STATE 15 ZIP C 10 0 ZIP 16 PHONE C 17 0 PHONE 17 LOCA_NUM N 5 0 LOCATION STREET # 18 LOCATION C 25 0 LOCATION STREET 19 DOGNAME C 20 0 ANIMAL'S NAME 20 SPECIES C 20 0 ANIMAL'S SPECIES 21 BREED C 20 0 ANIMAL'S BREED 22 SEX C 1 0 SEX (MALE OR FEMALE) 23 NEUTERED C 1 0 IS THE ANIMAL NEUTERED 24 DOB D 8 0 ANIMALS DATE OF BIRTH 25 AGE_YRS N 2 0 AGE IN YEARS 26 AGE_MNTHS N 2 0 AGE IN MONTHS 27 COLOR C 20 0 COLOR 28 SIZE C 1 0 SIZE (SMALL,MEDIUM,LARGE) 29 RAB_DATE D 8 0 RABIES DATE 30 RABEXP D 8 0 RABIES EXPIRATION DATE 31 RABIES_NUM C 7 0 RABIES CERTIFICATE NUMBER 32 ALTERED_DT D 8 0 DATE DOG WAS ALTERED 33 FEE N 7 2 FEE 34 LFEE N 7 2 LATE FEE PAID 35 SFEE N 7 2 STATE FEE 36 KFEE N 7 2 KENNEL FEE 37 BREEDER C 1 0 BREEDED ($0 FOR STATE SPAY/NEUTERING) 38 MISC_A C 3 0 MISC FIELD A 39 MISC_B C 3 0 MISC FIELD B 40 MISC_C C 30 0 MISC FIELD C 41 MISC_D C 30 0 MISC FIELD D 42 NETSTAMP N 2 0 43 DELFLAG C 1 0 DELETE FLAG (* = REUSABLE) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 43 FIELDS = 466 Related Indexes DGNAME : UPPER(LASTNAME+FIRSTNAME) DGTAGS : DELFLAG+TAG+TAG_LSTYR+DTOS(ISSUE_DATE) DGLTAG : DELFLAG+TAG_LSTYR+DTOS(ISSUE_DATE) DGADDR : DELFLAG+STCODE+STRTRAN(STR(HOUSE,4,0),' ','0')+SUFFIX+APT DGBREE : DELFLAG+BREED DGCOLO : DELFLAG+COLOR
DGHIST : DOG HISTORY FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 TAG C 6 0 ANIMAL TAG NUMBER 2 TAG_LSTYR C 6 0 LAST YEARS TAG NUMBER 3 ISSUE_DATE D 8 0 LICENSE ISSUE DATE 4 EXP_DATE D 8 0 LICENSE EXPIRATION DATE 5 LASTNAME C 25 0 OWNER: LAST NAME 6 FIRSTNAME C 20 0 OWNER: FIRST NAME 7 ADDR_A C 30 0 ADDRESS A 8 ADDR_B C 30 0 ADDRESS B 9 HOUSE N 4 0 HOUSE 10 APT C 4 0 APT 11 SUFFIX C 3 0 SUFFIX 12 STCODE C 6 0 STREET CODE 13 TOWN C 25 0 CITY 14 STATE C 10 0 STATE 15 ZIP C 10 0 ZIP 16 PHONE C 17 0 PHONE 17 LOCA_NUM N 5 0 ANIMAL'S LOCATION STREET NUMBER 18 LOCATION C 25 0 ANIMAL'S LOCATION STREET 19 DOGNAME C 20 0 ANIMAL'S NAME 20 SPECIES C 20 0 ANIMAL'S SPECIES 21 BREED C 20 0 ANIMAL'S BREED 22 SEX C 1 0 SEX (MALE OR FEMALE) 23 NEUTERED C 1 0 NEUTERED (YES OR NO) 24 DOB D 8 0 ANIMAL'S DATE OF BIRTH 25 AGE_YRS N 2 0 AGE IN YEARS 26 AGE_MNTHS N 2 0 AGE IN MONTHS 27 COLOR C 20 0 COLOR 28 SIZE C 1 0 SIZE (SMALL,MEDIUM,LARGE) 29 RAB_DATE D 8 0 RABIES DATE 30 RABEXP D 8 0 RABIES EXPIRATION DATE 31 RABIES_NUM C 6 0 RABIES CERTIFICATE NUMBER 32 ALTERED_DT D 8 0 DATE ANIMAL WAS ALTERED 33 FEE N 7 2 FEE 34 LFEE N 7 2 LATE FEE PAID 35 SFEE N 7 2 STATE FEE 36 KFEE N 7 2 KENNEL FEE 37 BREEDER C 1 0 0$ TO STATE FOR SPAY/NEUTERING 38 MISC_A C 3 0 MISC FIELD A 39 MISC_B C 3 0 MISC FIELD B 40 MISC_C C 30 0 MISC FIELD C 41 MISC_D C 30 0 MISC FIELD D 42 NETSTAMP N 2 0 43 DELFLAG C 1 0 DELETE FLAG (* = REUSABLE) 44 REMOVED D 8 0 DATE REMOVED 45 REASON C 30 0 REASON FOR REMOVAL ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 45 FIELDS = 503 Related Indexes DGHNAM : UPPER(LASTNAME+FIRSTNAME) DGHTAG : DELFLAG+TAG+TAG_LSTYR+DTOS(ISSUE_DATE) DGHLTG : DELFLAG+TAG_LSTYR+DTOS(ISSUE_DATE) DGHADD : DELFLAG+STCODE+STRTRAN(STR(HOUSE,4,0),' ','0')+SUFFIX+APT DGHBRE : DELFLAG+BREED DGHCOL : DELFLAG+COLOR
DGSTRE : STREET LIST No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 STCODE C 6 0 STREET CODE 2 STREET C 25 0 STREET NAME 3 DELFLAG C 1 0 DELETE FLAG ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 3 FIELDS = 32 Related Indexes DGSTRE : DELFLAG+STCODE
DGSYST : DOG LICENSE SYSTEM FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 S_SFEE N 7 2 DEFAULT NEUTERED FEMALE FEE 2 S_NFEE N 7 2 DEFAULT NEUTERED MALE FEE 3 S_MFEE N 7 2 DEFAULT MALE UN-NEUTERED FEE 4 S_FFEE N 7 2 DEFAULT FEMALE UN-NEUTERED FEE 5 S_LIFORM C 2 0 LICENSE FORM CODE 6 S_SPECIES C 20 0 DEFAULT SPECIES 7 S_CLERK C 20 0 TOWN CLERK NAME 8 S_RBDATE C 1 0 CALCULATE RABIES EXPIRATION DATE 9 S_MASSADD C 1 0 MASSACHUSETTES ADDRESS 10 S_F05 C 30 0 FUNCTION KEY F5 11 S_F06 C 30 0 FUNCTION KEY F6 12 S_F07 C 30 0 FUNCTION KEY F7 13 S_F08 C 30 0 FUNCTION KEY F8 14 S_F09 C 30 0 FUNCTION KEY F9 15 S_F10 C 30 0 FUNCTION KEY F10 16 S_F11 C 30 0 FUNCTION KEY F11 17 S_F12 C 30 0 FUNCTION KEY F12 18 S_NETSTAMP N 2 0 19 S_RNFORM C 2 0 RENEWAL FORM CODE 20 S_VERDATE D 8 0 DATE OF LAST UPDATE 21 S_PVERSION C 4 0 PREVIOUS NEMRC EXECUTABLE 22 S_VERSION C 4 0 NEMRC EXECUTABLE THAT MATCHES THIS DATA 23 S_YRCLOSE D 8 0 DATE LAST YEAR CLOSE WAS PERFORMED 24 S_LICEXP C 1 0 TRACK VARIABLE LICENSE EXPIRATION DATES? 25 S_LEXPIRE D 8 0 LAST DATE ENTERED AS AN EXPIRATION DATE 26 S_SSFEE N 7 2 DEFAULT NEUTERED FEMALE FEE (STATE) 27 S_NSFEE N 7 2 DEFAULT NEUTERED MALE FEE (STATE) 28 S_MSFEE N 7 2 DEFAULT MALE UN-NEUTERED FEE (STATE) 29 S_FSFEE N 7 2 DEFAULT FEMALE UN-NEUTERED FEE (STATE) 30 S_SLFEE N 7 2 DEFAULT NEUTERED FEMALE FEE (LATE) 31 S_NLFEE N 7 2 DEFAULT NEUTERED MALE FEE (LATE) 32 S_MLFEE N 7 2 DEFAULT MALE UN-NEUTERED FEE (LATE) 33 S_FLFEE N 7 2 DEFAULT FEMALE UN-NEUTERED FEE (LATE) ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 33 FIELDS = 405
