Slide Menu
Search Help Show/Hide Menu

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