Metadata Rubric

83%

5 / 6

View Report

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

CI99_FORM3

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

Title:	CI99_FORM3

Entity Information

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

Data Attributes

Attribute Summary

	Name	Type	Description
100	F3ASS11US	VARCHAR2(26 BYTE)	"MS Access: Description: Click if a Form 11US is associated with this Form. MS Access caption: 11US:."
100	F3ASS2	VARCHAR2(26 BYTE)	"MS Access: Description: Click if a Form 2 is associated with this Form. MS Access caption: Associated forms 2:."
100	F3ASS4	VARCHAR2(26 BYTE)	"MS Access: Description: Click if a Form 4 is associated with this Form. MS Access caption: 4:."
100	F3COM	VARCHAR2(2048 BYTE)	"MS Access: Description: Form 3 Comments MS Access caption: Comments:."
100	F3DATE	DATE	"MS Access: Description: Date observation of set began, match Form 1. MS Access caption: Date (mm/dd/yy)."
100	F3DID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of debriefer. MS Access caption: Debrief ID."
100	F3EID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of data enterer. MS Access caption: Entry ID."
100	F3FID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of field editor. Caption: Field ID."
100	F3FISHID	VARCHAR2(26 BYTE)	"MS Access: Description: No description. MS Access caption: Fishery."
100	F3FNLID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of final reviewer. MS Access caption: Final ID."
100	F3KEY	NUMBER(38,0)	"MS Access: Description: Form 3 primary key. Caption: No MS Access caption."
100	F3LBNO	VARCHAR2(26 BYTE)	"MS Access: Description: Logbook number with comments. MS Access caption: (for more info, see logbook #."
100	F3LBPG	NUMBER(38,0)	"MS Access: Description: Logbook page with comments. MS Access caption: and page #."
100	F3NETNO	VARCHAR2(26 BYTE)	"MS Access: Description: Grid layout position of net, should match Form 1. MS Access caption: Net ID code (set net):."
100	F3OBSID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of observer. MS Access caption: Obs. Code."
100	F3PERMITID	VARCHAR2(26 BYTE)	"MS Access: Description: CFEC permit (set) or ADFG vessel (drift) number and check digit, should match Form 1. MS Access caption: Permit code:."
100	F3PRRNO	NUMBER(38,0)	"MS Access: Description: Related photograph roll number. MS Access caption: For photo, see roll #."
100	F3PRSNO	NUMBER(38,0)	"MS Access: Description: Related photograph shot number. MS Access caption: and shot #."
100	F3SETNO	NUMBER(38,0)	"MS Access: Description: Sequential number of set observed per day by observer, matches Form 1. MS Access caption: Observed Set #."
100	F3VPNAME	VARCHAR2(26 BYTE)	"MS Access: Description: Vessel name (drift) or permit holder name (set; last, first, mi) MS Access caption: Vessel/permit name."
100	F3OID	VARCHAR2(26 BYTE)	"MS Access: Description: 3 digit unique ID code of office editor. Caption: Office ID."
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

F3ASS11US

VARCHAR2(26 BYTE)

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

100

F3ASS2

VARCHAR2(26 BYTE)

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

100

F3ASS4

VARCHAR2(26 BYTE)

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

100

F3COM

VARCHAR2(2048 BYTE)

"MS Access: Description: Form 3 Comments MS Access caption: Comments:."

100

F3DATE

DATE

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

100

F3DID

VARCHAR2(26 BYTE)

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

100

F3EID

VARCHAR2(26 BYTE)

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

100

F3FID

VARCHAR2(26 BYTE)

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

100

F3FISHID

VARCHAR2(26 BYTE)

"MS Access: Description: No description. MS Access caption: Fishery."

100

F3FNLID

VARCHAR2(26 BYTE)

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

100

F3KEY

NUMBER(38,0)

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

100

F3LBNO

VARCHAR2(26 BYTE)

"MS Access: Description: Logbook number with comments. MS Access caption: (for more info, see logbook #."

100

F3LBPG

NUMBER(38,0)

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

100

F3NETNO

VARCHAR2(26 BYTE)

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

100

F3OBSID

VARCHAR2(26 BYTE)

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

100

F3PERMITID

VARCHAR2(26 BYTE)

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

100

F3PRRNO

NUMBER(38,0)

"MS Access: Description: Related photograph roll number. MS Access caption: For photo, see roll #."

100

F3PRSNO

NUMBER(38,0)

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

100

F3SETNO

NUMBER(38,0)

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

100

F3VPNAME

VARCHAR2(26 BYTE)

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

100

F3OID

VARCHAR2(26 BYTE)

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

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

F3ASS11US

CC ID: 1373715

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. MS Access caption: 11US:."

F3ASS2

CC ID: 1373716

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

F3ASS4

CC ID: 1373717

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. MS Access caption: 4:."

F3COM

CC ID: 1373718

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

F3DATE

CC ID: 1373719

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

F3DID

CC ID: 1373720

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

F3EID

CC ID: 1373721

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. MS Access caption: Entry ID."

F3FID

CC ID: 1373722

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."

F3FISHID

CC ID: 1373723

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

F3FNLID

CC ID: 1373724

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. MS Access caption: Final ID."

F3KEY

CC ID: 1373725

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

F3LBNO

CC ID: 1373726

Data Storage Type:	VARCHAR2(26 BYTE)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Logbook number with comments. MS Access caption: (for more info, see logbook #."

F3LBPG

CC ID: 1373727

Data Storage Type:	NUMBER(38,0)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Logbook page with comments. MS Access caption: and page #."

F3NETNO

CC ID: 1373728

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. MS Access caption: Net ID code (set net):."

F3OBSID

CC ID: 1373729

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

F3PERMITID

CC ID: 1373730

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. MS Access caption: Permit code:."

F3PRRNO

CC ID: 1373731

Data Storage Type:	NUMBER(38,0)
Required:	No
Primary Key:	No
Status:	Active
Description:	"MS Access: Description: Related photograph roll number. MS Access caption: For photo, see roll #."

F3PRSNO

CC ID: 1373732

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

F3SETNO

CC ID: 1373733

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. MS Access caption: Observed Set #."

F3VPNAME

CC ID: 1373734

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."

F3OID

CC ID: 1373755

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."

GUID

CC ID: 1373756

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:	75146
GUID:	gov.noaa.nmfs.inport:75146
Metadata Record Created By:	Rachel Wuest
Metadata Record Created:	2025-03-06 16:18+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

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

F3ASS11US

F3ASS2

F3ASS4

F3COM

F3DATE

F3DID

F3EID

F3FID

F3FISHID

F3FNLID

F3KEY

F3LBNO

F3LBPG

F3NETNO

F3OBSID

F3PERMITID

F3PRRNO

F3PRSNO

F3SETNO

F3VPNAME

F3OID

GUID

Catalog Details