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_FORM3_ENTANGLEMENTS

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

Summary

Description

MS Access Cook Inlet 2000 Form3 entanglements

Entity Information

Data Attribute / Type Description
F3KEY
NUMBER(38,0) 		"MS Access: Description: Form 3 linking key. MS Access caption: No caption."
F3S
VARCHAR2(26 BYTE) 		"MS Access: Description: Offshore code MS Access caption: S."
F3SA
VARCHAR2(26 BYTE) 		"MS Access: Description: Age of entangled animal. MS Access caption: Age."
F3SCC
VARCHAR2(26 BYTE) 		"MS Access: Description: Condition Code MS Access caption: Cond. CCode."
F3SID
NUMBER(38,0) 		"MS Access: Description: Sequential ID number. MS Access caption: ID#."
F3SIU
VARCHAR2(26 BYTE) 		"MS Access: Description: U if first observation, I if linked to Form 2. MS Access caption: (I/U)."
F3SL
NUMBER(38,0) 		"MS Access: Description: Marine mammal length in centimeters, bird bill length in mm MS Access caption: Length."
F3SLM
VARCHAR2(26 BYTE) 		"MS Access: Description: Length measurement in cm or mm? MS Access caption: (cm/mm)."
F3SLT
VARCHAR2(26 BYTE) 		"MS Access: Description: Length estimated or actual? MS Access caption: (e/a)."
F3SOEN
VARCHAR2(26 BYTE) 		"MS Access: Description: Observer effect MS Access caption: N."
F3SOER
VARCHAR2(26 BYTE) 		"MS Access: Description: Observer effect at release. MS Access caption: R."
F3SPA
VARCHAR2(26 BYTE) 		"MS Access: Description: Position along net codes. MS Access caption: Along."
F3SPD
VARCHAR2(26 BYTE) 		"MS Access: Description: Code for depth where entanglement occurred MS Access caption: Depth."
F3SRC
VARCHAR2(26 BYTE) 		"MS Access: Description: Release codes MS Access caption: Rel. Code."
F3SRT
VARCHAR2(26 BYTE) 		"MS Access: Description: Time of release from net. MS Access caption: Cond. Time."
F3SS
VARCHAR2(26 BYTE) 		"MS Access: Description: Sex of entangled animal. MS Access caption: Sex."
F3SSAM
VARCHAR2(26 BYTE) 		"MS Access: Description: If samples, their ID number. MS Access caption: Sample sp. code#."
F3SSC
VARCHAR2(26 BYTE) 		"MS Access: Description: Code list provided in manual. MS Access caption: Spec. Code."
F3SSN
VARCHAR2(26 BYTE) 		"MS Access: Description: Species name for mammals and birds. MS Access caption: Species name."
F3STI
VARCHAR2(26 BYTE) 		"MS Access: Description: Actual or estimated time of entanglement MS Access caption: Time."

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_ENTANGLEMENTS

Entity Information

Description:

MS Access Cook Inlet 2000 Form3 entanglements

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 F3KEY NUMBER(38,0) "MS Access: Description: Form 3 linking key. MS Access caption: No caption."
100
 F3S VARCHAR2(26 BYTE) "MS Access: Description: Offshore code MS Access caption: S."
100
 F3SA VARCHAR2(26 BYTE) "MS Access: Description: Age of entangled animal. MS Access caption: Age."
100
 F3SCC VARCHAR2(26 BYTE) "MS Access: Description: Condition Code MS Access caption: Cond. CCode."
100
 F3SID NUMBER(38,0) "MS Access: Description: Sequential ID number. MS Access caption: ID#."
100
 F3SIU VARCHAR2(26 BYTE) "MS Access: Description: U if first observation, I if linked to Form 2. MS Access caption: (I/U)."
100
 F3SL NUMBER(38,0) "MS Access: Description: Marine mammal length in centimeters, bird bill length in mm MS Access caption: Length."
100
 F3SLM VARCHAR2(26 BYTE) "MS Access: Description: Length measurement in cm or mm? MS Access caption: (cm/mm)."
100
 F3SLT VARCHAR2(26 BYTE) "MS Access: Description: Length estimated or actual? MS Access caption: (e/a)."
100
 F3SOEN VARCHAR2(26 BYTE) "MS Access: Description: Observer effect MS Access caption: N."
100
 F3SOER VARCHAR2(26 BYTE) "MS Access: Description: Observer effect at release. MS Access caption: R."
100
 F3SPA VARCHAR2(26 BYTE) "MS Access: Description: Position along net codes. MS Access caption: Along."
100
 F3SPD VARCHAR2(26 BYTE) "MS Access: Description: Code for depth where entanglement occurred MS Access caption: Depth."
100
 F3SRC VARCHAR2(26 BYTE) "MS Access: Description: Release codes MS Access caption: Rel. Code."
100
 F3SRT VARCHAR2(26 BYTE) "MS Access: Description: Time of release from net. MS Access caption: Cond. Time."
100
 F3SS VARCHAR2(26 BYTE) "MS Access: Description: Sex of entangled animal. MS Access caption: Sex."
100
 F3SSAM VARCHAR2(26 BYTE) "MS Access: Description: If samples, their ID number. MS Access caption: Sample sp. code#."
100
 F3SSC VARCHAR2(26 BYTE) "MS Access: Description: Code list provided in manual. MS Access caption: Spec. Code."
100
 F3SSN VARCHAR2(26 BYTE) "MS Access: Description: Species name for mammals and birds. MS Access caption: Species name."
100
 F3STI VARCHAR2(26 BYTE) "MS Access: Description: Actual or estimated time of entanglement MS Access caption: Time."

Attribute Details

F3KEY

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

"MS Access: Description:

Form 3 linking key.

MS Access caption: No caption."

F3S

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

"MS Access: Description:

Offshore code

MS Access caption: S."

F3SA

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

"MS Access: Description:

Age of entangled animal.

MS Access caption: Age."

F3SCC

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

"MS Access: Description:

Condition Code

MS Access caption: Cond. CCode."

F3SID

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

"MS Access: Description:

Sequential ID number.

MS Access caption: ID#."

F3SIU

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

"MS Access: Description:

U if first observation, I if linked to Form 2.

MS Access caption: (I/U)."

F3SL

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

"MS Access: Description:

Marine mammal length in centimeters, bird bill length in mm

MS Access caption: Length."

F3SLM

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

"MS Access: Description:

Length measurement in cm or mm?

MS Access caption: (cm/mm)."

F3SLT

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

"MS Access: Description:

Length estimated or actual?

MS Access caption: (e/a)."

F3SOEN

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

"MS Access: Description:

Observer effect

MS Access caption: N."

F3SOER

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

"MS Access: Description:

Observer effect at release.

MS Access caption: R."

F3SPA

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

"MS Access: Description:

Position along net codes.

MS Access caption: Along."

F3SPD

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

"MS Access: Description:

Code for depth where entanglement occurred

MS Access caption: Depth."

F3SRC

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

"MS Access: Description:

Release codes

MS Access caption: Rel. Code."

F3SRT

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

"MS Access: Description:

Time of release from net.

MS Access caption: Cond. Time."

F3SS

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

"MS Access: Description:

Sex of entangled animal.

MS Access caption: Sex."

F3SSAM

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

"MS Access: Description:

If samples, their ID number.

MS Access caption: Sample sp. code#."

F3SSC

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

"MS Access: Description:

Code list provided in manual.

MS Access caption: Spec. Code."

F3SSN

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

"MS Access: Description:

Species name for mammals and birds.

MS Access caption: Species name."

F3STI

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

"MS Access: Description:

Actual or estimated time of entanglement

MS Access caption: Time."

Catalog Details

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