0.003/13/99 LORI J HAUGEN 1.0 PROGRAM NARRATIVE ----------------- PROGRAM MAS530, DUPLICATE EDIT, PRODUCES A LISTING SHOWING POS- SIBLE DUPLICATES IN SELECTED GROUPS AND/OR SUBGROUPS FROM THE MASS MAILING DATABASE. THE PROGRAM READS AN INPUT RECORD CONTAINING A REQUEST NUMBER, A GROUP NUMBER, A SELECTION TYPE, AND POSSIBLY A LIST OF SUBGROUP CODES. THE SELECTION TYPE INDICATES WHETHER AN ENTIRE MASS MAILING GROUP IS BEING SELECTED, OR ONLY CERTAIN SUB- GROUP(S) OF A MASS MAILING GROUP. UP TO 75 INPUT RECORDS MAY BE SPECIFIED. RECORDS ARE CONSIDERED DUPLICATES IF THE LAST NAMES ARE IDENTICAL, THE FIRST NAMES MATCH UP 40% OR BETTER, THE ADDRESSES ARE 80% OR BETTER AND THE ZIPCODES MATCH. RECORDS ARE ALSO CONSIDERED DUPLICATES IF THE ADDRESSES MATCH UP 100% AND THE ZIPCODES ARE IDENTICAL. THE PERCENTAGES ARE FOUND BY TAKING THE LENGTH OF THE LONGEST NAME AND DIVIDING IT INTO THE NUMBER OF MATCHING LETTERS IN BOTH NAMES. CERTAIN INPUT STANDARDS SHOULD BE USED WITH MAS030, MASS MAILING DETAIL UPDATE, IN ORDER TO MAKE THIS A MORE RELIABLE PROCEDURE. THE FOLLOWING PAGE PROVIDES A LIST OF RECOMMENDED INPUT STANDARDS TO BE USED WHEN ENTERING THE MASS MAILING DATA. * MAS030 RECOMMENDED INPUT STANDARDS ---------------------------------- 1. USE CONSISTANCY WHEN ENTERING ABBREVIATIONS. ALWAYS USE THE SAME ABBREVIATIONS AND PUNCTUATION (I.E., ST., BLVD., DR., MRS., JR., SR., ETC.). DO NOT MIX ABBREVIATED AND NON-ABBREVIATED TEXT. FOR EXAMPLE, ON STREET ADDRESSES, DECIDE WHETHER YOU WISH TO USE THE ABBREVIATED FORM (ST.) OR THE SPELLED OUT FORM (STREET) AND ALWAYS USE THIS SAME FORMAT. 2. THE POST OFFICE BOX ADDRESSES ARE THE MOST COMMON CAUSE OF INCONSISTANCY. THE RECOMMENDED FORMAT FOR ENTERING THESE ADDRESSES IS P. O. BOX OR P. O. DRAWER. --------- ------------ 3. ADOPT A CONSISTANT METHOD OF ENTERING APARTMENT NUMBERS AND PUNCTUATION (I.E., 1515 ANYWHERE ST., APT. 42). 4. ENTER NUMBERED STREET NAMES CONSISTANTLY. A GENERAL RULE IS TO SPELL STREET NAMES OF ONE THROUGH TEN (I.E., 22 FIRST ST.) AND USE THE NUMBERED DESIGNATION FOR OTHERS (I.E., 22 - 25TH ST.). NOTE THAT THE STANDARD USE OF DASHES AND SPACES IS IMPORTANT WITH THE LATTER. 5. USE SPACES AND PUNCTUATION CONSISTANTLY. TWO CONSECUTIVE INITIALS (R. U. MILLER) SUFFIXES (FRED R. WALKER, JR.) DIRECTIONAL ABBREVIATIONS (44 N. ARMISTEAD AVE.) FIRM NAMES (JONES, SMITH & JONES) 6. AND MOST IMPORTANTLY, PLEASE DELETE THE DUPLICATE ENTRIES FROM THE DATABASE ONCE THEY ARE IDENTIFIED ON THE MAS530 REPORT. THIS WILL SAVE YOUR TIME BY ELIMINATING THE TASK OF REMOVING DUPLICATE LABELS PRIOR TO EACH MAILING. * 2.0 SAMPLE JCL ---------- 2.1 RUN JCL ------- //TNMAS530 JOB (XXXX,YYYY,9,29),MAS530,CLASS=F, // MSGCLASS=A,MSGLEVEL=(1,1),PRTY=3,REGION=4096K /*ROUTE PRINT RMTZZ //MAS530 EXEC MAS530,AGENCY=XXX,COLLEGE=XX //MAS530.PARMCARD DD * --INPUT PARAMETER -- /* // SYMBOLIC DESCRIPTION ******************** REQUIRED - AGENCY COLLEGE AGENCY CODE NUMBER (E.G. AGENCY=293) COLLEGE TWO CHARACTER COLLEGE NAME ABBREVIATION (E.G. COLLEGE=TN) OPTIONAL - FORM THE FORM NUMBER THAT THE REPORT IS TO BE PRINTED ON. DEFAULT: 0001 (STANDARD ONE-PART) (E.G. FORM=A000) QUEUE QUEUE CLASS THE OUTPUT IS TO BE SPOOLED UNDER DEFAULT: * (E.G. QUEUE='A') DBTYPE INDICATES WHETHER OR NOT TO USE TEST OR PRODUCTION DATA BASES DEFAULT: PROD (E.G. DBTYPE=TEST) RUNTYPE INDICATES WHETHER OR NOT TO USE TEST OR PRODUCTION FILES DEFAULT: PROD (E.G. RUNTYPE=TEST) SRTSIZE AMOUNT OF DASD STORAGE IN CYLINDERS ALLOCATED TO EACH SORT WORK FILE DEFAULT=3 (E.G. SRTSIZE=4) 2.2 INPUT PARAMETERS ---------------- NOTE: UP TO 75 INPUT RECORDS MAY BE SPECIFIED. TO TREAT TWO OR MORE MASS MAILING GROUPS AS A SINGLE SET OF DATA IN CHECKING FOR POSSIBLE DUPLICATE ENTRIES: SPECIFY ONE INPUT RECORD FOR EACH PERTINENT GROUP CODE, USING THE SAME REQUEST NUMBER FOR EACH INPUT RECORD. TO PROCESS EACH MASS MAILING GROUP INDEPENDENTLY: SPECIFY ONE INPUT RECORD FOR EACH PERTINENT GROUP CODE, USING A UNIQUE REQUEST NUMBER FOR EACH INPUT RECORD. POS CONTENTS --- -------- 01-04 REQUEST NUMBER (I.E., 0001). 05-08 GROUP CODE NUMBER (I.E., 3300). 09-09 SELECTION TYPE: '1' OR BLANK SPACE - SELECT ALL MASDETAL SEGMENTS IN THE SPECIFIED MASS MAILING GROUP. '2' - SELECT ONLY MASDETAL SEGMENTS IN THE SPECIFIED MASS MAILING GROUP THAT HAVE AT LEAST ONE OF THE SPECIFIED SUBGROUP CODES. 10-27 SUBGROUP CODES - SUBGROUP CODES TO BE SELECTED WITHIN THE SPECIFIED MASS MAILING GROUP. UP TO 9 CODES MAY BE SPECIFIED. (USED ONLY FOR SELECTION TYPE '2'.) 28-80 NOT USED. 2.3 SORT PARAMETERS --------------- NO SORT PARAMETERS ARE USED. 3.0 JOB SETUP INSTRUCTIONS ---------------------- SPECIAL FORMS QUEUE: 0001 - STANDARD FORMS BUFFER: STANDARD ALIGNMENT INSTRUCTIONS: STANDARD PRINTED OUTPUT: MASS MAILING DUPLICATE EDIT REPORT FORMS TYPE: STANDARD SPECIAL INSTRUCTIONS: 4.0 FILES ----- 4.1 DATA BASE SEGMENTS USED: 1. MASDBD A. MASGROUP (READ) B. MASDETAL (READ) 2. CTLDBD A. CTLCAMP (READ) 4.2 ADDITIONAL FILES USED: N/A 4.3 INPUT/OUTPUT RECORD LAYOUT: N/A 5.0 SPECIAL OUTPUT MESSAGES ----------------------- 5.1 ERROR MESSAGES ERRORS IN THE PARAMETER RECORDS WILL BE DETECTED AND AN APPROPRIATE MESSAGE WILL BE PRINTED. THE OPERATOR SHOULD CORRECT THE PARAMETER RECORDS AND RERUN THE JOB. ERRORS RESULTING FROM DL/I CALLS WILL ALSO CAUSE THE PROGRAM TO TERMINATE. THESE CONDITIONS SHOULD BE BROUGHT TO THE ATTENTION OF THE SIS COORDINATOR. 6.0 SPECIAL FEATURES ---------------- 6.1 CALLING PROGRAMS: N/A 6.2 SUBPROGRAMS CALLED: UTL100S 6.3 MESSAGE CODES: N/A 7.0 PROGRAM OPTIONS: N/A --------------- 8.0 PROGRAM CHANGE HISTORY: ---------------------- 8.1 VERSION NO: V3.13 (INITIAL RELEASE) CHANGE DATE: 06-88 PROGRAMMER NAME: LORI J HAUGEN PROGRAM CHANGE REQUEST NO: N/A DESCRIPTION OF CHANGE: N/A 8.2 VERSION NO: V4.02 CHANGE DATE: 05-89 PROGRAMMER NAME: DARRELL SCRUGGS PROGRAM CHANGE REQUEST NO: 00002889 DESCRIPTION OF CHANGE: INCREASE PAGE COUNTER. 8.3 VERSION NO: V4.03 CHANGE DATE: 06/16/89 PROGRAMMER NAME: EUGENE WALLO PROGRAM CHANGE REQUEST NO: 3101 DESCRIPTION OF CHANGE: -ADDED THE SUBGROUP CODES OF THE MASDETAL SEGMENT TO THE RE- PORT. -CHANGED THE PROGRAM TO USE THE NEW COPYLIB MEMBERS (MASGROUP AND MASDETAL), INSTEAD OF USING HARD-CODED FIELD DEFINIT- IONS. PROGRAM CHANGE REQUEST NO: NONE DESCRIPTION OF CHANGE: -CHANGED THE PROGRAM TO USE A GENERIC I/O AREA FOR ALL DL/I CALLS. -CHANGED THE CTLDBD PCB KEY LENGTH IN THE PROGRAM FROM 5 TO 10. -ADDED THE DBTYPE AND RUNTYPE SYMBOLIC PARAMETERS TO THE DOC- UMENTATION. -CORRECTED THE SRTSIZE DEFAULT VALUE IN THE DOCUMENTATION. -CORRECTED THE FORM DEFAULT VALUE IN THE COMMENTS OF THE PROC. -REMOVED THE REGION PARAMETER FROM THE PROC. 8.4 VERSION NO: V4.05 CHANGE DATE: 08/18/89 PROGRAMMER NAME: EUGENE WALLO PROGRAM CHANGE REQUEST NO: 3225 DESCRIPTION OF CHANGE: -CHANGED THE PROGRAM TO HAVE THE CAPABILITY OF SELECTING BY SUBGROUP CODES WITHIN EACH MASS MAILING GROUP CODE SELECTED. 8.5 VERSION NO: V4.15 CHANGE DATE: 08/15/90 PROGRAMMER NAME: EUGENE WALLO PROGRAM CHANGE REQUEST NO: 00004608 DESCRIPTION OF CHANGE: -CHANGED THE PROGRAM TO ACCOMMODATE THE V4.10 CHANGES TO COPYLIB MEMBER "MASDETAL". DATANAME "TITLE" WAS CHANGED TO "JOB-TITLE". PROGRAM CHANGE REQUEST NO: 00006018 DESCRIPTION OF CHANGE: -CHANGED THE PROGRAM TO ACCOMMODATE THE V4.15 CHANGES TO COPYLIB MEMBER "MASDETAL". THE SIZES OF THE "NAME", "JOB-TITLE", AND "STREET" FIELDS WERE CHANGED FROM 34 BYTES TO 33 BYTES. PROGRAM CHANGE REQUEST NO: 00006096 DESCRIPTION OF CHANGE: -CHANGED THE REPORT TO INCLUDE THE LAST-UPDATE FIELD OF THE MASDETAL SEGMENT. CHANGE REQUEST NO: NONE DESCRIPTION OF CHANGE: -CHANGED THE PROGRAM TO ACCOMMODATE THE COBOL-II MIGRATION. 8.6 VERSION NO: V4.35 CHANGE DATE: 05/28/92 PROGRAMMER NAME: EUGENE WALLO PROGRAM CHANGE REQUEST NO: 00008419 DESCRIPTION OF CHANGE: - CHANGED THE DOCUMENTATION TO EXPLAIN HOW TWO OR MORE MASS MAILING GROUPS CAN BE TREATED AS A SINGLE SET OF DATA IN CHECKING FOR POSSIBLE DUPLICATE ENTRIES. 8.7 VERSION NO: V7.02 CHANGE DATE: 07/15/98 PROGRAMMER NAME: DIANE LIVELY PROGRAM CHANGE REQUEST NO: NONE DESCRIPTION OF CHANGE: CHANGED PROGRAM FOR THE NEW COMPILER AND Y2K.