CI99_FORM3_ENTANGLEMENTS

Alaska Fisheries Science Center
Entity (ENT) | ID: 75147 | Published / External
Created: 2025-03-06   |   Last Modified: 2025-05-21

Parent: AMMOP Oracle database 1999 - 2013
Data Set (DS) | ID: 75024

ID: 75147
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title CI99_FORM3_ENTANGLEMENTS
Short Name  
* Status  
Creation Date  
Revision Date  
• Publication Date  
* » Abstract
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type  
Active Version?  
Alias  
Schema Name  
» Description

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

Data Attributes

Attribute Summary

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

Attribute Name F3KEY
Seq. Order  
Data Storage Type NUMBER(38,0)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Form 3 linking key.

MS Access caption: No caption."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SA
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Age of entangled animal.

MS Access caption: Age."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SCC
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Condition Code

MS Access caption: Cond. CCode."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SID
Seq. Order  
Data Storage Type NUMBER(38,0)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Sequential ID number.

MS Access caption: ID#."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SIU
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

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

MS Access caption: (I/U)."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SL
Seq. Order  
Data Storage Type NUMBER(38,0)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Marine mammal length in centimeters, bird bill length in mm

MS Access caption: Length."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SLM
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Length measurement in cm or mm?

MS Access caption: (cm/mm)."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SLT
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Length estimated or actual?

MS Access caption: (e/a)."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SOEN
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Observer effect

MS Access caption: N."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SOER
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Observer effect at release.

MS Access caption: R."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SPA
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Position along net codes.

MS Access caption: Along."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SPD
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Code for depth where entanglement occurred

MS Access caption: Depth."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SRC
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Release codes

MS Access caption: Rel. Code."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SRT
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Time of release from net.

MS Access caption: Cond. Time."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SS
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Sex of entangled animal.

MS Access caption: Sex."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SSAM
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

If samples, their ID number.

MS Access caption: Sample sp. code#."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SSC
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Code list provided in manual.

MS Access caption: Spec. Code."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SSN
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Species name for mammals and birds.

MS Access caption: Species name."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3STI
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Actual or estimated time of entanglement

MS Access caption: Time."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name F3SNO1
Seq. Order  
Data Storage Type NUMBER(38,0)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Number of individuals sharing same characteristics.

Caption: #(1)."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name GUID
Seq. Order  
Data Storage Type VARCHAR2(26 BYTE)
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

"MS Access: Description:

Links Forms 1, 2, 3, and 4 unique to an observed "set".

Caption: No MS Access caption."
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 75147
Metadata Record Created By Rachel Wuest
Metadata Record Created 2025-03-06 16:26+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 Workflow State Published / External
Metadata Last Review Date  
Metadata Review Frequency 1 Year
Metadata Next Review Date  
Tags