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_FORM2

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

Summary

Description

Form2 data from CI00 MS Access Cook Inlet 2000. 20241022MM

Entity Information

Data Attribute / Type Description
F2ASS11US
VARCHAR2(26 BYTE) 		"MS Access: Description: Click if a Form 11US is associated with this Form. MS Access caption: 11US:."
F2ASS3
VARCHAR2(26 BYTE) 		"MS Access: Description: Click if a Form 3 is associated with this Form. MS Access caption: Associated forms 3:."
F2ASS4
VARCHAR2(26 BYTE) 		"MS Access: Description: Click if a Form 4 is associated with this Form. MS Access caption: 4:."
F2COM
VARCHAR2(2048 BYTE) 		"MS Access: Description: Form 2 comments. MS Access caption: Comments:."
F2COMYN
VARCHAR2(26 BYTE) 		"MS Access: Description: Click if comments present. MS Access caption: Comments:."
F2DATE
DATE 		"MS Access: Description: Date observation of set began, match Form 1. MS Access caption: Date (mm/dd/yy)."
F2DID
VARCHAR2(26 BYTE) 		"MS Access: Description: 3 digit unique ID code of debriefer. MS Access caption: Debrief ID."
F2EID
VARCHAR2(26 BYTE) 		"MS Access: Description: 3 digit unique ID code of data enterer. MS Access caption: Entry ID."
F2FID
VARCHAR2(26 BYTE) 		"MS Access: Description: 3 digit unique ID code of check editor. MS Access caption: Field ID."
F2FISHID
VARCHAR2(26 BYTE) 		"MS Access: Description: Fishery ID (S=set; D=Drift) MS Access caption: Fishery."
F2FNLID
VARCHAR2(26 BYTE) 		"MS Access: Description: 3 digit unique ID code of final reviewer. MS Access caption: Final ID."
F2KEY
NUMBER(38,0) 		"MS Access: Description: Form 2 primary key MS Access caption: No caption."
F2LBNO
VARCHAR2(26 BYTE) 		"MS Access: Description: Logbook number with comments. MS Access caption: Logbook #."
F2LBPG
VARCHAR2(26 BYTE) 		"MS Access: Description: Logbook page with comments. MS Access caption: page."
F2LBPGE
VARCHAR2(26 BYTE) 		"MS Access: Description: No description. MS Access caption: to."
F2NETNO
VARCHAR2(26 BYTE) 		"MS Access: Description: Grid layout position of net, should match Form 1. MS Access caption: Net ID code (set net):."
F2OBSID
VARCHAR2(26 BYTE) 		"MS Access: Description: 3 digit unique ID code of observer. MS Access caption: Obs. Code."
F2PERMITID
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:."
F2PRRNO
VARCHAR2(26 BYTE) 		"MS Access: Description: Related photograph roll number. MS Access caption: Roll #."
F2PRSNO
VARCHAR2(26 BYTE) 		"MS Access: Description: Related photograph shot number. MS Access caption: and frame #."
F2SETNO
NUMBER(38,0) 		"MS Access: Description: Sequential number of set observed per day by observer, matches Form 1. MS Access caption: Observed Set #."
F2VPNAME
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_FORM2

Entity Information

Description:

Form2 data from CI00 MS Access Cook Inlet 2000. 20241022MM

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 F2ASS11US VARCHAR2(26 BYTE) "MS Access: Description: Click if a Form 11US is associated with this Form. MS Access caption: 11US:."
100
 F2ASS3 VARCHAR2(26 BYTE) "MS Access: Description: Click if a Form 3 is associated with this Form. MS Access caption: Associated forms 3:."
100
 F2ASS4 VARCHAR2(26 BYTE) "MS Access: Description: Click if a Form 4 is associated with this Form. MS Access caption: 4:."
100
 F2COM VARCHAR2(2048 BYTE) "MS Access: Description: Form 2 comments. MS Access caption: Comments:."
100
 F2COMYN VARCHAR2(26 BYTE) "MS Access: Description: Click if comments present. MS Access caption: Comments:."
100
 F2DATE DATE "MS Access: Description: Date observation of set began, match Form 1. MS Access caption: Date (mm/dd/yy)."
100
 F2DID VARCHAR2(26 BYTE) "MS Access: Description: 3 digit unique ID code of debriefer. MS Access caption: Debrief ID."
100
 F2EID VARCHAR2(26 BYTE) "MS Access: Description: 3 digit unique ID code of data enterer. MS Access caption: Entry ID."
100
 F2FID VARCHAR2(26 BYTE) "MS Access: Description: 3 digit unique ID code of check editor. MS Access caption: Field ID."
100
 F2FISHID VARCHAR2(26 BYTE) "MS Access: Description: Fishery ID (S=set; D=Drift) MS Access caption: Fishery."
100
 F2FNLID VARCHAR2(26 BYTE) "MS Access: Description: 3 digit unique ID code of final reviewer. MS Access caption: Final ID."
100
 F2KEY NUMBER(38,0) "MS Access: Description: Form 2 primary key MS Access caption: No caption."
100
 F2LBNO VARCHAR2(26 BYTE) "MS Access: Description: Logbook number with comments. MS Access caption: Logbook #."
100
 F2LBPG VARCHAR2(26 BYTE) "MS Access: Description: Logbook page with comments. MS Access caption: page."
100
 F2LBPGE VARCHAR2(26 BYTE) "MS Access: Description: No description. MS Access caption: to."
100
 F2NETNO VARCHAR2(26 BYTE) "MS Access: Description: Grid layout position of net, should match Form 1. MS Access caption: Net ID code (set net):."
100
 F2OBSID VARCHAR2(26 BYTE) "MS Access: Description: 3 digit unique ID code of observer. MS Access caption: Obs. Code."
100
 F2PERMITID 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
 F2PRRNO VARCHAR2(26 BYTE) "MS Access: Description: Related photograph roll number. MS Access caption: Roll #."
100
 F2PRSNO VARCHAR2(26 BYTE) "MS Access: Description: Related photograph shot number. MS Access caption: and frame #."
100
 F2SETNO NUMBER(38,0) "MS Access: Description: Sequential number of set observed per day by observer, matches Form 1. MS Access caption: Observed Set #."
100
 F2VPNAME 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

F2ASS11US

CC ID: 1373217
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:."

F2ASS3

CC ID: 1373218
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.

MS Access caption: Associated forms 3:."

F2ASS4

CC ID: 1373219
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:."

F2COM

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

"MS Access: Description:

Form 2 comments.

MS Access caption: Comments:."

F2COMYN

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

"MS Access: Description:

Click if comments present.

MS Access caption: Comments:."

F2DATE

CC ID: 1373222
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)."

F2DID

CC ID: 1373223
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."

F2EID

CC ID: 1373224
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."

F2FID

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

"MS Access: Description:

3 digit unique ID code of check editor.

MS Access caption: Field ID."

F2FISHID

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

"MS Access: Description:

Fishery ID (S=set; D=Drift)

MS Access caption: Fishery."

F2FNLID

CC ID: 1373227
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."

F2KEY

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

"MS Access: Description:

Form 2 primary key

MS Access caption: No caption."

F2LBNO

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

"MS Access: Description:

Logbook number with comments.

MS Access caption: Logbook #."

F2LBPG

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

"MS Access: Description:

Logbook page with comments.

MS Access caption: page."

F2LBPGE

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

"MS Access: Description:

No description.

MS Access caption: to."

F2NETNO

CC ID: 1373232
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):."

F2OBSID

CC ID: 1373233
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."

F2PERMITID

CC ID: 1373234
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:."

F2PRRNO

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

"MS Access: Description:

Related photograph roll number.

MS Access caption: Roll #."

F2PRSNO

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

"MS Access: Description:

Related photograph shot number.

MS Access caption: and frame #."

F2SETNO

CC ID: 1373237
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 #."

F2VPNAME

CC ID: 1373238
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: 75109
GUID: gov.noaa.nmfs.inport:75109
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-05 19:46+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