Metadata Rubric

83%

5 / 6

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

CI99_FORM2

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Description

Table created from MS Access 1999 Cook Inlet Alaska Marine Mammal Observer Program Form 2. MS Access file CIOP99. 20240712MM

Data Attribute / Type	Description
F2ASS11US VARCHAR2(26 BYTE)	"MS Access: Description: Click if a Form 11US is associated with this Form. Caption: 11US:."
F2ASS3 VARCHAR2(26 BYTE)	"MS Access: Description: Click if a Form 3 is associated with this Form. Caption: Associated forms 3:."
F2ASS4 VARCHAR2(26 BYTE)	"MS Access: Description: Click if a Form 4 is associated with this Form. Caption: 4:."
F2COM VARCHAR2(2048 BYTE)	"MS Access: Description: Form 2 comments. Caption: Comments:"
F2COMYN VARCHAR2(26 BYTE)	"MS Access: Description: Click if comments present. Caption: Comments:."
F2DATE DATE	"MS Access: Description: Date observation of set began, match Form 1. Caption: Date (mm/dd/yy)."
F2DID VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of debriefer. Caption: Debrief ID."
F2EID VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of data enterer. Caption: Entry ID."
F2FID VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of field editor. Caption: Field ID."
F2FISHID VARCHAR2(26 BYTE)	"MS Access: Description: Fishery observed. Caption: Fishery:."
F2FNLID VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of final reviewer. Caption: Final ID."
F2KEY NUMBER(38,0)	MS Access: Description: Form 2 primary key. Caption: No MS Access caption.
F2LBNO VARCHAR2(26 BYTE)	"MS Access: Description: Logbook number with comments. Caption: (if yes): logbook #"
F2LBPG VARCHAR2(26 BYTE)	"MS Access: Description: Logbook page with comments. Caption: and page #."
F2LBREF VARCHAR2(26 BYTE)	"MS Access: Description: Relevant comments in logbook? Caption: Logbook reference?"
F2NETNO VARCHAR2(26 BYTE)	"MS Access: Description: Grid layout position of net, should match Form 1. Caption: Net ID code (set net):."
F2OBSID VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of observer. Caption: Obs. Code."
F2OID VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of office editor. Caption: Office ID."
F2PERMITID VARCHAR2(26 BYTE)	"MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit, should match Form 1. Caption: Permit code:."
F2PR VARCHAR2(26 BYTE)	"MS Access: Description: Related photograph taken? Caption: Photo reference (Y/N):."
F2PRRNO NUMBER(38,0)	"MS Access: Description: Related photograph roll number. Caption: (if yes): roll #."
F2PRSNO NUMBER(38,0)	"MS Access: Description: Related photograph shot number. Caption: and shot #."
F2SETNO NUMBER(38,0)	"MS Access: Description: Sequential number of set observed per day by observer, matches Form 1. Caption: Observed Set #."
F2VPNAME VARCHAR2(26 BYTE)	"MS Access: Description: Vessel name (drift) or permit holder name (set; last, first, mi). Caption: Vessel/permit name."
GUID VARCHAR2(26 BYTE)	"MS Access: Description: Links Forms 1, 2, 3, and 4 unique to an observed "set". Caption: No MS Access caption."

Data Attribute / Type

Description

F2ASS11US
VARCHAR2(26 BYTE)

"MS Access: Description: Click if a Form 11US is associated with this Form. Caption: 11US:."

F2ASS3
VARCHAR2(26 BYTE)

"MS Access: Description: Click if a Form 3 is associated with this Form. Caption: Associated forms 3:."

F2ASS4
VARCHAR2(26 BYTE)

"MS Access: Description: Click if a Form 4 is associated with this Form. Caption: 4:."

F2COM
VARCHAR2(2048 BYTE)

"MS Access: Description: Form 2 comments. Caption: Comments:"

F2COMYN
VARCHAR2(26 BYTE)

"MS Access: Description: Click if comments present. Caption: Comments:."

F2DATE
DATE

"MS Access: Description: Date observation of set began, match Form 1. Caption: Date (mm/dd/yy)."

F2DID
VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of debriefer. Caption: Debrief ID."

F2EID
VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of data enterer. Caption: Entry ID."

F2FID
VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of field editor. Caption: Field ID."

F2FISHID
VARCHAR2(26 BYTE)

"MS Access: Description: Fishery observed. Caption: Fishery:."

F2FNLID
VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of final reviewer. Caption: Final ID."

F2KEY
NUMBER(38,0)

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

F2LBNO
VARCHAR2(26 BYTE)

"MS Access: Description: Logbook number with comments. Caption: (if yes): logbook #"

F2LBPG
VARCHAR2(26 BYTE)

"MS Access: Description: Logbook page with comments. Caption: and page #."

F2LBREF
VARCHAR2(26 BYTE)

"MS Access: Description: Relevant comments in logbook? Caption: Logbook reference?"

F2NETNO
VARCHAR2(26 BYTE)

"MS Access: Description: Grid layout position of net, should match Form 1. Caption: Net ID code (set net):."

F2OBSID
VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of observer. Caption: Obs. Code."

F2OID
VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of office editor. Caption: Office ID."

F2PERMITID
VARCHAR2(26 BYTE)

"MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit, should match Form 1. Caption: Permit code:."

F2PR
VARCHAR2(26 BYTE)

"MS Access: Description: Related photograph taken? Caption: Photo reference (Y/N):."

F2PRRNO
NUMBER(38,0)

"MS Access: Description: Related photograph roll number. Caption: (if yes): roll #."

F2PRSNO
NUMBER(38,0)

"MS Access: Description: Related photograph shot number. Caption: and shot #."

F2SETNO
NUMBER(38,0)

"MS Access: Description: Sequential number of set observed per day by observer, matches Form 1. Caption: Observed Set #."

F2VPNAME
VARCHAR2(26 BYTE)

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

GUID
VARCHAR2(26 BYTE)

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

No Child Items for this record.

No contact information is available for this record.

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

Title:	CI99_FORM2

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

Attribute Summary

	Name	Type	Description
100	F2ASS11US	VARCHAR2(26 BYTE)	"MS Access: Description: Click if a Form 11US is associated with this Form. Caption: 11US:."
100	F2ASS3	VARCHAR2(26 BYTE)	"MS Access: Description: Click if a Form 3 is associated with this Form. Caption: Associated forms 3:."
100	F2ASS4	VARCHAR2(26 BYTE)	"MS Access: Description: Click if a Form 4 is associated with this Form. Caption: 4:."
100	F2COM	VARCHAR2(2048 BYTE)	"MS Access: Description: Form 2 comments. Caption: Comments:"
100	F2COMYN	VARCHAR2(26 BYTE)	"MS Access: Description: Click if comments present. Caption: Comments:."
100	F2DATE	DATE	"MS Access: Description: Date observation of set began, match Form 1. Caption: Date (mm/dd/yy)."
100	F2DID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of debriefer. Caption: Debrief ID."
100	F2EID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of data enterer. Caption: Entry ID."
100	F2FID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of field editor. Caption: Field ID."
100	F2FISHID	VARCHAR2(26 BYTE)	"MS Access: Description: Fishery observed. Caption: Fishery:."
100	F2FNLID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of final reviewer. Caption: Final ID."
100	F2KEY	NUMBER(38,0)	MS Access: Description: Form 2 primary key. Caption: No MS Access caption.
100	F2LBNO	VARCHAR2(26 BYTE)	"MS Access: Description: Logbook number with comments. Caption: (if yes): logbook #"
100	F2LBPG	VARCHAR2(26 BYTE)	"MS Access: Description: Logbook page with comments. Caption: and page #."
100	F2LBREF	VARCHAR2(26 BYTE)	"MS Access: Description: Relevant comments in logbook? Caption: Logbook reference?"
100	F2NETNO	VARCHAR2(26 BYTE)	"MS Access: Description: Grid layout position of net, should match Form 1. Caption: Net ID code (set net):."
100	F2OBSID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of observer. Caption: Obs. Code."
100	F2OID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of office editor. Caption: Office ID."
100	F2PERMITID	VARCHAR2(26 BYTE)	"MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit, should match Form 1. Caption: Permit code:."
100	F2PR	VARCHAR2(26 BYTE)	"MS Access: Description: Related photograph taken? Caption: Photo reference (Y/N):."
100	F2PRRNO	NUMBER(38,0)	"MS Access: Description: Related photograph roll number. Caption: (if yes): roll #."
100	F2PRSNO	NUMBER(38,0)	"MS Access: Description: Related photograph shot number. Caption: and shot #."
100	F2SETNO	NUMBER(38,0)	"MS Access: Description: Sequential number of set observed per day by observer, matches Form 1. Caption: Observed Set #."
100	F2VPNAME	VARCHAR2(26 BYTE)	"MS Access: Description: Vessel name (drift) or permit holder name (set; last, first, mi). Caption: Vessel/permit name."
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

F2ASS11US

VARCHAR2(26 BYTE)

"MS Access: Description: Click if a Form 11US is associated with this Form. Caption: 11US:."

100

F2ASS3

VARCHAR2(26 BYTE)

"MS Access: Description: Click if a Form 3 is associated with this Form. Caption: Associated forms 3:."

100

F2ASS4

VARCHAR2(26 BYTE)

"MS Access: Description: Click if a Form 4 is associated with this Form. Caption: 4:."

100

F2COM

VARCHAR2(2048 BYTE)

"MS Access: Description: Form 2 comments. Caption: Comments:"

100

F2COMYN

VARCHAR2(26 BYTE)

"MS Access: Description: Click if comments present. Caption: Comments:."

100

F2DATE

DATE

"MS Access: Description: Date observation of set began, match Form 1. Caption: Date (mm/dd/yy)."

100

F2DID

VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of debriefer. Caption: Debrief ID."

100

F2EID

VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of data enterer. Caption: Entry ID."

100

F2FID

VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of field editor. Caption: Field ID."

100

F2FISHID

VARCHAR2(26 BYTE)

"MS Access: Description: Fishery observed. Caption: Fishery:."

100

F2FNLID

VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of final reviewer. Caption: Final ID."

100

F2KEY

NUMBER(38,0)

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

100

F2LBNO

VARCHAR2(26 BYTE)

"MS Access: Description: Logbook number with comments. Caption: (if yes): logbook #"

100

F2LBPG

VARCHAR2(26 BYTE)

"MS Access: Description: Logbook page with comments. Caption: and page #."

100

F2LBREF

VARCHAR2(26 BYTE)

"MS Access: Description: Relevant comments in logbook? Caption: Logbook reference?"

100

F2NETNO

VARCHAR2(26 BYTE)

"MS Access: Description: Grid layout position of net, should match Form 1. Caption: Net ID code (set net):."

100

F2OBSID

VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of observer. Caption: Obs. Code."

100

F2OID

VARCHAR2(26 BYTE)

"MS Access: Description: 3 digit unique ID code of office editor. Caption: Office ID."

100

F2PERMITID

VARCHAR2(26 BYTE)

"MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit, should match Form 1. Caption: Permit code:."

100

F2PR

VARCHAR2(26 BYTE)

"MS Access: Description: Related photograph taken? Caption: Photo reference (Y/N):."

100

F2PRRNO

NUMBER(38,0)

"MS Access: Description: Related photograph roll number. Caption: (if yes): roll #."

100

F2PRSNO

NUMBER(38,0)

"MS Access: Description: Related photograph shot number. Caption: and shot #."

100

F2SETNO

NUMBER(38,0)

"MS Access: Description: Sequential number of set observed per day by observer, matches Form 1. Caption: Observed Set #."

100

F2VPNAME

VARCHAR2(26 BYTE)

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

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

F2ASS11US

CC ID: 1373661

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Click if a Form 11US is associated with this Form. Caption: 11US:."

F2ASS3

CC ID: 1373662

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Click if a Form 3 is associated with this Form. Caption: Associated forms 3:."

F2ASS4

CC ID: 1373663

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Click if a Form 4 is associated with this Form. Caption: 4:."

F2COM

CC ID: 1373664

Data Storage Type:	VARCHAR2(2048 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Form 2 comments. Caption: Comments:"

F2COMYN

CC ID: 1373665

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Click if comments present. Caption: Comments:."

F2DATE

CC ID: 1373666

Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Date observation of set began, match Form 1. Caption: Date (mm/dd/yy)."

F2DID

CC ID: 1373667

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: 3 digit unique ID code of debriefer. Caption: Debrief ID."

F2EID

CC ID: 1373668

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: 3 digit unique ID code of data enterer. Caption: Entry ID."

F2FID

CC ID: 1373669

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: 3 digit unique ID code of field editor. Caption: Field ID."

F2FISHID

CC ID: 1373670

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

F2FNLID

CC ID: 1373671

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: 3 digit unique ID code of final reviewer. Caption: Final ID."

F2KEY

CC ID: 1373672

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.

F2LBNO

CC ID: 1373673

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Logbook number with comments. Caption: (if yes): logbook #"

F2LBPG

CC ID: 1373674

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Logbook page with comments. Caption: and page #."

F2LBREF

CC ID: 1373675

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Relevant comments in logbook? Caption: Logbook reference?"

F2NETNO

CC ID: 1373676

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Grid layout position of net, should match Form 1. Caption: Net ID code (set net):."

F2OBSID

CC ID: 1373677

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: 3 digit unique ID code of observer. Caption: Obs. Code."

F2OID

CC ID: 1373678

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: 3 digit unique ID code of office editor. Caption: Office ID."

F2PERMITID

CC ID: 1373679

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, should match Form 1. Caption: Permit code:."

F2PR

CC ID: 1373680

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Related photograph taken? Caption: Photo reference (Y/N):."

F2PRRNO

CC ID: 1373681

Data Storage Type:	NUMBER(38,0)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Related photograph roll number. Caption: (if yes): roll #."

F2PRSNO

CC ID: 1373682

Data Storage Type:	NUMBER(38,0)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Related photograph shot number. Caption: and shot #."

F2SETNO

CC ID: 1373683

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, matches Form 1. Caption: Observed Set #."

F2VPNAME

CC ID: 1373684

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). Caption: Vessel/permit name."

GUID

CC ID: 1373685

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

CI99_FORM2

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

F2ASS11US

F2ASS3

F2ASS4

F2COM

F2COMYN

F2DATE

F2DID

F2EID

F2FID

F2FISHID

F2FNLID

F2KEY

F2LBNO

F2LBPG

F2LBREF

F2NETNO

F2OBSID

F2OID

F2PERMITID

F2PR

F2PRRNO

F2PRSNO

F2SETNO

F2VPNAME

GUID

Catalog Details