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