Slide Menu
InPort Release 5.2.0 Downtime: Thursday, May 19 @ 2:00pm - 3:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.2.0. Downtime Schedule Thursday, May 19, 2022 1:00pm - 2:30pm Eastern / 10:00am - 11:30am Pacific / 7:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inpor...
View All
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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SOURCE_ID NUMBER 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 BIORES table; and SOURCE_ID and ESI_Source in the ESI and HYDRO data layers. | 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
PUBLICATION VARCHAR Additional citation information. | Description Source: NOAA ESI Guidelines
100
ONLINE_LINK VARCHAR URL to the data if internet-available or to the website of the data provider | 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: 807531
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 7
Min Length: 7
Required: Yes
Primary Key: Yes
Status: Active
Description:

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 BIORES table; and SOURCE_ID and ESI_Source in the ESI and HYDRO data layers. | Description Source: NOAA ESI Guidelines

Allowed Values: 8000002-8000611

ORIGINATOR

CC ID: 807526
Seq. Order: 2
Data Storage Type: VARCHAR
Max Length: 255
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: 807524
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: YYYY, or YYYYMM, or YYYYMMDD, where Y=year, M=month, D=day

TITLE

CC ID: 807533
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: 807523
Seq. Order: 5
Data Storage Type: VARCHAR
Max Length: 80
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: 807529
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: 807528
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.

PUBLICATION

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

Additional citation information. | Description Source: NOAA ESI Guidelines

Allowed Values: Acceptable values change from atlas to atlas.

ONLINE_LINK

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

URL to the data if internet-available or to the website of the data provider | Description Source: NOAA ESI Guidelines

Allowed Values: URL. Must be copied as is from the address bar & must be fully qualified (begin with http://) & contain no “<” or “>” characters

SCALE

CC ID: 807530
Seq. Order: 10
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: Values may be numeric, such as 1:24000, or text, such as UNKNOWN (non-digital data only), or VARIES

TIME_PERIOD

CC ID: 807532
Seq. Order: 11
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: Date fields must be YYYY, or YYYYMM, or YYYYMMDD. If date is not known or if the day is not of consequence, then it should be YYYYMM. The same is true if month is not known or is not of consequence, you would use YYYY. The beginning and ending date range is separated by a dash (-)

Catalog Details

Catalog Item ID: 55189
GUID: gov.noaa.nmfs.inport:55189
Metadata Record Created By: Jill Petersen
Metadata Record Created: 2018-12-11 14:28+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2019-03-08
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-03-08