Slide Menu
Search Help Show/Hide Menu

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