Table: ALS_WATERBODY_OLD_NEW_XREF
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5463 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Lookup Table used to recode waterbody codes. Records are unique on the basis of fields alsstate, old water, begin date, end date, and region.
DescriptionLookup 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
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
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
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
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
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
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
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
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
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 |