Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Describes a golden crab trip

Purpose:

To store header information

Notes:

Loaded by batch 2045, 12-20-2007 10:28

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None goldeb crabs
None header record

Entity Information

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

Describes a golden crab trip

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SCHEDULE_NUMBER VARCHAR2 Identifies a trip
100
VESSEL_ID VARCHAR2 Vessel ID code
100
START_DATE DATE Trip's Start Date
100
END_DATE DATE Trips's End Date
100
NOFISH_DATE DATE First Day of the month in which there were no catches
100
STATE_CODE_UNLOADED VARCHAR2 NMFS State Code where it was unloaded
100
COUNTY_CODE_UNLOADED VARCHAR2 NMFS County Code where it was unloaded
100
TYPE_N_SIZE_TRAP_USED VARCHAR2 A list of the Type and Size combination of traps used in the trip

Attribute Details

SCHEDULE_NUMBER

CC ID: 25144
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: Yes
Status: Active
Description:

Identifies a trip

General Data Type: VARCHAR2

VESSEL_ID

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

Vessel ID code

General Data Type: VARCHAR2

START_DATE

CC ID: 25146
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Trip's Start Date

General Data Type: DATE

END_DATE

CC ID: 25147
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Trips's End Date

General Data Type: DATE

NOFISH_DATE

CC ID: 25148
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

First Day of the month in which there were no catches

General Data Type: DATE

STATE_CODE_UNLOADED

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

NMFS State Code where it was unloaded

General Data Type: VARCHAR2

COUNTY_CODE_UNLOADED

CC ID: 25150
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

NMFS County Code where it was unloaded

General Data Type: VARCHAR2

TYPE_N_SIZE_TRAP_USED

CC ID: 25151
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

A list of the Type and Size combination of traps used in the trip

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6880
GUID: gov.noaa.nmfs.inport:6880
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-20 10:28+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07