Downtime Notice: Thursday, May 29 @ 2:00pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 6.0.2. Downtime Schedule May 29, 2025 2:00pm - 3:00pm Eastern / 11:00am - 12:00pm Pacific / 8:00am - 9:00am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheri...
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_FORM3

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

Summary

Description

Form 3 MS Access Cook Inlet 2000 20241022MM

Entity Information

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

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_FORM3

Entity Information

Description:

Form 3 MS Access Cook Inlet 2000 20241022MM

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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(1024 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 checker. MS Access caption: Check 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. MS Access caption: No 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."

Attribute Details

F3ASS11US

CC ID: 1373262
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: 1373263
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: 1373264
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: 1373265
Data Storage Type: VARCHAR2(1024 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Form 3 Comments

MS Access caption: Comments:."

F3DATE

CC ID: 1373266
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: 1373267
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: 1373268
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: 1373269
Data Storage Type: VARCHAR2(26 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

3 digit unique ID code of checker.

MS Access caption: Check ID."

F3FISHID

CC ID: 1373270
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: 1373271
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: 1373272
Data Storage Type: NUMBER(38,0)
Required: No
Primary Key: No
Status: Active
Description:

"MS Access: Description:

Form 3 primary key.

MS Access caption: No caption."

F3LBNO

CC ID: 1373273
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: 1373274
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: 1373275
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: 1373276
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: 1373277
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: 1373278
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: 1373279
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: 1373280
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: 1373281
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."

Catalog Details

Catalog Item ID: 75111
GUID: gov.noaa.nmfs.inport:75111
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-05 20:21+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