Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: FISH_TICKET
Short Name: FISH_TICKET
Status: Completed
Abstract:

This entity represents the preprinted state fish ticket prepared from an offload event. Fish tickets are no longer recorded by observers and have been superseded by the landing report id recorded within an offload.

Notes:

Loaded by batch 2204, 03-28-2008 14:09

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: TURNBULLD
Description:

This entity represents the fish ticket preprared from an offload event.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FISH_TICKET_SEQ NUMBER Sequence within offload parent
100
FISHTICKET_NUMBER VARCHAR2 A Fish Ticket Number is the Alphanumeric value generated by a processor and given to a vessel captain detailing the transaction and sale of seafood.
100
OFFLOAD_SEQ NUMBER Sequence generated unique identifier for an offload record and the foreign key value within a fish ticket.

Attribute Details

FISH_TICKET_SEQ

CC ID: 29554
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence within offload parent

General Data Type: NUMBER

FISHTICKET_NUMBER

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

A Fish Ticket Number is the Alphanumeric value generated by a processor and given to a vessel captain detailing the transaction and sale of seafood.

General Data Type: VARCHAR2
Case Restriction: Upper

OFFLOAD_SEQ

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

Sequence generated unique identifier for an offload record and the foreign key value within a fish ticket.

General Data Type: NUMBER
Foreign Key Relations:

TURNBULLD.OFFLOAD

Catalog Details

Catalog Item ID: 7508
GUID: gov.noaa.nmfs.inport:7508
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2008-03-28 14:09+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