Table: ALS_WATERBODY_VALID_ERRORS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5464 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table that holds errors as a result of project to redo waterbody codes.
DescriptionTable that holds errors as a result of project to redo waterbody codes.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
ALSSTATE
VARCHAR2 |
NMFS State Code |
OLD_WATER
VARCHAR2 |
Old/Historical Water Body Code |
NEW_WATER
VARCHAR2 |
New/replacementl Water Body Code |
BEGIN_DATE
DATE |
Beginning Date WHere this transformation Is to be done |
END_DATE
DATE |
Beginning Date WHere this transformation Is to be done |
ERROR_TYPE
VARCHAR2 |
Can be either "Error" or "Warn" |
ERROR_MESSAGE
VARCHAR2 |
Error message |
REGION
VARCHAR2 |
Region Code |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (SEFSC) for inquiries on this record.
Item Identification
Title: | Table: ALS_WATERBODY_VALID_ERRORS |
---|---|
Short Name: | ALS_WATERBODY_VALID_ERRORS |
Status: | Completed |
Abstract: |
Table that holds errors as a result of project to redo waterbody codes. |
Notes: |
Loaded by batch 1727, 10-16-2007 09:13 |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
UNCONTROLLED | |
None | water body |
Physical Location
Organization: | Southeast Fisheries Science Center |
---|---|
City: | Miami |
State/Province: | FL |
Country: | USA |
Location Description: |
75 Virginia Beach Drive Miami, FL 33149 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | ALS |
Description: |
Table that holds errors as a result of project to redo waterbody codes. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ALSSTATE | VARCHAR2 | NMFS State Code | |
100
|
OLD_WATER | VARCHAR2 | Old/Historical Water Body Code | |
100
|
NEW_WATER | VARCHAR2 | New/replacementl Water Body Code | |
100
|
BEGIN_DATE | DATE | Beginning Date WHere this transformation Is to be done | |
100
|
END_DATE | DATE | Beginning Date WHere this transformation Is to be done | |
100
|
ERROR_TYPE | VARCHAR2 | Can be either "Error" or "Warn" | |
100
|
ERROR_MESSAGE | VARCHAR2 | Error message | |
100
|
REGION | VARCHAR2 | Region Code |
Attribute Details
ALSSTATE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
NMFS State Code |
General Data Type: | VARCHAR2 |
OLD_WATER
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Old/Historical Water Body Code |
General Data Type: | VARCHAR2 |
NEW_WATER
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
New/replacementl Water Body Code |
General Data Type: | VARCHAR2 |
BEGIN_DATE
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Beginning Date WHere this transformation Is to be done |
General Data Type: | DATE |
END_DATE
Seq. Order: | 5 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Beginning Date WHere this transformation Is to be done |
General Data Type: | DATE |
ERROR_TYPE
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Can be either "Error" or "Warn" |
General Data Type: | VARCHAR2 |
ERROR_MESSAGE
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 55 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Error message |
General Data Type: | VARCHAR2 |
REGION
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Region Code |
General Data Type: | VARCHAR2 |
Access Information
Security Class: | Restricted |
---|---|
Security Classification System: |
Password restricted |
Security Handling Description: |
Password restricted |
Data Access Policy: |
Password restricted |
Data Access Procedure: |
Password restricted |
Data Access Constraints: |
Password restricted |
Data Use Constraints: |
NOAA/SEFSC Internal use only. |
Metadata Access Constraints: |
Non-published Metadata access is restricted. Published Metadata is available to the public. |
Metadata Use Constraints: |
Use only Published Metadata. |
Catalog Details
Catalog Item ID: | 5464 |
---|---|
GUID: | gov.noaa.nmfs.inport:5464 |
Metadata Record Created By: | Lee M Weinberger |
Metadata Record Created: | 2007-10-16 09: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 |