                            Post PSC Auto Lookup Types                                                            
                                 Generated 20171116                                                            
                                                                                                                  
Lookup Type                      Lookup Table                                                                     
-------------------------------  -------------------------------------------------                                
adclip_selective_fishery         psc_lookup                                        
agency                           agencies                                          
agency_wire_prefix               agency_wire_prefix                                
coordinator                      coordinator                                       
counting_method                  psc_lookup                                        
detection_method                 psc_lookup                                        
epa_reaches_ruc                  psc_lookup                                        
epa_reaches_suc                  epa_reaches_suc                                   
escapement_estimation_method     escapement_estimation_method                      
estimation_level                 psc_lookup                                        
file_status                      psc_lookup                                        
file_type                        file_type                                         
fishery                          fisheries_041                                     
gear                             gears                                             
length_code                      psc_lookup                                        
length_type                      psc_lookup                                        
locations_description_state      psc_lookup                                        
location_type                    location_type                                     
marks                            marks                                             
period                           period                                            
rearing_type                     rearing_type                                      
recovery_date_type               psc_lookup                                        
related_group_type               related_group_type                                
release_stage                    release_stage                                     
release_strategy                 psc_lookup                                        
run                              run                                               
sampled_maturity                 psc_lookup                                        
sample_type                      sample_type                                       
sample_type_checklist            psc_lookup                                        
sex                              psc_lookup                                        
special_tag                      special_tag                                       
species                          species                                           
state_prov                       state_prov                                        
study_integrity                  study_integrity                                   
study_type                       study_type                                        
submission_status                psc_lookup                                        
tag_status                       tag_status                                        
tag_type                         tag_type                                          
water_type                       psc_lookup                                        
weight_code                      psc_lookup                                        
weight_type                      psc_lookup                                        
