Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Current Observer Data Interface > AFSC/FMA/Current Observer Data Interface >

TEMP_OFFLOAD

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:28570  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Keywords
Data Attributes
Catalog Details

Summary

Abstract

This table contains the list of cruise - permit pairs for presentation to the AKRO catch accounting. The table is populated and maintained by NORPAC trigger code. The chain of events is as follows: INSERT, UPDATE - The ATL_HAUL_OBSINT_AIUDR_T adds haul primary key records to the TEMP_OFFLOAD table. On Delete from ATL_HAUL the trigger performs a cross schema cascade delete to TEMP_OFFLOAD and current haul. An analogous process occurs with offloads, salmon, species composition ant trip records.

Entity Information

Data Attribute / Type Description
TEMP_OFFLOAD_SEQ
NUMBER 		Sequence generated unique identifier of a temp offload record.
CRUISE
NUMBER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
PERMIT
VARCHAR2 		Unique Code identifying a delivering vessel or processing plant - inherited from the NORPAC data set and created by the RAM division in Juneau
PROCESSED_DATE
DATE 		This attribute is the timestamp recording when the entry was processed. If the value is null then process. If not, ignore. This replaces the process and delete. Changed 9-14-09 dt
SOURCE
VARCHAR2 		Identifier of Source Table from which this record was generated by an after insert, update or delete trigger.

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: TEMP_OFFLOAD
Short Name: TEMP_OFFLOAD
Status: In Work
Abstract:

This table contains the list of cruise - permit pairs for presentation to the AKRO catch accounting. The table is populated and maintained by NORPAC trigger code. The chain of events is as follows: INSERT, UPDATE - The ATL_HAUL_OBSINT_AIUDR_T adds haul primary key records to the TEMP_OFFLOAD table. On Delete from ATL_HAUL the trigger performs a cross schema cascade delete to TEMP_OFFLOAD and current haul. An analogous process occurs with offloads, salmon, species composition ant trip records.
Purpose:

This table contains the list of cruise - permit pairs for presentation to the AKRO catch accounting. The table is populated and maintained by NORPAC trigger code. The chain of events is as follows: INSERT, UPDATE - The ATL_HAUL_OBSINT_AIUDR_T adds haul primary key records to the TEMP_OFFLOAD table. On Delete from ATL_HAUL the trigger performs a cross schema cascade delete to TEMP_OFFLOAD and current haul. An analogous process occurs with offloads, salmon, species composition ant trip records.

Keywords

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 2008 AND FORWARD

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None BS, AI, BSAI, GOA

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None OBSERVER, CURRENT DATA, FISHERY STATISTICS

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TEMP_OFFLOAD_SEQ NUMBER Sequence generated unique identifier of a temp offload record.
100
 CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
 PERMIT VARCHAR2 Unique Code identifying a delivering vessel or processing plant - inherited from the NORPAC data set and created by the RAM division in Juneau
100
 PROCESSED_DATE DATE This attribute is the timestamp recording when the entry was processed. If the value is null then process. If not, ignore. This replaces the process and delete. Changed 9-14-09 dt
100
 SOURCE VARCHAR2 Identifier of Source Table from which this record was generated by an after insert, update or delete trigger.

Attribute Details

TEMP_OFFLOAD_SEQ

CC ID: 247193
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 8
Required: No
Primary Key: Yes
Precision: 8
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a temp offload record.
General Data Type: INTEGER

CRUISE

CC ID: 247194
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 9
Required: No
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
General Data Type: INTEGER

PERMIT

CC ID: 247195
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Unique Code identifying a delivering vessel or processing plant - inherited from the NORPAC data set and created by the RAM division in Juneau
General Data Type: CHARACTER

PROCESSED_DATE

CC ID: 247196
Seq. Order: 40
Data Storage Type: DATE
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

This attribute is the timestamp recording when the entry was processed. If the value is null then process. If not, ignore. This replaces the process and delete. Changed 9-14-09 dt
General Data Type: DATE

SOURCE

CC ID: 247197
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

Identifier of Source Table from which this record was generated by an after insert, update or delete trigger.
General Data Type: CHARACTER

Catalog Details

Catalog Item ID: 28570
GUID: gov.noaa.nmfs.inport:28570
Metadata Record Created By: Julie A Blair
Metadata Record Created: 2015-11-05 18:14+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-04
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-04
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-04