Table: ALS_WATERBODY_VALID_ERRORS

Southeast Fisheries Science Center
Entity (ENT) | ID: 5464 | Published / External
Created: 2007-10-16   |   Last Modified: 2022-08-09

Parent: Reference Tables Used In Waterbody Project
Data Set (DS) | ID: 5455

ID: 5464
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: ALS_WATERBODY_VALID_ERRORS
Short Name ALS_WATERBODY_VALID_ERRORS
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

Table that holds errors as a result of project to redo waterbody codes.
* Purpose
Notes

Loaded by batch 1727, 10-16-2007 09:13
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
None water body
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

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? Y
Alias  
Schema Name ALS
» Description

Table that holds errors as a result of project to redo waterbody codes.
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 No No ALSSTATE VARCHAR2 NMFS State Code
100 No No OLD_WATER VARCHAR2 Old/Historical Water Body Code
100 No No NEW_WATER VARCHAR2 New/replacementl Water Body Code
100 No No BEGIN_DATE DATE Beginning Date WHere this transformation Is to be done
100 No No END_DATE DATE Beginning Date WHere this transformation Is to be done
100 No No ERROR_TYPE VARCHAR2 Can be either "Error" or "Warn"
100 No No ERROR_MESSAGE VARCHAR2 Error message
100 No No REGION VARCHAR2 Region Code

Attribute Details

Attribute Name ALSSTATE
Seq. Order 1
Data Storage Type VARCHAR2
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

NMFS State Code
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name OLD_WATER
Seq. Order 2
Data Storage Type VARCHAR2
Max Length 4
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Old/Historical Water Body Code
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NEW_WATER
Seq. Order 3
Data Storage Type VARCHAR2
Max Length 4
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

New/replacementl Water Body Code
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BEGIN_DATE
Seq. Order 4
Data Storage Type DATE
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Beginning Date WHere this transformation Is to be done
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name END_DATE
Seq. Order 5
Data Storage Type DATE
Max Length 7
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Beginning Date WHere this transformation Is to be done
General Data Type DATE
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ERROR_TYPE
Seq. Order 6
Data Storage Type VARCHAR2
Max Length 5
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Can be either "Error" or "Warn"
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ERROR_MESSAGE
Seq. Order 7
Data Storage Type VARCHAR2
Max Length 55
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Error message
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name REGION
Seq. Order 8
Data Storage Type VARCHAR2
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Region Code
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

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.

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 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 Workflow State Published / External
Metadata Last Review Date 2021-05-06
Metadata Review Frequency 1 Year
Metadata Next Review Date 2022-05-06
Tags