CURRENT_HAUL

Alaska Fisheries Science Center
Entity (ENT) | ID: 28148 | Published / External
Created: 2015-10-23 | Last Modified: 2022-08-09

Parent: AFSC/FMA/Current Observer Data Interface
Data Set (DS) | ID: 28125

ID: 28148
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title	CURRENT_HAUL
Short Name	CURRENT HAUL
* Status	In Work
Creation Date
Revision Date
• Publication Date
* » Abstract	This table contains the transformed haul data for presentation to the AKRO catch accounting. The table is populated and maintained through a combination of NORPAC trigger code and OBSINT procedural code. The chain of events is as follows: INSERT, UPDATE - The ATL_HAUL_OBSINT_AIUDR_T adds haul primary key records to the temp_haul table. A periodic process calls the procedure execute_load_current_haul which controls the extraction and transformation of norpac.atl_haul records for insert or update into current haul. On Delete from ATL_HAUL the trigger performs a cross schema cascade delete to temp_haul and current haul.
* Purpose	Present haul data that have been loaded into production to fishery managers and vessel owners prior the the finalization of those data by debriefing
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
None	2008 AND FORWARD

* Spatial Keywords

Thesaurus	Keyword
None	BS, AI, BSAI, GOA

Stratum Keywords

Thesaurus	Keyword
None	OBSERVER, CURRENT DATA, FISHERY STATISTICS

Instrument Keywords

Thesaurus	Keyword

Platform Keywords

Thesaurus	Keyword

Physical Location

• » Organization	Fisheries Monitoring and Analysis
• » City	Seattle
• » State/Province	WA
• Country	USA
• » Location Description	Alaska Fisheries Science Center

Entity Information

Entity Type	Data Table
Active Version?	Y
Alias	Haul
Schema Name	Obsint
» Description	This table contains the transformed haul data for presentation to the AKRO catch accounting. The table is populated and maintained through a combination of NORPAC trigger code and OBSINT procedural code. The chain of events is as follows: INSERT, UPDATE - The ATL_HAUL_OBSINT_AIUDR_T adds haul primary key records to the temp_haul table. A periodic process calls the procedure execute_load_current_haul which controls the extraction and transformation of norpac.atl_haul records for insert or update into current haul. On Delete from ATL_HAUL the trigger perfoms a cross schema cascade delete to temp_haul and current haul.
Change Summary

Data Attributes

Attribute Summary

Score	Req'd?	PKey?	» Name	Data Storage Type	Description
100	No	No	T_TABLE	VARCHAR2	Identifier of Source Table
100	Yes	No	Cruise	NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for a processing plant observer cruise record
100	Yes	No	Permit	VARCHAR2	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100	No	No	VESSEL	VARCHAR2	VessPlnt code from old NORPAC system plus new vessels recorded in ATL_LOV_Vessel. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic.
100	No	No	HAUL_SEQ	Number	Sequence generated unique identifier for a haul record
100	No	No	TRIP_SEQ	Number	Sequence generated unique identifier for a trip as defined in ATL_fma_trip.
100	No	No	HAUL_DATE	DATE	Date of haul retrieval.
100	No	No	HAUL	Number	Number which is entered by the observer identifying a unique haul within a trip.
100	No	No	HAUL_PURPOSE_CODE	VARCHAR2	Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set.
67	No	No	GEAR_TYPE	Number
100	No	No	PERFORMANCE	NUMBER	Unique performance code for a gear type. see ATL_LOV_gear_perfomrance.
100	No	No	VESSEL_TYPE	Number	Unique identifier of a vessel type, see ATL_LOV_vessel_type
100	No	No	DEPLOYMENT_DATE	DATE	Date and time of gear deployment
100	No	No	DEPLOYMENT_LATITUDE	Number	Gear deployment position. In Degrees and Minutes
100	No	No	DEPLOYMENT_LONGITUDE_CONVERTED	Number	The conversion of longitude is required of values to the east of the 180th meridian. The configuration within Oracle Spatial uses a 360 degree globe - 179 E must therefore be submitted as 181. The calling program must, as in the conversion to decimal degrees submit latitude to the east of the 180th meridian as a negative number.
100	No	No	DEPLOYMENT_E_W	VARCHAR2	Gear deployment position.
100	No	No	FISHING_DEPTH_FATHOMS	Number	Average fishing depth recorded by the observer from the vessel log.
100	No	No	BOTTOM_DEPTH_FATHOMS	Number	Average bottom depth recorded by the observer from the vessel log.
100	No	No	RETRIEVAL_DATE	DATE	Date and time of gear retrieval.
100	No	No	LOCATION	VARCHAR2	Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship).
100	No	No	LATITUDE	Number	Retrieval location in Degrees and Minutes
100	No	No	LONGITUDE	Number	Retrieval location. In Degrees and Minutes
100	No	No	LONGITUDE_CONVERTED	Number	Retrieval location. The conversion of longitude is required of values to the east of the 180th meridian. The configuration within Oracle Spatial uses a 360 degree globe - 179 E must therefore be submitted as 181. The calling program must, as in the conversion to decimal degrees submit latitude to the east of the 180th meridian as a negative number.
100	No	No	E_W	VARCHAR2	Retrieval location.
100	No	No	NMFS_AREA	Number	This attribute is computed using the MDSYS.SDO_GEOMETRY package and an ESRI shape file.
100	No	No	COBLZ_AREA	VARCHAR2	This attribute is computed using the MDSYS.SDO_GEOMETRY package and an ESRI shape file.
100	No	No	VESSEL_ESTIMATE	Number	Total catch weight in metric tons as recorded in the vessel log.
100	No	No	OFFICIAL_TOTAL_CATCH	Number	Total catch weight as computed from the sum of the extrapolate species composition records. For trawl fisheries in the GOA, prohibited species census data may be back apportioned to hauls which constitute an offload if one exists. OTC will then be computed as the sum of the extrapolated species plus the sum of the back apportioned species.
100	No	No	OBSERVER_ESTIMATE	Number	Total catch weight as estimated by the observer in kgs and converted to MT for this presentation.
100	No	No	OBSERVER_ESTIMATE_METHOD	VARCHAR2	Method used to determine the observer estimated catch.
100	No	No	DENSITY	Number	Density used by the observer to determine the total catch weights. Recorded in kgs per m3.
100	No	No	CATCHER_BOAT_ADFGv	Number	If this haul was delivered to a mothership or catcher processor, this attibute records the ADFG registration number of that vessel.
100	No	No	IFQ	VARCHAR2	Flag which identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules.
100	No	No	CDQ_CODE	VARCHAR2	Unique AlphaNumeric code representing a CDQ or research group.
100	No	No	SKATES_IN_SET	Number	Number of skates deployed for longline fishing operations
100	No	No	HOOKS_PER_SKATE	NUMBER	Number of hooks per skate for longline fishing usually calculated as the average number of hooks per segment from the atl_haul_hook_count table.
100	No	No	TOTAL_HOOKS_POTS	NUMBER	Total number of hooks deployed for this haul, usually calculated as the average number of hooks per segment from the atl_haul_hook_count table * the number of skates in set. Or in the case of a pot fishery the total number of pots deployed in a haul.
100	No	No	HAUL_SAMPLED_BY	NUMBER	Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise.
100	No	No	RANDOM_SAMPLE_TABLE	VARCHAR2	Random Sample Reference Table code reference.
100	No	No	RANDOM_BREAK_TABLE	VARCHAR2	Random Break Table identifier Currently limted to Y (es) or N(o).
100	No	No	MM_PERCENT_MONITORED	NUMBER	Percentage of time for this haul where marine mammal monitoring occurred. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100.
100	No	No	BIRD_DETERRENCE	V	Deterrence code from NORPAC bird or mammal deterance tables.
100	No	No	PROCESSOR	VARCHAR2	Processor is computed by atl_utilities, and returns the shore plant processor code for catcher vessels who have an offload, and the processor permit for catcher processors and motherships.
100	No	No	FISHING_START_DATE	DATE	Fishing start date is defined as the first haul deployment of a trip. If the deployment date is null due to unverifiable observer data then the trip start date is used; if null the default is a mandatory value haul retrieval date.
100	No	No	HAUL_JOIN	NUMBER	Surrogate FK to atl_haul. Composed of concatenation of cruise, permit and haul_seq.
100	No	No	DATE_OF_ENTRY	DATE	Date of entry is now (2010) recorded when a haul is loaded into the Norpac data set. In the case that that value is null then it is computed from the latest load date recorded in atl_record_status.';
100	No	No	YEAR	NUMBER	Year is extracted from the haul rettrv_date_time field.
100	No	No	LATDD_END	NUMBER	Latitude decimal degrees is computed from the retrieval latitude.
100	No	No	LONDD_END	NUMBER	Longitude decimal degrees is computed from the retrieval longitude.
100	No	No	LATDD_START	NUMBER	Latitude decimal degrees is computed from the deployment latitude.
100	No	No	LONDD_START	NUMBER	Longitude decimal degrees is computed from the deployment longitude.
100	No	No	RETRV_LONGITUDE_SECONDS	N	Gear retrieval position.
100	No	No	RETRV_LATITUDE_SECONDS	NUMBER	Gear retrieval position.
100	No	No	DEPLOY_LATITUDE_SECONDS	NUMBER	Gear retrieval position.
100	No	No	ATLAS_VERSION	NUMBER	If this haul data was transmitted from the field. This attribute records the version of the software used.
100	No	No	DEPLOYMENT_LONGITUDE	NUMBER	Location of start of haul
100	No	No	HAUL_HASH	VARCHAR2	The haul hash is utilized by AKRO to identify changes to a haul record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value.
100	No	No	SPECIES_HASH	VARCHAR2	The species hash is utilized by AKRO to identify changes to a species composition record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value.
100	No	No	SALMON_HASH	VARCHAR2	The salmon hash is utilized by AKRO to identify changes to a salmon retention record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value.
100	No	No	FLOW_SCALE_WEIGHT	N	Actual weight from the flow scale reading for a haul.
100	No	No	PRESORT_SAMPLE_HASH	Varchar2	The presort hash is utilized by AKRO to identify changes to presort records. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value.
100	No	No	LANDING_REPORT_ID_HASH	VARCHAR2	The landing report id hash is utilized by AKRO to identify changes to the list of eLanding report ids associated with a haul. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value.

Attribute Details

Attribute Name	T_TABLE
Seq. Order	1
Data Storage Type	VARCHAR2
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Identifier of Source Table
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	Cruise
Seq. Order	5
Data Storage Type	NUMBER
Max Length	8
Min Length
Required	Yes
Primary Key	No
Precision	8
Scale	0
Status	Active
Description	Sequence generated by Norpac and supplied to the observer as an unique identifier for a processing plant observer cruise record
General Data Type	Integer
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	Permit
Seq. Order	10
Data Storage Type	VARCHAR2
Max Length	6
Min Length
Required	Yes
Primary Key	No
Precision
Scale
Status	Active
Description	Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type	Character
Unit of Measure
Case Restriction	Upper
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	VESSEL
Seq. Order	15
Data Storage Type	VARCHAR2
Max Length	6
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	VessPlnt code from old NORPAC system plus new vessels recorded in ATL_LOV_Vessel. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic.
General Data Type	Character
Unit of Measure
Case Restriction	Upper
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	HAUL_SEQ
Seq. Order	20
Data Storage Type	Number
Max Length	8
Min Length
Required	No
Primary Key	No
Precision	8
Scale	0
Status	Active
Description	Sequence generated unique identifier for a haul record
General Data Type	Integer
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	TRIP_SEQ
Seq. Order	25
Data Storage Type	Number
Max Length	8
Min Length
Required	No
Primary Key	No
Precision	8
Scale	0
Status	Active
Description	Sequence generated unique identifier for a trip as defined in ATL_fma_trip.
General Data Type	Integer
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_DATE
Seq. Order	30
Data Storage Type	DATE
Max Length	8
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Date of haul retrieval.
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	HAUL
Seq. Order	35
Data Storage Type	Number
Max Length	6
Min Length
Required	No
Primary Key	No
Precision	6
Scale	0
Status	Active
Description	Number which is entered by the observer identifying a unique haul within a trip.
General Data Type	Integer
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_PURPOSE_CODE
Seq. Order	40
Data Storage Type	VARCHAR2
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Haul data may be utilized for catch accounting, stock assessment, or for various special projects. This field is entered by the observer and not validated by ATLAS. Validation is performed when loaded into the production NORPAC data set.
General Data Type	Character
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	GEAR_TYPE
Seq. Order	45
Data Storage Type	Number
Max Length	2
Min Length	2
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description
General Data Type	Integer
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	PERFORMANCE
Seq. Order	50
Data Storage Type	NUMBER
Max Length	2
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Unique performance code for a gear type. see ATL_LOV_gear_perfomrance.
General Data Type	Integer
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	VESSEL_TYPE
Seq. Order	55
Data Storage Type	Number
Max Length	2
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Unique identifier of a vessel type, see ATL_LOV_vessel_type
General Data Type	Integer
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	DEPLOYMENT_DATE
Seq. Order	60
Data Storage Type	DATE
Max Length	12
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Date and time of gear deployment
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	DEPLOYMENT_LATITUDE
Seq. Order	65
Data Storage Type	Number
Max Length	4
Min Length
Required	No
Primary Key	No
Precision	4
Scale	0
Status	Active
Description	Gear deployment position. In Degrees and Minutes
General Data Type	Integer
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	DEPLOYMENT_LONGITUDE_CONVERTED
Seq. Order	70
Data Storage Type	Number
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The conversion of longitude is required of values to the east of the 180th meridian. The configuration within Oracle Spatial uses a 360 degree globe - 179 E must therefore be submitted as 181. The calling program must, as in the conversion to decimal degrees submit latitude to the east of the 180th meridian as a negative number.
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	DEPLOYMENT_E_W
Seq. Order	75
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Gear deployment position.
General Data Type	Character
Unit of Measure
Case Restriction	Upper
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	FISHING_DEPTH_FATHOMS
Seq. Order	80
Data Storage Type	Number
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Average fishing depth recorded by the observer from the vessel log.
General Data Type	Integer
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	BOTTOM_DEPTH_FATHOMS
Seq. Order	85
Data Storage Type	Number
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Average bottom depth recorded by the observer from the vessel log.
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	RETRIEVAL_DATE
Seq. Order	90
Data Storage Type	DATE
Max Length	12
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Date and time of gear retrieval.
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	LOCATION
Seq. Order	95
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Identifies whether the information in a haul is based on retrieval or delivery (as in a mother ship).
General Data Type	Character
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	LATITUDE
Seq. Order	100
Data Storage Type	Number
Max Length	4
Min Length
Required	No
Primary Key	No
Precision	4
Scale	0
Status	Active
Description	Retrieval location in Degrees and Minutes
General Data Type	Integer
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	LONGITUDE
Seq. Order	105
Data Storage Type	Number
Max Length	5
Min Length
Required	No
Primary Key	No
Precision	5
Scale	0
Status	Active
Description	Retrieval location. In Degrees and Minutes
General Data Type	Integer
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	LONGITUDE_CONVERTED
Seq. Order	110
Data Storage Type	Number
Max Length	7
Min Length
Required	No
Primary Key	No
Precision	7
Scale	0
Status	Active
Description	Retrieval location. The conversion of longitude is required of values to the east of the 180th meridian. The configuration within Oracle Spatial uses a 360 degree globe - 179 E must therefore be submitted as 181. The calling program must, as in the conversion to decimal degrees submit latitude to the east of the 180th meridian as a negative number.
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	E_W
Seq. Order	115
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Retrieval location.
General Data Type	Character
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	NMFS_AREA
Seq. Order	120
Data Storage Type	Number
Max Length	3
Min Length
Required	No
Primary Key	No
Precision	3
Scale	0
Status	Active
Description	This attribute is computed using the MDSYS.SDO_GEOMETRY package and an ESRI shape file.
General Data Type	Integer
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	COBLZ_AREA
Seq. Order	125
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	This attribute is computed using the MDSYS.SDO_GEOMETRY package and an ESRI shape file.
General Data Type	Character
Unit of Measure
Case Restriction	Upper
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values	Y, N, NULL
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	VESSEL_ESTIMATE
Seq. Order	130
Data Storage Type	Number
Max Length	6
Min Length
Required	No
Primary Key	No
Precision	6
Scale	2
Status	Active
Description	Total catch weight in metric tons as recorded in the vessel log.
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	OFFICIAL_TOTAL_CATCH
Seq. Order	135
Data Storage Type	Number
Max Length	10
Min Length
Required	No
Primary Key	No
Precision	10
Scale	2
Status	Active
Description	Total catch weight as computed from the sum of the extrapolate species composition records. For trawl fisheries in the GOA, prohibited species census data may be back apportioned to hauls which constitute an offload if one exists. OTC will then be computed as the sum of the extrapolated species plus the sum of the back apportioned species.
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	OBSERVER_ESTIMATE
Seq. Order	140
Data Storage Type	Number
Max Length	10
Min Length
Required	No
Primary Key	No
Precision	10
Scale	2
Status	Active
Description	Total catch weight as estimated by the observer in kgs and converted to MT for this presentation.
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	OBSERVER_ESTIMATE_METHOD
Seq. Order	145
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Method used to determine the observer estimated catch.
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	DENSITY
Seq. Order	150
Data Storage Type	Number
Max Length	10
Min Length
Required	No
Primary Key	No
Precision	10
Scale	2
Status	Active
Description	Density used by the observer to determine the total catch weights. Recorded in kgs per m3.
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	CATCHER_BOAT_ADFGv
Seq. Order	155
Data Storage Type	Number
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	If this haul was delivered to a mothership or catcher processor, this attibute records the ADFG registration number of that vessel.
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	IFQ
Seq. Order	160
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Flag which identifies whether fishing is on an IFQ quota with the subsequent application of IFQ rules.
General Data Type
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value	Y, N, NULL
Null Value Meaning	Unknown
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CDQ_CODE
Seq. Order	165
Data Storage Type	VARCHAR2
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Unique AlphaNumeric code representing a CDQ or research group.
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	SKATES_IN_SET
Seq. Order	170
Data Storage Type	Number
Max Length	6
Min Length
Required	No
Primary Key	No
Precision	6
Scale	2
Status	Active
Description	Number of skates deployed for longline fishing operations
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	HOOKS_PER_SKATE
Seq. Order	175
Data Storage Type	NUMBER
Max Length	6
Min Length
Required	No
Primary Key	No
Precision	6
Scale	2
Status	Active
Description	Number of hooks per skate for longline fishing usually calculated as the average number of hooks per segment from the atl_haul_hook_count table.
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	TOTAL_HOOKS_POTS
Seq. Order	180
Data Storage Type	NUMBER
Max Length	6
Min Length
Required	No
Primary Key	No
Precision	6
Scale	2
Status	Active
Description	Total number of hooks deployed for this haul, usually calculated as the average number of hooks per segment from the atl_haul_hook_count table * the number of skates in set. Or in the case of a pot fishery the total number of pots deployed in a haul.
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	HAUL_SAMPLED_BY
Seq. Order	185
Data Storage Type	NUMBER
Max Length	8
Min Length
Required	No
Primary Key	No
Precision	8
Scale	0
Status	Active
Description	Identifies where a haul is sampled by an observer and in some cases by which observer. The observer of a haul is not necessarily the primary observer recorded for a cruise.
General Data Type	INTEGER
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	RANDOM_SAMPLE_TABLE
Seq. Order	190
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Random Sample Reference Table code reference.
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	RANDOM_BREAK_TABLE
Seq. Order	195
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Random Break Table identifier Currently limted to Y (es) or N(o).
General Data Type	Character
Unit of Measure
Case Restriction	Upper
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values	Y, N, NULL
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	MM_PERCENT_MONITORED
Seq. Order	200
Data Storage Type	NUMBER
Max Length	3
Min Length
Required	No
Primary Key	No
Precision	3
Scale	0
Status	Active
Description	Percentage of time for this haul where marine mammal monitoring occurred. For fixed gear deployments the valid values are anywhere in the range. For mobile gear deployments the values may be either 0 or 100.
General Data Type	INTEGER
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	BIRD_DETERRENCE
Seq. Order	205
Data Storage Type	V
Max Length	2
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Deterrence code from NORPAC bird or mammal deterance tables.
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	PROCESSOR
Seq. Order	210
Data Storage Type	VARCHAR2
Max Length	6
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Processor is computed by atl_utilities, and returns the shore plant processor code for catcher vessels who have an offload, and the processor permit for catcher processors and motherships.
General Data Type	Character
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	FISHING_START_DATE
Seq. Order	215
Data Storage Type	DATE
Max Length	8
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Fishing start date is defined as the first haul deployment of a trip. If the deployment date is null due to unverifiable observer data then the trip start date is used; if null the default is a mandatory value haul retrieval date.
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	HAUL_JOIN
Seq. Order	220
Data Storage Type	NUMBER
Max Length	26
Min Length
Required	No
Primary Key	No
Precision	26
Scale	0
Status	Active
Description	Surrogate FK to atl_haul. Composed of concatenation of cruise, permit and haul_seq.
General Data Type	Integer
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	DATE_OF_ENTRY
Seq. Order	225
Data Storage Type	DATE
Max Length	8
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Date of entry is now (2010) recorded when a haul is loaded into the Norpac data set. In the case that that value is null then it is computed from the latest load date recorded in atl_record_status.';
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	230
Data Storage Type	NUMBER
Max Length	4
Min Length	4
Required	No
Primary Key	No
Precision	4
Scale	0
Status	Active
Description	Year is extracted from the haul rettrv_date_time field.
General Data Type	Integer
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	LATDD_END
Seq. Order	235
Data Storage Type	NUMBER
Max Length	7
Min Length
Required	No
Primary Key	No
Precision	7
Scale	5
Status	Active
Description	Latitude decimal degrees is computed from the retrieval latitude.
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	LONDD_END
Seq. Order	240
Data Storage Type	NUMBER
Max Length	8
Min Length
Required	No
Primary Key	No
Precision	8
Scale	5
Status	Active
Description	Longitude decimal degrees is computed from the retrieval longitude.
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	LATDD_START
Seq. Order	245
Data Storage Type	NUMBER
Max Length	7
Min Length
Required	No
Primary Key	No
Precision	7
Scale	5
Status	Active
Description	Latitude decimal degrees is computed from the deployment latitude.
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	LONDD_START
Seq. Order	250
Data Storage Type	NUMBER
Max Length	8
Min Length
Required	No
Primary Key	No
Precision	8
Scale	5
Status	Active
Description	Longitude decimal degrees is computed from the deployment longitude.
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	RETRV_LONGITUDE_SECONDS
Seq. Order	255
Data Storage Type	N
Max Length	2
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Gear retrieval position.
General Data Type	Integer
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	RETRV_LATITUDE_SECONDS
Seq. Order	260
Data Storage Type	NUMBER
Max Length	2
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Gear retrieval position.
General Data Type	Integer
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	DEPLOY_LATITUDE_SECONDS
Seq. Order	265
Data Storage Type	NUMBER
Max Length	2
Min Length
Required	No
Primary Key	No
Precision	2
Scale	0
Status	Active
Description	Gear retrieval position.
General Data Type	Integer
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	ATLAS_VERSION
Seq. Order	270
Data Storage Type	NUMBER
Max Length	3
Min Length
Required	No
Primary Key	No
Precision	3
Scale	2
Status	Active
Description	If this haul data was transmitted from the field. This attribute records the version of the software used.
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	DEPLOYMENT_LONGITUDE
Seq. Order	275
Data Storage Type	NUMBER
Max Length	23
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Location of start of haul
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_HASH
Seq. Order	280
Data Storage Type	VARCHAR2
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The haul hash is utilized by AKRO to identify changes to a haul record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value.
General Data Type	Character
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_HASH
Seq. Order	285
Data Storage Type	VARCHAR2
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The species hash is utilized by AKRO to identify changes to a species composition record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value.
General Data Type	Character
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	SALMON_HASH
Seq. Order	290
Data Storage Type	VARCHAR2
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The salmon hash is utilized by AKRO to identify changes to a salmon retention record. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value.
General Data Type	Character
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	FLOW_SCALE_WEIGHT
Seq. Order	295
Data Storage Type	N
Max Length	10
Min Length
Required	No
Primary Key	No
Precision	10
Scale	3
Status	Active
Description	Actual weight from the flow scale reading for a haul.
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	PRESORT_SAMPLE_HASH
Seq. Order	296
Data Storage Type	Varchar2
Max Length	32
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The presort hash is utilized by AKRO to identify changes to presort records. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value.
General Data Type
Unit of Measure
Case Restriction	Upper
Display Example	EE3CACFD295AAB8A5DD7D975B358F620
Format Mask
Null Value	null set
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	LANDING_REPORT_ID_HASH
Seq. Order
Data Storage Type	VARCHAR2
Max Length
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	The landing report id hash is utilized by AKRO to identify changes to the list of eLanding report ids associated with a haul. The hash is created every time that a record is created or updated. Only critical data columns are referenced and change is denoted by a change in the hash value.
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	28148
Metadata Record Created By	Julie A Blair
Metadata Record Created	2015-10-23 17:39+0000
Metadata Record Last Modified By	SysAdmin InPortAdmin
» Metadata Record Last Modified	2022-08-09 17:11+0000
Metadata Record Published	2016-08-23
Owner Org	AFSC
Metadata Publication Status	Published Externally
Do Not Publish?	N
Metadata Workflow State	Published / External
Metadata Last Review Date	2016-08-23
Metadata Review Frequency	1 Year
Metadata Next Review Date	2017-08-23

Tags