
                                     Summary Report
 
The file and Matrix were built based on export_collector with the following options:
Date Created               = 09/21/2023
The Output file name       = 2023 SABINE CERTIFIED COLLECTORS 9.21.23.txt
The Matrix file name       = 2023 SABINE CERTIFIED COLLECTORS 9.21.23_Matrix.txt
Delimiter                  = |
Text Qualifier ("")        = False
Fixed Length Fields        = False
Column Names on First Row  = True

 
Column Name                   Data Type           Length    
-----------------------------------------------------------
collector_id                  varchar             25        
collector_yr                  smallint            5         
collector_geoid               varchar             25        
collector_altid               varchar             25        
collector_minid               varchar             25        
collector_ownerid             varchar             25        
collector_name                varchar             50        
collector_xname               varchar             50        
collector_attn                varchar             50        
collector_incareof            varchar             50        
collector_addr1               varchar             50        
collector_addr2               varchar             50        
collector_addr3               varchar             50        
collector_city                varchar             50        
collector_state               varchar             2         
collector_zip                 varchar             10        
collector_country             varchar             50        
collector_confidential        varchar             1         
collector_undelcd             varchar             10        
collector_undeldt             datetime            10        
collector_birthdate           datetime            10        
collector_street              varchar             50        
collector_strdir              varchar             2         
collector_strnum              int                 10        
collector_strsfx              varchar             10        
collector_strsfx2             varchar             10        
collector_strzip              varchar             10        
collector_unitnum             varchar             10        
collector_unitind             varchar             10        
collector_lndhs               int                 10        
collector_newlndhs            int                 10        
collector_lndnonhs            int                 10        
collector_newlndnonhs         int                 10        
collector_imphs               int                 10        
collector_newimphs            int                 10        
collector_impnonhs            int                 10        
collector_newimpnonhs         int                 10        
collector_prd                 int                 10        
collector_prdmkt              int                 10        
collector_inv                 int                 10        
collector_invmkt              int                 10        
collector_tmb                 int                 10        
collector_tmbmkt              int                 10        
collector_tmb78               int                 10        
collector_per                 int                 10        
collector_min                 bigint              19        
collector_hscaploss           int                 10        
collector_ptdlnd              varchar             3         
collector_ptdimp              varchar             3         
collector_ptdprd              varchar             3         
collector_ptdper              varchar             3         
collector_ptdmin              varchar             3         
collector_modified            varchar             10        
collector_hscode              varchar             10        
collector_hsdays              smallint            5         
collector_hsdtbeg             datetime            10        
collector_hsdtend             datetime            10        
collector_hslink              varchar             25        
collector_hspct               decimal             (6,5)         
collector_hstransamt          int                 10        
collector_disaster            bit                 5         
collector_disasterdt          datetime            10        
collector_dvcode              tinyint             3         
collector_dvamt               smallint            5         
collector_dvpct               decimal             (6,5)         
collector_exempt              varchar             1         
collector_exemptdays          smallint            5         
collector_exemptdtbeg         datetime            10        
collector_exemptdtend         datetime            10        
collector_rend                int                 10        
collector_rendcd              varchar             10        
collector_rollbackacres       decimal             (12,3)         
collector_rollbackdt          datetime            10        
collector_rollbackyr          smallint            5         
collector_lease               int                 10        
collector_rrc                 varchar             10        
collector_legal               varchar             256       
collector_lot                 varchar             50        
collector_block               varchar             50        
collector_subd                varchar             50        
collector_tract               varchar             50        
collector_abstract            varchar             50        
collector_mhpmake             varchar             50        
collector_mhpmodel            varchar             50        
collector_mhpsize             varchar             50        
collector_mhpyear             smallint            5         
collector_mhpserial           varchar             50        
collector_mhplabel            varchar             50        
collector_mhptitlestate       varchar             50        
collector_mhpdescr            varchar             256       
collector_divacres            decimal             (12,3)         
collector_legalacres          decimal             (12,3)         
collector_interest            decimal             (10,9)         
collector_interestcd          varchar             10        
collector_deedvol             varchar             10        
collector_deedpage            varchar             10        
collector_deeddate            datetime            10        
collector_instnumber          varchar             50        
collector_agent               varchar             10        
collector_mortgage            varchar             10        
collector_lfa                 varchar             1         
collector_lpr                 varchar             1         
collector_lpt                 varchar             1         
collector_disastertmp         bit                 5         
collector_disastertmpdt       datetime            10        
collector_disastertmptmvi     int                 10        
collector_disastertmpdmgamt   int                 10        
collector_disastertmpdmgpct   decimal             (7,6)         
collector_disastertmpdmglvl   int                 10        
collector_disastertmpdmglvlpctdecimal             (7,6)         
collector_disastertmpexfct    decimal             (7,6)         
collector_disastertmpexpct    decimal             (7,6)         
collector_del                 varchar             1         
collector_jereasoncd          varchar             128       
collector_jenote              varchar             256       
