Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07