Slide Menu
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu

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