Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Contains information about dealer weighout sheets for the domestic longline fishery. Each rowcontains weights for a single species. Additional species weights are recorded in a new row but will contain the same control information as the previous record.

Notes:

Loaded by batch 5871, 04-20-2015 08:47

Entity Information

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

Contains information about dealer weighout sheets for the domestic longline fishery. Each rowcontains weights for a single species. Additional species weights are recorded in a new row but will contain the same control information as the previous record.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TRIP_NUMBER VARCHAR2 Trip Number, equal to schedule number in Fisheries Logook System (FLS) or Unified Data Processing (UDP) system
100
BATCH_NUMBER VARCHAR2 Number that identify a group of trips. This 4 digits number is extracted from the source file which represents two digit year and a sequential two digit code (yy##).
100
VESSEL_ID NUMBER Vessel Id. These codes are unique to this system.
100
LOG_DATE NUMBER Date in which the trip was landed.
100
STATE_CODE VARCHAR2 State of landing.
100
PORT_CODE NUMBER Port of landing. These codes are unique to this system.
100
DEALER_CODE NUMBER Dealer code number. These codes are unique to this system and do not conform to any pre-existingcodes tables.
100
GEAR_CODE VARCHAR2 Code of the gear used. These codes are unique to this system.
100
DATA_SOURCE VARCHAR2 Fishing information source (captain logbook, interview, etc.)
100
LOCATION_CODE NUMBER Area were the catch was made.
100
TOTAL_HOOKS_FISHED NUMBER Effort: Total hooks fished. For example: 200 Hooks/Set * 5 sets is entered as 01000. Data is imported from Fisheries Logbook System (FLS) records.
100
DAYS_OF_FISHING NUMBER Days of actual fishing. Does not include steaming time or days not fished on the fishing grounds. Data is imported from Fisheries Logbook System (FLS) records.
100
TOTAL_NUMBER_OF_SETS NUMBER Total number of sets for this trip. Data is imported from Fisheries Logbook System (FLS) records.
100
SPECIES_CODE VARCHAR2 Species code. These codes are unique to this system.
100
WEIGHT1 NUMBER Carcass Weight (1)
100
WEIGHT2 NUMBER Carcass Weight (2)
100
WEIGHT3 NUMBER Carcass Weight (3)
100
WEIGHT4 NUMBER Carcass Weight (4)
100
WEIGHT5 NUMBER Carcass Weight (5)
100
WEIGHT6 NUMBER Carcass Weight (6)
100
WEIGHT7 NUMBER Carcass Weight (7)
100
WEIGHT8 NUMBER Carcass Weight (8)
100
WEIGHT9 NUMBER Carcass Weight (9)
100
WEIGHT10 NUMBER Carcass Weight (10)
100
WEIGHT11 NUMBER Carcass Weight (11)
100
WEIGHT12 NUMBER Carcass Weight (12)
100
WEIGHT13 NUMBER Carcass Weight (13)
100
WEIGHT14 NUMBER Carcass Weight (14)
100
WEIGHT15 NUMBER Carcass Weight (15)
100
WEIGHT16 NUMBER Carcass Weight (16)
100
WEIGHT17 NUMBER Carcass Weight (17)
100
WEIGHT18 NUMBER Carcass Weight (18)
100
WEIGHT19 NUMBER Carcass Weight (19)
100
WEIGHT20 NUMBER Carcass Weight (20)
100
WEIGHT21 NUMBER Carcass Weight (21)
100
WEIGHT22 NUMBER Carcass Weight (22)
100
WEIGHT23 NUMBER Carcass Weight (23)
100
WEIGHT24 NUMBER Carcass Weight (24)
100
WEIGHT25 NUMBER Carcass Weight (25)
100
WEIGHT26 NUMBER Carcass Weight (26)
100
WEIGHT27 NUMBER Carcass Weight (27)
100
WEIGHT28 NUMBER Carcass Weight (28)
100
WEIGHT29 NUMBER Carcass Weight (29)
100
WEIGHT30 NUMBER Carcass Weight (30)
100
WEIGHT31 NUMBER Carcass Weight (31)
100
WEIGHT32 NUMBER Carcass Weight (32)
100
SOURCE_FILE VARCHAR2 Name of the loading file.
100
ACTION_CODE VARCHAR2 test
100
CUTOFF_CODE VARCHAR2 Code used to identify a set of data to be used in the annual ICCAT processing for DLS and PLL.
100
RECNUM_KEY NUMBER Sequential Key For This table

Attribute Details

TRIP_NUMBER

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

Trip Number, equal to schedule number in Fisheries Logook System (FLS) or Unified Data Processing (UDP) system

General Data Type: VARCHAR2

BATCH_NUMBER

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

Number that identify a group of trips. This 4 digits number is extracted from the source file which represents two digit year and a sequential two digit code (yy##).

General Data Type: VARCHAR2

VESSEL_ID

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

Vessel Id. These codes are unique to this system.

General Data Type: NUMBER

LOG_DATE

CC ID: 197623
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

Date in which the trip was landed.

General Data Type: NUMBER

STATE_CODE

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

State of landing.

General Data Type: VARCHAR2

PORT_CODE

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

Port of landing. These codes are unique to this system.

General Data Type: NUMBER

DEALER_CODE

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

Dealer code number. These codes are unique to this system and do not conform to any pre-existingcodes tables.

General Data Type: NUMBER

GEAR_CODE

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

Code of the gear used. These codes are unique to this system.

General Data Type: VARCHAR2

DATA_SOURCE

CC ID: 197639
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Fishing information source (captain logbook, interview, etc.)

General Data Type: VARCHAR2

LOCATION_CODE

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

Area were the catch was made.

General Data Type: NUMBER

TOTAL_HOOKS_FISHED

CC ID: 197592
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Effort: Total hooks fished. For example: 200 Hooks/Set * 5 sets is entered as 01000. Data is imported from Fisheries Logbook System (FLS) records.

General Data Type: NUMBER

DAYS_OF_FISHING

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

Days of actual fishing. Does not include steaming time or days not fished on the fishing grounds. Data is imported from Fisheries Logbook System (FLS) records.

General Data Type: NUMBER

TOTAL_NUMBER_OF_SETS

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

Total number of sets for this trip. Data is imported from Fisheries Logbook System (FLS) records.

General Data Type: NUMBER

SPECIES_CODE

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

Species code. These codes are unique to this system.

General Data Type: VARCHAR2

WEIGHT1

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

Carcass Weight (1)

General Data Type: NUMBER

WEIGHT2

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

Carcass Weight (2)

General Data Type: NUMBER

WEIGHT3

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

Carcass Weight (3)

General Data Type: NUMBER

WEIGHT4

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

Carcass Weight (4)

General Data Type: NUMBER

WEIGHT5

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

Carcass Weight (5)

General Data Type: NUMBER

WEIGHT6

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

Carcass Weight (6)

General Data Type: NUMBER

WEIGHT7

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

Carcass Weight (7)

General Data Type: NUMBER

WEIGHT8

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

Carcass Weight (8)

General Data Type: NUMBER

WEIGHT9

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

Carcass Weight (9)

General Data Type: NUMBER

WEIGHT10

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

Carcass Weight (10)

General Data Type: NUMBER

WEIGHT11

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

Carcass Weight (11)

General Data Type: NUMBER

WEIGHT12

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

Carcass Weight (12)

General Data Type: NUMBER

WEIGHT13

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

Carcass Weight (13)

General Data Type: NUMBER

WEIGHT14

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

Carcass Weight (14)

General Data Type: NUMBER

WEIGHT15

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

Carcass Weight (15)

General Data Type: NUMBER

WEIGHT16

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

Carcass Weight (16)

General Data Type: NUMBER

WEIGHT17

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

Carcass Weight (17)

General Data Type: NUMBER

WEIGHT18

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

Carcass Weight (18)

General Data Type: NUMBER

WEIGHT19

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

Carcass Weight (19)

General Data Type: NUMBER

WEIGHT20

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

Carcass Weight (20)

General Data Type: NUMBER

WEIGHT21

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

Carcass Weight (21)

General Data Type: NUMBER

WEIGHT22

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

Carcass Weight (22)

General Data Type: NUMBER

WEIGHT23

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

Carcass Weight (23)

General Data Type: NUMBER

WEIGHT24

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

Carcass Weight (24)

General Data Type: NUMBER

WEIGHT25

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

Carcass Weight (25)

General Data Type: NUMBER

WEIGHT26

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

Carcass Weight (26)

General Data Type: NUMBER

WEIGHT27

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

Carcass Weight (27)

General Data Type: NUMBER

WEIGHT28

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

Carcass Weight (28)

General Data Type: NUMBER

WEIGHT29

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

Carcass Weight (29)

General Data Type: NUMBER

WEIGHT30

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

Carcass Weight (30)

General Data Type: NUMBER

WEIGHT31

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

Carcass Weight (31)

General Data Type: NUMBER

WEIGHT32

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

Carcass Weight (32)

General Data Type: NUMBER

SOURCE_FILE

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

Name of the loading file.

General Data Type: VARCHAR2

ACTION_CODE

CC ID: 197632
Seq. Order: 48
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

test

General Data Type: VARCHAR2

CUTOFF_CODE

CC ID: 197633
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code used to identify a set of data to be used in the annual ICCAT processing for DLS and PLL.

General Data Type: VARCHAR2

RECNUM_KEY

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

Sequential Key For This table

General Data Type: NUMBER

FAQs

FAQ 1

CC ID: 197710
Date: 2015-04-20 00:00:00
Author: Allison Shideler
Question:

Why is the trip number missing from some records?

Answer:

Trip numbers were not used prior to April 1996.

In rare instances, a dealer report is received that contains the necessary fish weights, but the corresponding logbook from the vessel is not received. The logbook contains the number used as the trip number; when the logbook is missing, the trip number is left blank.

FAQ 2

CC ID: 197711
Date: 2015-04-20 00:00:00
Author: Allison Shideler
Question:

Why are the effort columns empty?

Answer:

Effort columns include the TOTAL_HOOKS_FISHED, DAYS_OF_FISHING, and TOTAL_NUMBER_OF_SETS columns. These columns are populated on an annual basis using data in the Fisheries Logbook System (FLS) or Unified Data Processing (UDP) system.

Effort columns for data from the current year may be blank if the data has not been populated yet. Additionally, records with large discrepancies between catch reported in FLS/UDP and DLS will not have effort data.

FAQ 3

CC ID: 197712
Date: 2015-04-20 00:00:00
Author: Allison Shideler
Question:

Are the weigh out images available?

Answer:

Beginning in 2011, groups of coded weigh out forms were scanned as large pdf documents. Individual trip weigh outs were scanned for trips received beginning 17 June 2013. An effort is underway to scan individual trip weigh outs prior to that date.

Catalog Details

Catalog Item ID: 24491
GUID: gov.noaa.nmfs.inport:24491
Metadata Record Created By: Allison Shideler
Metadata Record Created: 2015-04-20 08:47+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