Metadata Rubric

100%

6 / 6

Alaska Regional Office Library > AKRO Restricted Access Management (RAM) Program... > Charter Halibut Limited Access Program >

View: V_CHP_PERMIT

Entity (ENT) | Alaska Regional Office (AKRO)
GUID: gov.noaa.nmfs.inport:26548 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

CHP Permit values combined with holder and BUSINESS names and the concatenated permit_type/ID.

Description

CHP Permit values combined with holder and BUSINESS names and the concatenated permit_type/ID.

Entity Type
Data View

Data Attribute / Type	Description
ID NUMBER	This is the permit ID.
PERMIT_NUMBER VARCHAR2	Concatenated permit_type and ID.
VERSION VARCHAR2	Current permit version.
OLD_VERSION VARCHAR2	This is the version code for previously issued versions of this permit.
HOLDER_PERSON_ID NUMBER	ID of the business or individual getting the permit.
HOLDER_NAME VARCHAR2	Name of the permit holder.
BUSINESS_PERSON_ID NUMBER	ID of the BUSINESS individual or business name.
BUSINESS_NAME VARCHAR2	Name of the person BUSINESS with the permit holder.
TRANSFERRABLE_FLAG VARCHAR2	This is a permanent status of the permit.
GRANDFATHER_FLAG VARCHAR2	Over five (5) permits issued to an entity are grandfathered.
DATE_ISSUED DATE	Date permit was created on the database.
INTERIM_FLAG VARCHAR2	Some permits will be interim until the appeal process is complete. They are non-transferable.
REVOKED_FLAG VARCHAR2	This permit is eliminated.
DATE_REVOKED DATE	Date permit was permanently revoked.
FISHING_AREA VARCHAR2	Just one fishing area per permit, 2A or 3C.
CLIENT_COUNT NUMBER	Maximum number of clients allowed on a vessel.
CQE_COMMUNITY NUMBER	Foreign key to the chp_cqe_city table which is cities that may apply for CQE type permits.
ADMIN_TRANS_RESTRICT_FLAG VARCHAR2	Permit transferability restricted by RAM Admin staff for various reasons.
CAUSE_OF_ISSUANCE VARCHAR2	What caused the issuance of this permit version.
CURRENT_RECORD_FLAG VARCHAR2	Just to make querying for the current stat of a permit easy.
FISHING_AREA_ID NUMBER	Foreign key to management_area. It matches the fishing_area column.

Data Attribute / Type

Description

ID
NUMBER

This is the permit ID.

PERMIT_NUMBER
VARCHAR2

Concatenated permit_type and ID.

VERSION
VARCHAR2

Current permit version.

OLD_VERSION
VARCHAR2

This is the version code for previously issued versions of this permit.

HOLDER_PERSON_ID
NUMBER

ID of the business or individual getting the permit.

HOLDER_NAME
VARCHAR2

Name of the permit holder.

BUSINESS_PERSON_ID
NUMBER

ID of the BUSINESS individual or business name.

BUSINESS_NAME
VARCHAR2

Name of the person BUSINESS with the permit holder.

TRANSFERRABLE_FLAG
VARCHAR2

This is a permanent status of the permit.

GRANDFATHER_FLAG
VARCHAR2

Over five (5) permits issued to an entity are grandfathered.

DATE_ISSUED
DATE

Date permit was created on the database.

INTERIM_FLAG
VARCHAR2

Some permits will be interim until the appeal process is complete. They are non-transferable.

REVOKED_FLAG
VARCHAR2

This permit is eliminated.

DATE_REVOKED
DATE

Date permit was permanently revoked.

FISHING_AREA
VARCHAR2

Just one fishing area per permit, 2A or 3C.

CLIENT_COUNT
NUMBER

Maximum number of clients allowed on a vessel.

CQE_COMMUNITY
NUMBER

Foreign key to the chp_cqe_city table which is cities that may apply for CQE type permits.

ADMIN_TRANS_RESTRICT_FLAG
VARCHAR2

Permit transferability restricted by RAM Admin staff for various reasons.

CAUSE_OF_ISSUANCE
VARCHAR2

What caused the issuance of this permit version.

CURRENT_RECORD_FLAG
VARCHAR2

Just to make querying for the current stat of a permit easy.

FISHING_AREA_ID
NUMBER

Foreign key to management_area. It matches the fishing_area column.

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: V_CHP_PERMIT
Short Name:	V_CHP_PERMIT
Status:	Completed
Abstract:	CHP Permit values combined with holder and BUSINESS names and the concatenated permit_type/ID.
Notes:	Loaded by batch 6893, 08-21-2015 14:18

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	AKFISH
Description:	CHP Permit values combined with holder and BUSINESS names and the concatenated permit_type/ID.

Attribute Summary

	Name	Type	Description
100	ID	NUMBER	This is the permit ID.
100	PERMIT_NUMBER	VARCHAR2	Concatenated permit_type and ID.
100	VERSION	VARCHAR2	Current permit version.
100	OLD_VERSION	VARCHAR2	This is the version code for previously issued versions of this permit.
100	HOLDER_PERSON_ID	NUMBER	ID of the business or individual getting the permit.
100	HOLDER_NAME	VARCHAR2	Name of the permit holder.
100	BUSINESS_PERSON_ID	NUMBER	ID of the BUSINESS individual or business name.
100	BUSINESS_NAME	VARCHAR2	Name of the person BUSINESS with the permit holder.
100	TRANSFERRABLE_FLAG	VARCHAR2	This is a permanent status of the permit.
100	GRANDFATHER_FLAG	VARCHAR2	Over five (5) permits issued to an entity are grandfathered.
100	DATE_ISSUED	DATE	Date permit was created on the database.
100	INTERIM_FLAG	VARCHAR2	Some permits will be interim until the appeal process is complete. They are non-transferable.
100	REVOKED_FLAG	VARCHAR2	This permit is eliminated.
100	DATE_REVOKED	DATE	Date permit was permanently revoked.
100	FISHING_AREA	VARCHAR2	Just one fishing area per permit, 2A or 3C.
100	CLIENT_COUNT	NUMBER	Maximum number of clients allowed on a vessel.
100	CQE_COMMUNITY	NUMBER	Foreign key to the chp_cqe_city table which is cities that may apply for CQE type permits.
100	ADMIN_TRANS_RESTRICT_FLAG	VARCHAR2	Permit transferability restricted by RAM Admin staff for various reasons.
100	CAUSE_OF_ISSUANCE	VARCHAR2	What caused the issuance of this permit version.
100	CURRENT_RECORD_FLAG	VARCHAR2	Just to make querying for the current stat of a permit easy.
100	FISHING_AREA_ID	NUMBER	Foreign key to management_area. It matches the fishing_area column.

Name

Type

Description

100

NUMBER

This is the permit ID.

100

PERMIT_NUMBER

VARCHAR2

Concatenated permit_type and ID.

100

VERSION

VARCHAR2

Current permit version.

100

OLD_VERSION

VARCHAR2

This is the version code for previously issued versions of this permit.

100

HOLDER_PERSON_ID

NUMBER

ID of the business or individual getting the permit.

100

HOLDER_NAME

VARCHAR2

Name of the permit holder.

100

BUSINESS_PERSON_ID

NUMBER

ID of the BUSINESS individual or business name.

100

BUSINESS_NAME

VARCHAR2

Name of the person BUSINESS with the permit holder.

100

TRANSFERRABLE_FLAG

VARCHAR2

This is a permanent status of the permit.

100

GRANDFATHER_FLAG

VARCHAR2

Over five (5) permits issued to an entity are grandfathered.

100

DATE_ISSUED

DATE

Date permit was created on the database.

100

INTERIM_FLAG

VARCHAR2

Some permits will be interim until the appeal process is complete. They are non-transferable.

100

REVOKED_FLAG

VARCHAR2

This permit is eliminated.

100

DATE_REVOKED

DATE

Date permit was permanently revoked.

100

FISHING_AREA

VARCHAR2

Just one fishing area per permit, 2A or 3C.

100

CLIENT_COUNT

NUMBER

Maximum number of clients allowed on a vessel.

100

CQE_COMMUNITY

NUMBER

Foreign key to the chp_cqe_city table which is cities that may apply for CQE type permits.

100

ADMIN_TRANS_RESTRICT_FLAG

VARCHAR2

Permit transferability restricted by RAM Admin staff for various reasons.

100

CAUSE_OF_ISSUANCE

VARCHAR2

What caused the issuance of this permit version.

100

CURRENT_RECORD_FLAG

VARCHAR2

Just to make querying for the current stat of a permit easy.

100

FISHING_AREA_ID

NUMBER

Foreign key to management_area. It matches the fishing_area column.

Attribute Details

ID

CC ID: 213846

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	This is the permit ID.
General Data Type:	NUMBER

PERMIT_NUMBER

CC ID: 213857

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	43
Required:	No
Primary Key:	No
Status:	Active
Description:	Concatenated permit_type and ID.
General Data Type:	VARCHAR2

VERSION

CC ID: 213860

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Current permit version.
General Data Type:	VARCHAR2

OLD_VERSION

CC ID: 213861

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is the version code for previously issued versions of this permit.
General Data Type:	VARCHAR2

HOLDER_PERSON_ID

CC ID: 213862

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	ID of the business or individual getting the permit.
General Data Type:	NUMBER

HOLDER_NAME

CC ID: 213863

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the permit holder.
General Data Type:	VARCHAR2

BUSINESS_PERSON_ID

CC ID: 213864

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	ID of the BUSINESS individual or business name.
General Data Type:	NUMBER

BUSINESS_NAME

CC ID: 213865

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the person BUSINESS with the permit holder.
General Data Type:	VARCHAR2

TRANSFERRABLE_FLAG

CC ID: 213866

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This is a permanent status of the permit.
General Data Type:	VARCHAR2

GRANDFATHER_FLAG

CC ID: 213847

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Over five (5) permits issued to an entity are grandfathered.
General Data Type:	VARCHAR2

DATE_ISSUED

CC ID: 213848

Seq. Order:	11
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date permit was created on the database.
General Data Type:	DATE

INTERIM_FLAG

CC ID: 213849

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Some permits will be interim until the appeal process is complete. They are non-transferable.
General Data Type:	VARCHAR2

REVOKED_FLAG

CC ID: 213850

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	This permit is eliminated.
General Data Type:	VARCHAR2

DATE_REVOKED

CC ID: 213851

Seq. Order:	14
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date permit was permanently revoked.
General Data Type:	DATE

FISHING_AREA

CC ID: 213852

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Just one fishing area per permit, 2A or 3C.
General Data Type:	VARCHAR2

CLIENT_COUNT

CC ID: 213853

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Maximum number of clients allowed on a vessel.
General Data Type:	NUMBER

CQE_COMMUNITY

CC ID: 213854

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Foreign key to the chp_cqe_city table which is cities that may apply for CQE type permits.
General Data Type:	NUMBER

ADMIN_TRANS_RESTRICT_FLAG

CC ID: 213855

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Permit transferability restricted by RAM Admin staff for various reasons.
General Data Type:	VARCHAR2

CAUSE_OF_ISSUANCE

CC ID: 213856

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	Yes
Primary Key:	No
Status:	Active
Description:	What caused the issuance of this permit version.
General Data Type:	VARCHAR2

CURRENT_RECORD_FLAG

CC ID: 213858

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Just to make querying for the current stat of a permit easy.
General Data Type:	VARCHAR2

FISHING_AREA_ID

CC ID: 213859

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Foreign key to management_area. It matches the fishing_area column.
General Data Type:	NUMBER

Catalog Item ID:	26548
GUID:	gov.noaa.nmfs.inport:26548
Metadata Record Created By:	Pamela A Mason
Metadata Record Created:	2015-08-21 14:18+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

View: V_CHP_PERMIT

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ID

PERMIT_NUMBER

VERSION

OLD_VERSION

HOLDER_PERSON_ID

HOLDER_NAME

BUSINESS_PERSON_ID

BUSINESS_NAME

TRANSFERRABLE_FLAG

GRANDFATHER_FLAG

DATE_ISSUED

INTERIM_FLAG

REVOKED_FLAG

DATE_REVOKED

FISHING_AREA

CLIENT_COUNT

CQE_COMMUNITY

ADMIN_TRANS_RESTRICT_FLAG

CAUSE_OF_ISSUANCE

CURRENT_RECORD_FLAG

FISHING_AREA_ID

Catalog Details