Land Records Support Document

Open as: PDF or Word Document

Data Dictionary

Table of Contents


LRCODE : INSTRUMENT CODE FILE

LRGREE : GRANTEE FILE

LRGROW : GRANTOR FILE

LRMAIN : MAIN FILE

LRRTRN : RETURN TO CODES

LRSYST : SYSTEM FILE


									
LRCODE : INSTRUMENT CODE FILE 

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    C_CODE         C      4     0   LAND RECORD CODE       
   2    C_DESC         C     30     0   CODE DESCRIPTION    
   3    C_EECOLOR      C      3     0   COLOR DESCRIPTION       
   4    C_ORCOLOR      C      3     0   COLOR DESCRIPTION         
   5    C_COMBINE      C      1     0   COMBINED CODE = '*' IF COMBINED  
   6    C_NETSTAMP     N      2     0   NETWORK SIGNATURE   
   7    C_DELFLAG      C      1     0   DELETION FLAG    
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 7 FIELDS = 44

                                Related Indexes                                

LRCODE : C_DELFLAG+C_CODE                                                      
LRDESC : C_DELFLAG+C_DESC                                                       



 
LRGREE : GRANTEE FILE                         

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    E_SEQNO        C      5     0   SEQUENCE NUMBER    
   2    E_NAME         C     45     0   GRANTEE NAME     
   3    E_NETSTAMP     N      2     0   NETWORK STAMP   
   4    E_DELFLAG      C      1     0   DELETION FLAG    
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 4 FIELDS = 53

                                Related Indexes                                

LRGREE : E_DELFLAG+UPPER(E_NAME)                                               
LRESEQ : E_DELFLAG+E_SEQNO                                                      



 
LRGROW : GRANTOR FILE                         

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    O_SEQNO        C      5     0   SEQUENCE NUMBER           
   2    O_NAME         C     45     0   GRANTOR OR GRANTEE NAME   
   3    O_NETSTAMP     N      2     0   NETWORK STAMP           
   4    O_DELFLAG      C      1     0   DELETION FLAG        
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 4 FIELDS = 53

                                Related Indexes                                

LRGROW : O_DELFLAG+UPPER(O_NAME)                                               
LROSEQ : O_DELFLAG+O_SEQNO                                                     



 
LRMAIN : MAIN FILE                         

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    M_SEQNO        C      5     0   SEQUENCE NUMBER          
   2    M_PROP         C     10     0   GRAND LIST PROP NUMBER         
   3    M_SUB          C     10     0   GRAND LIST SUB NUMBER      
   4    M_SPAN         C     13     0   GRAND LIST SPAN NUMBER (999-999-9999) 
   5    M_GRANTOR      C     45     0   GRANTOR NAME                  
   6    M_GRANTOR1     C     45     0   GRANTOR NAME 1                     
   7    M_GRANTOR2     C     45     0   GRANTOR NAME 2                     
   8    M_GRANTOR3     C     45     0   GRANTOR NAME 3                    
   9    M_GRANTOR4     C     45     0   GRANTOR NAME 4                   
  10    M_GRANTOR5     C     45     0   GRANTOR NAME 5                     
  11    M_GRANTOR6     C     45     0   GRANTOR NAME 6                       
  12    M_GRANTOR7     C     45     0   GRANTOR NAME 7                     
  13    M_GRANTEE      C     45     0   GRANTEE NAME                      
  14    M_GRANTEE1     C     45     0   GRANTEE NAME 1               
  15    M_GRANTEE2     C     45     0   GRANTEE NAME 2                 
  16    M_GRANTEE3     C     45     0   GRANTEE NAME 3              
  17    M_GRANTEE4     C     45     0   GRANTEE NAME 4             
  18    M_GRANTEE5     C     45     0   GRANTEE NAME 5      
  19    M_GRANTEE6     C     45     0   GRANTEE NAME 6                  
  20    M_GRANTEE7     C     45     0   GRANTEE NAME 7              
  21    M_CODE         C      4     0   INSTRUMENT CODE                          
  22    M_TYPE         C     30     0   INSTRUMENT CODE DESCRIPTION          
  23    M_LOCATION     C     30     0   LOCATION OF PROPERTY                
  24    M_LOCA_B       C     30     0   ADDITIONAL LOCATION FIELD         
  25    M_BOOK         C      4     0   DEED BOOK NUMBER (RIGHT-JUSTIFIED)  
  26    M_PAGE         C     10     0   DEED BOOK PAGE NUMBER (NOT USED)         
  27    M_LOPAGE       C      4     0   BEGINNING DEED BOOK PAGE NUMBER       
  28    M_HIPAGE       C      4     0   ENDING DEED BOOK PAGE NUMBER         
  29    M_DEED         D      8     0   DATE OF DEED                         
  30    M_RBOOK        C      4     0   REFERENCE BOOK NUMBER (RIGHT-
JUSTIFIED)        
  31    M_RLOPAGE      C      4     0   BEGINNING REFERENCE BOOK PAGE NUMBER     
  32    M_RHIPAGE      C      4     0   ENDING REFERENCE BOOK PAGE NUMBER          
  33    M_RPAGE        C     10     0   REFERENCE BOOK PAGE NUMBER (NOT USED)   
  34    M_DATE         D      8     0   ENTERED/RECORDED DATE       
  35    M_TIME         C     10     0   ENTERED/RECORDED TIME        
  36    M_FEE          N      7     2   RECORDING FEE               
  37    M_FEEDATE      D      8     0   DATE RECORDING FEE WAS PAID 
  38    M_DISCHARG     D      8     0   DATE OF LIEN DISCHARGE (NOT USED)   
  39    M_DBOOK        C      4     0   DISCHARGE BOOK NUMBER (RIGHT-
JUSTIFIED)  (NOT USED)                  
  40    M_DPAGE        C     10     0   DISCHARGE BOOK PAGE NUMBER (NOT 
USED)                                
  41    M_DLOPAGE      C      4     0   BEGINNING DISCHARGE BOOK PAGE NUMBER  
(NOT USED)                      
  42    M_DHIPAGE      C      4     0   ENDING DISCHARGE BOOK PAGE NUMBER  
(NOT USED)                         
  43    M_DISSING      C      5     0   DISCHARGING THIS LAND RECORD SEQUENCE 
NUMBER                          
  44    M_ASFROM       C      5     0   ASSIGNMENT RECEIVED FROM THIS LAND 
RECORD SEQUENCE NUMBER             
  45    M_ASINTO       C      5     0   ASSIGNED TO THIS LAND RECORD SEQUENCE 
NUMBER                          
  46    M_ASSIGN       D      8     0   DATE OF ASSIGNMENT        
  47    M_ABOOK        C      4     0   ASSIGNMENT BOOK NUMBER (RIGHT-
JUSTIFIED)  (NOT USED)                 
  48    M_ALOPAGE      C      4     0   BEGINNING ASSIGNMENT BOOK PAGE NUMBER  
(NOT USED)                     
  49    M_AHIPAGE      C      4     0   ENDING ASSIGNMENT BOOK PAGE NUMBER  
(NOT USED)                        
  50    M_RECEIVE      C     30     0   RECEIVED THE DOCUMENTATION FROM WHOM  
  51    M_RETURN2      C     30     0   RETURN THE DOCUMENTATION TO WHOM      
  52    M_RADD1        C     24     0   RETURN TO: ADDRESS 1                  
  53    M_RADD2        C     24     0   RETURN TO: ADDRESS 2                  
  54    M_RCITY        C     24     0   RETURN TO: CITY                       
  55    M_RSTATE       C     10     0   RETURN TO: STATE                      
  56    M_RZIP         C     10     0   RETURN TO: ZIP                        
  57    M_RDATE        D      8     0   RETURN TO: DATE                       
  58    M_RHOW         C      1     0   RETURN TO METHOD (M)AIL,(H)AND,(F)ILE 
  59    M_NEEDTRAN     C      1     0   NEEDS TO BE TRANSFERRED TO GRAND LIST 
(Y/N)                           
  60    M_DIDTRAN      C      1     0   WAS TRANSFERRED TO GRAND LIST (Y/N)   
  61    M_TRANDATE     D      8     0   TRANSFER DATE                         
  62    M_TPRICE       N     10     2   SALE PRICE                            
  63    M_TDATE        D      8     0   SALE DATE                             
  64    M_TOWNER       C     40     0   NEW OWNER NAME                        
  65    M_TADDR1       C     40     0   NEW OWNER ADDRESS 1                   
  66    M_TADDR2       C     40     0   NEW OWNER ADDRESS 2                   
  67    M_TCITY        C     25     0   NEW OWNER CITY                        
  68    M_TSTATE       C     10     0   NEW OWNER STATE                       
  69    M_TZIP         C     10     0   NEW OWNER ZIP                         
  70    M_MISC         C     45     0   MISC FIELD 0                           
  71    M_MISC1        C     45     0   MISC FIELD 1                           
  72    M_MISC2        C     45     0   MISC FIELD 2                           
  73    M_MISC3        C     45     0   MISC FIELD 3                           
  74    M_MISC4        C     45     0   MISC FIELD 4                           
  75    M_MISC5        C     45     0   MISC FIELD 5                           
  76    M_MISC6        C     45     0   MISC FIELD 6                           
  77    M_MISC7        C     45     0   MISC FIELD 7                           
  78    M_MISC8        C     45     0   MISC FIELD 8                           
  79    M_MISC9        C     45     0   MISC FIELD 9                           
  80    M_NETSTAMP     N      2     0   NETWORK SIGNATURE                      
  81    M_TAG          C      2     0   INDEX CARD PRINTED? (Y/N) 
(GRANTOR/GRANTEE)                    
  82    M_DELFLAG      C      1     0   DELETE FLAG ("*"=REUSABLE)             
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 82 FIELDS = 1811

                                Related Indexes                                

LRMAIN : M_DELFLAG+M_SEQNO                                                     
LRGTOR : M_DELFLAG+UPPER(M_GRANTOR+M_GRANTEE)                                  
LRGTEE : M_DELFLAG+UPPER(M_GRANTEE+M_GRANTOR)                                  
LRDATE : M_DELFLAG+DTOS(M_DATE)                                                
LRBOOK : M_DELFLAG+upper(M_BOOK)+RIGHT(SPACE(4)+ALLT(M_LOPAGE),4)              
LRUQBK : M_DELFLAG +upper(M_BOOK)                                              
LRPRNT : M_DELFLAG+M_TAG                                                       



 
LRRTRN : RETURN TO CODES                       

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    R_RCODE        C      4     0   RETURN TO CODE                         
   2    R_RETURN2      C     30     0   RETURN TO NAME                         
   3    R_RADD1        C     24     0   RETURN TO ADDRESS 1                    
   4    R_RADD2        C     24     0   RETURN TO ADDRESS 2                    
   5    R_RCITY        C     24     0   RETURN TO CITY                         
   6    R_RSTATE       C     10     0   RETURN TO STATE                        
   7    R_RZIP         C     10     0   RETURN TO ZIP                          
   8    R_NETSTAMP     N      2     0   NETWORK SIGNATURE                      
   9    R_DELFLAG      C      1     0   DELETE FLAG ("*"=REUSABLE)             
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 9 FIELDS = 129

                                Related Indexes                                

LRRTRN : R_DELFLAG+upper(R_RETURN2)                                            



 
LRSYST : SYSTEM FILE                         

  No   Field Name   Type   Len   Dec    Description of field                
-----------------------------------------------------------------------------
   1    S_NXTSEQNO     N      5     0   NEXT SEQUENCE NUMBER                   
   2    S_COLOR        C      1     0   USE COLOR INDEX CARDS (Y/N) ?          
   3    S_COVER        C      1     0   ALLOW PRINITNG OF COVER SHEETS FROM 
EDIT LAND RECORDS (Y/N) ?         
   4    S_PROPLEN      N      2     0   PARCEL NUMBER LENGTH                   
   5    S_SUBLEN       N      2     0   PARCEL SUBNUMBER LENGTH                
   6    S_LSLINK       C      1     0   LINKED TO GRAND LIST (Y/N) ?           
   7    S_LSCOMP       C      2     0   GRAND LIST ENTITY THIS ENTITY IS 
LINKED TO                            
   8    S_F05          C     30     0   FUNCTION KEY F5                        
   9    S_F06          C     30     0   FUNCTION KEY F6                        
  10    S_F07          C     30     0   FUNCTION KEY F7                        
  11    S_F08          C     30     0   FUNCTION KEY F8                        
  12    S_F09          C     30     0   FUNCTION KEY F9                        
  13    S_F10          C     30     0   FUNCTION KEY F10                       
  14    S_F11          C     30     0   FUNCTION KEY F11                       
  15    S_F12          C     30     0   FUNCTION KEY F12                       
  16    S_MISC         C     20     0   MISC FIELD                             
  17    S_MISC1        C     20     0   MISC FIELD 1                           
  18    S_MISC2        C     20     0   MISC FIELD 2                           
  19    S_MISC3        C     20     0   MISC FIELD 3                           
  20    S_MISC4        C     20     0   MISC FIELD 4                           
  21    S_MISC5        C     20     0   MISC FIELD 5                           
  22    S_MISC6        C     20     0   MISC FIELD 6                           
  23    S_MISC7        C     20     0   MISC FIELD 7                           
  24    S_MISC8        C     20     0   MISC FIELD 8                           
  25    S_MISC9        C     20     0   MISC FIELD 9                           
  26    S_VERSION      C      4     0   NEMRC EXECUTABLE THAT MATCHES THIS 
DATA                               
  27    S_OLDVER       C      4     0   PREVIOUS INSTALLED VERSION OF THE 
MODULE                              
  28    S_UPVER        D      8     0   DATE THE NEW VERSION WAS INSTALLED 
  29    S_NETSTAMP     N      2     0   NETWORK SIGNATURE                  
-----------------------------------------------------------------------------

                    TOTAL LENGTH OF ALL 29 FIELDS = 472
							
							

© NEMRC 2010-2024 | Privacy Policy