Table: VESCOMP
Entity (ENT) | Greater Atlantic Regional Fisheries Office (GARFO)GUID: gov.noaa.nmfs.inport:5124 | Updated: August 9, 2022 | Published / External
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
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 |