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 >

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

Summary

Description

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

Entity Information

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

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: CI99_FORM2

Entity Information

Description:

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

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

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