Search Help Show/Hide Menu
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Access Info
Catalog Details

Summary

Abstract

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

Description

Table 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

Rubric Score Primary Key? 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

CC ID: 17403
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

CC ID: 17402
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

CC ID: 17401
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

CC ID: 17400
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

CC ID: 17399
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

CC ID: 17398
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

CC ID: 17397
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

CC ID: 17396
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