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 >

View: V_CRAT_QUOTA_WITH_COMMUNITY

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

Summary

Abstract

This view retrieves information about Crab Quota Share holders. It includes the fishery, and reflects year-end values for each archived year.

Description

This view retrieves information about Crab Quota Share holders. It includes the fishery, and reflects year-end values for each archived year.

Entity Information

Entity Type
Data View

Data Attribute / Type Description
YEAR
NUMBER 		Crab fishing year.
NMFS_ID
NUMBER 		Unique NMFS person identifier.
NAME
VARCHAR2 		Person name.
CITY_NAME
VARCHAR2 		Self-reported, unverified city of residence for person.
STATE_CODE
VARCHAR2 		Self-reported, unverified code for state of residence for person.
FISHERY
VARCHAR2 		The nine fisheries as defined in 680.40 (b)(2)(iii). The allowable values are listed in the MANAGEMENT_AREA table as CODEs of CRAT area type. Each area is mapped to state stat (SSTAT) areas in the MANAGEMENT_AREA_CONTENT table.
SECTOR
VARCHAR2 		CRAT sector code: CPC = Catcher/Processor Crew, CPO = Catcher/Processor Owner, CVC = Catcher Vessel Crew, CVO = Catcher Vessel Owner, PRO = Processor Owner.
QUOTA_SHARE
NUMBER 		Total quota share units for this account.

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: View: V_CRAT_QUOTA_WITH_COMMUNITY
Short Name: V_CRAT_QUOTA_WITH_COMMUNITY
Status: Completed
Abstract:

This view retrieves information about Crab Quota Share holders. It includes the fishery, and reflects year-end values for each archived year.
Notes:

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

Entity Information

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

This view retrieves information about Crab Quota Share holders. It includes the fishery, and reflects year-end values for each archived year.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 YEAR NUMBER Crab fishing year.
100
 NMFS_ID NUMBER Unique NMFS person identifier.
100
 NAME VARCHAR2 Person name.
100
 CITY_NAME VARCHAR2 Self-reported, unverified city of residence for person.
100
 STATE_CODE VARCHAR2 Self-reported, unverified code for state of residence for person.
100
 FISHERY VARCHAR2 The nine fisheries as defined in 680.40 (b)(2)(iii). The allowable values are listed in the MANAGEMENT_AREA table as CODEs of CRAT area type. Each area is mapped to state stat (SSTAT) areas in the MANAGEMENT_AREA_CONTENT table.
100
 SECTOR VARCHAR2 CRAT sector code: CPC = Catcher/Processor Crew, CPO = Catcher/Processor Owner, CVC = Catcher Vessel Crew, CVO = Catcher Vessel Owner, PRO = Processor Owner.
100
 QUOTA_SHARE NUMBER Total quota share units for this account.

Attribute Details

YEAR

CC ID: 223233
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Crab fishing year.
General Data Type: NUMBER

NMFS_ID

CC ID: 223234
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Unique NMFS person identifier.
General Data Type: NUMBER

NAME

CC ID: 223235
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Person name.
General Data Type: VARCHAR2

CITY_NAME

CC ID: 223236
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Self-reported, unverified city of residence for person.
General Data Type: VARCHAR2

STATE_CODE

CC ID: 223237
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Self-reported, unverified code for state of residence for person.
General Data Type: VARCHAR2

FISHERY

CC ID: 223238
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The nine fisheries as defined in 680.40 (b)(2)(iii). The allowable values are listed in the MANAGEMENT_AREA table as CODEs of CRAT area type. Each area is mapped to state stat (SSTAT) areas in the MANAGEMENT_AREA_CONTENT table.
General Data Type: VARCHAR2

SECTOR

CC ID: 223239
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

CRAT sector code: CPC = Catcher/Processor Crew, CPO = Catcher/Processor Owner, CVC = Catcher Vessel Crew, CVO = Catcher Vessel Owner, PRO = Processor Owner.
General Data Type: VARCHAR2

QUOTA_SHARE

CC ID: 223240
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Total quota share units for this account.
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 27347
GUID: gov.noaa.nmfs.inport:27347
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