Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Dealer Reporting > Pelagic Dealer Compliance > Pelagic Dealer Commercial Landings Monitoring (... >

Table: FLS_INT_VALIDATION_ERRORS

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Hold Validation Errors from the processing of a scanned batchof logbook data. All columns may not be used in this table depeneding upon whether the validation run is for a dealer logbook, or from whatever fishers logbook that was scanned

Description

Entity Type
Data Table

Data Attribute / Type	Description
ERROR_NUMBER VARCHAR2	Error Number
BATCH_NUMBER VARCHAR2	Batch Number
SCHEDULE_NUMBER VARCHAR2	Schedule Number
LOGBOOK_KEY NUMBER	Logbook Key -- Links to FLS_LOGBOOKS Received
FISHING_ACTIVITY_KEY NUMBER	Fishing Activity Key
GEAR_FISHED_KEY NUMBER	Gear Fished Key Of Record With Errors
CATCH_KEY NUMBER	Catch Key Of Record With Errors
CHILD_NAME_KEY VARCHAR2	In caes of fisher logbooks, the name of the child table that is generating the error
CHILD_VALUE_KEY NUMBER	In caes of fisher logbooks, the valuef the child table column that is generating the error
TABLE_NAME VARCHAR2	Oracle Table that contains validation Error
COLUMN_NAME VARCHAR2	Oracle Column of Record containg validation error
VALUE VARCHAR2	Data Value in error
ERROR_MESSAGE VARCHAR2	Validation Error Message
DATA_TYPE VARCHAR2	Data Type Of Column That is in err
TABLE_TYPE VARCHAR2	Type Of table that has validation error
ERROR_TYPE VARCHAR2	Type Of validation error
DATE_ENTERED DATE	Date Time stamp of when record was added to this table
SOURCE_FILE VARCHAR2	Name Of File Loaded That caused validation error
USERID VARCHAR2	Oracle Id of one who ran validation program
ERROR_TYPE_CHANGED VARCHAR2	Has Type Of Error changed. Valid values or Y or N.
BATCH_SEQUENCE_NUMBER VARCHAR2	Batch sequence Number of record that erred
VESSEL_ID_NUMBER VARCHAR2	Vessel Identification Number Of Record that erred

Data Attribute / Type

Description

ERROR_NUMBER
VARCHAR2

Error Number

BATCH_NUMBER
VARCHAR2

Batch Number

SCHEDULE_NUMBER
VARCHAR2

Schedule Number

LOGBOOK_KEY
NUMBER

Logbook Key -- Links to FLS_LOGBOOKS Received

FISHING_ACTIVITY_KEY
NUMBER

Fishing Activity Key

GEAR_FISHED_KEY
NUMBER

Gear Fished Key Of Record With Errors

CATCH_KEY
NUMBER

Catch Key Of Record With Errors

CHILD_NAME_KEY
VARCHAR2

In caes of fisher logbooks, the name of the child table that is generating the error

CHILD_VALUE_KEY
NUMBER

In caes of fisher logbooks, the valuef the child table column that is generating the error

TABLE_NAME
VARCHAR2

Oracle Table that contains validation Error

COLUMN_NAME
VARCHAR2

Oracle Column of Record containg validation error

VALUE
VARCHAR2

Data Value in error

ERROR_MESSAGE
VARCHAR2

Validation Error Message

DATA_TYPE
VARCHAR2

Data Type Of Column That is in err

TABLE_TYPE
VARCHAR2

Type Of table that has validation error

ERROR_TYPE
VARCHAR2

Type Of validation error

DATE_ENTERED
DATE

Date Time stamp of when record was added to this table

SOURCE_FILE
VARCHAR2

Name Of File Loaded That caused validation error

USERID
VARCHAR2

Oracle Id of one who ran validation program

ERROR_TYPE_CHANGED
VARCHAR2

Has Type Of Error changed. Valid values or Y or N.

BATCH_SEQUENCE_NUMBER
VARCHAR2

Batch sequence Number of record that erred

VESSEL_ID_NUMBER
VARCHAR2

Vessel Identification Number Of Record that erred

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: FLS_INT_VALIDATION_ERRORS
Short Name:	FLS_INT_VALIDATION_ERRORS
Status:	Completed
Abstract:	Hold Validation Errors from the processing of a scanned batchof logbook data. All columns may not be used in this table depeneding upon whether the validation run is for a dealer logbook, or from whatever fishers logbook that was scanned
Notes:	Loaded by batch 1703, 10-15-2007 10:13

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	FLS
Description:	Hold Validation Errors from the processing of a scanned batchof logbook data. All columns may not be used in this table depeneding upon whether the validation run is for a dealer logbook, or from whatever fishers logbook that was scanned

Attribute Summary

	Name	Type	Description
100	ERROR_NUMBER	VARCHAR2	Error Number
100	BATCH_NUMBER	VARCHAR2	Batch Number
100	SCHEDULE_NUMBER	VARCHAR2	Schedule Number
100	LOGBOOK_KEY	NUMBER	Logbook Key -- Links to FLS_LOGBOOKS Received
100	FISHING_ACTIVITY_KEY	NUMBER	Fishing Activity Key
100	GEAR_FISHED_KEY	NUMBER	Gear Fished Key Of Record With Errors
100	CATCH_KEY	NUMBER	Catch Key Of Record With Errors
100	CHILD_NAME_KEY	VARCHAR2	In caes of fisher logbooks, the name of the child table that is generating the error
100	CHILD_VALUE_KEY	NUMBER	In caes of fisher logbooks, the valuef the child table column that is generating the error
100	TABLE_NAME	VARCHAR2	Oracle Table that contains validation Error
100	COLUMN_NAME	VARCHAR2	Oracle Column of Record containg validation error
100	VALUE	VARCHAR2	Data Value in error
100	ERROR_MESSAGE	VARCHAR2	Validation Error Message
100	DATA_TYPE	VARCHAR2	Data Type Of Column That is in err
100	TABLE_TYPE	VARCHAR2	Type Of table that has validation error
100	ERROR_TYPE	VARCHAR2	Type Of validation error
100	DATE_ENTERED	DATE	Date Time stamp of when record was added to this table
100	SOURCE_FILE	VARCHAR2	Name Of File Loaded That caused validation error
100	USERID	VARCHAR2	Oracle Id of one who ran validation program
100	ERROR_TYPE_CHANGED	VARCHAR2	Has Type Of Error changed. Valid values or Y or N.
100	BATCH_SEQUENCE_NUMBER	VARCHAR2	Batch sequence Number of record that erred
100	VESSEL_ID_NUMBER	VARCHAR2	Vessel Identification Number Of Record that erred

Name

Type

Description

100

ERROR_NUMBER

VARCHAR2

Error Number

100

BATCH_NUMBER

VARCHAR2

Batch Number

100

SCHEDULE_NUMBER

VARCHAR2

Schedule Number

100

LOGBOOK_KEY

NUMBER

Logbook Key -- Links to FLS_LOGBOOKS Received

100

FISHING_ACTIVITY_KEY

NUMBER

Fishing Activity Key

100

GEAR_FISHED_KEY

NUMBER

Gear Fished Key Of Record With Errors

100

CATCH_KEY

NUMBER

Catch Key Of Record With Errors

100

CHILD_NAME_KEY

VARCHAR2

In caes of fisher logbooks, the name of the child table that is generating the error

100

CHILD_VALUE_KEY

NUMBER

In caes of fisher logbooks, the valuef the child table column that is generating the error

100

TABLE_NAME

VARCHAR2

Oracle Table that contains validation Error

100

COLUMN_NAME

VARCHAR2

Oracle Column of Record containg validation error

100

VALUE

VARCHAR2

Data Value in error

100

ERROR_MESSAGE

VARCHAR2

Validation Error Message

100

DATA_TYPE

VARCHAR2

Data Type Of Column That is in err

100

TABLE_TYPE

VARCHAR2

Type Of table that has validation error

100

ERROR_TYPE

VARCHAR2

Type Of validation error

100

DATE_ENTERED

DATE

Date Time stamp of when record was added to this table

100

SOURCE_FILE

VARCHAR2

Name Of File Loaded That caused validation error

100

USERID

VARCHAR2

Oracle Id of one who ran validation program

100

ERROR_TYPE_CHANGED

VARCHAR2

Has Type Of Error changed. Valid values or Y or N.

100

BATCH_SEQUENCE_NUMBER

VARCHAR2

Batch sequence Number of record that erred

100

VESSEL_ID_NUMBER

VARCHAR2

Vessel Identification Number Of Record that erred

Attribute Details

ERROR_NUMBER

CC ID: 16803

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Error Number
General Data Type:	VARCHAR2

BATCH_NUMBER

CC ID: 16802

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Batch Number
General Data Type:	VARCHAR2

SCHEDULE_NUMBER

CC ID: 16801

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Schedule Number
General Data Type:	VARCHAR2

LOGBOOK_KEY

CC ID: 16800

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Logbook Key -- Links to FLS_LOGBOOKS Received
General Data Type:	NUMBER

FISHING_ACTIVITY_KEY

CC ID: 16799

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Fishing Activity Key
General Data Type:	NUMBER

GEAR_FISHED_KEY

CC ID: 16798

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Gear Fished Key Of Record With Errors
General Data Type:	NUMBER

CATCH_KEY

CC ID: 16797

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Catch Key Of Record With Errors
General Data Type:	NUMBER

CHILD_NAME_KEY

CC ID: 16796

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	In caes of fisher logbooks, the name of the child table that is generating the error
General Data Type:	VARCHAR2

CHILD_VALUE_KEY

CC ID: 16795

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	In caes of fisher logbooks, the valuef the child table column that is generating the error
General Data Type:	NUMBER

TABLE_NAME

CC ID: 16794

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Oracle Table that contains validation Error
General Data Type:	VARCHAR2

COLUMN_NAME

CC ID: 16793

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Oracle Column of Record containg validation error
General Data Type:	VARCHAR2

VALUE

CC ID: 16792

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Data Value in error
General Data Type:	VARCHAR2

ERROR_MESSAGE

CC ID: 16791

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	Validation Error Message
General Data Type:	VARCHAR2

DATA_TYPE

CC ID: 16790

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Data Type Of Column That is in err
General Data Type:	VARCHAR2

TABLE_TYPE

CC ID: 16789

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Type Of table that has validation error
General Data Type:	VARCHAR2

ERROR_TYPE

CC ID: 16788

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Type Of validation error
General Data Type:	VARCHAR2

DATE_ENTERED

CC ID: 16787

Seq. Order:	17
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date Time stamp of when record was added to this table
General Data Type:	DATE

SOURCE_FILE

CC ID: 16786

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Name Of File Loaded That caused validation error
General Data Type:	VARCHAR2

USERID

CC ID: 16785

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Oracle Id of one who ran validation program
General Data Type:	VARCHAR2

ERROR_TYPE_CHANGED

CC ID: 16784

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Has Type Of Error changed. Valid values or Y or N.
General Data Type:	VARCHAR2

BATCH_SEQUENCE_NUMBER

CC ID: 16783

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Batch sequence Number of record that erred
General Data Type:	VARCHAR2

VESSEL_ID_NUMBER

CC ID: 16782

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	Vessel Identification Number Of Record that erred
General Data Type:	VARCHAR2

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ERROR_NUMBER

BATCH_NUMBER

SCHEDULE_NUMBER

LOGBOOK_KEY

FISHING_ACTIVITY_KEY

GEAR_FISHED_KEY

CATCH_KEY

CHILD_NAME_KEY

CHILD_VALUE_KEY

TABLE_NAME

COLUMN_NAME

VALUE

ERROR_MESSAGE

DATA_TYPE

TABLE_TYPE

ERROR_TYPE

DATE_ENTERED

SOURCE_FILE

USERID

ERROR_TYPE_CHANGED

BATCH_SEQUENCE_NUMBER

VESSEL_ID_NUMBER

Catalog Details