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

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:29945 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

The unedited Puerto Rico ALS table from 1983-2011 with primary key (record_number_id) added to link with edited errata table ALS.als_land_pr_1983-2011_errata. This is a copy of ALS.ALS_LANDINGS_PUERTO_RICO for the years 1983-2011. This copy was assigned a record id number for each record linking it to the errata file als.als_land_pr_1983_2011_errata for the corresponding record.

Description

The unedited Puerto Rico ALS table from 1983-2011 with primary key (record_number_id) added to link with edited errata table ALS.als_land_pr_1983-2011_errata.

Entity Type
Data Table

Data Attribute / Type	Description
MONTH_LANDED VARCHAR2	Month of landing
YEAR_LANDED VARCHAR2	4 character Year Landed
STATE_LANDED VARCHAR2	State Code Landed. Currently is defaulted to 55.
FISHING_CENTER VARCHAR2	Areas of fishing activity in Puerto Rico, the 1st 2 characters represent the NMFS code for the municipality the fishing center occurs in.
DEALER VARCHAR2	Dealer information not present here. Code is currently filled with 9s.
WATER_BODY VARCHAR2	Column normally contains area of catch. Defaulted to 9s.
GEAR VARCHAR2	The NMFS gear code as determined by the submitted Puerto Rico (Erdman) gear code. Multiple gears may occur within a trip.
SPECIES VARCHAR2	The NMFS Species Code as best determined by the submitted Puerto Rico (Erdman) species code. Some NMFS species codes are more general where the Erdman codes are specific.
SHELL_OR_FINFISH VARCHAR2	1 is finfish and 2 is shellfish. For general extractions.
POUNDS NUMBER	The landed pounds. Currently the landed conditions vary according to fishery. Trap and net fish are whole weight, fish caught with hooks or speared are typically gutted. Sharks are typically dressed weight. For Conchs, (prior to 2003, all landings presumably are reported as uncleaned (including head and viscera). In 2003 aproximately 50% of meats were cleaned and by 2004 all conch was reported in cleaned condition - SEDAR 14). No adjustments have been made for any landed condtions in these data.
VALUE NUMBER	Value in dollars. Dollars are rounded to integers in data.
SECTION VARCHAR2	Section Code, Added for compatibility with ALS.ALS_LANDINGS
PRICE NUMBER	Price payed for fish. (In dollars) Used with landings to calculate value.
DISTANCE VARCHAR2	Distance From Shore Code. EEZ begins at 9 miles out to sea in Puerto Rico. Data in this column are incomplete. 9s used as placeholders.
STATE_CAUGHT VARCHAR2	State Caught. No meaning to this column here. Added For compatibility WIth ALS.ALS_LANDINGS
LANDING_DATE DATE	The date the vessel arrived back at dock with landings.
PR_ID_CODE VARCHAR2	Code assigned to individual or other entity when permit is issued. Coding is inconsistent. 1st 3 characters appear to represent fishing center of permit holder for earlier years until 1998.
PR_GEAR VARCHAR2	The Puerto Rico gear code (Developed by Donald S. Erdman).
NUMBER_OF_TRIPS NUMBER	Number Of Trips
PR_SPECIES VARCHAR2	The Puerto Rico species code (Developed by Donald S. Erdman).
GEAR_QTY NUMBER	Represents the maximum number of gear in use at any one time during the trip.
GEAR_HOURS NUMBER	Soak Time - Amount of time the gear is in the water. Likely to exceed trip duration in the case of traps.
DAY_LANDED VARCHAR2	Day landed. Derived from landing date
USERID VARCHAR2	Oracle Id Of The Person Loading The Data
SOURCE_FILE VARCHAR2	Source File used to load data.
MINIMUM_DEPTH NUMBER	Minimum Depth Fished in fathoms - data are incomplete.
MAXIMUM_DEPTH NUMBER	Maximum Depth Fished in fathoms. Data are incomplete.
TRIP_TICKET_NUMBER VARCHAR2	Trip Ticket Number. Currently assigned after PRDNR receives trip ticket from fisher (not preprinted).
RECORD_NUMBER_ID NUMBER	Primary Key to the table. Foreign Key to als.als_land_pr_1983_2011_errata

Data Attribute / Type

Description

MONTH_LANDED
VARCHAR2

Month of landing

YEAR_LANDED
VARCHAR2

4 character Year Landed

STATE_LANDED
VARCHAR2

State Code Landed. Currently is defaulted to 55.

FISHING_CENTER
VARCHAR2

Areas of fishing activity in Puerto Rico, the 1st 2 characters represent the NMFS code for the municipality the fishing center occurs in.

DEALER
VARCHAR2

Dealer information not present here. Code is currently filled with 9s.

WATER_BODY
VARCHAR2

Column normally contains area of catch. Defaulted to 9s.

GEAR
VARCHAR2

The NMFS gear code as determined by the submitted Puerto Rico (Erdman) gear code. Multiple gears may occur within a trip.

SPECIES
VARCHAR2

The NMFS Species Code as best determined by the submitted Puerto Rico (Erdman) species code. Some NMFS species codes are more general where the Erdman codes are specific.

SHELL_OR_FINFISH
VARCHAR2

1 is finfish and 2 is shellfish. For general extractions.

POUNDS
NUMBER

The landed pounds. Currently the landed conditions vary according to fishery. Trap and net fish are whole weight, fish caught with hooks or speared are typically gutted. Sharks are typically dressed weight. For Conchs, (prior to 2003, all landings presumably are reported as uncleaned (including head and viscera). In 2003 aproximately 50% of meats were cleaned and by 2004 all conch was reported in cleaned condition - SEDAR 14). No adjustments have been made for any landed condtions in these data.

VALUE
NUMBER

Value in dollars. Dollars are rounded to integers in data.

SECTION
VARCHAR2

Section Code, Added for compatibility with ALS.ALS_LANDINGS

PRICE
NUMBER

Price payed for fish. (In dollars) Used with landings to calculate value.

DISTANCE
VARCHAR2

Distance From Shore Code. EEZ begins at 9 miles out to sea in Puerto Rico. Data in this column are incomplete. 9s used as placeholders.

STATE_CAUGHT
VARCHAR2

State Caught. No meaning to this column here. Added For compatibility WIth ALS.ALS_LANDINGS

LANDING_DATE
DATE

The date the vessel arrived back at dock with landings.

PR_ID_CODE
VARCHAR2

Code assigned to individual or other entity when permit is issued. Coding is inconsistent. 1st 3 characters appear to represent fishing center of permit holder for earlier years until 1998.

PR_GEAR
VARCHAR2

The Puerto Rico gear code (Developed by Donald S. Erdman).

NUMBER_OF_TRIPS
NUMBER

Number Of Trips

PR_SPECIES
VARCHAR2

The Puerto Rico species code (Developed by Donald S. Erdman).

GEAR_QTY
NUMBER

Represents the maximum number of gear in use at any one time during the trip.

GEAR_HOURS
NUMBER

Soak Time - Amount of time the gear is in the water. Likely to exceed trip duration in the case of traps.

DAY_LANDED
VARCHAR2

Day landed. Derived from landing date

USERID
VARCHAR2

Oracle Id Of The Person Loading The Data

SOURCE_FILE
VARCHAR2

Source File used to load data.

MINIMUM_DEPTH
NUMBER

Minimum Depth Fished in fathoms - data are incomplete.

MAXIMUM_DEPTH
NUMBER

Maximum Depth Fished in fathoms. Data are incomplete.

TRIP_TICKET_NUMBER
VARCHAR2

Trip Ticket Number. Currently assigned after PRDNR receives trip ticket from fisher (not preprinted).

RECORD_NUMBER_ID
NUMBER

Primary Key to the table. Foreign Key to als.als_land_pr_1983_2011_errata

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: ALS_LAND_PR_1983_2011
Short Name:	ALS_LAND_PR_1983_2011
Status:	Completed
Abstract:	The unedited Puerto Rico ALS table from 1983-2011 with primary key (record_number_id) added to link with edited errata table ALS.als_land_pr_1983-2011_errata. This is a copy of ALS.ALS_LANDINGS_PUERTO_RICO for the years 1983-2011. This copy was assigned a record id number for each record linking it to the errata file als.als_land_pr_1983_2011_errata for the corresponding record.
Purpose:	Allows for display of edited records and their previous values in the raw data for 1983-2011 to account for where changes were made.
Notes:	Loaded by batch 7906, 12-22-2015 14:11

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	ALS
Description:	The unedited Puerto Rico ALS table from 1983-2011 with primary key (record_number_id) added to link with edited errata table ALS.als_land_pr_1983-2011_errata.

Attribute Summary

	Name	Type	Description
100	MONTH_LANDED	VARCHAR2	Month of landing
100	YEAR_LANDED	VARCHAR2	4 character Year Landed
100	STATE_LANDED	VARCHAR2	State Code Landed. Currently is defaulted to 55.
100	FISHING_CENTER	VARCHAR2	Areas of fishing activity in Puerto Rico, the 1st 2 characters represent the NMFS code for the municipality the fishing center occurs in.
100	DEALER	VARCHAR2	Dealer information not present here. Code is currently filled with 9s.
100	WATER_BODY	VARCHAR2	Column normally contains area of catch. Defaulted to 9s.
100	GEAR	VARCHAR2	The NMFS gear code as determined by the submitted Puerto Rico (Erdman) gear code. Multiple gears may occur within a trip.
100	SPECIES	VARCHAR2	The NMFS Species Code as best determined by the submitted Puerto Rico (Erdman) species code. Some NMFS species codes are more general where the Erdman codes are specific.
100	SHELL_OR_FINFISH	VARCHAR2	1 is finfish and 2 is shellfish. For general extractions.
100	POUNDS	NUMBER	The landed pounds. Currently the landed conditions vary according to fishery. Trap and net fish are whole weight, fish caught with hooks or speared are typically gutted. Sharks are typically dressed weight. For Conchs, (prior to 2003, all landings presumably are reported as uncleaned (including head and viscera). In 2003 aproximately 50% of meats were cleaned and by 2004 all conch was reported in cleaned condition - SEDAR 14). No adjustments have been made for any landed condtions in these data.
100	VALUE	NUMBER	Value in dollars. Dollars are rounded to integers in data.
100	SECTION	VARCHAR2	Section Code, Added for compatibility with ALS.ALS_LANDINGS
100	PRICE	NUMBER	Price payed for fish. (In dollars) Used with landings to calculate value.
100	DISTANCE	VARCHAR2	Distance From Shore Code. EEZ begins at 9 miles out to sea in Puerto Rico. Data in this column are incomplete. 9s used as placeholders.
100	STATE_CAUGHT	VARCHAR2	State Caught. No meaning to this column here. Added For compatibility WIth ALS.ALS_LANDINGS
100	LANDING_DATE	DATE	The date the vessel arrived back at dock with landings.
100	PR_ID_CODE	VARCHAR2	Code assigned to individual or other entity when permit is issued. Coding is inconsistent. 1st 3 characters appear to represent fishing center of permit holder for earlier years until 1998.
100	PR_GEAR	VARCHAR2	The Puerto Rico gear code (Developed by Donald S. Erdman).
100	NUMBER_OF_TRIPS	NUMBER	Number Of Trips
100	PR_SPECIES	VARCHAR2	The Puerto Rico species code (Developed by Donald S. Erdman).
100	GEAR_QTY	NUMBER	Represents the maximum number of gear in use at any one time during the trip.
100	GEAR_HOURS	NUMBER	Soak Time - Amount of time the gear is in the water. Likely to exceed trip duration in the case of traps.
100	DAY_LANDED	VARCHAR2	Day landed. Derived from landing date
100	USERID	VARCHAR2	Oracle Id Of The Person Loading The Data
100	SOURCE_FILE	VARCHAR2	Source File used to load data.
100	MINIMUM_DEPTH	NUMBER	Minimum Depth Fished in fathoms - data are incomplete.
100	MAXIMUM_DEPTH	NUMBER	Maximum Depth Fished in fathoms. Data are incomplete.
100	TRIP_TICKET_NUMBER	VARCHAR2	Trip Ticket Number. Currently assigned after PRDNR receives trip ticket from fisher (not preprinted).
100	RECORD_NUMBER_ID	NUMBER	Primary Key to the table. Foreign Key to als.als_land_pr_1983_2011_errata

Name

Type

Description

100

MONTH_LANDED

VARCHAR2

Month of landing

100

YEAR_LANDED

VARCHAR2

4 character Year Landed

100

STATE_LANDED

VARCHAR2

State Code Landed. Currently is defaulted to 55.

100

FISHING_CENTER

VARCHAR2

Areas of fishing activity in Puerto Rico, the 1st 2 characters represent the NMFS code for the municipality the fishing center occurs in.

100

DEALER

VARCHAR2

Dealer information not present here. Code is currently filled with 9s.

100

WATER_BODY

VARCHAR2

Column normally contains area of catch. Defaulted to 9s.

100

GEAR

VARCHAR2

The NMFS gear code as determined by the submitted Puerto Rico (Erdman) gear code. Multiple gears may occur within a trip.

100

SPECIES

VARCHAR2

The NMFS Species Code as best determined by the submitted Puerto Rico (Erdman) species code. Some NMFS species codes are more general where the Erdman codes are specific.

100

SHELL_OR_FINFISH

VARCHAR2

1 is finfish and 2 is shellfish. For general extractions.

100

POUNDS

NUMBER

100

VALUE

NUMBER

Value in dollars. Dollars are rounded to integers in data.

100

SECTION

VARCHAR2

Section Code, Added for compatibility with ALS.ALS_LANDINGS

100

PRICE

NUMBER

Price payed for fish. (In dollars) Used with landings to calculate value.

100

DISTANCE

VARCHAR2

Distance From Shore Code. EEZ begins at 9 miles out to sea in Puerto Rico. Data in this column are incomplete. 9s used as placeholders.

100

STATE_CAUGHT

VARCHAR2

State Caught. No meaning to this column here. Added For compatibility WIth ALS.ALS_LANDINGS

100

LANDING_DATE

DATE

The date the vessel arrived back at dock with landings.

100

PR_ID_CODE

VARCHAR2

Code assigned to individual or other entity when permit is issued. Coding is inconsistent. 1st 3 characters appear to represent fishing center of permit holder for earlier years until 1998.

100

PR_GEAR

VARCHAR2

The Puerto Rico gear code (Developed by Donald S. Erdman).

100

NUMBER_OF_TRIPS

NUMBER

Number Of Trips

100

PR_SPECIES

VARCHAR2

The Puerto Rico species code (Developed by Donald S. Erdman).

100

GEAR_QTY

NUMBER

Represents the maximum number of gear in use at any one time during the trip.

100

GEAR_HOURS

NUMBER

Soak Time - Amount of time the gear is in the water. Likely to exceed trip duration in the case of traps.

100

DAY_LANDED

VARCHAR2

Day landed. Derived from landing date

100

USERID

VARCHAR2

Oracle Id Of The Person Loading The Data

100

SOURCE_FILE

VARCHAR2

Source File used to load data.

100

MINIMUM_DEPTH

NUMBER

Minimum Depth Fished in fathoms - data are incomplete.

100

MAXIMUM_DEPTH

NUMBER

Maximum Depth Fished in fathoms. Data are incomplete.

100

TRIP_TICKET_NUMBER

VARCHAR2

Trip Ticket Number. Currently assigned after PRDNR receives trip ticket from fisher (not preprinted).

100

RECORD_NUMBER_ID

NUMBER

Primary Key to the table. Foreign Key to als.als_land_pr_1983_2011_errata

Attribute Details

MONTH_LANDED

CC ID: 267176

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month of landing
General Data Type:	VARCHAR2

YEAR_LANDED

CC ID: 267187

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	4 character Year Landed
General Data Type:	VARCHAR2

STATE_LANDED

CC ID: 267198

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	State Code Landed. Currently is defaulted to 55.
General Data Type:	VARCHAR2

FISHING_CENTER

CC ID: 267199

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Areas of fishing activity in Puerto Rico, the 1st 2 characters represent the NMFS code for the municipality the fishing center occurs in.
General Data Type:	VARCHAR2

DEALER

CC ID: 267200

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	14
Required:	No
Primary Key:	No
Status:	Active
Description:	Dealer information not present here. Code is currently filled with 9s.
General Data Type:	VARCHAR2

WATER_BODY

CC ID: 267201

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Column normally contains area of catch. Defaulted to 9s.
General Data Type:	VARCHAR2

GEAR

CC ID: 267202

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	The NMFS gear code as determined by the submitted Puerto Rico (Erdman) gear code. Multiple gears may occur within a trip.
General Data Type:	VARCHAR2

SPECIES

CC ID: 267203

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	The NMFS Species Code as best determined by the submitted Puerto Rico (Erdman) species code. Some NMFS species codes are more general where the Erdman codes are specific.
General Data Type:	VARCHAR2

SHELL_OR_FINFISH

CC ID: 267204

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	1 is finfish and 2 is shellfish. For general extractions.
General Data Type:	VARCHAR2

POUNDS

CC ID: 267177

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	The landed pounds. Currently the landed conditions vary according to fishery. Trap and net fish are whole weight, fish caught with hooks or speared are typically gutted. Sharks are typically dressed weight. For Conchs, (prior to 2003, all landings presumably are reported as uncleaned (including head and viscera). In 2003 aproximately 50% of meats were cleaned and by 2004 all conch was reported in cleaned condition - SEDAR 14). No adjustments have been made for any landed condtions in these data.
General Data Type:	NUMBER

VALUE

CC ID: 267178

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	Value in dollars. Dollars are rounded to integers in data.
General Data Type:	NUMBER

SECTION

CC ID: 267179

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Section Code, Added for compatibility with ALS.ALS_LANDINGS
General Data Type:	VARCHAR2

PRICE

CC ID: 267180

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	3
Status:	Active
Description:	Price payed for fish. (In dollars) Used with landings to calculate value.
General Data Type:	NUMBER

DISTANCE

CC ID: 267181

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Distance From Shore Code. EEZ begins at 9 miles out to sea in Puerto Rico. Data in this column are incomplete. 9s used as placeholders.
General Data Type:	VARCHAR2

STATE_CAUGHT

CC ID: 267182

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	State Caught. No meaning to this column here. Added For compatibility WIth ALS.ALS_LANDINGS
General Data Type:	VARCHAR2

LANDING_DATE

CC ID: 267183

Seq. Order:	16
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date the vessel arrived back at dock with landings.
General Data Type:	DATE

PR_ID_CODE

CC ID: 267184

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Code assigned to individual or other entity when permit is issued. Coding is inconsistent. 1st 3 characters appear to represent fishing center of permit holder for earlier years until 1998.
General Data Type:	VARCHAR2

PR_GEAR

CC ID: 267185

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	The Puerto Rico gear code (Developed by Donald S. Erdman).
General Data Type:	VARCHAR2

NUMBER_OF_TRIPS

CC ID: 267186

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Number Of Trips
General Data Type:	NUMBER

PR_SPECIES

CC ID: 267188

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	The Puerto Rico species code (Developed by Donald S. Erdman).
General Data Type:	VARCHAR2

GEAR_QTY

CC ID: 267189

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Represents the maximum number of gear in use at any one time during the trip.
General Data Type:	NUMBER

GEAR_HOURS

CC ID: 267190

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Soak Time - Amount of time the gear is in the water. Likely to exceed trip duration in the case of traps.
General Data Type:	NUMBER

DAY_LANDED

CC ID: 267191

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Day landed. Derived from landing date
General Data Type:	VARCHAR2

USERID

CC ID: 267192

Seq. Order:	24
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Oracle Id Of The Person Loading The Data
General Data Type:	VARCHAR2

SOURCE_FILE

CC ID: 267193

Seq. Order:	25
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Source File used to load data.
General Data Type:	VARCHAR2

MINIMUM_DEPTH

CC ID: 267194

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Minimum Depth Fished in fathoms - data are incomplete.
General Data Type:	NUMBER

MAXIMUM_DEPTH

CC ID: 267195

Seq. Order:	27
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Maximum Depth Fished in fathoms. Data are incomplete.
General Data Type:	NUMBER

TRIP_TICKET_NUMBER

CC ID: 267196

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	11
Required:	No
Primary Key:	No
Status:	Active
Description:	Trip Ticket Number. Currently assigned after PRDNR receives trip ticket from fisher (not preprinted).
General Data Type:	VARCHAR2

RECORD_NUMBER_ID

CC ID: 267197

Seq. Order:	29
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Primary Key to the table. Foreign Key to als.als_land_pr_1983_2011_errata
General Data Type:	NUMBER

Catalog Item ID:	29945
GUID:	gov.noaa.nmfs.inport:29945
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

Table: ALS_LAND_PR_1983_2011

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

MONTH_LANDED

YEAR_LANDED

STATE_LANDED

FISHING_CENTER

DEALER

WATER_BODY

GEAR

SPECIES

SHELL_OR_FINFISH

POUNDS

VALUE

SECTION

PRICE

DISTANCE

STATE_CAUGHT

LANDING_DATE

PR_ID_CODE

PR_GEAR

NUMBER_OF_TRIPS

PR_SPECIES

GEAR_QTY

GEAR_HOURS

DAY_LANDED

USERID

SOURCE_FILE

MINIMUM_DEPTH

MAXIMUM_DEPTH

TRIP_TICKET_NUMBER

RECORD_NUMBER_ID

Catalog Details