Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
GARFO Metadata Library > _Information Resources Management (IRM) Divisio... > Vessel Permit System > Vessel Permit System Data Set >

Table: VESCOMP

Entity (ENT)  |  Greater Atlantic Regional Fisheries Office (GARFO)
GUID: gov.noaa.nmfs.inport:5124  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Vessel compliance information

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
NUM
NUMBER 		Permit Number
RENYR
NUMBER 		Renewal Year
COMP
CHAR 		Complaint?(T or F)
DE
DATE 		Date Entered
UE
CHAR 		User Entered
DCLR
DATE 		Declaration Date
UC
CHAR 		User Changed
COMPLIANCE_REASON
VARCHAR2 		COMPLIANCE REASON
COMMENTS
VARCHAR2 		COMMENTS
REPORT_TYPE
VARCHAR2 		REPORT TYPE

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: VESCOMP
Short Name: VESCOMP
Status: Completed
Notes:

Loaded by batch 1579, 09-04-2007 12:20

Entity Information

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

Vessel compliance information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 NUM NUMBER Permit Number
100
 RENYR NUMBER Renewal Year
100
 COMP CHAR Complaint?(T or F)
100
 DE DATE Date Entered
100
 UE CHAR User Entered
100
 DCLR DATE Declaration Date
100
 UC CHAR User Changed
100
 COMPLIANCE_REASON VARCHAR2 COMPLIANCE REASON
100
 COMMENTS VARCHAR2 COMMENTS
100
 REPORT_TYPE VARCHAR2 REPORT TYPE

Attribute Details

NUM

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

Permit Number
General Data Type: NUMBER

RENYR

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

Renewal Year
General Data Type: NUMBER

COMP

CC ID: 14631
Seq. Order: 3
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Complaint?(T or F)
General Data Type: CHAR

DE

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

Date Entered
General Data Type: DATE

UE

CC ID: 14639
Seq. Order: 5
Data Storage Type: CHAR
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

User Entered
General Data Type: CHAR

DCLR

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

Declaration Date
General Data Type: DATE

UC

CC ID: 14638
Seq. Order: 7
Data Storage Type: CHAR
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

User Changed
General Data Type: CHAR

COMPLIANCE_REASON

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

COMPLIANCE REASON
General Data Type: VARCHAR2

COMMENTS

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

COMMENTS
General Data Type: VARCHAR2

REPORT_TYPE

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

REPORT TYPE
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5124
GUID: gov.noaa.nmfs.inport:5124
Metadata Record Created By: SysAdmin InPortAdmin
Metadata Record Created: 2007-09-04 12:20+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-02-29
Owner Org: GARFO
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-02-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-02-28