Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06