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

 
Column Name                   Data Type           Length    
-----------------------------------------------------------
collectore_id                 varchar             25        
collectore_yr                 smallint            5         
collectore_code               varchar             10        
collectore_imppct             decimal             (8,7)         
collectore_lndpct             decimal             (8,7)         
collectore_prdpct             decimal             (8,7)         
collectore_invpct             decimal             (8,7)         
collectore_tmbpct             decimal             (8,7)         
collectore_perpct             decimal             (8,7)         
collectore_minpct             decimal             (8,7)         
collectore_amtabt             int                 10        
collectore_amtchr             int                 10        
collectore_amtfrp             int                 10        
collectore_amthst             int                 10        
collectore_amtmin             int                 10        
collectore_amtoth             int                 10        
collectore_amtpol             int                 10        
collectore_amtsol             int                 10        
collectore_anxdnx             varchar             1         
collectore_frzovr             bit                 5         
collectore_frzyr              smallint            5         
collectore_frzamt             decimal             (12,2)         
collectore_frzdays            smallint            5         
collectore_frzportcd          varchar             1         
collectore_frzportpct         decimal             (6,5)         
collectore_histfrzovr         bit                 5         
collectore_histfrzyr          smallint            5         
collectore_histfrzamt         decimal             (12,2)         
collectore_histfrzdays        smallint            5         
collectore_histfrzportcd      varchar             1         
collectore_histfrzportpct     decimal             (6,5)         
collectore_disaster           bit                 5         
collectore_tiffnumber         smallint            5         
collectore_vlacap             int                 10        
collectore_vlacaploss         int                 10        
collectore_hscode             varchar             10        
collectore_hscodeovr          bit                 5         
collectore_hspct              decimal             (6,5)         
collectore_disastertmp        int                 10        
collectore_txbl               bigint              19        
