Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 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 Haul

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

Summary

Abstract

This table contains the primary key haul data 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_haul table. On Delete from ATL_HAUL the trigger perfoms a cross schema cascade delete to temp_haul and current haul.

Description

This table contains the primary key haul data 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_haul table. On Delete from ATL_HAUL the trigger perfoms a cross schema cascade delete to temp_haul and current haul.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TEMP_HAUL_SEQ
NUMBER 		Sequence generated unique identifier of a temp haul 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
SOURCE
VARCHAR2 		Identifier of Source Table from which this record was generated by an after insert, update or delete trigger.
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

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

This table contains the primary key haul data 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_haul table. On Delete from ATL_HAUL the trigger perfoms a cross schema cascade delete to temp_haul and current haul.
Purpose:

This table contains the primary key haul data 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_haul table. On Delete from ATL_HAUL the trigger perfoms a cross schema cascade delete to temp_haul and current haul.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Alias: Temp_Haul
Schema Name: Obsint
Description:

This table contains the primary key haul data 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_haul table. On Delete from ATL_HAUL the trigger perfoms a cross schema cascade delete to temp_haul and current haul.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TEMP_HAUL_SEQ NUMBER Sequence generated unique identifier of a temp haul 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
 SOURCE VARCHAR2 Identifier of Source Table from which this record was generated by an after insert, update or delete trigger.
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

Attribute Details

TEMP_HAUL_SEQ

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

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

CRUISE

CC ID: 247189
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: 247190
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
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

SOURCE

CC ID: 247191
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 50
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

PROCESSED_DATE

CC ID: 247192
Seq. Order: 50
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

Catalog Details

Catalog Item ID: 28568
GUID: gov.noaa.nmfs.inport:28568
Metadata Record Created By: Julie A Blair
Metadata Record Created: 2015-11-05 17:57+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