28428 CURRENT_SALMON Entity Published / External 28125 AFSC/FMA/Current Observer Data Interface Data Set In Work This entity records the number of prohibited pacific salmon recorded as bycatch, by species, for an offload or a haul. Temporal 2008 AND FORWARD Spatial BS, AI, BSAI, GOA Stratum BYCATCH Stratum OBSERVER, CURRENT DATA, FISHERY STATISTICS Fisheries Monitoring and Analysis Seattle WA USA Alaska Fisheries Science Center Data Table Yes This entity records the number of prohibited pacif OBSING This entity records the number of prohibited pacific salmon recorded as bycatch, by species, for an offload or a haul. 10 T_TABLE VARCHAR2 32 Yes No Active Identifier of Source Table CHARACTER 15 SALMON_SEQ NUMBER 9 No Yes 9 0 Active Sequence generated unique identifier of a salmon record generated by the. Because salmon species are summed for this construct, this value is generated locally and not inherited INTEGER 20 CRUISE NUMGER 9 No No 9 0 Active Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. INTEGER 25 PERMIT VARCHAR2 7 No No Active Unique Code identifying a delivering vessel - inherited from the NORPAC data set and created by the RAM division in Juneau CHARACTER 30 OFFLOAD_SEQ NUMBER 9 No No 9 0 Active Optional foreign key identifier from an offload record. Sequence generated unique identifier for an offload record INTEGER 35 HAUL_SEQ NUMBER 9 No No 9 0 Active Optional foreign key column from current_haul INTEGER 40 SPECIES_CODE NUMBER 4 No No 4 0 In Development Unique identifier for a species imported from Norpac INTEGER 45 HAUL_JOIN NUMBER 20 No No 20 0 Active Surrogate FK to haul if salmon record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul. INTEGER 50 OFFLOAD_JOIN NUMBER 20 No No 20 0 Active Surrogate FK to offload if salmon record is so derived Composed of concatenation of cruise, permit and offloadl_seq. INTEGER 55 COUNT NUMBER 4 Yes No 4 0 Active Number of Individual Salmon Observed and Recorded. INTEGER 60 LAST_MODIFIED_DATE DATE 12 No No Active Everytime an offload-salmon or haul-salmon record from the production schema is processed the the obsint.load_current_salmon the processing datetime is recorded here. This does not necessarily mean the current offload-haul-salmon record was modified as the program processes every record within a cruise permit when initiated. DATE gov.noaa.nmfs.inport:28428 Julie Blair 2015-10-30T18:02:13 SysAdmin InPortAdmin 2022-08-09T17:11:13 2016-05-04 Alaska Fisheries Science Center AFSC 7600 Sand Point Way N.E., Building 4 Seattle WA 98115 USA https://www.afsc.noaa.gov 0700-1700 Pacific Time 1001 Public No 2016-05-04 1 Year 2017-05-04