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

        :                                                                       
							

© NEMRC 2010-2023 | Privacy Policy