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

Summary

Abstract

Lookup Table used to recode waterbody codes. Records are unique on the basis of fields alsstate, old water, begin date, end date, and region.

Description

Lookup Table used to recode 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
DESCRIPTION
VARCHAR2
Description Of Waterbody Code
BEGIN_DATE
DATE
Beginning Date WHere this transformation Is to be done
END_DATE
DATE
Ending Date where this transformation Is to be done. If transformation is still current it is null.
NEW_DESCRIPTION
VARCHAR2
Descition Of New Waterbody Code
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_OLD_NEW_XREF
Short Name: ALS_WATERBODY_OLD_NEW_XREF
Status: Completed
Abstract:

Lookup Table used to recode waterbody codes. Records are unique on the basis of fields alsstate, old water, begin date, end date, and region.

Purpose:

To provide a history of code updates and to serve as a lookup table to the ALS (General Canvass) tables.

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:

Lookup Table used to recode 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
DESCRIPTION VARCHAR2 Description Of Waterbody Code
100
BEGIN_DATE DATE Beginning Date WHere this transformation Is to be done
100
END_DATE DATE Ending Date where this transformation Is to be done. If transformation is still current it is null.
100
NEW_DESCRIPTION VARCHAR2 Descition Of New Waterbody Code
100
REGION VARCHAR2 Region Code

Attribute Details

ALSSTATE

CC ID: 17395
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: 17394
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: 17393
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

DESCRIPTION

CC ID: 17392
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Description Of Waterbody Code

General Data Type: VARCHAR2

BEGIN_DATE

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

END_DATE

CC ID: 17390
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Ending Date where this transformation Is to be done. If transformation is still current it is null.

General Data Type: DATE

NEW_DESCRIPTION

CC ID: 17389
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Descition Of New Waterbody Code

General Data Type: VARCHAR2

REGION

CC ID: 17388
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: Unclassified
Security Classification System:

Password Restricted

Security Handling Description:

Password Restricted

Data Access Policy:

Password Restricted

Data Access Procedure:

Password Restricted. Request from data steward or designee.

Data Access Constraints:

Password Restricted

Data Use Constraints:

None

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: 5463
GUID: gov.noaa.nmfs.inport:5463
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