Table: FOREIGN_AGE
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 9558
| Published / External
Created: 2009-06-29
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 9556
ID: 9558
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: FOREIGN_AGE |
---|---|
Short Name | FOREIGN_AGE |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
This table contains age and biological data (and some maturity data) of individual specimens of commercially-important groundfish and Pacific salmon caught in the foreign and joint venture groundfish fishery. |
* Purpose | |
Notes |
Loaded by batch 2364, 06-29-2009 18:15 |
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 | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | NORPAC |
» Description |
This table contains age and biological data (and some maturity data) of individual specimens of commercially-important groundfish and Pacific salmon caught in the foreign and joint venture groundfish fishery. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | CRUISE | NUMBER | A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. |
100 | Yes | No | VESSEL | VARCHAR2 | A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number. |
100 | Yes | No | DT | DATE | Similar to NORPAC.DOMESTIC_AGE.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00). |
100 | Yes | No | YEAR | NUMBER | A four-digit number identifying the year in which the gear retrieval of the haul began. |
100 | Yes | No | HAUL | NUMBER | A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days. |
100 | Yes | Yes | SPECIES | NUMBER | A three-digit numeric code representing a marine species. |
100 | Yes | Yes | SPECIMEN_NUMBER | NUMBER | A unique number assigned a single specimen within a collection. |
100 | Yes | No | SEX | VARCHAR2 | A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown. |
100 | No | No | LENGTH | NUMBER | The fork length in centimeters. |
100 | No | No | AGE | NUMBER | The age of the fish, recorded in years. Recorded by age readers following examination of the specimens in the age determination laboratory. |
100 | No | No | INDIV_WEIGHT | NUMBER | The weight (to one-hundredth of a kilogram) of the individual fish from which the age structure (or maturity information) was taken. |
100 | No | No | SPECIAL_HANDLING | NUMBER | A one-digit numeric code associated with additional information related to the fish. NORPAC.FOREIGN_SPECIAL_HANDLING provides a description of the codes. |
100 | No | No | TOTAL_AGE | NUMBER | Unknown definition. Likely to have been a field used by the REFM Age Unit. A single numeric digit 0-9. Recorded for years 1975, 1976, 1977, 1983, and 1986, and only for salmon species 221, 222, and 223. |
100 | No | No | MATURITY_CODE | NUMBER | A one-digit numeric code used to identify the developmental stage of gonads. The meaning of the maturity code depends on the species for which the information is being collected. NORPAC.FOREIGN_MATURITY_CODE uses SPECIES and MATURITY_CODE to provide a description of the codes. |
100 | No | No | FILENAME | VARCHAR2 | he original filename on the Burroughs computer system from which this data record came. |
100 | Yes | Yes | HAUL_JOIN | NUMBER | Unique assigned number. Forms a one to many link between the foreign_haul table and the foreign_age table. |
Attribute Details
Attribute Name | CRUISE |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
A unique four-digit number assigned to the observer for the length of their contract period. This number alone identifies and groups a set of observer information. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
NORPAC.FOREIGN_FISHING_OPERATI |
Derivation | |
Validation Rules |
Attribute Name | VESSEL |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A unique, four-digit, alpha-numeric code identifying each vessel that contracts for observer coverage. All vessel codes begin with the alpha code B, followed by a three-digit number. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
Refers to more than one entity |
Derivation | |
Validation Rules |
Attribute Name | DT |
---|---|
Seq. Order | 3 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Similar to NORPAC.DOMESTIC_AGE.HAUL_DATE, this is the date in Greenwich Mean Time. Format is stored in the database as DD-MON-YY format (i.e., 15-MAR-86), and displayed as MM/DD/YYYY HH:MI:SS (i.e., 3/15/86 00:00:00). |
General Data Type | DATE |
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 | YEAR |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
A four-digit number identifying the year in which the gear retrieval of the haul began. |
General Data Type | NUMBER |
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 | HAUL |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
A unique number which identifies a specific occurrence of net, pot, or longline fishing effort. This table does not include "no fishing" days. |
General Data Type | NUMBER |
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 | SPECIES |
---|---|
Seq. Order | 6 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
A three-digit numeric code representing a marine species. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
Refers to more than one entity |
Derivation | |
Validation Rules |
Attribute Name | SPECIMEN_NUMBER |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
A unique number assigned a single specimen within a collection. |
General Data Type | NUMBER |
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 | SEX |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A one-digit alpha code indicating the sex of the organism. F = female, M = male, U = unknown. |
General Data Type | VARCHAR2 |
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 | LENGTH |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
The fork length in centimeters. |
General Data Type | NUMBER |
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 | AGE |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
The age of the fish, recorded in years. Recorded by age readers following examination of the specimens in the age determination laboratory. |
General Data Type | NUMBER |
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 | INDIV_WEIGHT |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 2 |
Status | Active |
Description |
The weight (to one-hundredth of a kilogram) of the individual fish from which the age structure (or maturity information) was taken. |
General Data Type | NUMBER |
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 | SPECIAL_HANDLING |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | 0 |
Status | Active |
Description |
A one-digit numeric code associated with additional information related to the fish. NORPAC.FOREIGN_SPECIAL_HANDLING provides a description of the codes. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
NORPAC.FOREIGN_SPECIAL_HANDLIN |
Derivation | |
Validation Rules |
Attribute Name | TOTAL_AGE |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | 0 |
Status | Active |
Description |
Unknown definition. Likely to have been a field used by the REFM Age Unit. A single numeric digit 0-9. Recorded for years 1975, 1976, 1977, 1983, and 1986, and only for salmon species 221, 222, and 223. |
General Data Type | NUMBER |
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 | MATURITY_CODE |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | 0 |
Status | Active |
Description |
A one-digit numeric code used to identify the developmental stage of gonads. The meaning of the maturity code depends on the species for which the information is being collected. NORPAC.FOREIGN_MATURITY_CODE uses SPECIES and MATURITY_CODE to provide a description of the codes. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
NORPAC.FOREIGN_MATURITY_CODE |
Derivation | |
Validation Rules |
Attribute Name | FILENAME |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
he original filename on the Burroughs computer system from which this data record came. |
General Data Type | VARCHAR2 |
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 | HAUL_JOIN |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | 6 |
Scale | 0 |
Status | Active |
Description |
Unique assigned number. Forms a one to many link between the foreign_haul table and the foreign_age table. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations |
NORPAC.FOREIGN_HAUL |
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
* » 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 | 9558 |
---|---|
Metadata Record Created By | Doug Turnbull |
Metadata Record Created | 2009-06-29 18:15+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2016-05-18 |
Owner Org | AFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2016-05-18 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-05-18 |
Tags |
---|