TEMP_OFFLOAD
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:28570 | Updated: August 9, 2022 | Published / External
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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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 |