Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Regional Office Library > AKRO Restricted Access Management (RAM) Program... > Crab Rationalization Permit Program >

Table: CRAT_COOP_MEMBER_FISHERIES

Entity (ENT)  |  Alaska Regional Office (AKRO)
GUID: gov.noaa.nmfs.inport:27339  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table contains information about the members' Quota Share fisheries that are being entered into this Coop for this fishing year.

Description

This table contains information about the members' Quota Share fisheries that are being entered into this Coop for this fishing year.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
COOP_NMFS_ID
NUMBER 		NMFS ID of the crab cooperative.
YEAR
NUMBER 		Crab fishing year.
MEMBER_NMFS_ID
NUMBER 		COOP member NMFS ID.
FISHERY_CODE
VARCHAR2 		Fishery_code entered in this coop for this year.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: CRAT_COOP_MEMBER_FISHERIES
Short Name: CRAT_COOP_MEMBER_FISHERIES
Status: Completed
Abstract:

This table contains information about the members' Quota Share fisheries that are being entered into this Coop for this fishing year.
Notes:

Loaded by batch 7095, 09-22-2015 13:02

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: AKFISH
Description:

This table contains information about the members' Quota Share fisheries that are being entered into this Coop for this fishing year.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key COOP_NMFS_ID NUMBER NMFS ID of the crab cooperative.
100
 Primary Key YEAR NUMBER Crab fishing year.
100
 Primary Key MEMBER_NMFS_ID NUMBER COOP member NMFS ID.
100
 Primary Key FISHERY_CODE VARCHAR2 Fishery_code entered in this coop for this year.

Attribute Details

COOP_NMFS_ID

CC ID: 223138
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 6
Scale: 0
Status: Active
Description:

NMFS ID of the crab cooperative.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.CRAT_COOP_MEMBER

YEAR

CC ID: 223139
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 4
Scale: 0
Status: Active
Description:

Crab fishing year.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.CRAT_COOP_MEMBER

MEMBER_NMFS_ID

CC ID: 223140
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 6
Scale: 0
Status: Active
Description:

COOP member NMFS ID.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.CRAT_COOP_MEMBER

FISHERY_CODE

CC ID: 223141
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: Yes
Status: Active
Description:

Fishery_code entered in this coop for this year.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 27339
GUID: gov.noaa.nmfs.inport:27339
Metadata Record Created By: Pamela A Mason
Metadata Record Created: 2015-09-22 13:02+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2015-12-14
Owner Org: AKRO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2015-12-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2016-12-14