Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07