Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

CI00_FORM1

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75104  |  Updated: May 21, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Table created from MS Access 2000 Cook Inlet Alaska Marine Mammal Observer Program Form 1. File CIOP00. 20241022MM

Entity Information

Data Attribute / Type Description
ASS11US
VARCHAR2(26 BYTE) 		"MS Access: Description: Associated Form 11US? MS Access caption: 11US."
ASS2
VARCHAR2(26 BYTE) 		"MS Access: Description: Associated form 2's? MS Access caption: Circle other forms for this set: 2."
ASS3
VARCHAR2(26 BYTE) 		"MS Access: Description: Associated form 3's? MS Access caption: 3."
ASS4
VARCHAR2(26 BYTE) 		"MS Access: Description: Associated form 4's? MS Access caption: 4."
BHNC
VARCHAR2(26 BYTE) 		"MS Access: Description: Predominate manner the net fished during haul (enter up to three in order of predominance) MS Access caption: No caption."
BSNC
VARCHAR2(26 BYTE) 		"MS Access: Description: Predominate manner the net fished during soak (enter up to three in order of predominance) MS Access caption: No caption."
COMMENTS
VARCHAR2(1024 BYTE) 		"MS Access: Description: Comments. MS Access caption: No caption."
COMYN
VARCHAR2(26 BYTE) 		"MS Access: Description: Comments written on back of form? MS Access caption: For more info. see back of form:."
DEBID
VARCHAR2(26 BYTE) 		"MS Access: Description: (Debrief ID) 3 digit unique code of person who debriefed observer. MS Access caption: Debrief"
DEPBH
NUMBER(38,0) 		"MS Access: Description: Average water depth in area at beginning of haul, in feet MS Access caption: Depth."
DEPBS
NUMBER(38,0) 		"MS Access: Description: Average water depth in area of soak, in feet MS Access caption: Depth."
DISTBH
VARCHAR2(26 BYTE) 		"MS Access: Description: Code for maximum distance in meters net is from shore at beginning of haul MS Access caption: Distance."
DISTBS
VARCHAR2(26 BYTE) 		"MS Access: Description: Code for maximum distance in meters net is from shore during soak. MS Access caption: Distance"
DISTNNH
VARCHAR2(26 BYTE) 		"MS Access: Description: Distance code for distance to next active fishing net at haul. MS Access caption: Dist to nn haul."
DISTNNS
VARCHAR2(26 BYTE) 		"MS Access: Description: Distance code for distance to next active fishing net at soak. MS Access caption: Dist. to next net:"
DISTOBH
NUMBER(38,0) 		"MS Access: Description: Observer distance from net during haul, in feet. MS Access caption: No caption."
DISTOBS
VARCHAR2(26 BYTE) 		"MS Access: Description: Distance code for distance between observer and furthest part of observed net during soak. MS Access caption: No caption."
DISTRICTBS
VARCHAR2(26 BYTE) 		"MS Access: Description: District code from ADFG statistical map. MS Access caption: District"
ENTID
VARCHAR2(26 BYTE) 		"MS Access: Description: (Entry ID) 3 digit unique code of person who entered data into form. MS Access caption: Data Entry"
EO1
VARCHAR2(26 BYTE) 		"MS Access: Description: Time when observation stops. MS Access caption: End Obs."
EO2
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
EO3
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
EO4
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
ESTDAM
NUMBER(38,0) 		"MS Access: Description: Estimated square feet (to nearest tenth) of damage MS Access caption: Est. sq.ft. damage:."
FINALID
VARCHAR2(26 BYTE) 		"MS Access: Description: (Final ID) 3 digit unique code of the individual who does the final data check. MS Access caption: Final ID"
FISHERY
VARCHAR2(26 BYTE) 		"MS Access: Description: S = Set; D = Drift caption: Fishery"
FTRIP
VARCHAR2(26 BYTE) 		"MS Access: Description: Full trip observed? MS Access caption: Full trip (y/n)"
HABBH
VARCHAR2(26 BYTE) 		"MS Access: Description: Code for substrate type at beginning of haul MS Access caption: Habitat."
HABBS
VARCHAR2(26 BYTE) 		"MS Access: Description: Code for substrate type for soak MS Access caption: Habitat."
LATBH
VARCHAR2(26 BYTE) 		"MS Access: Description: Latitude of begin haul MS Access caption: Latitude."
LATBS
VARCHAR2(26 BYTE) 		"MS Access: Description: Latitude of begin soak. MS Access caption: Latitude"
LBREFNO
VARCHAR2(26 BYTE) 		"MS Access: Description: Comments in logbook #. MS Access caption: Log book #."
LBREFPG
VARCHAR2(26 BYTE) 		"MS Access: Description: Comments on page number (?) of logbook. MS Access caption: page #."
LDR
NUMBER(38,0) 		"MS Access: Description: Set nets only. Web lead used? (zero is default if none present) MS Access caption: If leader, length (fath.)"
LONGBH
VARCHAR2(26 BYTE) 		"MS Access: Description: Longitude of begin haul MS Access caption: Longitude."
LONGBS
VARCHAR2(26 BYTE) 		"MS Access: Description: Longitude of begin soak. MS Access caption: Longitude"
MSIZE
NUMBER(38,14) 		"MS Access: Description: Stretch mesh size in inches MS Access caption: Mesh size (inches)"
NETD
NUMBER(38,0) 		"MS Access: Description: Hung depth of the net, in meshes. MS Access caption: Net depth (meshes)"
NETL
NUMBER(38,0) 		"MS Access: Description: Length of fished net as first set, in fathoms MS Access caption: Net length (fath.)"
NETNO
VARCHAR2(26 BYTE) 		"MS Access: Description: For set nets only. Position of set net observed based on grid layout. MS Access caption: Net ID (if >1 net/permit)"
NONETS
NUMBER(38,0) 		"MS Access: Description: Total number of nets being fished by same permit at time of observation MS Access caption: # of nets fished"
NUMNN
NUMBER(38,0) 		"MS Access: Description: Approx. number of fishing nets within 800m. MS Access caption: # nets<800m"
OBSERVATION_DATE
DATE 		"MS Access: Description: Date observation of set began MS Access caption: Date (mm/dd/yy)"
OBSID
VARCHAR2(26 BYTE) 		"MS Access: Description: (Obs. Code) 3 digit unique observer ID code MS Access caption: Obs. code"
OFFID
VARCHAR2(26 BYTE) 		"MS Access: Description: (Check ID) 3 digit unique code of office person who reviewed data. MS Access caption: Office Edit"
ORIENT
VARCHAR2(26 BYTE) 		"MS Access: Description: Orientation codes of net during set. MS Access caption: Orientation"
OVRLP
VARCHAR2(26 BYTE) 		"MS Access: Description: Mainly for set nets. Any overlap between nearest nets? MS Access caption: Overlap (y/n)"
PERMIN
VARCHAR2(26 BYTE) 		"MS Access: Description: Percent code of least amount of net fished during set. MS Access caption: min % of net fished:."
PERMITID
VARCHAR2(26 BYTE) 		"MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit. MS Access caption: Permit #"
PERTG
VARCHAR2(26 BYTE) 		"MS Access: Description: Code for % time gear was tended. MS Access caption: % time tended gear:."
PERWN
VARCHAR2(26 BYTE) 		"MS Access: Description: Percent code best reflecting total time whole net fished. MS Access caption: % time whole net fished:."
PHET1
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
PHET2
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
PHET3
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
PHET4
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
PHST1
VARCHAR2(26 BYTE) 		"MS Access: Description: If partial haul, time started. MS Access caption: No caption."
PHST2
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
PHST3
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
PHST4
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
PLATFORM
VARCHAR2(26 BYTE) 		"MS Access: Description: Platform from which observations were made MS Access caption: Platform code(s)"
PRIMKEY
NUMBER(38,0) 		No MS Access metadata.
PROLL
VARCHAR2(26 BYTE) 		"MS Access: Description: Roll number of photographs. MS Access caption: Roll #."
PSHOT1
NUMBER(38,0) 		"MS Access: Description: Beginning frame number. MS Access caption: Frames #."
PSHOT2
NUMBER(38,0) 		"MS Access: Description: Ending frame number. MS Access caption: to."
PULLG
VARCHAR2(26 BYTE) 		"MS Access: Description: Did fisherman pull the net to keep it taut? MS Access caption: Pulled gear? (y/n)."
RELNETIN
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: Inside"
RELNETOUT
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: Outside"
RUNG
VARCHAR2(26 BYTE) 		"MS Access: Description: Did skipper run gear? MS Access caption: Run Gear (y/n/u)."
SEABH
NUMBER(38,0) 		"MS Access: Description: Sea state code at begining of haul MS Access caption: No caption."
SEABS
NUMBER(38,0) 		"MS Access: Description: Sea state code during soak. MS Access caption: Sea state."
SETNO
NUMBER(38,0) 		"MS Access: Description: Sequential number of set observed per day by observer MS Access caption: Observed set"
SO1
VARCHAR2(26 BYTE) 		"MS Access: Description: Time when first begin observing. MS Access caption: Start obs."
SO2
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
SO3
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
SO4
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: No caption."
STABH
VARCHAR2(26 BYTE) 		"MS Access: Description: Tide stage code at begin of haul MS Access caption: Stage."
STABS
VARCHAR2(26 BYTE) 		"MS Access: Description: Tide stage code at begin of soak. MS Access caption: Stage"
TIDEBH
VARCHAR2(26 BYTE) 		"MS Access: Description: Tide code at beginning of haul MS Access caption: Tide."
TIDEBS
VARCHAR2(26 BYTE) 		"MS Access: Description: Tide code at beginning of soak. MS Access caption: Tide"
TIMEBH
VARCHAR2(26 BYTE) 		"MS Access: Description: Time beginning set retrieval or pick. MS Access caption: Begin haul."
TIMEBS
VARCHAR2(26 BYTE) 		"MS Access: Description: Time of drift/set net set start (or time of set net last haul). MS Access caption: Begin (set/last haul)."
TIMEEH
VARCHAR2(26 BYTE) 		"MS Access: Description: Time set retrieval ends. MS Access caption: End haul."
TIMEES
VARCHAR2(26 BYTE) 		"MS Access: Description: Time ofdrift/set net begin soak. MS Access caption: Begin/soak."
VISBH
VARCHAR2(26 BYTE) 		"MS Access: Description: Visibility code for conditions during haul. MS Access caption: No caption."
VISBS
VARCHAR2(26 BYTE) 		"MS Access: Description: Visibility code for conditions during soak. MS Access caption: Visibility."
VPNAME
VARCHAR2(26 BYTE) 		"MS Access: Description: Vessel name (drift) or permit holder name (set; last, first, mi) MS Access caption: Vessel/permit name"
WEABH
VARCHAR2(26 BYTE) 		"MS Access: Description: Weather code for conditions during haul. MS Access caption: No caption."
WEABS
VARCHAR2(26 BYTE) 		"MS Access: Description: Weather code for conditions during soak. MS Access caption: Weather."
WNFISH
VARCHAR2(26 BYTE) 		"MS Access: Description: Did entire length and depth of net fish entire set? MS Access caption: Whole net fished for set (y/n)."
ZONEBH
VARCHAR2(26 BYTE) 		"MS Access: Description: Code for land form at beginning of haul MS Access caption: ZoneH."
ZONEBS
VARCHAR2(26 BYTE) 		"MS Access: Description: Code for land form during soak. MS Access caption: Zone."
WLINE
NUMBER(38,0) 		"MS Access: Description: If a weedline is present, how long is the drop? (zero is default if none present) MS Access caption: If weedline (inch)"

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: CI00_FORM1

Entity Information

Description:

Table created from MS Access 2000 Cook Inlet Alaska Marine Mammal Observer Program Form 1. File CIOP00. 20241022MM

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ASS11US VARCHAR2(26 BYTE) "MS Access: Description: Associated Form 11US? MS Access caption: 11US."
100
 ASS2 VARCHAR2(26 BYTE) "MS Access: Description: Associated form 2's? MS Access caption: Circle other forms for this set: 2."
100
 ASS3 VARCHAR2(26 BYTE) "MS Access: Description: Associated form 3's? MS Access caption: 3."
100
 ASS4 VARCHAR2(26 BYTE) "MS Access: Description: Associated form 4's? MS Access caption: 4."
100
 BHNC VARCHAR2(26 BYTE) "MS Access: Description: Predominate manner the net fished during haul (enter up to three in order of predominance) MS Access caption: No caption."
100
 BSNC VARCHAR2(26 BYTE) "MS Access: Description: Predominate manner the net fished during soak (enter up to three in order of predominance) MS Access caption: No caption."
100
 COMMENTS VARCHAR2(1024 BYTE) "MS Access: Description: Comments. MS Access caption: No caption."
100
 COMYN VARCHAR2(26 BYTE) "MS Access: Description: Comments written on back of form? MS Access caption: For more info. see back of form:."
100
 DEBID VARCHAR2(26 BYTE) "MS Access: Description: (Debrief ID) 3 digit unique code of person who debriefed observer. MS Access caption: Debrief"
100
 DEPBH NUMBER(38,0) "MS Access: Description: Average water depth in area at beginning of haul, in feet MS Access caption: Depth."
100
 DEPBS NUMBER(38,0) "MS Access: Description: Average water depth in area of soak, in feet MS Access caption: Depth."
100
 DISTBH VARCHAR2(26 BYTE) "MS Access: Description: Code for maximum distance in meters net is from shore at beginning of haul MS Access caption: Distance."
100
 DISTBS VARCHAR2(26 BYTE) "MS Access: Description: Code for maximum distance in meters net is from shore during soak. MS Access caption: Distance"
100
 DISTNNH VARCHAR2(26 BYTE) "MS Access: Description: Distance code for distance to next active fishing net at haul. MS Access caption: Dist to nn haul."
100
 DISTNNS VARCHAR2(26 BYTE) "MS Access: Description: Distance code for distance to next active fishing net at soak. MS Access caption: Dist. to next net:"
100
 DISTOBH NUMBER(38,0) "MS Access: Description: Observer distance from net during haul, in feet. MS Access caption: No caption."
100
 DISTOBS VARCHAR2(26 BYTE) "MS Access: Description: Distance code for distance between observer and furthest part of observed net during soak. MS Access caption: No caption."
100
 DISTRICTBS VARCHAR2(26 BYTE) "MS Access: Description: District code from ADFG statistical map. MS Access caption: District"
100
 ENTID VARCHAR2(26 BYTE) "MS Access: Description: (Entry ID) 3 digit unique code of person who entered data into form. MS Access caption: Data Entry"
100
 EO1 VARCHAR2(26 BYTE) "MS Access: Description: Time when observation stops. MS Access caption: End Obs."
100
 EO2 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 EO3 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 EO4 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 ESTDAM NUMBER(38,0) "MS Access: Description: Estimated square feet (to nearest tenth) of damage MS Access caption: Est. sq.ft. damage:."
100
 FINALID VARCHAR2(26 BYTE) "MS Access: Description: (Final ID) 3 digit unique code of the individual who does the final data check. MS Access caption: Final ID"
100
 FISHERY VARCHAR2(26 BYTE) "MS Access: Description: S = Set; D = Drift caption: Fishery"
100
 FTRIP VARCHAR2(26 BYTE) "MS Access: Description: Full trip observed? MS Access caption: Full trip (y/n)"
100
 HABBH VARCHAR2(26 BYTE) "MS Access: Description: Code for substrate type at beginning of haul MS Access caption: Habitat."
100
 HABBS VARCHAR2(26 BYTE) "MS Access: Description: Code for substrate type for soak MS Access caption: Habitat."
100
 LATBH VARCHAR2(26 BYTE) "MS Access: Description: Latitude of begin haul MS Access caption: Latitude."
100
 LATBS VARCHAR2(26 BYTE) "MS Access: Description: Latitude of begin soak. MS Access caption: Latitude"
100
 LBREFNO VARCHAR2(26 BYTE) "MS Access: Description: Comments in logbook #. MS Access caption: Log book #."
100
 LBREFPG VARCHAR2(26 BYTE) "MS Access: Description: Comments on page number (?) of logbook. MS Access caption: page #."
100
 LDR NUMBER(38,0) "MS Access: Description: Set nets only. Web lead used? (zero is default if none present) MS Access caption: If leader, length (fath.)"
100
 LONGBH VARCHAR2(26 BYTE) "MS Access: Description: Longitude of begin haul MS Access caption: Longitude."
100
 LONGBS VARCHAR2(26 BYTE) "MS Access: Description: Longitude of begin soak. MS Access caption: Longitude"
100
 MSIZE NUMBER(38,14) "MS Access: Description: Stretch mesh size in inches MS Access caption: Mesh size (inches)"
100
 NETD NUMBER(38,0) "MS Access: Description: Hung depth of the net, in meshes. MS Access caption: Net depth (meshes)"
100
 NETL NUMBER(38,0) "MS Access: Description: Length of fished net as first set, in fathoms MS Access caption: Net length (fath.)"
100
 NETNO VARCHAR2(26 BYTE) "MS Access: Description: For set nets only. Position of set net observed based on grid layout. MS Access caption: Net ID (if >1 net/permit)"
100
 NONETS NUMBER(38,0) "MS Access: Description: Total number of nets being fished by same permit at time of observation MS Access caption: # of nets fished"
100
 NUMNN NUMBER(38,0) "MS Access: Description: Approx. number of fishing nets within 800m. MS Access caption: # nets<800m"
100
 OBSERVATION_DATE DATE "MS Access: Description: Date observation of set began MS Access caption: Date (mm/dd/yy)"
100
 OBSID VARCHAR2(26 BYTE) "MS Access: Description: (Obs. Code) 3 digit unique observer ID code MS Access caption: Obs. code"
100
 OFFID VARCHAR2(26 BYTE) "MS Access: Description: (Check ID) 3 digit unique code of office person who reviewed data. MS Access caption: Office Edit"
100
 ORIENT VARCHAR2(26 BYTE) "MS Access: Description: Orientation codes of net during set. MS Access caption: Orientation"
100
 OVRLP VARCHAR2(26 BYTE) "MS Access: Description: Mainly for set nets. Any overlap between nearest nets? MS Access caption: Overlap (y/n)"
100
 PERMIN VARCHAR2(26 BYTE) "MS Access: Description: Percent code of least amount of net fished during set. MS Access caption: min % of net fished:."
100
 PERMITID VARCHAR2(26 BYTE) "MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit. MS Access caption: Permit #"
100
 PERTG VARCHAR2(26 BYTE) "MS Access: Description: Code for % time gear was tended. MS Access caption: % time tended gear:."
100
 PERWN VARCHAR2(26 BYTE) "MS Access: Description: Percent code best reflecting total time whole net fished. MS Access caption: % time whole net fished:."
100
 PHET1 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 PHET2 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 PHET3 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 PHET4 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 PHST1 VARCHAR2(26 BYTE) "MS Access: Description: If partial haul, time started. MS Access caption: No caption."
100
 PHST2 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 PHST3 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 PHST4 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 PLATFORM VARCHAR2(26 BYTE) "MS Access: Description: Platform from which observations were made MS Access caption: Platform code(s)"
100
 PRIMKEY NUMBER(38,0) No MS Access metadata.
100
 PROLL VARCHAR2(26 BYTE) "MS Access: Description: Roll number of photographs. MS Access caption: Roll #."
100
 PSHOT1 NUMBER(38,0) "MS Access: Description: Beginning frame number. MS Access caption: Frames #."
100
 PSHOT2 NUMBER(38,0) "MS Access: Description: Ending frame number. MS Access caption: to."
100
 PULLG VARCHAR2(26 BYTE) "MS Access: Description: Did fisherman pull the net to keep it taut? MS Access caption: Pulled gear? (y/n)."
100
 RELNETIN VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: Inside"
100
 RELNETOUT VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: Outside"
100
 RUNG VARCHAR2(26 BYTE) "MS Access: Description: Did skipper run gear? MS Access caption: Run Gear (y/n/u)."
100
 SEABH NUMBER(38,0) "MS Access: Description: Sea state code at begining of haul MS Access caption: No caption."
100
 SEABS NUMBER(38,0) "MS Access: Description: Sea state code during soak. MS Access caption: Sea state."
100
 SETNO NUMBER(38,0) "MS Access: Description: Sequential number of set observed per day by observer MS Access caption: Observed set"
100
 SO1 VARCHAR2(26 BYTE) "MS Access: Description: Time when first begin observing. MS Access caption: Start obs."
100
 SO2 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 SO3 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 SO4 VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: No caption."
100
 STABH VARCHAR2(26 BYTE) "MS Access: Description: Tide stage code at begin of haul MS Access caption: Stage."
100
 STABS VARCHAR2(26 BYTE) "MS Access: Description: Tide stage code at begin of soak. MS Access caption: Stage"
100
 TIDEBH VARCHAR2(26 BYTE) "MS Access: Description: Tide code at beginning of haul MS Access caption: Tide."
100
 TIDEBS VARCHAR2(26 BYTE) "MS Access: Description: Tide code at beginning of soak. MS Access caption: Tide"
100
 TIMEBH VARCHAR2(26 BYTE) "MS Access: Description: Time beginning set retrieval or pick. MS Access caption: Begin haul."
100
 TIMEBS VARCHAR2(26 BYTE) "MS Access: Description: Time of drift/set net set start (or time of set net last haul). MS Access caption: Begin (set/last haul)."
100
 TIMEEH VARCHAR2(26 BYTE) "MS Access: Description: Time set retrieval ends. MS Access caption: End haul."
100
 TIMEES VARCHAR2(26 BYTE) "MS Access: Description: Time ofdrift/set net begin soak. MS Access caption: Begin/soak."
100
 VISBH VARCHAR2(26 BYTE) "MS Access: Description: Visibility code for conditions during haul. MS Access caption: No caption."
100
 VISBS VARCHAR2(26 BYTE) "MS Access: Description: Visibility code for conditions during soak. MS Access caption: Visibility."
100
 VPNAME VARCHAR2(26 BYTE) "MS Access: Description: Vessel name (drift) or permit holder name (set; last, first, mi) MS Access caption: Vessel/permit name"
100
 WEABH VARCHAR2(26 BYTE) "MS Access: Description: Weather code for conditions during haul. MS Access caption: No caption."
100
 WEABS VARCHAR2(26 BYTE) "MS Access: Description: Weather code for conditions during soak. MS Access caption: Weather."
100
 WNFISH VARCHAR2(26 BYTE) "MS Access: Description: Did entire length and depth of net fish entire set? MS Access caption: Whole net fished for set (y/n)."
100
 ZONEBH VARCHAR2(26 BYTE) "MS Access: Description: Code for land form at beginning of haul MS Access caption: ZoneH."
100
 ZONEBS VARCHAR2(26 BYTE) "MS Access: Description: Code for land form during soak. MS Access caption: Zone."
100
 WLINE NUMBER(38,0) "MS Access: Description: If a weedline is present, how long is the drop? (zero is default if none present) MS Access caption: If weedline (inch)"

Attribute Details

ASS11US

CC ID: 1373109
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Associated Form 11US?

MS Access caption: 11US."

ASS2

CC ID: 1373110
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Associated form 2's?

MS Access caption: Circle other forms for this set: 2."

ASS3

CC ID: 1373111
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Associated form 3's?

MS Access caption: 3."

ASS4

CC ID: 1373112
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Associated form 4's?

MS Access caption: 4."

BHNC

CC ID: 1373113
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Predominate manner the net fished during haul (enter up to three in order of predominance)

MS Access caption: No caption."

BSNC

CC ID: 1373114
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Predominate manner the net fished during soak (enter up to three in order of predominance)

MS Access caption: No caption."

COMMENTS

CC ID: 1373115
Data Storage Type: VARCHAR2(1024 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Comments.

MS Access caption: No caption."

COMYN

CC ID: 1373116
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Comments written on back of form?

MS Access caption: For more info. see back of form:."

DEBID

CC ID: 1373117
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description: (Debrief ID) 3 digit unique code of person who debriefed observer.

MS Access caption: Debrief"

DEPBH

CC ID: 1373118
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Average water depth in area at beginning of haul, in feet

MS Access caption: Depth."

DEPBS

CC ID: 1373119
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Average water depth in area of soak, in feet

MS Access caption: Depth."

DISTBH

CC ID: 1373120
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Code for maximum distance in meters net is from shore at beginning of haul

MS Access caption: Distance."

DISTBS

CC ID: 1373121
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Code for maximum distance in meters net is from shore during soak.

MS Access caption: Distance"

DISTNNH

CC ID: 1373122
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Distance code for distance to next active fishing net at haul.

MS Access caption: Dist to nn haul."

DISTNNS

CC ID: 1373123
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Distance code for distance to next active fishing net at soak.

MS Access caption: Dist. to next net:"

DISTOBH

CC ID: 1373124
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Observer distance from net during haul, in feet.

MS Access caption: No caption."

DISTOBS

CC ID: 1373125
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Distance code for distance between observer and furthest part of observed net during soak.

MS Access caption: No caption."

DISTRICTBS

CC ID: 1373126
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

District code from ADFG statistical map.

MS Access caption: District"

ENTID

CC ID: 1373127
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description: (Entry ID) 3 digit unique code of person who entered data into form.

MS Access caption: Data Entry"

EO1

CC ID: 1373128
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Time when observation stops.

MS Access caption: End Obs."

EO2

CC ID: 1373129
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

EO3

CC ID: 1373130
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

EO4

CC ID: 1373131
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

ESTDAM

CC ID: 1373132
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Estimated square feet (to nearest tenth) of damage

MS Access caption: Est. sq.ft. damage:."

FINALID

CC ID: 1373133
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description: (Final ID) 3 digit unique code of the individual who does the final data check.

MS Access caption: Final ID"

FISHERY

CC ID: 1373134
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description: S = Set; D = Drift

caption: Fishery"

FTRIP

CC ID: 1373135
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Full trip observed?

MS Access caption: Full trip (y/n)"

HABBH

CC ID: 1373136
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Code for substrate type at beginning of haul

MS Access caption: Habitat."

HABBS

CC ID: 1373137
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Code for substrate type for soak

MS Access caption: Habitat."

LATBH

CC ID: 1373138
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Latitude of begin haul

MS Access caption: Latitude."

LATBS

CC ID: 1373139
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Latitude of begin soak.

MS Access caption: Latitude"

LBREFNO

CC ID: 1373140
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Comments in logbook #.

MS Access caption: Log book #."

LBREFPG

CC ID: 1373141
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Comments on page number (?) of logbook.

MS Access caption: page #."

LDR

CC ID: 1373142
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Set nets only. Web lead used? (zero is default if none present)

MS Access caption: If leader, length (fath.)"

LONGBH

CC ID: 1373143
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Longitude of begin haul

MS Access caption: Longitude."

LONGBS

CC ID: 1373144
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Longitude of begin soak.

MS Access caption: Longitude"

MSIZE

CC ID: 1373145
Data Storage Type: NUMBER(38,14)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Stretch mesh size in inches

MS Access caption: Mesh size (inches)"

NETD

CC ID: 1373146
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Hung depth of the net, in meshes.

MS Access caption: Net depth (meshes)"

NETL

CC ID: 1373147
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Length of fished net as first set, in fathoms

MS Access caption: Net length (fath.)"

NETNO

CC ID: 1373148
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description: For set nets only. Position of set net observed based on grid layout.

MS Access caption: Net ID (if >1 net/permit)"

NONETS

CC ID: 1373149
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Total number of nets being fished by same permit at time of observation

MS Access caption: # of nets fished"

NUMNN

CC ID: 1373150
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Approx. number of fishing nets within 800m.

MS Access caption: # nets<800m"

OBSERVATION_DATE

CC ID: 1373151
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Date observation of set began

MS Access caption: Date (mm/dd/yy)"

OBSID

CC ID: 1373152
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description: (Obs. Code) 3 digit unique observer ID code

MS Access caption: Obs. code"

OFFID

CC ID: 1373153
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description: (Check ID) 3 digit unique code of office person who reviewed data.

MS Access caption: Office Edit"

ORIENT

CC ID: 1373154
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Orientation codes of net during set.

MS Access caption: Orientation"

OVRLP

CC ID: 1373155
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Mainly for set nets. Any overlap between nearest nets?

MS Access caption: Overlap (y/n)"

PERMIN

CC ID: 1373156
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Percent code of least amount of net fished during set.

MS Access caption: min % of net fished:."

PERMITID

CC ID: 1373157
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit.

MS Access caption: Permit #"

PERTG

CC ID: 1373158
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Code for % time gear was tended.

MS Access caption: % time tended gear:."

PERWN

CC ID: 1373159
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Percent code best reflecting total time whole net fished.

MS Access caption: % time whole net fished:."

PHET1

CC ID: 1373160
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

PHET2

CC ID: 1373161
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

PHET3

CC ID: 1373162
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

PHET4

CC ID: 1373163
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

PHST1

CC ID: 1373164
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

If partial haul, time started.

MS Access caption: No caption."

PHST2

CC ID: 1373165
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

PHST3

CC ID: 1373166
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

PHST4

CC ID: 1373167
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

PLATFORM

CC ID: 1373168
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Platform from which observations were made

MS Access caption: Platform code(s)"

PRIMKEY

CC ID: 1373169
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

No MS Access metadata.

PROLL

CC ID: 1373170
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Roll number of photographs.

MS Access caption: Roll #."

PSHOT1

CC ID: 1373171
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Beginning frame number.

MS Access caption: Frames #."

PSHOT2

CC ID: 1373172
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Ending frame number.

MS Access caption: to."

PULLG

CC ID: 1373173
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Did fisherman pull the net to keep it taut?

MS Access caption: Pulled gear? (y/n)."

RELNETIN

CC ID: 1373174
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: Inside"

RELNETOUT

CC ID: 1373175
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: Outside"

RUNG

CC ID: 1373176
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Did skipper run gear?

MS Access caption: Run Gear (y/n/u)."

SEABH

CC ID: 1373177
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Sea state code at begining of haul

MS Access caption: No caption."

SEABS

CC ID: 1373178
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Sea state code during soak.

MS Access caption: Sea state."

SETNO

CC ID: 1373179
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Sequential number of set observed per day by observer

MS Access caption: Observed set"

SO1

CC ID: 1373180
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Time when first begin observing.

MS Access caption: Start obs."

SO2

CC ID: 1373181
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

SO3

CC ID: 1373182
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

SO4

CC ID: 1373183
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

No description.

MS Access caption: No caption."

STABH

CC ID: 1373184
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Tide stage code at begin of haul

MS Access caption: Stage."

STABS

CC ID: 1373185
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Tide stage code at begin of soak.

MS Access caption: Stage"

TIDEBH

CC ID: 1373186
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Tide code at beginning of haul

MS Access caption: Tide."

TIDEBS

CC ID: 1373187
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Tide code at beginning of soak.

MS Access caption: Tide"

TIMEBH

CC ID: 1373188
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Time beginning set retrieval or pick.

MS Access caption: Begin haul."

TIMEBS

CC ID: 1373189
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Time of drift/set net set start (or time of set net last haul).

MS Access caption: Begin (set/last haul)."

TIMEEH

CC ID: 1373190
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Time set retrieval ends.

MS Access caption: End haul."

TIMEES

CC ID: 1373191
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Time ofdrift/set net begin soak.

MS Access caption: Begin/soak."

VISBH

CC ID: 1373192
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Visibility code for conditions during haul.

MS Access caption: No caption."

VISBS

CC ID: 1373193
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Visibility code for conditions during soak.

MS Access caption: Visibility."

VPNAME

CC ID: 1373194
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description: Vessel name (drift) or permit holder name (set; last, first, mi)

MS Access caption: Vessel/permit name"

WEABH

CC ID: 1373195
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Weather code for conditions during haul.

MS Access caption: No caption."

WEABS

CC ID: 1373196
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Weather code for conditions during soak.

MS Access caption: Weather."

WNFISH

CC ID: 1373197
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Did entire length and depth of net fish entire set?

MS Access caption: Whole net fished for set (y/n)."

ZONEBH

CC ID: 1373198
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Code for land form at beginning of haul

MS Access caption: ZoneH."

ZONEBS

CC ID: 1373199
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Code for land form during soak.

MS Access caption: Zone."

WLINE

CC ID: 1373200
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

If a weedline is present, how long is the drop? (zero is default if none present)

MS Access caption: If weedline (inch)"

Catalog Details

Catalog Item ID: 75104
GUID: gov.noaa.nmfs.inport:75104
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-05 19:17+0000
Metadata Record Last Modified By: Daniel Woodrich
Metadata Record Last Modified: 2025-05-21 19:12+0000
Metadata Record Published: 2025-05-21
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year