RecFIN_MARTS Schema
Data Set (DS) | Pacific States Marine Fisheries Commission (PSMFC)GUID: gov.noaa.nmfs.inport:55991 | Updated: August 9, 2022 | Published / External
Summary
Short Citation
Pacific States Marine Fisheries Commission, 2024: RecFIN_MARTS Schema, https://www.fisheries.noaa.gov/inport/item/55991.
Full Citation Examples
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.
Distribution Information
No Distributions available.
Child Items
Type | Title |
---|---|
Entity | Table: COMPREHENSIVE_BIO_DETAIL |
Entity | Table: COMPREHENSIVE_REC_AGEING |
Entity | Table: COMPREHENSIVE_REC_CATCH_EST |
Entity | Table: COMPREHENSIVE_REC_SAMPLE |
Contact Information
Metadata Contact
Jason Edwards
jedwards@psmfc.org
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
Date Effective From: | 2019-04-01 |
---|---|
Date Effective To: | |
Contact (Person): | Edwards, Jason |
Email Address: | jedwards@psmfc.org |
URLs
URL 1
URL: | https://www.recfin.org/ |
---|---|
Name: | Recreational Fisheries Information Network |
URL Type: |
Online Resource
|
Child Items
Rubric scores updated every 15m
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: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2019-04-02 |
Owner Org: | PSMFC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2019-04-02 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2020-04-02 |