5463
Table: ALS_WATERBODY_OLD_NEW_XREF
ALS_WATERBODY_OLD_NEW_XREF
Entity
Published / External
5455
Reference Tables Used In Waterbody Project
Data Set
Completed
Lookup Table used to recode waterbody codes. Records are unique on the basis of fields alsstate, old water, begin date, end date, and region.
To provide a history of code updates and to serve as a lookup table to the ALS (General Canvass) tables.
Loaded by batch 1727, 10-16-2007 09:13
Theme
water body
Southeast Fisheries Science Center
Miami
FL
USA
75 Virginia Beach Drive
Miami, FL 33149
Data Table
Yes
ALS
Lookup Table used to recode waterbody codes.
1
ALSSTATE
VARCHAR2
2
No
No
Active
NMFS State Code
VARCHAR2
2
OLD_WATER
VARCHAR2
4
No
No
Active
Old/Historical Water Body Code
VARCHAR2
3
NEW_WATER
VARCHAR2
4
No
No
Active
New/replacementl Water Body Code
VARCHAR2
4
DESCRIPTION
VARCHAR2
60
No
No
Active
Description Of Waterbody Code
VARCHAR2
5
BEGIN_DATE
DATE
7
No
No
Active
Beginning Date WHere this transformation Is to be done
DATE
6
END_DATE
DATE
7
No
No
Active
Ending Date where this transformation Is to be done. If transformation is still current it is null.
DATE
7
NEW_DESCRIPTION
VARCHAR2
60
No
No
Active
Descition Of New Waterbody Code
VARCHAR2
8
REGION
VARCHAR2
1
No
No
Active
Region Code
VARCHAR2
Unclassified
Password Restricted
Password Restricted
Password Restricted
Password Restricted. Request from data steward or designee.
Password Restricted
None
Non-published Metadata access is restricted. Published Metadata is available to the public.
Use only Published Metadata.
gov.noaa.nmfs.inport:5463
Lee Weinberger
2007-10-16T09:13:51
SysAdmin InPortAdmin
2022-08-09T17:11:00
2021-05-06
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-05-06
1 Year
2022-05-06