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