Slide Menu
Search Help Show/Hide Menu
Short Citation:
Pacific States Marine Fisheries Commission, 2022: RecFIN_MARTS Schema, https://www.fisheries.noaa.gov/inport/item/55991.

Item Identification

Title: RecFIN_MARTS Schema
Short Name: RecFIN_MARTS Schema
Status: In Work
Abstract:

RecFIN_MARTS is a schema of the RecFIN database that contains the RecFIN comprehensive tables, a set of flat tables that provide standardized data for marine recreational fisheries data from California, Oregon, and Washington.

Purpose:

The RecFIN_MARTS schema stores the RecFIN comprehensive data tables. These tables combine multiple relational data tables into a flat structure for more efficient data querying and reporting. The comprehensive tables also standardize disparate data codes and structures provided by the sampling programs from each state, creating a consistent, intuitive data structure. The comprehensive tables in the RecFIN_MARTS schema server as the basis for reporting data from the RecFIN database to end users.

Physical Location

Organization: Pacific States Marine Fisheries Commission
City: Portland
State/Province: OR
Country: United States of America

Data Set Information

Data Set Scope Code: Data Set
Data Set Type: Oracle Database
Maintenance Frequency: Monthly

Support Roles

Metadata Contact

CC ID: 832133
Date Effective From: 2019-04-01
Date Effective To:
Contact (Person): Edwards, Jason
Email Address: jedwards@psmfc.org

URLs

URL 1

CC ID: 832134
URL: https://www.recfin.org/
Name: Recreational Fisheries Information Network
URL Type:
Online Resource

Child Items

Rubric scores updated every 15m

Rubric Score Type Title
Entity Table: COMPREHENSIVE_BIO_DETAIL
Entity Table: COMPREHENSIVE_REC_AGEING
Entity Table: COMPREHENSIVE_REC_CATCH_EST
Entity Table: COMPREHENSIVE_REC_SAMPLE

Catalog Details

Catalog Item ID: 55991
GUID: gov.noaa.nmfs.inport:55991
Metadata Record Created By: Jason Edwards
Metadata Record Created: 2019-04-01 23:39+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2019-04-02
Owner Org: PSMFC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year