Vitals Marriage Support Document
Open as: PDF or Word Document
Data Dictionary
Table of Contents
VMCODE : MARRIAGE CODE FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 C_CODE C 4 0 MARRIAGE/CIVIL UNION CODE 2 C_DESC C 30 0 CODE DESCRIPTION 3 C_COLOR C 3 0 CODE COLOR 4 C_NETSTAMP N 2 0 NETWORK SIGNATURE 5 C_DELFLAG C 1 0 DELETION FLAG ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 5 FIELDS = 40 Related Indexes VMCODE : C_DELFLAG + C_CODE VMDESC : C_DELFLAG + C_DESC VMMARR : MARRIAGE FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 H_INT_NUM C 6 0 INTENTION NUMBER 2 H_MAR_NUM C 6 0 MARRIAGE NUMBER 3 H_INT_DATE D 8 0 INTENTION DATE 4 H_MAR_DATE D 8 0 MARRIAGE DATE (APPLICATION DATE) 5 H_DATE D 8 0 AFFIRMATION DATE (DATE OF CEREMONY) 6 H_CERT_DAT D 8 0 DATE OF CERTIFICATE 7 H_CULAP C 1 0 CVL UNION LICENSE/APPLICATION OR MARRIAGE 8 H_ACODE C 4 0 GROOM OR PARTY A CODE 9 H_BCODE C 4 0 BRIDE OR PARTY B CODE 10 H_GFNAME C 25 0 GROOM: LAST NAME 11 H_GMIDDLE C 15 0 GROOM: MIDDLE INITIAL 12 H_GLNAME C 25 0 GROOM: FIRST NAME 13 H_GSURNAME C 25 0 GROOM: SURNAME 14 H_GEXT C 5 0 GROOM: NAME EXTENSION (JR., SR.) 15 H_GDOB D 8 0 GROOM: DATE OF BIRTH 16 H_GSEX C 1 0 GROOM: SEX 17 H_GOCCUP C 20 0 GROOM: OCCUPATION 18 H_GADD1 C 25 0 GROOM: ADDRESS 1 19 H_GADD2 C 25 0 GROOM: ADDRESS 2 20 H_GCITY C 25 0 GROOM: CITY 21 H_GSTATE C 10 0 GROOM: STATE 22 H_GZIP C 10 0 GROOM: ZIP CODE 23 H_GMADD1 C 25 0 GROOM: MAILING ADDRESS 1 24 H_GMADD2 C 25 0 GROOM: MAILING ADDRESS 2 25 H_GMCITY C 25 0 GROOM: MAILING CITY 26 H_GMSTATE C 10 0 GROOM: MAILING STATE 27 H_GMZIP C 10 0 GROOM: MAILING ZIP 28 H_GNUMMAR N 2 0 GROOM: NUMBER OF MARRIAGES 29 H_GOCCUPAT C 25 0 PARTY A GROOM OCCCUPATION 30 H_GLMSTAT C 1 0 LAST MARRIAGE STATUS 31 H_GGUARD C 1 0 DOES THE GROOM HAVE A LEGAL GUARDIAN? 32 H_GBIRLOCA C 25 0 BIRTH LOCATION 33 H_GMOTHER C 30 0 MOTHER'S FULL MAIDEN NAME 34 H_GMBIRTH C 15 0 MOTHER'S BIRTH PLACE 35 H_GFATHER C 30 0 FATHER'S FULL NAME 36 H_GFBIRTH C 15 0 FATHER'S BIRTH PLACE 37 H_BFNAME C 25 0 BRIDE: FIRST NAME 38 H_BMIDDLE C 15 0 BRIDE: MIDDLE INITIAL 39 H_BLNAME C 25 0 BRIDE: LAST NAME 40 H_BSURNAME C 25 0 BRIDE: SURNAME 41 H_BEXT C 5 0 BRIDE: EXTENSION NAME 42 H_BDOB D 8 0 BRIDE: DATE OF BIRTH 43 H_BSEX C 1 0 BRIDE: SEX 44 H_BOCCUP C 20 0 BRIDE: OCCUPATION 45 H_BADD1 C 25 0 BRIDE: ADDRESS LINE 1 46 H_BADD2 C 25 0 BRIDE: ADDRESS LINE 2 47 H_BCITY C 25 0 BRIDE: CITY 48 H_BSTATE C 10 0 BRIDE: STATE 49 H_BZIP C 10 0 BRIDE: ZIP 50 H_BMADD1 C 25 0 BRIDE: MAILING ADDRESS 1 51 H_BMADD2 C 25 0 BRIDE: MAILING ADDRESS 1 52 H_BMCITY C 25 0 BRIDE: CITY 53 H_BMSTATE C 10 0 BRIDE: MAILING STATE 54 H_BMZIP C 10 0 BRIDE: MAILING ZIP 55 H_BNUMMAR N 2 0 BRIDE: NUMBER OF MARRIAGES 56 H_BLMSTAT C 1 0 BRIDE: LAST MARRIAGE STATUS 57 H_BGUARD C 1 0 DOES THE BRIDE HAVE A LEGAL GUARDIAN? 58 H_BBIRLOCA C 25 0 LOCATION OF BIRTH 59 H_BMOTHER C 30 0 MOTHER'S FULL MAIDEN NAME 60 H_BMBIRTH C 15 0 MOTHER'S BIRTH PLACE 61 H_BFATHER C 30 0 FATHER'S FULL NAME 62 H_BFBIRTH C 15 0 FATHER'S BIRTH PLACE 63 H_BOCCUPAT C 25 0 PARTY B BRIDE OCCCUPATION 64 H_MARLOC C 25 0 MARRIAGE LOCATION 65 H_PASTOR C 25 0 NAME OF PERSON WHO PERFORMED CEREMONY 66 H_OFFSTAT C 25 0 OFFICIAL STATION 67 H_OADDR C 25 0 ADDRESS OF OFFICIANT 68 H_OCITY C 25 0 OFFICIANT'S CITY 69 H_OSTATE C 2 0 OFFICIANT'S STATE 70 H_OZIP C 10 0 OFFICIANT'S ZIP CODE 71 H_NOTES M 0 0 NOTES 72 H_DELFLAG C 1 0 DELETE FLAG 73 H_NETSTAMP N 2 0 NETWORK STAMP 74 H_BOOK N 4 0 NUMBER OF BOOK MARRIAGE IS LISTED 75 H_PAGE N 4 0 PAGE NUMBER IN BOOK 76 H_BOOKK C 4 0 CHARACTER FIELD FOR BOOK NUMBER 77 H_PAGEE C 4 0 CHARACTER FIELD FOR PAGE NUMBER 78 H_ACARD L 1 0 PRINTED INDEX CARD FOR GROOM/PARTY A? 79 H_BCARD L 1 0 PRINTED INDEX CARD FOR BRIDE/PARTY B? 80 H_CONFID M 0 0 CONFIDENTIAL MARRIAGE INFO ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 80 FIELDS = 1127 Related Indexes VMREGS : H_DELFLAG + ALLTRIM(STR(YEAR(H_MAR_DATE))) + H_MAR_NUM VMGROM : H_DELFLAG + UPPER(H_GLNAME + H_GFNAME) VMDATE : H_DELFLAG + DTOS(H_MAR_DATE) VMBRID : H_DELFLAG + UPPER(H_BLNAME + H_BFNAME) VMINTE : H_DELFLAG + ALLTRIM(STR(YEAR(H_INT_DATE))) + H_INT_NUM VMOFFI : OFFICIANTS No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 H_PASTOR C 25 0 NAME OF PERSON WHO PERFORMED CEREMONY 2 H_OFFSTAT C 25 0 OFFICIAL STATION 3 H_OADDR C 25 0 ADDRESS OF OFFICIANT 4 H_OCITY C 25 0 OFFICIANT'S CITY 5 H_OSTATE C 2 0 OFFICIANT'S STATE 6 H_OZIP C 10 0 OFFICIANT'S ZIP CODE 7 H_DELFLAG C 1 0 DELETED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 7 FIELDS = 113 Related Indexes VMOFFI : H_DELFLAG+H_PASTOR VMSYST : MARRIAGE SYSTEM FILE No Field Name Type Len Dec Description of field ----------------------------------------------------------------------------- 1 S_CLERK C 25 0 TOWN CLERK NAME 2 S_FORM C 2 0 MARRIAGE LICENSE FORM TO USE 3 S_LICEXP N 3 0 MARRIAGE LICENSE EXPIRATION PERIOD 4 S_OFFSET N 5 0 LASER MARRIAGE LICENSE PRINT OFFSET 5 S_UAFORM C 2 0 CIVIL UNION APPLICATON FORM TO USE 6 S_ULFORM C 2 0 CIVIL UNION LICENSE FORM TO USE 7 S_ULICEXP N 3 0 CIVIL UNION LICENSE EXPIRATION PERIOD 8 S_UOFFSET N 5 0 LASER CIVIL UNION LICENSE PRINT OFFSET 9 S_COLOR C 1 0 USE COLOR INDEX CARDS (Y/N) ? 10 S_STATE C 2 0 STATE USING PROGRAM 11 S_ORDER N 1 0 LAST ORDER SELECTED IN LOOKUPS 12 S_F05 C 30 0 FUNCTION KEY F05 13 S_F06 C 30 0 FUNCTION KEY F06 14 S_F07 C 30 0 FUNCTION KEY F07 15 S_F08 C 30 0 FUNCTION KEY F08 16 S_F09 C 30 0 FUNCTION KEY F09 17 S_F10 C 30 0 FUNCTION KEY F10 18 S_F11 C 30 0 FUNCTION KEY F11 19 S_F12 C 30 0 FUNCTION KEY F12 20 S_MISC0 C 10 0 MISC FIELD 0 21 S_MISC1 C 10 0 MISC FIELD 1 22 S_MISC2 C 10 0 MISC FIELD 2 23 S_MISC3 C 10 0 MISC FIELD 3 24 S_MISC4 C 10 0 MISC FIELD 4 25 S_MISC5 C 10 0 MISC FIELD 5 26 S_MISC6 C 10 0 MISC FIELD 6 27 S_MISC7 C 10 0 MISC FIELD 7 28 S_MISC8 C 10 0 MISC FIELD 8 29 S_MISC9 C 10 0 MISC FIELD 9 30 S_ALLOW0 C 1 0 ALLOWANCE FIELD 0 31 S_ALLOW1 C 1 0 ALLOWANCE FIELD 1 32 S_ALLOW2 C 1 0 ALLOWANCE FIELD 2 33 S_ALLOW3 C 1 0 ALLOWANCE FIELD 3 34 S_ALLOW4 C 1 0 ALLOWANCE FIELD 4 35 S_ALLOW5 C 1 0 ALLOWANCE FIELD 5 36 S_ALLOW6 C 1 0 ALLOWANCE FIELD 6 37 S_ALLOW7 C 1 0 ALLOWANCE FIELD 7 38 S_ALLOW8 C 1 0 ALLOWANCE FIELD 8 39 S_ALLOW9 C 1 0 ALLOWANCE FIELD 9 40 S_DELFLAG C 1 0 DELETE FLAG 41 S_NETSTAMP N 2 0 SYSTEM STAMP 42 S_VERSION C 4 0 VERSION NUMBER 43 S_OLDVER C 4 0 PREVIOUS INSTALLED VERSION OF THE MODULE 44 S_UPVER D 8 0 DATE THE NEW VERSION WAS INSTALLED ----------------------------------------------------------------------------- TOTAL LENGTH OF ALL 44 FIELDS = 420
