Slide Menu
Search Help Show/Hide Menu

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: 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