Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > Puerto Rico Commercial Landings Statistics 1983... >

Table: ALS_LAND_PR_1983_2011_ERRATA

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:29946  |  Updated: August 9, 2022  |  Published / External 
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