Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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

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

Entity Information

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

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: 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 Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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 Details

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