33266 ASMAVG Entity Published / External 24111 Observer and At Sea Monitor Database (OBDBS) Data Set Completed At Sea Monitor Averages Table (individual values used to calculate averages) Loaded by batch 8948, 07-06-2016 08:22 Data View Yes OBDBS At Sea Monitor Averages Table (individual values used to calculate averages) 1 PROGRAM VARCHAR2 3 No No Active First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. VARCHAR2 2 YEAR VARCHAR2 4 No No Active Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. VARCHAR2 3 MONTH VARCHAR2 2 No No Active Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. VARCHAR2 4 TRIPID VARCHAR2 6 No No Active May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. VARCHAR2 5 LINK1 VARCHAR2 15 No No Active 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. VARCHAR2 6 LINK4 VARCHAR2 17 Yes No Active Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable. VARCHAR2 7 AVGCOLNAME VARCHAR2 20 Yes No Active Colunm name of the column used to calculate average value. Collected for ASM where applicable. VARCHAR2 8 AVGCOLVALUE NUMBER 22 Yes No 3 0 Active Value of the column used to calculate average value. Collected for ASM where applicable. NUMBER 9 AVGCOMMENTS VARCHAR2 50 No No Active Comments from averages table of individual values used to calculate average values. Collected for ASM where applicable. VARCHAR2 10 ASMTEST_STATUS VARCHAR2 6 No No Active Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested VARCHAR2 gov.noaa.nmfs.inport:33266 Patricia Jones 2016-07-06T08:22:52 SysAdmin InPortAdmin 2022-08-09T17:11:11 2016-07-28 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2016-07-28 1 Year 2017-07-28