Metadata Rubric

83%

5 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

CI99_FORM2_ENCOUNTERS

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75145 | Updated: May 21, 2025 | Published / External

Item Identification

Title:	CI99_FORM2_ENCOUNTERS

Entity Information

Description:	Table created from MS Access 1999 Cook Inlet Alaska Marine Mammal Observer Program Form 2 encounters. MS Access file CIOP99. 20240715MM

Data Attributes

Attribute Summary

	Name	Type	Description
100	F2KEY	NUMBER(38,0)	"MS Access: Description: Form 2 primary key. Caption: No MS Access caption."
100	F2SAN	VARCHAR2(26 BYTE)	"MS Access: Description: Enter predominate behavior of the animal within about 2 m of net. Caption: at net."
100	F2SB4N	VARCHAR2(26 BYTE)	"MS Access: Description: Enter predominate behavior code for animal outside of 2 m of the net. Caption: b4 net."
100	F2SDC	VARCHAR2(26 BYTE)	"MS Access: Description: Observer provided info on deterrents? Caption: C."
100	F2SDD	VARCHAR2(26 BYTE)	"MS Access: Description: Proximate closest distance that the deterrent came to animal. Caption: Distance."
100	F2SDIC	VARCHAR2(26 BYTE)	"MS Access: Description: Physical impact of deterrent. Caption: Impact code."
100	F2SDM	VARCHAR2(26 BYTE)	"MS Access: Description: Method(s) used to deter mammals/birds from net. Caption: Method."
100	F2SDN	VARCHAR2(26 BYTE)	"MS Access: Description: Effect of presence on deterrent use. Caption: N."
100	F2SDNT	NUMBER(38,0)	"MS Access: Description: Number of times deterrent was used. Caption: # times."
100	F2SDRC	VARCHAR2(26 BYTE)	"MS Access: Description: Animals reaction to deterrent. Caption: React. code."
100	F2SDT	VARCHAR2(26 BYTE)	"MS Access: Description: Time deterrent first used. Caption: Time."
100	F2SGA	VARCHAR2(26 BYTE)	"MS Access: Description: Age code. Caption: A."
100	F2SGC	VARCHAR2(26 BYTE)	"MS Access: Description: Code best reflecting age composition of group. Caption: C."
100	F2SGG	NUMBER(38,0)	"MS Access: Description: Total number of individuals in the larger group. Caption: G#."
100	F2SGS	VARCHAR2(26 BYTE)	"MS Access: Description: Sex codes. Caption: S."
100	F2SIDNO	NUMBER(38,0)	"MS Access: Description: Unique sequential identifier that differentiaties one animal encounter from another. Caption: ID#."
100	F2SNO1	NUMBER(38,0)	"MS Access: Description: Number of individuals grouped on this line sharing same characteristics. Caption: #(1)."
100	F2SSPCO	VARCHAR2(26 BYTE)	"MS Access: Description: Code list provided in manual. Caption: Code."
100	F2SSPNA	VARCHAR2(26 BYTE)	"MS Access: Description: Species name for marine mammals and birds. Caption: Species name."
100	F2ST1	VARCHAR2(26 BYTE)	"MS Access: Description: First time sighted within 10 m of net. Caption: 1st."
100	F2STN	VARCHAR2(26 BYTE)	"MS Access: Description: Enter predominate behavior code for animal in relationship to the net. Caption: to net."
100	F2STT	VARCHAR2(26 BYTE)	"MS Access: Description: Total time spent within 10 m of net. Caption: total."
100	F2SWN	VARCHAR2(26 BYTE)	"MS Access: Description: Code reflecting area of net where the animal spent most time. Caption: where."
100	GUID	VARCHAR2(26 BYTE)	"MS Access: Description: Links Forms 1, 2, 3, and 4 unique to an observed "set". Caption: No MS Access caption."

Name

Type

Description

100

F2KEY

NUMBER(38,0)

"MS Access: Description: Form 2 primary key. Caption: No MS Access caption."

100

F2SAN

VARCHAR2(26 BYTE)

"MS Access: Description: Enter predominate behavior of the animal within about 2 m of net. Caption: at net."

100

F2SB4N

VARCHAR2(26 BYTE)

"MS Access: Description: Enter predominate behavior code for animal outside of 2 m of the net. Caption: b4 net."

100

F2SDC

VARCHAR2(26 BYTE)

"MS Access: Description: Observer provided info on deterrents? Caption: C."

100

F2SDD

VARCHAR2(26 BYTE)

"MS Access: Description: Proximate closest distance that the deterrent came to animal. Caption: Distance."

100

F2SDIC

VARCHAR2(26 BYTE)

"MS Access: Description: Physical impact of deterrent. Caption: Impact code."

100

F2SDM

VARCHAR2(26 BYTE)

"MS Access: Description: Method(s) used to deter mammals/birds from net. Caption: Method."

100

F2SDN

VARCHAR2(26 BYTE)

"MS Access: Description: Effect of presence on deterrent use. Caption: N."

100

F2SDNT

NUMBER(38,0)

"MS Access: Description: Number of times deterrent was used. Caption: # times."

100

F2SDRC

VARCHAR2(26 BYTE)

"MS Access: Description: Animals reaction to deterrent. Caption: React. code."

100

F2SDT

VARCHAR2(26 BYTE)

"MS Access: Description: Time deterrent first used. Caption: Time."

100

F2SGA

VARCHAR2(26 BYTE)

"MS Access: Description: Age code. Caption: A."

100

F2SGC

VARCHAR2(26 BYTE)

"MS Access: Description: Code best reflecting age composition of group. Caption: C."

100

F2SGG

NUMBER(38,0)

"MS Access: Description: Total number of individuals in the larger group. Caption: G#."

100

F2SGS

VARCHAR2(26 BYTE)

"MS Access: Description: Sex codes. Caption: S."

100

F2SIDNO

NUMBER(38,0)

"MS Access: Description: Unique sequential identifier that differentiaties one animal encounter from another. Caption: ID#."

100

F2SNO1

NUMBER(38,0)

"MS Access: Description: Number of individuals grouped on this line sharing same characteristics. Caption: #(1)."

100

F2SSPCO

VARCHAR2(26 BYTE)

"MS Access: Description: Code list provided in manual. Caption: Code."

100

F2SSPNA

VARCHAR2(26 BYTE)

"MS Access: Description: Species name for marine mammals and birds. Caption: Species name."

100

F2ST1

VARCHAR2(26 BYTE)

"MS Access: Description: First time sighted within 10 m of net. Caption: 1st."

100

F2STN

VARCHAR2(26 BYTE)

"MS Access: Description: Enter predominate behavior code for animal in relationship to the net. Caption: to net."

100

F2STT

VARCHAR2(26 BYTE)

"MS Access: Description: Total time spent within 10 m of net. Caption: total."

100

F2SWN

VARCHAR2(26 BYTE)

"MS Access: Description: Code reflecting area of net where the animal spent most time. Caption: where."

100

GUID

VARCHAR2(26 BYTE)

"MS Access: Description: Links Forms 1, 2, 3, and 4 unique to an observed "set". Caption: No MS Access caption."

Attribute Details

F2KEY

CC ID: 1373686

Data Storage Type:	NUMBER(38,0)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Form 2 primary key. Caption: No MS Access caption."

F2SAN

CC ID: 1373687

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Enter predominate behavior of the animal within about 2 m of net. Caption: at net."

F2SB4N

CC ID: 1373688

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Enter predominate behavior code for animal outside of 2 m of the net. Caption: b4 net."

F2SDC

CC ID: 1373689

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Observer provided info on deterrents? Caption: C."

F2SDD

CC ID: 1373690

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Proximate closest distance that the deterrent came to animal. Caption: Distance."

F2SDIC

CC ID: 1373696

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Physical impact of deterrent. Caption: Impact code."

F2SDM

CC ID: 1373697

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Method(s) used to deter mammals/birds from net. Caption: Method."

F2SDN

CC ID: 1373698

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Effect of presence on deterrent use. Caption: N."

F2SDNT

CC ID: 1373699

Data Storage Type:	NUMBER(38,0)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Number of times deterrent was used. Caption: # times."

F2SDRC

CC ID: 1373700

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Animals reaction to deterrent. Caption: React. code."

F2SDT

CC ID: 1373701

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Time deterrent first used. Caption: Time."

F2SGA

CC ID: 1373702

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Age code. Caption: A."

F2SGC

CC ID: 1373703

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Code best reflecting age composition of group. Caption: C."

F2SGG

CC ID: 1373704

Data Storage Type:	NUMBER(38,0)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Total number of individuals in the larger group. Caption: G#."

F2SGS

CC ID: 1373705

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Sex codes. Caption: S."

F2SIDNO

CC ID: 1373706

Data Storage Type:	NUMBER(38,0)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Unique sequential identifier that differentiaties one animal encounter from another. Caption: ID#."

F2SNO1

CC ID: 1373707

Data Storage Type:	NUMBER(38,0)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Number of individuals grouped on this line sharing same characteristics. Caption: #(1)."

F2SSPCO

CC ID: 1373708

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Code list provided in manual. Caption: Code."

F2SSPNA

CC ID: 1373709

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Species name for marine mammals and birds. Caption: Species name."

F2ST1

CC ID: 1373710

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: First time sighted within 10 m of net. Caption: 1st."

F2STN

CC ID: 1373711

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Enter predominate behavior code for animal in relationship to the net. Caption: to net."

F2STT

CC ID: 1373712

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Total time spent within 10 m of net. Caption: total."

F2SWN

CC ID: 1373713

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Code reflecting area of net where the animal spent most time. Caption: where."

GUID

CC ID: 1373714

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Links Forms 1, 2, 3, and 4 unique to an observed "set". Caption: No MS Access caption."

Catalog Details

Catalog Item ID:	75145
GUID:	gov.noaa.nmfs.inport:75145
Metadata Record Created By:	Rachel Wuest
Metadata Record Created:	2025-03-06 15:49+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