5404 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