26731
Northeast Electronic Reporting System (NERS)
Northeast Electronic Reporting System (NERS)
Data Set
Published / External
23136
Northeast Cooperative Research Program (NCRP)
Project
Completed
The NOAA/NEFSC Study fleets are a subset of fishing vessels from which high quality, self-reported data on fishing effort, area fished, gear characteristics, catch, and biological observations are collected. Participating vessels collect data within their permitted fisheries using normal commercial fishing operations, and are selected to address specific research topics. Vessels collect data via electronic logbook (ELB) and submit the data to NMFS (refer to VERS system for details). The data collected by the vessel operators serve as the basis for ancillary data which are collected by Study Fleet staff and are usually associated with one or more targeted research objectives. The data collected from these vessels can be used to supplement the stock assessment process and are especially useful when catch data are limited.
The NEFSC Study Fleet program was initiated to assemble groups of commercial New England vessels capable of providing high resolution (temporal and spatial) self-reported data on catch, effort and environmental conditions while conducting "normal" fishing operations. The ultimate goals are for scientific researchers to:
Provide additional data sources to the stock assessment process
Gain a better understanding of fishing operation in the region
Improve the accuracy and precision of fishery dependent data
Examine the catch estimation error associated with fishery dependent data
Collect biological samples based on specific special/temporal needs
Collect oceanographic data (temperature depth) during fishing activities
The NEFSC Study Fleet Program is a Cooperative Research program. Cooperative Research is designed to bring stakeholders together in a spirit of mutual participation, enabling an environment of shared knowledge and collaborative management strategies. As such, the Study Fleet program provides several benefits to its commercial participants including:
Participate directly in the scientific data collection process
Documentation of fishery and anecdotal knowledge inaccessible to researchers
Sharing of ideas and observations among fisheries scientists and commercial fishermen
Gain insight into how environmental factors influence catch rates
Financial compensation for time and effort involved
Theme
Cooperative Research
Theme
area fished
Theme
biological observations
Theme
catch
Theme
eVTR
Theme
fishing effort
Theme
gear characteristics
Theme
self-reported data
Theme
study fleet
Theme
temperature depth
Spatial
Mid-Atlantic
Spatial
New England
NEFSC Woods Hole Lab
Woods Hole
MA
USA
Data Set
Oracle Database
Continually
Table (digital)
archival data loggers, global positioning system, electronic logbook software, data entry via webpage, or data transcribed from paper to spreadsheet then uploaded
commercial fishing vessels
commercial fishing vessels
34567
Table: GPS_LOAD_HISTORY
GPS_LOAD_HISTORY
Published / External
Completed
Contains a single entry for each FLDRS generated GPS Polling file uploaded, serves as a means to track GPS upload status
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Contains a single entry for each FLDRS generated GPS Polling file uploaded, serves as a means to track GPS upload status
1
GPD_TRIP_ID
NUMBER
22
Yes
Yes
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
GLM_LOAD_METHOD
NUMBER
22
Yes
No
2
0
Active
GPS Database Load Method; supporting table GPS_LOAD_METHOD
NUMBER
3
ORIGINAL_RECORDS
NUMBER
22
Yes
No
7
0
Active
Number of records in raw file
NUMBER
4
LOADED_RECORDS
NUMBER
22
Yes
No
7
0
Active
Number of records loaded to database
NUMBER
5
GPS_LOAD_DATE
DATE
7
No
No
Active
Date data uploaded
DATE
6
COMMENTS
VARCHAR2
255
No
No
Active
Additonal Comments
VARCHAR2
34568
Table: GPS_LOAD_METHOD
GPS_LOAD_METHOD
Published / External
Completed
Table to track method used to load FLDRS generated GPS polling files
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Table to track method used to load FLDRS generated GPS polling files
1
LOAD_METHOD
NUMBER
22
Yes
Yes
2
0
Active
Unique GPS polling file load method identifier
NUMBER
2
LOAD_METHOD_DESC
VARCHAR2
60
Yes
No
Active
Descripiton of the method used to load the GPS polling file
VARCHAR2
34569
Table: GPS_POLL_DATA
GPS_POLL_DATA
Published / External
Completed
Data recorded from GPS receiver during each trip conducted using FLDRS
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Data recorded from GPS receiver during each trip conducted using FLDRS
1
TRIP_ID
NUMBER
22
Yes
Yes
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
DATETIME_GMT
DATE
7
Yes
Yes
Active
Date and time in Greenwich Mean Time
DATE
3
LATITUDE
NUMBER
22
Yes
No
12
6
Active
Latitude in decimal degrees
NUMBER
4
LONGITUDE
NUMBER
22
Yes
No
12
6
Active
Longitude in decimal degrees
NUMBER
5
SPEED_KNOTS
NUMBER
22
No
No
6
2
Active
Speed in knots
NUMBER
6
COURSE_TRUE
NUMBER
22
No
No
6
2
Active
Course direction
NUMBER
7
FIX
NUMBER
22
No
No
2
0
Active
Availablility of satellite fix; yes=1 no=0
NUMBER
8
SAT_AVAIL
NUMBER
22
No
No
2
0
Active
Number of satellites
NUMBER
9
BOT_DEPTH_M
NUMBER
22
No
No
6
1
Active
Bottom depth in meters
NUMBER
10
EVENT_TYPE
VARCHAR2
50
No
No
Active
Event type indicating effort number and start of haul or end of set or haul
VARCHAR2
34570
Table: GTE_CODES
GTE_CODES
Published / External
Completed
Description of all the codes used in the GTE data editing process.
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Description of all the codes used in the GTE data editing process.
1
GTE_CODE
VARCHAR2
5
Yes
Yes
Active
A unqiue identifier of a data quality issue.
VARCHAR2
2
GTE_CODE_LEVEL
VARCHAR2
2
Yes
No
Active
A code that signifies the severity of data issue/error encountered; fatal=F informative=I
VARCHAR2
3
GTE_CODE_DESCR
VARCHAR2
255
Yes
No
Active
A description of each code used in the data editing process.
VARCHAR2
34571
Table: GTE_EDITING_LIST
GTE_EDITING_LIST
Published / External
Completed
Communicates effort editing issues among users of the SF GTE application
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Communicates effort editing issues among users of the SF GTE application
1
TRIP_ID
NUMBER
22
Yes
No
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
EFFORT_NUM
VARCHAR2
3
No
No
Active
Unique identifier representing an effort documented in a trip
VARCHAR2
3
EFFORT_STATUS
VARCHAR2
2
Yes
No
Active
Event codes used to track effort status in edtiing process
VARCHAR2
4
DATA_ISSUE
VARCHAR2
255
Yes
No
Active
Data quality issue(s) that exist for a specific effort
VARCHAR2
5
DATA_ACTION
VARCHAR2
255
No
No
Active
Action needed/taken to resolve the issue
VARCHAR2
6
RESOLVED
NUMBER
22
Yes
No
1
0
Active
Denotes whether or not the documented issue has been resolved; Yes=1 No=0
NUMBER
7
USER_ISSUE
VARCHAR2
15
Yes
No
Active
The ID of the user who documented the issue; supporting table NERS.SF_USERS
VARCHAR2
8
USER_ACTION
VARCHAR2
15
No
No
Active
The ID of the USER who recognized/resolved issue; supporting table NERS.SF_USERS
VARCHAR2
34572
Table: GTE_EFFORTS
GTE_EFFORTS
Published / External
Completed
Summary statistics for each complete effort contained in NERS.GTE_JOIN
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Summary statistics for each complete effort contained in NERS.GTE_JOIN
1
TRIP_ID
NUMBER
22
Yes
Yes
38
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
EFFORT_NUM
VARCHAR2
4
Yes
Yes
Active
Unique identifier representing an effort documented in a trip
VARCHAR2
3
TOTAL_NUM_RECORDS
NUMBER
22
No
No
4
0
Active
Total number of records for an effort
NUMBER
4
PERCENT_RECORDS_MATCH
NUMBER
22
No
No
3
0
Active
Percentage of the total number of records where there is a valid TD-GPS match
NUMBER
5
START_HAUL_DATE_GMT
DATE
7
No
No
Active
Date and time in Greenwich Mean Time of the start of the effort based data corrected in GTE processing
DATE
6
END_HAUL_DATE_GMT
DATE
7
No
No
Active
Date and time in Greenwich Mean Time of the end of the effort based data corrected in GTE processing
DATE
7
CALC_DUR_HR
NUMBER
22
No
No
4
2
Active
Duration of the effort in hours
NUMBER
8
CALC_DIST_NM
NUMBER
22
No
No
5
2
Active
Total distance towed in nautical miles
NUMBER
9
MIN_TEMP_C
NUMBER
22
No
No
4
2
Active
Min temperature in Celsius
NUMBER
10
MEAN_TEMP_C
NUMBER
22
No
No
4
2
Active
Mean temperature in Celsius
NUMBER
11
MAX_TEMP_C
NUMBER
22
No
No
4
2
Active
Max temperature in Celsius
NUMBER
12
TEMP_VARIANCE
NUMBER
22
No
No
4
2
Active
Temperature variance value
NUMBER
13
TEMP_DEVIATION
NUMBER
22
No
No
4
2
Active
Standard deviation of temperature
NUMBER
14
MIN_DPTH_M
NUMBER
22
No
No
5
2
Active
Min depth in meters
NUMBER
15
MEAN_DPTH_M
NUMBER
22
No
No
5
2
Active
Mean depth in meters
NUMBER
16
MAX_DPTH_M
NUMBER
22
No
No
5
2
Active
Max depth in meters
NUMBER
17
DPTH_VARIANCE
NUMBER
22
No
No
6
2
Active
Depth variance value
NUMBER
18
DPTH_DEVIATION
NUMBER
22
No
No
5
2
Active
Standard deviation of depth
NUMBER
19
MIN_SPD_NMPH
NUMBER
22
No
No
4
2
Active
Min vessel speed in nautical miles per hour
NUMBER
20
MEAN_SPD_NMPH
NUMBER
22
No
No
4
2
Active
Mean vessel speed in nautical miles per hour
NUMBER
21
MAX_SPD_NMPH
NUMBER
22
No
No
4
2
Active
Max vessel speed in nautical miles per hour
NUMBER
22
SPD_VARIANCE
NUMBER
22
No
No
4
2
Active
Speed variance value
NUMBER
23
SPD_DEVIATION
NUMBER
22
No
No
4
2
Active
Standard deviation of speed
NUMBER
24
GTE_CODE
VARCHAR2
30
No
No
Active
GTE codes for the effort; supporting table NERS.GTE_CODES
VARCHAR2
25
GEAR_CODE
VARCHAR2
6
No
No
Active
ACCSP Gear type code; supporting table FVTR.FVTR_GEAR_CODES
VARCHAR2
34573
Table: GTE_JOIN
GTE_JOIN
Published / External
Completed
Data from sucessfully joined and edited efforts
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Data from sucessfully joined and edited efforts
1
TRIP_ID
NUMBER
22
Yes
No
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
VP_NUM
NUMBER
22
No
No
38
Active
Federal vessel permit number
NUMBER
3
PROBE_LOG_ID
NUMBER
22
Yes
Yes
38
Active
Deployment identification number for TD logger used; supporting table NERS.SF_EQUIP_LOG
NUMBER
4
EFFORT_NUM
VARCHAR2
4
Yes
No
Active
Unique identifier representing an effort documented in a trip based data corrected in GTE processing
VARCHAR2
5
TD_DATETIME
DATE
7
Yes
Yes
Active
Date and time in Greenwich Mean Time from a single TD probe reading
DATE
6
TEMP
NUMBER
22
No
No
38
Active
Temperature (Celisus) from a single TD probe reading
NUMBER
7
GEAR_DEPTH
NUMBER
22
No
No
38
Active
Gear depth (meters) from a single TD probe reading
NUMBER
8
GPS_DATETIME
DATE
7
No
No
Active
Date and time in Greenwich Mean Time from a single GPS reading
DATE
9
LATITUDE
NUMBER
22
No
No
12
6
Active
Latitude value from a single GPS reading
NUMBER
10
LONGITUDE
NUMBER
22
No
No
12
6
Active
Longitude value from a single GPS reading
NUMBER
11
COURSE_TRUE
NUMBER
22
No
No
6
2
Active
Heading (degrees) from a single GPS reading
NUMBER
12
BOT_DEPTH_M
NUMBER
22
No
No
6
1
Active
Depth sounder reading (meters)
NUMBER
13
TOW_EVENT_CODE
VARCHAR2
30
No
No
Active
Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES
VARCHAR2
34574
Table: GTE_JOIN_AUDIT
GTE_JOIN_AUDIT
Published / External
Completed
Output from the GTE join procedure. Data quality analysis then performed on data through the GTE GUI
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Output from the GTE join procedure. Data quality analysis then performed on data through the GTE GUI
1
TRIP_ID
NUMBER
22
Yes
No
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
VP_NUM
NUMBER
22
No
No
38
Active
Federal vessel permit number
NUMBER
3
PROBE_LOG_ID
NUMBER
22
No
No
38
Active
Deployment identification number for TD logger used; supporting table NERS.SF_EQUIP_LOG
NUMBER
4
EFFORT_NUM
VARCHAR2
4
No
No
Active
Unique identifier representing an effort documented in a trip
VARCHAR2
5
EFFORT_NUM_CORRECTION
VARCHAR2
4
No
No
Active
Documents the adjusted start and end times for an effort
VARCHAR2
6
TD_DATETIME
DATE
7
Yes
No
Active
Date and time in Greenwich Mean Time from a single TD probe reading
DATE
7
TEMP
NUMBER
22
No
No
38
Active
Temperature (Celisus) from a single TD probe reading
NUMBER
8
GEAR_DEPTH
NUMBER
22
No
No
38
Active
Gear depth (meters) from a single TD probe reading
NUMBER
9
GPS_DATETIME
DATE
7
No
No
Active
Date and time in Greenwich Mean Time from a single GPS reading
DATE
10
LATITUDE
NUMBER
22
No
No
12
6
Active
Latitude value from a single GPS reading
NUMBER
11
LONGITUDE
NUMBER
22
No
No
12
6
Active
Longitude value from a single GPS reading
NUMBER
12
SPEED_KNOTS
NUMBER
22
No
No
6
2
Active
Speed of the vessel from a single GPS reading
NUMBER
13
COURSE_TRUE
NUMBER
22
No
No
6
2
Active
Heading (degrees) from a single GPS reading
NUMBER
14
BOT_DEPTH_M
NUMBER
22
No
No
6
1
Active
Depth sounder reading (meters)
NUMBER
15
RATE_OF_CHANGE
NUMBER
22
No
No
6
2
Active
Calculates rate of changes in gear depth to identify the possible start or end of an effort
NUMBER
16
LEAD_RATE
NUMBER
22
No
No
6
2
Active
Calculates rate of changes in gear depth to identify the possible start or end of an effort
NUMBER
17
RN
NUMBER
22
No
No
38
Active
A SQL generated row number for the joined data
NUMBER
18
EFFORT_TYPE
VARCHAR2
10
No
No
Active
Identifies possible start or end effort events based on the values in the RATE_OF_CHANGE and LEAD_RATE columns
VARCHAR2
19
TOW_EVENT_CODE
VARCHAR2
30
No
No
Active
Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES
VARCHAR2
34575
Table: GTE_LOAD_HISTORY
GTE_LOAD_HISTORY
Published / External
Completed
Tracks a trip/effort through the data editing process, providing data quality information at each step
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Tracks a trip/effort through the data editing process, providing data quality information at each step
1
TRIP_ID
NUMBER
22
Yes
Yes
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
EFFORT_NUM
VARCHAR2
4
Yes
Yes
Active
Unique identifier representing an effort documented in a trip
VARCHAR2
3
POPULATE_TABLE_CODE
VARCHAR2
15
Yes
No
Active
Code identifying results from GTE join procedure; supporting table NERS.GTE_CODES
VARCHAR2
NERS.GTE_CODES
4
POPULATE_TABLE_DATE
DATE
7
Yes
No
Active
Date the GTE join procedure was run
DATE
5
POPULATE_TABLE_USER
VARCHAR2
20
Yes
No
Active
Staff member that ran the GTE join procedure; supporting table NERS.SF_USERS
VARCHAR2
6
EFFORT_CORR_CODE
VARCHAR2
30
No
No
Active
Code(s) used to describe data quality issues; supporting table NERS.GTE_CODES
VARCHAR2
7
EFFORT_CORR_DATE
DATE
7
No
No
Active
Date of latest change to record.
DATE
8
EFFORT_CORR_USER
VARCHAR2
20
No
No
Active
Staff member that performed the editing; supporting table NERS.SF_USERS
VARCHAR2
9
USE_CODE
VARCHAR2
3
No
No
Active
Code used to describe the appropriate analytical usage based on the quality of the data; supporting table NERS.GTE_CODES
VARCHAR2
NERS.GTE_CODES
10
DATA_MOVED
VARCHAR2
1
Yes
No
Active
A yes (Y) or no (N) field stating whether or not editing was completed and data moved to the final NERS.GTE_JOIN table
VARCHAR2
11
MOVE_DATE
DATE
7
No
No
Active
Date the finalized data was moved
DATE
12
MOVE_USER
VARCHAR2
20
No
No
Active
Staff member that moved the data; supporting table NERS.SF_USERS
VARCHAR2
13
COMMENTS
VARCHAR2
255
No
No
Active
Additional information
VARCHAR2
14
EFFORT_SUMMARY
VARCHAR2
1
Yes
No
Active
States whether or not summary statistics were generated for the effort in NERS.GTE_EFFORTS; Yes (Y) or no (N)
VARCHAR2
15
SUMMARY_DATE
DATE
7
No
No
Active
Date the effort summary procedure was performed
DATE
16
SUMMARY_USER
VARCHAR2
30
No
No
Active
Staff member that ran the effort summary procedure; supporting table NERS.SF_USERS
VARCHAR2
34576
Table: GTE_TRIPS
GTE_TRIPS
Published / External
Completed
Status of the trip in the editing process. It also provides a means to document any comments that pertain to the entire trip
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Status of the trip in the editing process. It also provides a means to document any comments that pertain to the entire trip
1
TRIP_ID
NUMBER
22
Yes
Yes
38
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
LOAD_STATUS
NUMBER
22
Yes
No
38
Active
Current status of the trip in the editing process; supporting table NERS.GTE_CODES
NUMBER
3
COMMENTS
VARCHAR2
255
No
No
Active
Trip level comments
VARCHAR2
34577
Table: SF_BIOSAMP_AGE_TYPES
SF_BIOSAMP_AGE_TYPES
Published / External
Completed
Types of samples used for aging
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Types of samples used for aging
1
AGE_SAMPLE_TYPE
VARCHAR2
3
Yes
Yes
Active
Unique age sample type identifier
VARCHAR2
2
AGE_SAMPLE_DESCR
VARCHAR2
250
Yes
No
Active
A description of the type of sample used for aging
VARCHAR2
34578
Table: SF_BIOSAMP_BIOSAMPLE
SF_BIOSAMP_BIOSAMPLE
Published / External
Completed
Biosample data
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Biosample data
1
TRIP_ID
NUMBER
22
Yes
Yes
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
EFFORT_NUM
VARCHAR2
5
Yes
No
Active
Trip effort Number where sample was collected
VARCHAR2
3
START_HAUL_DATE_GMT
DATE
7
Yes
No
Active
Start of haul date in Greenwich Mean Time
DATE
4
STAT_AREA_CODE
VARCHAR2
3
Yes
No
Active
Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS
VARCHAR2
5
FISH_ID
NUMBER
22
Yes
Yes
3
0
Active
Individual fish ID for sample
NUMBER
6
SPECIES_ITIS
VARCHAR2
11
Yes
No
Active
Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
VARCHAR2
7
MARKET_CODE
VARCHAR2
2
Yes
No
Active
ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
VARCHAR2
8
GRADE_CODE
VARCHAR2
2
Yes
No
Active
ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES
VARCHAR2
9
DISPOSITION_CODE
VARCHAR2
3
Yes
No
Active
ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
VARCHAR2
NERS.FVTR_DISPOSITIONS
10
LENGTH_TYPE
VARCHAR2
2
Yes
No
Active
Type of length collected; support table NERS.SF_BIOSAMP_LENGTH_TYPES
VARCHAR2
NERS.SF_BIOSAMP_LENGTH_TYPES
11
LENGTH_CM
NUMBER
22
No
No
6
1
Active
Length in centimeters
NUMBER
12
WEIGHT_TYPE
VARCHAR2
3
Yes
No
Active
Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES
VARCHAR2
NERS.SF_BIOSAMP_WEIGHT_TYPES
13
WEIGHT_KG
NUMBER
22
No
No
10
4
Active
Weight in kilograms
NUMBER
14
SEX_CODE
NUMBER
22
Yes
No
2
0
Active
Species sex type; support table NERS.SF_BIOSAMP_SEX_CODES
NUMBER
NERS.SF_BIOSAMP_SEX_CODES
15
MATURITY_CODE
VARCHAR2
1
Yes
No
Active
Reproductive maturity of species; support table NERS.SF_BIOSAMP_MATURITY_CODES
VARCHAR2
NERS.SF_BIOSAMP_MATURITY_CODES
16
AGE_SAMPLE_TYPE
VARCHAR2
3
Yes
No
Active
Type of age sample collected; support table NERS_BIOSAMP_AGE_TYPES
VARCHAR2
NERS.SF_BIOSAMP_AGE_TYPES
17
COMMENTS
VARCHAR2
250
No
No
Active
Additional information
VARCHAR2
18
RECORDER
VARCHAR2
20
Yes
No
Active
Staff member who collected sample
VARCHAR2
34579
Table: SF_BIOSAMP_BIOSAMPLE_AGE
SF_BIOSAMP_BIOSAMPLE_AGE
Published / External
Completed
Biosample age data
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Biosample age data
1
AGE_SAMPLE_ID
VARCHAR2
14
Yes
Yes
Active
Unique age sample identifier
VARCHAR2
2
TRIP_ID
NUMBER
22
Yes
Yes
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
NERS.SF_BIOSAMP_BIOSAMPLE
3
FISH_ID
NUMBER
22
Yes
No
3
0
Active
Unigue fish identifier per trip
NUMBER
NERS.SF_BIOSAMP_BIOSAMPLE
4
READER
VARCHAR2
20
No
No
Active
Staff member who determined age
VARCHAR2
5
AGE
NUMBER
22
No
No
3
0
Active
Determined age in years
NUMBER
6
ENTERED_BY
VARCHAR2
20
No
No
Active
Staff member who made the database entry
VARCHAR2
7
DATE_ENTERED
DATE
7
No
No
Active
Date data was entered
DATE
34580
Table: SF_BIOSAMP_BIOSAMPLE_EXT
SF_BIOSAMP_BIOSAMPLE_EXT
Published / External
Completed
Specialized data collected on biosamples
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Specialized data collected on biosamples
1
TRIP_ID
NUMBER
22
Yes
Yes
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
FISH_ID
NUMBER
22
Yes
Yes
3
0
Active
Unique fish identifier per trip
NUMBER
3
BIOSAMPLE_TYPE
VARCHAR2
3
Yes
Yes
Active
Type of biological sample collected; supporting table NERS.SF_BIOSAMP_BIOSAMP_TYPES
VARCHAR2
NERS.SF_BIOSAMP_BIOSAMPLE_TYPE
4
BIOSAMPLE_VALUE
VARCHAR2
30
Yes
No
Active
Sample value
VARCHAR2
5
BIOSAMPLE_ID
VARCHAR2
30
Yes
Yes
Active
Unique sample identifier
VARCHAR2
6
COMMENTS
VARCHAR2
250
No
No
Active
Additional information
VARCHAR2
34581
Table: SF_BIOSAMP_BIOSAMPLE_TYPES
SF_BIOSAMP_BIOSAMPLE_TYPES
Published / External
Completed
Details for biosample data types
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Details for biosample data types
1
BIOSAMPLE_TYPE
VARCHAR2
3
Yes
Yes
Active
Unique biosample type identifier
VARCHAR2
2
BIOSAMPLE_TYPE_DESCR
VARCHAR2
250
Yes
No
Active
Description of the type of biosample collected
VARCHAR2
3
BIOSAMPLE_DATA_FORMAT
VARCHAR2
10
Yes
No
Active
Oracle database data format
VARCHAR2
4
BIOSAMPLE_DATA_LENGTH
NUMBER
22
Yes
No
3
0
Active
Number of characters allowed during data entry
NUMBER
5
BIOSAMPLE_DATA_PRECISION
NUMBER
22
No
No
2
0
Active
Number of digits allowed after the decimal point
NUMBER
6
BIOSAMPLE_SAMPLE_ID_REQ
NUMBER
22
Yes
No
1
0
Active
Indicatition of whether a samle id is required yes=1 no=0
NUMBER
7
BIOSAMPLE_DATA_TYPE_REF
NUMBER
22
Yes
No
38
Active
Biosample data type, support table NERS.SF_BIOSAMP_DATA_TYPES
NUMBER
NERS.SF_BIOSAMP_DATA_TYPES
34582
Table: SF_BIOSAMP_CATCH_EST
SF_BIOSAMP_CATCH_EST
Published / External
Completed
Biosample data for Study Fleet catch estimation project
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Biosample data for Study Fleet catch estimation project
1
TRIP_ID
NUMBER
22
Yes
Yes
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
EFFORT_NUM
VARCHAR2
5
Yes
Yes
Active
Trip effort number where sample was collected
VARCHAR2
3
SPECIES_ITIS
VARCHAR2
11
Yes
Yes
Active
Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
VARCHAR2
4
GRADE_CODE
VARCHAR2
2
Yes
Yes
Active
ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES
VARCHAR2
5
MARKET_CODE
VARCHAR2
2
Yes
Yes
Active
ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
VARCHAR2
6
DISPOSITION_CODE
VARCHAR2
3
Yes
Yes
Active
ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
VARCHAR2
NERS.FVTR_DISPOSITIONS
7
UOM
VARCHAR2
2
Yes
Yes
Active
Unit of measurement; supporting table FVTR.FVTR_UNIT_OF_MEASURE
VARCHAR2
8
CATCH_AMOUNT
NUMBER
22
Yes
No
9
1
Active
Estimated catch amount
NUMBER
9
WEIGHT_TYPE_CODE
VARCHAR2
2
Yes
No
Active
Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES
VARCHAR2
NERS.SF_BIOSAMP_WEIGHT_TYPES
10
COMMENTS
VARCHAR2
250
No
No
Active
Additional information
VARCHAR2
11
RECORDER
VARCHAR2
20
Yes
No
Active
Technician who collected sample
VARCHAR2
12
START_HAUL_DATE_GMT
DATE
7
Yes
No
Active
Start of haul date in Greenwich Mean Time
DATE
34583
Table: SF_BIOSAMP_CATCH_TYPES
SF_BIOSAMP_CATCH_TYPES
Published / External
Completed
Allowed ways to which the catch can be retained for research
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Allowed ways to which the catch can be retained for research
1
CATCH_TYPE_CODE
NUMBER
22
Yes
Yes
38
Active
Unique catch type identifier
NUMBER
2
CATCH_TYPE_DESCR
VARCHAR2
255
Yes
No
Active
The allowed ways to which the catch can be retained for research
VARCHAR2
3
CATCH_TYPE_DESCR_SHORT
VARCHAR2
30
Yes
No
Active
Short description of the ways to which the catch can be retained for research
VARCHAR2
34584
Table: SF_BIOSAMP_DATA_TYPES
SF_BIOSAMP_DATA_TYPES
Published / External
Completed
Types of biosample data collected as part of the Study Fleet Program
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Types of biosample data collected as part of the Study Fleet Program
1
DATA_TYPE
NUMBER
22
Yes
Yes
38
Active
Unique biosample data type identifier
NUMBER
2
DATA_TYPE_DESCR
VARCHAR2
30
Yes
No
Active
Biosample data type collected
VARCHAR2
3
DESCR_SHORT
VARCHAR2
15
Yes
No
Active
Short description of data type
VARCHAR2
34585
Table: SF_BIOSAMP_LENGTH_FREQ
SF_BIOSAMP_LENGTH_FREQ
Published / External
Completed
Biosample length frequency data
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Biosample length frequency data
1
TRIP_ID
NUMBER
22
Yes
Yes
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
EFFORT_NUM
VARCHAR2
5
Yes
Yes
Active
Trip effort number where sample was collected
VARCHAR2
3
DISPOSITION_CODE
VARCHAR2
3
Yes
Yes
Active
ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
VARCHAR2
NERS.FVTR_DISPOSITIONS
4
SPECIES_ITIS
VARCHAR2
11
Yes
Yes
Active
Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
VARCHAR2
5
LENGTH_CM
NUMBER
22
Yes
Yes
6
1
Active
Length in centimeters
NUMBER
6
COUNT
NUMBER
22
Yes
No
38
Active
Number of individuals at length
NUMBER
7
LENGTH_TYPE
VARCHAR2
2
Yes
No
Active
Type of length measurement used; supporting table NERS.SF_BIOSAMP_LENGHT_TYPES
VARCHAR2
NERS.SF_BIOSAMP_LENGTH_TYPES
8
RECORDER
VARCHAR2
20
Yes
No
Active
Staff member who collected sample
VARCHAR2
9
STAT_AREA
VARCHAR2
3
Yes
No
Active
Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS
VARCHAR2
10
START_HAUL_DATE_GMT
DATE
7
Yes
No
Active
Start haul date in Greenwich Mean Time
DATE
11
SEX_CODE
NUMBER
22
Yes
Yes
38
Active
Species sex type; support table NERS.SF_BIOSAMP_SEX_CODES
NUMBER
NERS.SF_BIOSAMP_SEX_CODES
12
COMMENTS
VARCHAR2
250
No
No
Active
Additional information
VARCHAR2
34586
Table: SF_BIOSAMP_LENGTH_TYPES
SF_BIOSAMP_LENGTH_TYPES
Published / External
Completed
Types of length measurments used in data collection
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Types of length measurments used in data collection
1
LENGTH_TYPE
VARCHAR2
2
Yes
Yes
Active
Unique length type identifier
VARCHAR2
2
LENGTH_TYPE_DESCR
VARCHAR2
250
Yes
No
Active
Type of length measurement used
VARCHAR2
34587
Table: SF_BIOSAMP_LENWGT_CONV
SF_BIOSAMP_LENWGT_CONV
Published / External
Completed
Biosample length weight conversion data
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Biosample length weight conversion data
1
TRIP_ID
NUMBER
22
Yes
Yes
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
EFFORT_NUM
VARCHAR2
5
Yes
No
Active
Trip effort number where sample was collected
VARCHAR2
3
STAT_AREA
VARCHAR2
3
Yes
No
Active
Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS
VARCHAR2
4
FISH_ID
NUMBER
22
Yes
Yes
3
0
Active
Unigue fish identifier per trip
NUMBER
5
SPECIES_ITIS
VARCHAR2
11
Yes
No
Active
Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
VARCHAR2
6
DISPOSITION_CODE
VARCHAR2
3
Yes
No
Active
ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
VARCHAR2
NERS.FVTR_DISPOSITIONS
7
GRADE_CODE_1
VARCHAR2
2
Yes
No
Active
Initial ACCSP grade code description of fish products cut or part; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES
VARCHAR2
8
MARKET_CODE_1
VARCHAR2
2
Yes
No
Active
Initial ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
VARCHAR2
9
LENGTH_CM_1
NUMBER
22
No
No
6
1
Active
Initial length of sample in centimeters
NUMBER
10
LENGTH_TYPE_1
VARCHAR2
2
No
No
Active
Initial length measurement type; support table NERS.SF_BIOSAMP_LENGTH_TYPES
VARCHAR2
NERS.SF_BIOSAMP_LENGTH_TYPES
11
WEIGHT_KG_1
NUMBER
22
No
No
10
4
Active
Initial weight of sample in kilograms
NUMBER
12
WEIGHT_TYPE_1
VARCHAR2
3
No
No
Active
Initial Method used to weigh sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES
VARCHAR2
NERS.SF_BIOSAMP_WEIGHT_TYPES
13
GRADE_CODE_2
VARCHAR2
2
Yes
No
Active
Secondary ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES
VARCHAR2
14
MARKET_CODE_2
VARCHAR2
2
Yes
No
Active
Secondary ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
VARCHAR2
15
LENGTH_CM_2
NUMBER
22
No
No
6
1
Active
Secondary length of sample in centimeters
NUMBER
16
LENGTH_TYPE_2
VARCHAR2
2
No
No
Active
Secondary length measurement type; support table NERS.SF_BIOSAMP_LENGTH_TYPES
VARCHAR2
NERS.SF_BIOSAMP_LENGTH_TYPES
17
WEIGHT_KG_2
NUMBER
22
No
No
10
4
Active
Secondary weight of sample in kilograms
NUMBER
18
WEIGHT_TYPE_2
VARCHAR2
3
No
No
Active
Secondary Method used to weigh sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES
VARCHAR2
NERS.SF_BIOSAMP_WEIGHT_TYPES
19
RECORDER
VARCHAR2
20
Yes
No
Active
Staff member who collected sample
VARCHAR2
20
START_HAUL_DATE_GMT
DATE
7
No
No
Active
Start haul date in Greenwich Mean Time
DATE
21
COMMENTS
VARCHAR2
250
No
No
Active
Additional information
VARCHAR2
34588
Table: SF_BIOSAMP_MATURITY_CODES
SF_BIOSAMP_MATURITY_CODES
Published / External
Completed
Types of maturity stages used in data collection
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Types of maturity stages used in data collection
1
MATURITY_CODE
VARCHAR2
2
Yes
Yes
Active
Unique maturity code identifier
VARCHAR2
2
MATURITY_DESCR
VARCHAR2
250
Yes
No
Active
Types of maturity stages used in data collection
VARCHAR2
34589
Table: SF_BIOSAMP_PROGRAM_CODES
SF_BIOSAMP_PROGRAM_CODES
Published / External
Completed
Study Fleet biosample progam projects
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Study Fleet biosample progam projects
1
PROGRAM_CODE
NUMBER
22
Yes
Yes
3
0
Active
Unique biosample program project code identifier
NUMBER
2
PROGRAM_DESCR
VARCHAR2
255
Yes
No
Active
Project description
VARCHAR2
3
PROG_DESC_SHORT
VARCHAR2
30
Yes
No
Active
Project title
VARCHAR2
34590
Table: SF_BIOSAMP_QTY_TYPES
SF_BIOSAMP_QTY_TYPES
Published / External
Completed
Quantity types used in data collection
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Quantity types used in data collection
1
QTY_TYPE_CODE
NUMBER
22
Yes
Yes
2
0
Active
Unique quantity type identifier
NUMBER
2
QTY_TYPE_DESCR
VARCHAR2
30
Yes
No
Active
Quanitity type; weight=1 animals=2
VARCHAR2
34591
Table: SF_BIOSAMP_REQUEST_SAMPLES
SF_BIOSAMP_REQUEST_SAMPLES
Published / External
Completed
Data collected for biosample requests
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Data collected for biosample requests
1
SBR_REQUEST_ID
VARCHAR2
15
Yes
Yes
Active
Unique biosample request identification number
VARCHAR2
2
PROGRAM_CODE
NUMBER
22
Yes
Yes
3
0
Active
Biosample program project code;supporting table NERS.SF_BIOSAMP_PROGRAM_CODES
NUMBER
3
TOTE_ID
VARCHAR2
5
Yes
Yes
Active
Tote identifier where sample was stored
VARCHAR2
4
TRANSFER_BIN
VARCHAR2
5
No
No
Active
Bin identifier sample was transported in
VARCHAR2
5
ELB_EFFORT_NUM
VARCHAR2
5
Yes
No
Active
Trip effort number where sample was collected
VARCHAR2
6
SPECIES_ITIS
VARCHAR2
11
Yes
Yes
Active
Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
VARCHAR2
7
MARKET_CODE
VARCHAR2
2
Yes
Yes
Active
ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
VARCHAR2
8
GRADE_CODE
VARCHAR2
2
Yes
Yes
Active
ACCSP grade code description of fish products cut or part; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES
VARCHAR2
9
DISPOSITION_CODE
VARCHAR2
3
Yes
Yes
Active
ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
VARCHAR2
10
WEIGHT_LBS
NUMBER
22
Yes
No
5
1
Active
Weight of sample in pounds
NUMBER
11
WEIGHT_TYPE
VARCHAR2
2
Yes
No
Active
Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES
VARCHAR2
12
MARKET_PRICE_LB
NUMBER
22
No
No
7
2
Active
Price paid per pound for sample
NUMBER
13
COMMENTS
VARCHAR2
250
No
No
Active
Additional information
VARCHAR2
14
SF_SAMPLE_COLLECTOR
VARCHAR2
20
Yes
No
Active
Staff member who collected sample
VARCHAR2
15
UOE
VARCHAR2
20
Yes
No
Active
Staff member who issued BSR request
VARCHAR2
16
DOE
DATE
7
Yes
No
Active
Date of entry into database
DATE
17
CATCH_TYPE_CODE
NUMBER
22
Yes
Yes
38
Active
The allowed ways to which the catch can be retained for research; support table NERS.SF_BIOSAMP_CATCH_TYPES
NUMBER
18
SAMPLE_COUNT
NUMBER
22
Yes
No
38
Active
Number of individuals purchased in sample
NUMBER
34592
Table: SF_BIOSAMP_SEX_CODES
SF_BIOSAMP_SEX_CODES
Published / External
Completed
Sex types used in data collection
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Sex types used in data collection
1
SEX_CODE
NUMBER
22
Yes
Yes
2
0
Active
Unique Sex type identifier
NUMBER
2
SEX_DESCR
VARCHAR2
250
Yes
No
Active
Sex type of species collected
VARCHAR2
34593
Table: SF_BIOSAMP_SEX_FREQ
SF_BIOSAMP_SEX_FREQ
Published / External
Completed
Biosample sex frequency data
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Biosample sex frequency data
1
TRIP_ID
NUMBER
22
Yes
Yes
14
0
Active
Unique trip identifier generated in FLDRS software
NUMBER
2
EFFORT_NUM
VARCHAR2
5
Yes
Yes
Active
Trip Effort where sample was collected
VARCHAR2
3
SPECIES_ITIS
VARCHAR2
11
Yes
Yes
Active
Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
VARCHAR2
4
GRADE_CODE
VARCHAR2
2
Yes
Yes
Active
ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES
VARCHAR2
5
MARKET_CODE
VARCHAR2
2
Yes
Yes
Active
ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
VARCHAR2
6
DISPOSITION_CODE
VARCHAR2
3
Yes
Yes
Active
ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
VARCHAR2
NERS.FVTR_DISPOSITIONS
7
SEX_CODE
NUMBER
22
Yes
Yes
38
Active
Sex type of species collected; supporting table NERS.SF_BIOSAMP_SEX_CODES
NUMBER
NERS.SF_BIOSAMP_SEX_CODES
8
COUNT
NUMBER
22
Yes
No
38
Active
Number of individuals in sex type
NUMBER
9
RECORDER
VARCHAR2
20
Yes
No
Active
Staff member who recorded data
VARCHAR2
10
START_HAUL_DATE_GMT
DATE
7
Yes
No
Active
Start haul date in Greenwich Mean Time
DATE
11
COMMENTS
VARCHAR2
255
No
No
Active
Additional information
VARCHAR2
12
STAT_AREA
VARCHAR2
3
Yes
No
Active
Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS
VARCHAR2
34594
Table: SF_BIOSAMP_TRIP_TYPES
SF_BIOSAMP_TRIP_TYPES
Published / External
Completed
Types of trip samples are collected on
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Types of trip samples are collected on
1
TRIP_TYPE_CODE
NUMBER
22
Yes
Yes
2
0
Active
Unique trip type identifier
NUMBER
2
TRIP_TYPE
VARCHAR2
30
Yes
No
Active
Trip type name
VARCHAR2
3
TRIP_TYPE_DESCR
VARCHAR2
255
Yes
No
Active
Type of trip sample collected on
VARCHAR2
4
TRIP_TYPE_SHORT
VARCHAR2
10
Yes
No
Active
Trip type short description
VARCHAR2
34595
Table: SF_BIOSAMP_WEIGHT_TYPES
SF_BIOSAMP_WEIGHT_TYPES
Published / External
Completed
Methods used to weigh samples
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Methods used to weigh samples
1
WEIGHT_TYPE
VARCHAR2
2
Yes
Yes
Active
Unique weight type identifier
VARCHAR2
2
WEIGHT_TYPE_DESCR
VARCHAR2
250
Yes
No
Active
Method used to weigh sample
VARCHAR2
3
WEIGHT_DESCR_SHORT
VARCHAR2
30
No
No
Active
Short description for methods used to weigh sample
VARCHAR2
34596
Table: SF_SAMPLING_PROJECTS
SF_SAMPLING_PROJECTS
Published / External
Completed
Prioritzes species for biosample collection projects
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Prioritzes species for biosample collection projects
1
PROJECT_TYP
VARCHAR2
20
Yes
No
Active
Identifies sampling project type; wholeSpec or advancedBio
VARCHAR2
2
PROJECT_TITLE
VARCHAR2
100
No
No
Active
Specifies a species/region combination for sampling
VARCHAR2
3
SPECIES_ITIS
VARCHAR2
25
No
No
Active
Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
VARCHAR2
4
REGION
VARCHAR2
5
No
No
Active
Area abbreviations
VARCHAR2
5
PRIORITY
NUMBER
22
No
No
38
Active
Priority of sampling
NUMBER
6
SAMPLING_QTY
NUMBER
22
No
No
38
Active
Number of individuals requested per sampling unit
NUMBER
7
SAMPLING_UNIT
VARCHAR2
10
No
No
Active
Frequency of sample collection
VARCHAR2
34597
Table: TD_DEPLOYMENT_FILES
TD_DEPLOYMENT_FILES
Published / External
Completed
TD data loading event log
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
TD data loading event log
1
SEL_LOG_ID
NUMBER
22
Yes
Yes
38
Active
Unique log event identifier; supporting table NERS.SF_Equip_log
NUMBER
2
FILE_SEQ
NUMBER
22
Yes
Yes
38
Active
Sequencial file load identifier per TD sel_log_id
NUMBER
3
FILE_NAME
VARCHAR2
80
No
No
Active
File name of archived data
VARCHAR2
4
COLLECTION_DATE
DATE
7
Yes
No
Active
Date TD data was collected from vessel
DATE
5
LOADED_TO_DB
NUMBER
22
Yes
No
1
0
Active
TD data load status; loaded=1, not loaded=0
NUMBER
6
SAMP_FREQ_MMSS
VARCHAR2
20
Yes
No
Active
Sample frequency in minures and seconds (MM:SS)
VARCHAR2
7
RAW_TIME_OFFSET
NUMBER
22
Yes
No
38
Active
Number of hours raw data is offset from Greenwich Mean Time (GMT)
NUMBER
8
CLOCK_DRIFT
VARCHAR2
20
Yes
No
Active
Amount of time probe internal time has drifted from official time
VARCHAR2
9
COMMENTS
VARCHAR2
255
No
No
Active
Additional information
VARCHAR2
34598
Table: TD_DEPLOYMENT_HISTORY
TD_DEPLOYMENT_HISTORY
Published / External
Completed
TD logger deployment events
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
TD logger deployment events
1
SEL_LOG_ID
NUMBER
22
Yes
Yes
38
Active
Unique log event identifier; supporting table NERS.SF_EQUIP_LOG
NUMBER
2
INITIALIZATION_DATE
DATE
7
Yes
No
Active
Date logger was initialized to start recording data
DATE
3
EXPIRATION_DATE
DATE
7
Yes
No
Active
Estimated date some probes may reach storage capacity
DATE
4
TDL_TD_LOCATION_CODE
NUMBER
22
Yes
No
38
Active
Code describing TD logger installation location on vessel gear; supporting table NERS.TD_LOCATION
NUMBER
NERS.TD_LOCATION
5
DEPLOYMENT_DATE
DATE
7
Yes
No
Active
Date logger was deployed on vessel
DATE
34599
Table: TD_LOCATION
TD_LOCATION
Published / External
Completed
Possible installation locations for loggers on fishing gear
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
Possible installation locations for loggers on fishing gear
1
TD_LOCATION_CODE
NUMBER
22
Yes
Yes
38
Active
Unique logger location identifier
NUMBER
2
TD_LOCATION_DESCR
VARCHAR2
50
Yes
No
Active
Description of location on gear where TD probe is installed
VARCHAR2
34600
Table: TD_PROBE_DATA
TD_PROBE_DATA
Published / External
Completed
TD data collected during each trip from logger deployed on fishing gear
Loaded by batch 9249, 09-01-2016 13:11
Data Table
Yes
NERS
TD data collected during each trip from logger deployed on fishing gear
1
TDH_SEL_LOG_ID
NUMBER
22
Yes
Yes
38
Active
Unique log event identifier; supporting table NERS.SF_EQUIP_LOG
NUMBER
2
FILE_SEQ
NUMBER
22
Yes
No
38
Active
Sequencial file load identifier per TD sel_log_id
NUMBER
3
DATE_TIME_GMT
DATE
7
Yes
Yes
Active
Date time in Greenwich Mean Time
DATE
4
TEMP
NUMBER
22
Yes
No
38
Active
Temperature reading (Celcius)
NUMBER
5
GEAR_DEPTH
NUMBER
22
Yes
No
38
Active
Depth reading (Meters)
NUMBER
Data Steward
2012
Person
Morin, Michael D
mike.morin@noaa.gov
28 Tarzwell Drive
Narragansett
RI
02882
USA
401-782-3278
401-782-3292
Distributor
2006
Organization
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center
NEFSC Home Page
Online Resource
8:00 a.m. to 4:30 p.m. Monday - Friday
Metadata Contact
2012
Person
Morin, Michael D
mike.morin@noaa.gov
28 Tarzwell Drive
Narragansett
RI
02882
USA
401-782-3278
401-782-3292
Originator
2006
Organization
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center
NEFSC Home Page
Online Resource
8:00 a.m. to 4:30 p.m. Monday - Friday
Point of Contact
2006
Person
Hoey, John J
john.hoey@noaa.gov
28 Tarzwell Drive
Narragansett
RI
02882
USA
401-782-3323
401-782-3201
-76
-67
45
35
US/Canada border to Cape Hatteras, NC; Continental East Coast to the boundary of US managed waters
Continuing
1996
Sensitive
NEFSC data set which is governed by NEFSC Data Access Authorization
NEFSC Data Access Procedure:
1. Formal request in writing usually to the data owner/contact or Center Director;
2. Requester is contacted by data owner to review and verify the request content and details for data delivery options.
3. If data is confidential then owner will determine if the data may be released to the requester;
4. If data can be released, the data is downloaded and packaged for delivery electronically; or the requester may be directed to where the data is available online.
NEFSC Data Access Constraint:
If data is stored on an internal NEFSC network, the requester may not have direct access to query the data unless they are also authorized for network access.
not applicable
http://www.nefsc.noaa.gov/read/popdy/studyfleet
Online Resource
HTML
Study Fleet main web page
Oracle 11g on Centralized Data Management System
Data are audited in several ways: a) automated database audit triggers and procedures, b) post load comparison to other data sets (eg. matching biological sample trips to Observer data to examine fishing location and species composition), c) determination of 'realistic' values (eg. does the age determined from an age structure agree with the measured length of the fish)
Data validation during data collection, Data validation during data entry, Post audits by internal editors, Database integrity constraints, Matching of vessel reported data to external data sources (eg. VMS and observer data, archival data recording devices), post trip review by fishermen
Yes
Unknown
Yes
Yes
1 - 6 months dependent on NERS component
Other
Unknown
Archival of source data preserving unaltered collected data, Scheduled backups, Remote storage backups, Password protection
Catch data are collected using the FLDRS data collection system (refer to VERS system), these data serve as the basis for additional data elements collected by Study Fleet staff which are stored in the NERS database. Study Fleet staff collect field data both on paper or via electronic application, logistics are dependent upon the particular configuration of the vessel and the data collection objectives of the specific trip.
34567
Entity
Table: GPS_LOAD_HISTORY
34568
Entity
Table: GPS_LOAD_METHOD
34569
Entity
Table: GPS_POLL_DATA
34570
Entity
Table: GTE_CODES
34571
Entity
Table: GTE_EDITING_LIST
34572
Entity
Table: GTE_EFFORTS
34573
Entity
Table: GTE_JOIN
34574
Entity
Table: GTE_JOIN_AUDIT
34575
Entity
Table: GTE_LOAD_HISTORY
34576
Entity
Table: GTE_TRIPS
34577
Entity
Table: SF_BIOSAMP_AGE_TYPES
34578
Entity
Table: SF_BIOSAMP_BIOSAMPLE
34579
Entity
Table: SF_BIOSAMP_BIOSAMPLE_AGE
34580
Entity
Table: SF_BIOSAMP_BIOSAMPLE_EXT
34581
Entity
Table: SF_BIOSAMP_BIOSAMPLE_TYPES
34582
Entity
Table: SF_BIOSAMP_CATCH_EST
34583
Entity
Table: SF_BIOSAMP_CATCH_TYPES
34584
Entity
Table: SF_BIOSAMP_DATA_TYPES
34585
Entity
Table: SF_BIOSAMP_LENGTH_FREQ
34586
Entity
Table: SF_BIOSAMP_LENGTH_TYPES
34587
Entity
Table: SF_BIOSAMP_LENWGT_CONV
34588
Entity
Table: SF_BIOSAMP_MATURITY_CODES
34589
Entity
Table: SF_BIOSAMP_PROGRAM_CODES
34590
Entity
Table: SF_BIOSAMP_QTY_TYPES
34591
Entity
Table: SF_BIOSAMP_REQUEST_SAMPLES
34592
Entity
Table: SF_BIOSAMP_SEX_CODES
34593
Entity
Table: SF_BIOSAMP_SEX_FREQ
34594
Entity
Table: SF_BIOSAMP_TRIP_TYPES
34595
Entity
Table: SF_BIOSAMP_WEIGHT_TYPES
34596
Entity
Table: SF_SAMPLING_PROJECTS
34597
Entity
Table: TD_DEPLOYMENT_FILES
34598
Entity
Table: TD_DEPLOYMENT_HISTORY
34599
Entity
Table: TD_LOCATION
34600
Entity
Table: TD_PROBE_DATA
26273
Data Set
Enhanced Biological Sampling Data
Cross Reference
Biological samples commonly (but not exclusively) collected during trips which are included in the NERS system. The processing of these samples is more comprehensive than the SF Biological Sampling program, data are stored in a separate database but contain linkages back to the NERS system.
27317
Data Set
Northeast Cooperative Research Study Fleet (SF) Program Biological Sampling Data
Cross Reference
Biological data and samples collected during Study Fleet participant trips which are included in the NERS system
26983
Data Set
Northeast Cooperative Research Study Fleet (SF) Program Combined GPS, Temperature/Depth, and Effort Fishery Dependent Data
Cross Reference
Study Fleet Participant GPS, Temperature/Depth and Effort data joined together based on on datetime. All GTE data will be associated with a trip which is included within the NERS system
gov.noaa.nmfs.inport:26731
Patricia Jones
2015-08-31T07:58:40
SysAdmin InPortAdmin
2022-08-09T17:11:12
2016-09-01
Northeast Fisheries Science Center
NEFSC
166 Water Street
Woods Hole
MA
02543-1026
USA
(508)495-2000
http://www.nefsc.noaa.gov
8:00 a.m. to 4:30 p.m. Monday - Friday
1001
Public
No
2016-09-01
1 Year
2017-09-01