Slide Menu
InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.3. Downtime Schedule Tuesday, November 29, 2022 12:00pm - 1:30pm Eastern / 10:00am - 11:30pm Pacific / 7:00am - 8:30pm Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheries.noaa.gov/inportserve/waf What's...
View All
Search Help Show/Hide Menu

Item Identification

Title: edc_cvcost_view_conf

Entity Information

Entity Type: Data Table
Description:

Replicate of EDC Catcher-Vessel cost view

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
edcsurvey_dbid int2 EDC survey database identifier
100
year int4 The year the catch was delivered. The database table is partitioned by PacFIN year. All queries that include year should use PACFIN_YEAR instead of LANDING_YEAR
100
cost numeric Total expense
100
fullcode varchar Full code used to identify a value in a table
100
fisherycode varchar Code for fishery
100
survey_year int4 Survey year
100
vessel_id varchar Similar to Legacy PacFINs DRVID, but not exactly. It can be a USCG VID (ex: 1234567 or AK1234nn) or MISSING or UNKNOWN if vessel ID not provided or invalid. It is also Null if no vessel was used. For the at-sea sector, populated with catcher vessel_id or catcher processor vessel_id

Attribute Details

edcsurvey_dbid

CC ID: 376460
Data Storage Type: int2
Max Length: 16
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

EDC survey database identifier

Unit of Measure: unspecified
Allowed Values: Any

year

CC ID: 376461
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

The year the catch was delivered. The database table is partitioned by PacFIN year. All queries that include year should use PACFIN_YEAR instead of LANDING_YEAR

Unit of Measure: unspecified
Allowed Values: Any

cost

CC ID: 376462
Data Storage Type: numeric
Max Length: 20
Required: No
Primary Key: No
Precision: 9
Status: Active
Description:

Total expense

Unit of Measure: unspecified
Allowed Values: Any

fullcode

CC ID: 376463
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Full code used to identify a value in a table

Unit of Measure: unspecified
Allowed Values: Any

fisherycode

CC ID: 376464
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Code for fishery

Unit of Measure: unspecified
Allowed Values: Any

survey_year

CC ID: 376465
Data Storage Type: int4
Max Length: 32
Required: No
Primary Key: No
Precision: 0
Status: Active
Description:

Survey year

Unit of Measure: unspecified
Allowed Values: Any

vessel_id

CC ID: 376466
Data Storage Type: varchar
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Similar to Legacy PacFINs DRVID, but not exactly. It can be a USCG VID (ex: 1234567 or AK1234nn) or MISSING or UNKNOWN if vessel ID not provided or invalid. It is also Null if no vessel was used. For the at-sea sector, populated with catcher vessel_id or catcher processor vessel_id

Unit of Measure: unspecified
Allowed Values: Any

Catalog Details

Catalog Item ID: 36428
GUID: gov.noaa.nmfs.inport:36428
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2017-01-25 12:55+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-02-13
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-02-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-02-13