Table: FLS_INT_VALIDATION_ERRORS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5404 | Updated: August 9, 2022 | Published / External
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
![]() |
![]() |
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |