Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Dealer Reporting > Pelagic Dealer Compliance > Pelagic Dealer Commercial Landings Monitoring (... >

View: PDC_SCANNED_VESSELS_ERRORS_V

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5424  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View Of Errors Detected While validating pelagic dealer Vessel data

Description

View Of Errors Detected While validating pelagic dealer Vessel data

Entity Information

Entity Type
Data View

Data Attribute / Type Description
BATCH_NUMBER
VARCHAR2 		Vendor assigned number for all records processed during a data scan
SCHEDULE
VARCHAR2 		This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemIn the INT files we programatically check to see that a cobination of teh e Year of The BEGIN_DATE and thiu column are unique.
VESSELID
VARCHAR2 		The corrected vessel information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error.
VESSEL_NAME
VARCHAR2 		Reported Vessel Name On The Form
DATE_LANDED
VARCHAR2 		Dta vessel landed
STATE_LANDED
VARCHAR2 		State Landed
PORT_LANDED
VARCHAR2 		Port Landed On Data Entry Form
VESSEL_ID_VALUE
VARCHAR2 		Suggested Vessel Id Value
VESSEL_NAME_VALUE
VARCHAR2 		Suggested New Vessel Name Value
PORT_LANDED_VALUE
VARCHAR2 		Suggested New Port Landed Value
COLUMN_NAME
VARCHAR2 		Column That has the validation error. (Usually this will be a port name that there is no assigned port/county code or a case where a vessel name is supplied with no vessel id.
USERID
VARCHAR2 		Oracle ID of the runner of the validation program

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: View: PDC_SCANNED_VESSELS_ERRORS_V
Short Name: PDC_SCANNED_VESSELS_ERRORS_V
Status: Completed
Abstract:

View Of Errors Detected While validating pelagic dealer Vessel data
Notes:

Loaded by batch 1703, 10-15-2007 10:13

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: FLS
Description:

View Of Errors Detected While validating pelagic dealer Vessel data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 BATCH_NUMBER VARCHAR2 Vendor assigned number for all records processed during a data scan
100
 SCHEDULE VARCHAR2 This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemIn the INT files we programatically check to see that a cobination of teh e Year of The BEGIN_DATE and thiu column are unique.
100
 VESSELID VARCHAR2 The corrected vessel information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error.
100
 VESSEL_NAME VARCHAR2 Reported Vessel Name On The Form
100
 DATE_LANDED VARCHAR2 Dta vessel landed
100
 STATE_LANDED VARCHAR2 State Landed
100
 PORT_LANDED VARCHAR2 Port Landed On Data Entry Form
100
 VESSEL_ID_VALUE VARCHAR2 Suggested Vessel Id Value
100
 VESSEL_NAME_VALUE VARCHAR2 Suggested New Vessel Name Value
100
 PORT_LANDED_VALUE VARCHAR2 Suggested New Port Landed Value
100
 COLUMN_NAME VARCHAR2 Column That has the validation error. (Usually this will be a port name that there is no assigned port/county code or a case where a vessel name is supplied with no vessel id.
100
 USERID VARCHAR2 Oracle ID of the runner of the validation program

Attribute Details

BATCH_NUMBER

CC ID: 17031
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Vendor assigned number for all records processed during a data scan
General Data Type: VARCHAR2

SCHEDULE

CC ID: 17036
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 12
Required: Yes
Primary Key: No
Status: Active
Description:

This is a number handwritten by FSB at the top right of the form. This is a unique number and was used to associate the form with the computer record in the header.dbf file in the PC SDC systemIn the INT files we programatically check to see that a cobination of teh e Year of The BEGIN_DATE and thiu column are unique.
General Data Type: VARCHAR2

VESSELID

CC ID: 17039
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

The corrected vessel information. This will often be the same as the repoerted vessel information. Though in some cases it will correct a typographical error.
General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 17038
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Reported Vessel Name On The Form
General Data Type: VARCHAR2

DATE_LANDED

CC ID: 17032
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Dta vessel landed
General Data Type: VARCHAR2

STATE_LANDED

CC ID: 17033
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

State Landed
General Data Type: VARCHAR2

PORT_LANDED

CC ID: 17034
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Port Landed On Data Entry Form
General Data Type: VARCHAR2

VESSEL_ID_VALUE

CC ID: 17029
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Suggested Vessel Id Value
General Data Type: VARCHAR2

VESSEL_NAME_VALUE

CC ID: 17028
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Suggested New Vessel Name Value
General Data Type: VARCHAR2

PORT_LANDED_VALUE

CC ID: 17037
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Suggested New Port Landed Value
General Data Type: VARCHAR2

COLUMN_NAME

CC ID: 17030
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Column That has the validation error. (Usually this will be a port name that there is no assigned port/county code or a case where a vessel name is supplied with no vessel id.
General Data Type: VARCHAR2

USERID

CC ID: 17035
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Oracle ID of the runner of the validation program
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5424
GUID: gov.noaa.nmfs.inport:5424
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-15 10:13+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+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