Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: FLS_DELINQUENT_STATUS
Short Name: FLS_DELINQUENT_STATUS
Status: Completed
Abstract:

A record of the vessels that are delinquent at the time of their permit expiration.

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None compliance
None permits
None vessels

Entity Information

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

A record of the vessels that are delinquent at the time of their permit expiration.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key VESSEL_ID VARCHAR2 The ID of the vessel for which the logbook has been completed.Validation:A foreign key between this table and FLS_VESSEL_LIST ensures that only valid vessel ids can be entered into this table.The column is mandatory and may not be left empty.
100
Primary Key PERMIT_CATEGORY VARCHAR2 The permit category that is missing required reports.
100
Primary Key REPORTING_PERIOD DATE The first day of the month and year that the fisherman must report for.
100
MONTH_CLEARED_DATE DATE For that month, the date the reporting requirement was met or null if still delinquent.
100
VESSEL_CLEARED_DATE DATE The date the vessel met all of it's reporting requirements.
100
VESSEL_UNCLEARED_DATE DATE The date the vessel became delinquent again after being cleared
100
EMAIL_SENT_DATE DATE The date that SERO (the SouthEast Regional Office) was e-mailed a report the delinquency was cleared.

Attribute Details

VESSEL_ID

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

The ID of the vessel for which the logbook has been completed.Validation:A foreign key between this table and FLS_VESSEL_LIST ensures that only valid vessel ids can be entered into this table.The column is mandatory and may not be left empty.

General Data Type: VARCHAR2

PERMIT_CATEGORY

CC ID: 27191
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: Yes
Status: Active
Description:

The permit category that is missing required reports.

General Data Type: VARCHAR2

REPORTING_PERIOD

CC ID: 27192
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: Yes
Status: Active
Description:

The first day of the month and year that the fisherman must report for.

General Data Type: DATE

MONTH_CLEARED_DATE

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

For that month, the date the reporting requirement was met or null if still delinquent.

General Data Type: DATE

VESSEL_CLEARED_DATE

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

The date the vessel met all of it's reporting requirements.

General Data Type: DATE

VESSEL_UNCLEARED_DATE

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

The date the vessel became delinquent again after being cleared

General Data Type: DATE

EMAIL_SENT_DATE

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

The date that SERO (the SouthEast Regional Office) was e-mailed a report the delinquency was cleared.

General Data Type: DATE

Catalog Details

Catalog Item ID: 7153
GUID: gov.noaa.nmfs.inport:7153
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07