Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: SOURCES
Status: Completed
Abstract:

The data table SOURCES contains the primary sources used to create the ESI data set. See the Browse_Graphic section for a link to the entity-relationship diagram, which describes the way this table relates to other attribute tables in the ESI data structure. | Description Source: NOAA ESI Guidelines

Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SOURCE_ID NUMBER An 8-digit Source identifier that links records in the SOURCES data table to the items G_SOURCE and A_SOURCE in the SOC_DAT table; G_SOURCE and S_SOURCE in the BIOFILE table; SOURCE_ID and ESI_SOURCE in the ESIP and ESIL data layers, and SOURCE_ID in the HYDROL data layer. | Description Source: NOAA ESI Guidelines
100
ORIGINATOR VARCHAR Author or developer of source material or data set. | Description Source: NOAA ESI Guidelines
100
DATE_PUB NUMBER Date of source material, publication, or date of personal communication with expert source. | Description Source: NOAA ESI Guidelines
100
TITLE VARCHAR Title of source material or data. | Description Source: NOAA ESI Guidelines
100
DATA_FORMAT VARCHAR The format of the source material. | Description Source: NOAA ESI Guidelines
100
PUB_PLACE VARCHAR Publication place. | Description Source: NOAA ESI Guidelines
100
PUBLISHER VARCHAR Publisher. | Description Source: NOAA ESI Guidelines
100
ONLINE_LINK VARCHAR Online computer resource URL. | Description Source: NOAA ESI Guidelines
100
SCALE VARCHAR Description of the source scale. | Description Source: NOAA ESI Guidelines
100
TIME_PERIOD VARCHAR Date(s) of data collection that the source material is based upon. | Description Source: NOAA ESI Guidelines

Attribute Details

SOURCE_ID

CC ID: 796319
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 8
Min Length: 8
Required: Yes
Primary Key: Yes
Status: Active
Description:

An 8-digit Source identifier that links records in the SOURCES data table to the items G_SOURCE and A_SOURCE in the SOC_DAT table; G_SOURCE and S_SOURCE in the BIOFILE table; SOURCE_ID and ESI_SOURCE in the ESIP and ESIL data layers, and SOURCE_ID in the HYDROL data layer. | Description Source: NOAA ESI Guidelines

Allowed Values: 33500001 - 33500479

ORIGINATOR

CC ID: 796315
Seq. Order: 2
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Author or developer of source material or data set. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

DATE_PUB

CC ID: 796313
Seq. Order: 3
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Date of source material, publication, or date of personal communication with expert source. | Description Source: NOAA ESI Guidelines

Allowed Values: YYYYMM: YYYY for year and optionally MM for month |

TITLE

CC ID: 796321
Seq. Order: 4
Data Storage Type: VARCHAR
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Title of source material or data. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

DATA_FORMAT

CC ID: 796312
Seq. Order: 5
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

The format of the source material. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

PUB_PLACE

CC ID: 796317
Seq. Order: 6
Data Storage Type: VARCHAR
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Publication place. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

PUBLISHER

CC ID: 796316
Seq. Order: 7
Data Storage Type: VARCHAR
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Publisher. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

ONLINE_LINK

CC ID: 796314
Seq. Order: 8
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Online computer resource URL. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

SCALE

CC ID: 796318
Seq. Order: 9
Data Storage Type: VARCHAR
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Description of the source scale. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

TIME_PERIOD

CC ID: 796320
Seq. Order: 10
Data Storage Type: VARCHAR
Max Length: 34
Required: No
Primary Key: No
Status: Active
Description:

Date(s) of data collection that the source material is based upon. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

Catalog Details

Catalog Item ID: 54626
GUID: gov.noaa.nmfs.inport:54626
Metadata Record Created By: Jill Petersen
Metadata Record Created: 2018-11-02 14:25+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-11-13
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-11-13
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-11-13