Metadata Rubric

100%

6 / 6

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

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

	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

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