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

Table: SHARC_CERTIFICATE_CARD

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

Summary

Abstract

This table contains information on all Subsistence Halibut registrations issued.

Description

This table contains information on all Subsistence Halibut registrations issued.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SUBSIST_PERSON_ID
NUMBER 		Subsistence certificate number.
SEQUENCE_NUMBER
NUMBER 		A certificate may be renewed, generating a subsequent sequence number.
CARD_NAME
VARCHAR2 		Name of individual issued the subsistence certificate.
CARD_EXP_DATE
VARCHAR2 		Date subsistence certificate expires.
TIMES_CARD_PRINTED
NUMBER 		Number of times the subsistence certificate has been printed.
TRIBAL_ABBR
VARCHAR2 		Abbreviated name of eligible Alaska tribe.
PRINTED_DATE
DATE 		Date subsistence certificate was last printed.
PRINTED_USER
VARCHAR2 		Identifies NMFS or web user that printed the certificate.
REG_TYPE
VARCHAR2 		T = Tribal, R = Rural.
CURRENT_RECORD_FLAG
VARCHAR2 		Indicates whether or not this is the current record.
IFQ_AREA
VARCHAR2 		IFQ Area code: IPHC area code for halibut.
REVOKED_FLAG
VARCHAR2 		Indicates whether or not the certificate has been revoked.

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

This table contains information on all Subsistence Halibut registrations issued.
Notes:

Loaded by batch 6893, 08-21-2015 14:18

Entity Information

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

This table contains information on all Subsistence Halibut registrations issued.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SUBSIST_PERSON_ID NUMBER Subsistence certificate number.
100
 Primary Key SEQUENCE_NUMBER NUMBER A certificate may be renewed, generating a subsequent sequence number.
100
 CARD_NAME VARCHAR2 Name of individual issued the subsistence certificate.
100
 CARD_EXP_DATE VARCHAR2 Date subsistence certificate expires.
100
 TIMES_CARD_PRINTED NUMBER Number of times the subsistence certificate has been printed.
100
 TRIBAL_ABBR VARCHAR2 Abbreviated name of eligible Alaska tribe.
100
 PRINTED_DATE DATE Date subsistence certificate was last printed.
100
 PRINTED_USER VARCHAR2 Identifies NMFS or web user that printed the certificate.
100
 REG_TYPE VARCHAR2 T = Tribal, R = Rural.
100
 CURRENT_RECORD_FLAG VARCHAR2 Indicates whether or not this is the current record.
100
 IFQ_AREA VARCHAR2 IFQ Area code: IPHC area code for halibut.
100
 REVOKED_FLAG VARCHAR2 Indicates whether or not the certificate has been revoked.

Attribute Details

SUBSIST_PERSON_ID

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

Subsistence certificate number.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.SHARC_CERTIFICATE

SEQUENCE_NUMBER

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

A certificate may be renewed, generating a subsequent sequence number.
General Data Type: NUMBER
Foreign Key Relations:

AKFISH.SHARC_CERTIFICATE

CARD_NAME

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

Name of individual issued the subsistence certificate.
General Data Type: VARCHAR2

CARD_EXP_DATE

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

Date subsistence certificate expires.
General Data Type: VARCHAR2

TIMES_CARD_PRINTED

CC ID: 213801
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number of times the subsistence certificate has been printed.
General Data Type: NUMBER

TRIBAL_ABBR

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

Abbreviated name of eligible Alaska tribe.
General Data Type: VARCHAR2

PRINTED_DATE

CC ID: 213803
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date subsistence certificate was last printed.
General Data Type: DATE

PRINTED_USER

CC ID: 213804
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Identifies NMFS or web user that printed the certificate.
General Data Type: VARCHAR2

REG_TYPE

CC ID: 213805
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

T = Tribal, R = Rural.
General Data Type: VARCHAR2

CURRENT_RECORD_FLAG

CC ID: 213796
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Indicates whether or not this is the current record.
General Data Type: VARCHAR2

IFQ_AREA

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

IFQ Area code: IPHC area code for halibut.
General Data Type: VARCHAR2

REVOKED_FLAG

CC ID: 213798
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Indicates whether or not the certificate has been revoked.
General Data Type: VARCHAR2

Catalog Details

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