Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Tables Recording Landings Information

Notes:

Loaded by batch 2004, 12-03-2007 09:39

Entity Information

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

Tables Recording Landings Information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Unique ID
100
INTERVIEW_ID NUMBER Unique key
100
SPECIES_SIZE_ID NUMBER Key to size (MIXED/UNSIZED, JUMBO, etc)
100
MARKET_SPECIES_ID VARCHAR2 Key to an agency specific species table
100
SPECIES_QTY NUMBER How many fish of that species were reported
100
GEAR_CODE VARCHAR2 Key to agency specific gear table
100
REGION_ID NUMBER Key to region (GULF, ATLANTIC, etc)
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
CREATED_DATE DATE Date/Time stamp of record creation
100
SPECIES_CONDITION_ID NUMBER Key to CONDITION_TYPE (ROUND(whole), HEADS ON, etc)
100
ISRIPE NUMBER not used
100
ISBYCATCH NUMBER HISTORICAL DATA
100
GRADE_ID NUMBER Key to Grade (NO GRADE, #1 IF TUNA, etc)
100
MARKET_COUNT_MIN NUMBER Minimun number of individuals per unit for this category
100
MARKET_COUNT_MAX NUMBER Maximun number of individuals per unit for this category
100
TOTAL_VOLUME NUMBER Not used
100
TOTAL_WEIGHT NUMBER Total weight of the catch for that species
100
WEIGHT_UNIT_ID NUMBER Key to Weight_Unit (KILLOGRAMS, POUNDS, etc)
100
VOLUME_UNIT_ID NUMBER Not used
100
ISAGGREGATED NUMBER Not used
100
LANDING_COMMENT VARCHAR2 Comment on this landing record
100
PRICE NUMBER HISTORICAL DATA
100
VALUE NUMBER HISTORICAL DATA
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
AREA_ID NUMBER Key to agency specific area table telling the primary area where fishing occurred
100
REPLICATE NUMBER Part of key to relate the data back to the historical data.
100
STANDARD_GEAR_ID VARCHAR2 The standardized gear for this catch
100
STANDARD_SPECIES_ID VARCHAR2 Key to standard_species
100
STANDARD_AREA_ID NUMBER Key to standard area

Attribute Details

ID

CC ID: 22195
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Unique ID

General Data Type: NUMBER

INTERVIEW_ID

CC ID: 22196
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique key

General Data Type: NUMBER

SPECIES_SIZE_ID

CC ID: 22197
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Key to size (MIXED/UNSIZED, JUMBO, etc)

General Data Type: NUMBER

MARKET_SPECIES_ID

CC ID: 22198
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Key to an agency specific species table

General Data Type: VARCHAR2

SPECIES_QTY

CC ID: 22199
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

How many fish of that species were reported

General Data Type: NUMBER

GEAR_CODE

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

Key to agency specific gear table

General Data Type: VARCHAR2

REGION_ID

CC ID: 22201
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to region (GULF, ATLANTIC, etc)

General Data Type: NUMBER

CREATED_BY_USER_ID

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

User creating Record

General Data Type: VARCHAR2

CREATED_DATE

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

Date/Time stamp of record creation

General Data Type: DATE

SPECIES_CONDITION_ID

CC ID: 22204
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to CONDITION_TYPE (ROUND(whole), HEADS ON, etc)

General Data Type: NUMBER

ISRIPE

CC ID: 22205
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

not used

General Data Type: NUMBER

ISBYCATCH

CC ID: 22206
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

HISTORICAL DATA

General Data Type: NUMBER

GRADE_ID

CC ID: 22207
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to Grade (NO GRADE, #1 IF TUNA, etc)

General Data Type: NUMBER

MARKET_COUNT_MIN

CC ID: 22208
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Minimun number of individuals per unit for this category

General Data Type: NUMBER

MARKET_COUNT_MAX

CC ID: 22209
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Maximun number of individuals per unit for this category

General Data Type: NUMBER

TOTAL_VOLUME

CC ID: 22210
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Not used

General Data Type: NUMBER

TOTAL_WEIGHT

CC ID: 22211
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Total weight of the catch for that species

General Data Type: NUMBER

WEIGHT_UNIT_ID

CC ID: 22212
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to Weight_Unit (KILLOGRAMS, POUNDS, etc)

General Data Type: NUMBER

VOLUME_UNIT_ID

CC ID: 22213
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Not used

General Data Type: NUMBER

ISAGGREGATED

CC ID: 22214
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Not used

General Data Type: NUMBER

LANDING_COMMENT

CC ID: 22215
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comment on this landing record

General Data Type: VARCHAR2

PRICE

CC ID: 22216
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

HISTORICAL DATA

General Data Type: NUMBER

VALUE

CC ID: 22217
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

HISTORICAL DATA

General Data Type: NUMBER

MODIFIED_DATE

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

Date/Time stamp of when record was modifed

General Data Type: DATE

MODIFIED_BY_USER_ID

CC ID: 22219
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

User modifying record

General Data Type: VARCHAR2

AREA_ID

CC ID: 22220
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to agency specific area table telling the primary area where fishing occurred

General Data Type: NUMBER

REPLICATE

CC ID: 22221
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Part of key to relate the data back to the historical data.

General Data Type: NUMBER

STANDARD_GEAR_ID

CC ID: 22222
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

The standardized gear for this catch

General Data Type: VARCHAR2

STANDARD_SPECIES_ID

CC ID: 22223
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Key to standard_species

General Data Type: VARCHAR2

STANDARD_AREA_ID

CC ID: 22224
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to standard area

General Data Type: NUMBER

Related Items

Item Type Relationship Type Title
Entity (ENT) Cross Reference Table: CONDITION_TYPE
Entity (ENT) Cross Reference Table: GRADE
Entity (ENT) Cross Reference Table: SPECIES_SIZE
Entity (ENT) Cross Reference Table: VOLUME_UNIT

Valid Volumn Units

Entity (ENT) Cross Reference Table: WEIGHT_UNIT

Valida Weight Units

Catalog Details

Catalog Item ID: 6567
GUID: gov.noaa.nmfs.inport:6567
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 09:39+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05