Slide Menu
Search Help Show/Hide Menu

Item Identification

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

An errata table holding Puerto Rico commercial landings which were edited by the SEFSC to correct errors and to standardize coding for the period of 1983-2011 in the table als.als_land_pr_1983_2011, the link for which is the primary key record_number_id. Records are primarily edited for invalid or highly unlikely species/gear combinations, as well as edit/standardization and resolution of fisher permits and names, as well as a limited number of fishing center and species edits.

Notes:

Loaded by batch 7906, 12-22-2015 14:11

Entity Information

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

An errata table holding Puerto Rico commercial landings which were edited by the SEFSC to correct errors and to standardize coding for the period of 1983-2011 in the table als.als_land_pr_1983_2011, the link for which is the primary key record_number_id. Records are primarily edited for invalid or highly unlikely species/gear combinations, as well as edit/standardization and resolution of fisher permits and names, as well as a limited number of fishing center and species edits.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
RECORD_NUMBER_ID NUMBER The primary key. Foreign key to als.als_land_pr_1983_2011 primary key.
100
FISHING_CENTER_ED VARCHAR2 The edited fishing_center code
100
NMFS_GEAR_ED VARCHAR2 The edited NMFSGEAR code
100
NMFS_SPECIES_ED VARCHAR2 The edited NMFS species code
100
SHELL_OR_FINFISH_ED VARCHAR2 The edited NMFS shellfin code
100
PR_ID_CODE_ED VARCHAR2 The edited fisher id code
100
FISHER_FIRST_NAME VARCHAR2 Fisher first name
100
FISHER_LAST_NAME VARCHAR2 Fisher last name
100
PR_GEAR_ED VARCHAR2 Edited PR_GEAR code
100
PR_SPECIES_ED VARCHAR2 Edited PR_SPECIES code
100
TRIP_TICKET_NUMBER_ED VARCHAR2 edited trip ticket number
100
DUPLICATE_RECORD VARCHAR2 is record a duplicate?
100
NUMBER_OF_TRIPS_ED NUMBER Edited number of trips
100
GEAR_QTY_ED NUMBER Edited gear quantity
100
GEAR_HOURS_ED NUMBER Edited hours gear was fished
100
MINIMUM_DEPTH_ED NUMBER Edited minimum depth (fathoms)
100
MAXIMUM_DEPTH_ED NUMBER Edited maximum depth (fathoms)
100
YEAR_LANDED VARCHAR2 edited landing year
100
COAST VARCHAR2 Edited landing coast (N,E,S,W)
100
AREA_FISHED1 VARCHAR2 The first area fished recorded on form
100
AREA_FISHED2 VARCHAR2 The 2nd area fished recorded on form
100
AREA_FISHED3 VARCHAR2 The 3rd area fished recorded on form.
100
AREA_FISHED4 VARCHAR2 The 4th area fished recorded on form

Attribute Details

RECORD_NUMBER_ID

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

The primary key. Foreign key to als.als_land_pr_1983_2011 primary key.

General Data Type: NUMBER

FISHING_CENTER_ED

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

The edited fishing_center code

General Data Type: VARCHAR2

NMFS_GEAR_ED

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

The edited NMFSGEAR code

General Data Type: VARCHAR2

NMFS_SPECIES_ED

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

The edited NMFS species code

General Data Type: VARCHAR2

SHELL_OR_FINFISH_ED

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

The edited NMFS shellfin code

General Data Type: VARCHAR2

PR_ID_CODE_ED

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

The edited fisher id code

General Data Type: VARCHAR2

FISHER_FIRST_NAME

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

Fisher first name

General Data Type: VARCHAR2

FISHER_LAST_NAME

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

Fisher last name

General Data Type: VARCHAR2

PR_GEAR_ED

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

Edited PR_GEAR code

General Data Type: VARCHAR2

PR_SPECIES_ED

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

Edited PR_SPECIES code

General Data Type: VARCHAR2

TRIP_TICKET_NUMBER_ED

CC ID: 267207
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

edited trip ticket number

General Data Type: VARCHAR2

DUPLICATE_RECORD

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

is record a duplicate?

General Data Type: VARCHAR2

NUMBER_OF_TRIPS_ED

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

Edited number of trips

General Data Type: NUMBER

GEAR_QTY_ED

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

Edited gear quantity

General Data Type: NUMBER

GEAR_HOURS_ED

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

Edited hours gear was fished

General Data Type: NUMBER

MINIMUM_DEPTH_ED

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

Edited minimum depth (fathoms)

General Data Type: NUMBER

MAXIMUM_DEPTH_ED

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

Edited maximum depth (fathoms)

General Data Type: NUMBER

YEAR_LANDED

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

edited landing year

General Data Type: VARCHAR2

COAST

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

Edited landing coast (N,E,S,W)

General Data Type: VARCHAR2

AREA_FISHED1

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

The first area fished recorded on form

General Data Type: VARCHAR2

AREA_FISHED2

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

The 2nd area fished recorded on form

General Data Type: VARCHAR2

AREA_FISHED3

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

The 3rd area fished recorded on form.

General Data Type: VARCHAR2

AREA_FISHED4

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

The 4th area fished recorded on form

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 29946
GUID: gov.noaa.nmfs.inport:29946
Metadata Record Created By: Joshua Bennett
Metadata Record Created: 2015-12-22 14:11+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