5404
Table: FLS_INT_VALIDATION_ERRORS
FLS_INT_VALIDATION_ERRORS
Entity
Published / External
5402
Pelagic Dealer Commercial Landings Monitoring (HMS Dealers)
Data Set
Completed
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
Loaded by batch 1703, 10-15-2007 10:13
Data Table
Yes
FLS
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
1
ERROR_NUMBER
VARCHAR2
10
No
No
Active
Error Number
VARCHAR2
2
BATCH_NUMBER
VARCHAR2
10
No
No
Active
Batch Number
VARCHAR2
3
SCHEDULE_NUMBER
VARCHAR2
10
No
No
Active
Schedule Number
VARCHAR2
4
LOGBOOK_KEY
NUMBER
22
No
No
10
0
Active
Logbook Key -- Links to FLS_LOGBOOKS Received
NUMBER
5
FISHING_ACTIVITY_KEY
NUMBER
22
No
No
10
0
Active
Fishing Activity Key
NUMBER
6
GEAR_FISHED_KEY
NUMBER
22
No
No
10
0
Active
Gear Fished Key Of Record With Errors
NUMBER
7
CATCH_KEY
NUMBER
22
No
No
10
0
Active
Catch Key Of Record With Errors
NUMBER
8
CHILD_NAME_KEY
VARCHAR2
30
No
No
Active
In caes of fisher logbooks, the name of the child table that is generating the error
VARCHAR2
9
CHILD_VALUE_KEY
NUMBER
22
No
No
10
0
Active
In caes of fisher logbooks, the valuef the child table column that is generating the error
NUMBER
10
TABLE_NAME
VARCHAR2
50
No
No
Active
Oracle Table that contains validation Error
VARCHAR2
11
COLUMN_NAME
VARCHAR2
50
No
No
Active
Oracle Column of Record containg validation error
VARCHAR2
12
VALUE
VARCHAR2
50
No
No
Active
Data Value in error
VARCHAR2
13
ERROR_MESSAGE
VARCHAR2
200
No
No
Active
Validation Error Message
VARCHAR2
14
DATA_TYPE
VARCHAR2
10
No
No
Active
Data Type Of Column That is in err
VARCHAR2
15
TABLE_TYPE
VARCHAR2
10
No
No
Active
Type Of table that has validation error
VARCHAR2
16
ERROR_TYPE
VARCHAR2
10
Yes
No
Active
Type Of validation error
VARCHAR2
17
DATE_ENTERED
DATE
7
No
No
Active
Date Time stamp of when record was added to this table
DATE
18
SOURCE_FILE
VARCHAR2
30
No
No
Active
Name Of File Loaded That caused validation error
VARCHAR2
19
USERID
VARCHAR2
20
No
No
Active
Oracle Id of one who ran validation program
VARCHAR2
20
ERROR_TYPE_CHANGED
VARCHAR2
1
No
No
Active
Has Type Of Error changed. Valid values or Y or N.
VARCHAR2
21
BATCH_SEQUENCE_NUMBER
VARCHAR2
10
No
No
Active
Batch sequence Number of record that erred
VARCHAR2
22
VESSEL_ID_NUMBER
VARCHAR2
10
No
No
Active
Vessel Identification Number Of Record that erred
VARCHAR2
gov.noaa.nmfs.inport:5404
Lee Weinberger
2007-10-15T10:13:54
SysAdmin InPortAdmin
2022-08-09T17:11:00
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06