Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Linkages Station Data table

Description

Linkages Station Data table

Entity Information

Entity Type
Data File

Data Attribute / Type Description
key
VARCHAR
concatenation of Cruise code and Standard Station number
cr
VARCHAR
2 char each for ship, year and consecutive cruise number (for the year)
consta
INTEGER
consecutive station number for a given cruise
stdsta
INTEGER
standard,or fixed, station number
date
DATE
sample date, format mm/dd/yyyy
mon
INTEGER
number of month (1 to 12) of sampling
year
INTEGER
year of sampling, 4-digit
sur
INTEGER
consecutive survey number

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: LnkSta
Short Name: LnkSta
Status: Completed
Abstract:

Linkages Station Data table

Entity Information

Entity Type: Data File
Active Version?: Yes
Description:

Linkages Station Data table

Data Attributes

Note: Metadata requirements do not apply to attributes for non-tabular entities.

Attribute Summary

Rubric Score Primary Key? Name Type Description
N/A
Primary Key key VARCHAR concatenation of Cruise code and Standard Station number
N/A
cr VARCHAR 2 char each for ship, year and consecutive cruise number (for the year)
N/A
consta INTEGER consecutive station number for a given cruise
N/A
stdsta INTEGER standard,or fixed, station number
N/A
date DATE sample date, format mm/dd/yyyy
N/A
mon INTEGER number of month (1 to 12) of sampling
N/A
year INTEGER year of sampling, 4-digit
N/A
sur INTEGER consecutive survey number

Attribute Details

key

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

concatenation of Cruise code and Standard Station number

General Data Type: VARCHAR

cr

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

2 char each for ship, year and consecutive cruise number (for the year)

General Data Type: VARCHAR

consta

CC ID: 372222
Seq. Order: 3
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

consecutive station number for a given cruise

General Data Type: INTEGER

stdsta

CC ID: 372223
Seq. Order: 4
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

standard,or fixed, station number

General Data Type: INTEGER

date

CC ID: 372224
Seq. Order: 5
Data Storage Type: DATE
Max Length: 8
Required: Yes
Primary Key: No
Status: Active
Description:

sample date, format mm/dd/yyyy

General Data Type: DATE

mon

CC ID: 372225
Seq. Order: 6
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

number of month (1 to 12) of sampling

General Data Type: INTEGER

year

CC ID: 372226
Seq. Order: 7
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

year of sampling, 4-digit

General Data Type: INTEGER

sur

CC ID: 372227
Seq. Order: 8
Data Storage Type: INTEGER
Max Length: 2
Required: Yes
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

consecutive survey number

General Data Type: INTEGER

Catalog Details

Catalog Item ID: 36202
GUID: gov.noaa.nmfs.inport:36202
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2017-01-04 11:40+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-02-15
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-02-15
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-02-15