Cemetery FAQ
Data Dictionary
. 01/07/02 NEMRC Customer Support Page 1 04:24 pm Filename: CMLOCA File Description: Plot Locator File No Field Name Type Len Dec Description of field -------------------------------------------------------------------------------- 1 L_LOCATION C 3 0 PLOT LOCATION 2 L_DESC C 20 0 DESCRIPTION OF LOCATION 3 L_NUMPLOTS N 5 0 TOTAL NUMBER OF PLOTS FOR LOCATION 4 L_CARETAKE C 30 0 CARETAKER OF THE LOCATION 5 L_DELFLAG C 1 0 * IF DELETED 6 L_NETSTAMP N 2 0 NETWORK STAMP -------------------------------------------------------------------------------- TOTAL LENGTH OF ALL 6 FIELDS = 61 Related Indexes CMLOCA : L_DELFLAG+L_LOCATION . 01/07/02 NEMRC Customer Support Page 1 04:24 pm Filename: CMPLOT File Description: Cemetary Plot File No Field Name Type Len Dec Description of field -------------------------------------------------------------------------------- 1 P_LNAME C 25 0 DECEASED LAST NAME 2 P_FNAME C 25 0 DEACESED FIRST NAME 3 P_OLNAME C 25 0 OWNER LAST NAME 4 P_SEX C 1 0 MALE FEMALE 5 P_MAIDEN C 25 0 DECEASED MAIDEN NAME, IF FEMALE 6 P_FILLDATE D 8 0 DATE THE GRAVE WAS FILLED 7 P_OFNAME C 25 0 OWNER FIRST NAME 8 P_LOTNUM C 5 0 PLOT ID NUMBER 9 P_PURDATE D 8 0 DATE PLOT WAS FUNDED 10 P_COST N 9 2 COST OF THE PLOT 11 P_BALANCE N 9 2 BALANCE OWED ON PLOT 12 P_ROWNUM C 4 0 ROW NUMBER 13 P_GRAVENUM C 4 0 GRAVE NUMBER 14 P_LOCATION C 3 0 LOCATION OF PLOT 15 P_PLOTSIZE N 2 0 PLOT SIZE 16 P_CREAMATE C 1 0 CREAMATED STATUS 17 P_GRAVETYP C 1 0 GRAVE TYPE 18 P_LIFEB C 4 0 DATE LIFE BEGAN 19 P_LIFEE C 4 0 DATE LIFE ENDED 20 P_WAR C 25 0 WAR SERVED IN, IF ANY 21 P_NOTES M 0 0 ANTHING THE USER WANT TO ENTER 22 P_MISC0 C 25 0 MISC FIELD 0 23 P_MISC1 C 25 0 MISC FIELD 1 24 P_MISC2 C 25 0 MISC FIELD 2 25 P_MISC3 C 25 0 MISC FIELD 3 26 P_MISC4 C 25 0 MISC FIELD 4 27 P_MISC5 C 25 0 MISC FIELD 5 28 P_MISC6 C 25 0 MISC FIELD 6 29 P_MISC7 C 25 0 MISC FIELD 7 30 P_MISC8 C 25 0 MISC FIELD 8 31 P_MISC9 C 25 0 MISC FIELD 9 32 P_DELFLAG C 1 0 * IF DELETED 33 P_NETSTAMP N 2 0 NETWORK STAMP -------------------------------------------------------------------------------- TOTAL LENGTH OF ALL 33 FIELDS = 466 Related Indexes CMPLOT : P_DELFLAG+P_LOCATION+P_LOTNUM+P_ROWNUM+P_GRAVENUM CMDNAM : P_DELFLAG+P_LNAME+P_FNAME CMONAM : P_DELFLAG+P_OLNAME+P_OFNAME CMLCOW : P_DELFLAG+P_LOCATION+P_OLNAME+P_OFNAME CMLCDM : P_DELFLAG+P_LOCATION+P_LNAME+P_FNAME . 01/07/02 NEMRC Customer Support Page 1 04:24 pm Filename: CMSYST File Description: Cemetery System File No Field Name Type Len Dec Description of field -------------------------------------------------------------------------------- 1 S_F05 C 30 0 FUNCTION KEY F5 2 S_F06 C 30 0 FUNCTION KEY F6 3 S_F07 C 30 0 FUNCTION KEY F7 4 S_F08 C 30 0 FUNCTION KEY F8 5 S_F09 C 30 0 FUNCTION KEY F9 6 S_F10 C 30 0 FUNCTION KEY F10 7 S_F11 C 30 0 FUNCTION KEY F11 8 S_F12 C 30 0 FUNCTION KEY F12 9 S_MISC0 C 10 0 MISC DESCRIPTION 10 S_MISC1 C 10 0 MISC DESCRIPTION 11 S_MISC2 C 10 0 MISC DESCRIPTION 12 S_MISC3 C 10 0 MISC DESCRIPTION 13 S_MISC4 C 10 0 MISC DESCRIPTION 14 S_MISC5 C 10 0 MISC DESCRIPTION 15 S_MISC6 C 10 0 MISC DESCRIPTION 16 S_MISC7 C 10 0 MISC DESCRIPTION 17 S_MISC8 C 10 0 MISC DESCRIPTION 18 S_MISC9 C 10 0 MISC DESCRIPTION 19 S_ALLOW0 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N) 20 S_ALLOW1 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N) 21 S_ALLOW2 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N) 22 S_ALLOW3 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N) 23 S_ALLOW4 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N) 24 S_ALLOW5 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N) 25 S_ALLOW6 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N) 26 S_ALLOW7 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N) 27 S_ALLOW8 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N) 28 S_ALLOW9 C 1 0 ALLOW REPORT/PROCEDURE RANGES (Y/N) 29 S_NETSTAMP N 2 0 NETWORK STAMP 30 S_VERSION C 4 0 NEMRC EXECUTABLE THAT MATCHES THIS DATA 31 S_OLDVER C 4 0 PREVIOUS INSTALLED VERSION OF THE MODULE 32 S_UPVER D 8 0 DATE THE NEW VERSION WAS INSTALLED -------------------------------------------------------------------------------- TOTAL LENGTH OF ALL 32 FIELDS = 368 :