Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: VERS_APPORTION

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34230 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	Table: VERS_APPORTION
Short Name:	VERS_APPORTION
Status:	Completed
Abstract:	Table contains apportionment level records for electronically reported vessel catch sold to dealers or 'MISC' options listed in FVTR_DEALERS_MISC
Notes:	Loaded by batch 9189, 08-11-2016 10:02

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	FVTR
Description:	Table contains apportionment level records for electronically reported vessel catch sold to dealers or 'MISC' options listed in FVTR_DEALERS_MISC

Data Attributes

Attribute Summary

	Name	Type	Description
100	TRIP_ID	NUMBER	Unique trip identifier
100	LANDING_NUM	NUMBER	Sequential number of landing events
100	APPOR_NUM	NUMBER	Sequential number of apportionment events within a landing
100	SPECIES_ITIS	VARCHAR2	ACCSP species ITIS code
100	MARKET_CODE	VARCHAR2	ACCSP market code of the apportioned catch
100	GRADE_CODE	VARCHAR2	ACCSP grade code of the apportioned catch
100	APPOR_AMOUNT	NUMBER	Quantity entered for species apportionment to a dealer
100	APPOR_AMOUNT_UOM	VARCHAR2	Unit of measure for APPOR_AMOUNT
100	DEALER_PERMIT	VARCHAR2	Dealer identifier of the dealer purchasing catch
100	ISSUING_AGENCY	VARCHAR2	Government agency which issued the dealer permit (eg. state or federal)
100	SOLD_DATE	DATE	Date on which catch was sold to the dealer
100	APPOR_ENTRY_DATE_GMT	DATE	Datetime (UTC) at which the apportionment record was entered into the ELB
100	UPLOAD_DATE_GMT	DATE	Datetime (UTC) at which the submitted data was loaded to NEFSC servers
100	CD_DISPOSITION_CODE	VARCHAR2	ACCSP disposition code for the apportioned catch

Name

Type

Description

100

TRIP_ID

NUMBER

Unique trip identifier

100

LANDING_NUM

NUMBER

Sequential number of landing events

100

APPOR_NUM

NUMBER

Sequential number of apportionment events within a landing

100

SPECIES_ITIS

VARCHAR2

ACCSP species ITIS code

100

MARKET_CODE

VARCHAR2

ACCSP market code of the apportioned catch

100

GRADE_CODE

VARCHAR2

ACCSP grade code of the apportioned catch

100

APPOR_AMOUNT

NUMBER

Quantity entered for species apportionment to a dealer

100

APPOR_AMOUNT_UOM

VARCHAR2

Unit of measure for APPOR_AMOUNT

100

DEALER_PERMIT

VARCHAR2

Dealer identifier of the dealer purchasing catch

100

ISSUING_AGENCY

VARCHAR2

Government agency which issued the dealer permit (eg. state or federal)

100

SOLD_DATE

DATE

Date on which catch was sold to the dealer

100

APPOR_ENTRY_DATE_GMT

DATE

Datetime (UTC) at which the apportionment record was entered into the ELB

100

UPLOAD_DATE_GMT

DATE

Datetime (UTC) at which the submitted data was loaded to NEFSC servers

100

CD_DISPOSITION_CODE

VARCHAR2

ACCSP disposition code for the apportioned catch

Attribute Details

TRIP_ID

CC ID: 343939

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	14
Scale:	0
Status:	Active
Description:	Unique trip identifier
General Data Type:	NUMBER
Foreign Key Relations:	FVTR.VERS_LANDING

LANDING_NUM

CC ID: 343940

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	2
Scale:	0
Status:	Active
Description:	Sequential number of landing events
General Data Type:	NUMBER
Foreign Key Relations:	FVTR.VERS_LANDING

APPOR_NUM

CC ID: 343944

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	2
Scale:	0
Status:	Active
Description:	Sequential number of apportionment events within a landing
General Data Type:	NUMBER

SPECIES_ITIS

CC ID: 343935

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	11
Required:	Yes
Primary Key:	No
Status:	Active
Description:	ACCSP species ITIS code
General Data Type:	VARCHAR2
Foreign Key Relations:	FVTR.FVTR_SPECIES_CODES

MARKET_CODE

CC ID: 343936

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	ACCSP market code of the apportioned catch
General Data Type:	VARCHAR2
Foreign Key Relations:	FVTR.FVTR_SPECIES_CODES

GRADE_CODE

CC ID: 343937

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	ACCSP grade code of the apportioned catch
General Data Type:	VARCHAR2
Foreign Key Relations:	FVTR.FVTR_SPECIES_CODES

APPOR_AMOUNT

CC ID: 343945

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	1
Status:	Active
Description:	Quantity entered for species apportionment to a dealer
General Data Type:	NUMBER

APPOR_AMOUNT_UOM

CC ID: 343938

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Unit of measure for APPOR_AMOUNT
General Data Type:	VARCHAR2
Foreign Key Relations:	FVTR.FVTR_SPECIES_CODES

DEALER_PERMIT

CC ID: 343933

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Dealer identifier of the dealer purchasing catch
General Data Type:	VARCHAR2
Foreign Key Relations:	FVTR.FVTR_DEALERS

ISSUING_AGENCY

CC ID: 343932

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Government agency which issued the dealer permit (eg. state or federal)
General Data Type:	VARCHAR2
Foreign Key Relations:	FVTR.FVTR_DEALERS

SOLD_DATE

CC ID: 343941

Seq. Order:	11
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date on which catch was sold to the dealer
General Data Type:	DATE

APPOR_ENTRY_DATE_GMT

CC ID: 343942

Seq. Order:	12
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Datetime (UTC) at which the apportionment record was entered into the ELB
General Data Type:	DATE

UPLOAD_DATE_GMT

CC ID: 343943

Seq. Order:	13
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Datetime (UTC) at which the submitted data was loaded to NEFSC servers
General Data Type:	DATE

CD_DISPOSITION_CODE

CC ID: 343934

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	ACCSP disposition code for the apportioned catch
General Data Type:	VARCHAR2
Foreign Key Relations:	FVTR.FVTR_DISPOSITIONS

Catalog Details

Catalog Item ID:	34230
GUID:	gov.noaa.nmfs.inport:34230
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-08-11 10:02+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-08-23
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-08-23
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-08-23