Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Table Listing Inconsistancies When processing Compliance Information

Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None compliance

Entity Information

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

Table Listing Inconsistancies When processing Compliance Information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
VESID VARCHAR2 Vessel ID
100
TOP VARCHAR2 Type(s) of permits approved.
100
EDOP DATE Effective date of the first fishery permit issued for the record.
100
EXPDATE DATE Expiration date of the permit, which is based upon the vessel owner's date of birth. All permits expire at the same time, regardless of their issue date.
100
STATUS VARCHAR2 Indicates the status of the permit. The permit can be in several different states, e.g., Active (A), Inactive (I), Expired (E), Renewed before the expiration date (R) or Transferred (T) Since there are multiple records for the same vessel, always check the most current record to obtain the most current information. The column DOS (i.e., Date of Status) can help you pick the most current record. Records with null DOS are generally the most current, otherwise you must select the maximum or highest date.
100
DOS DATE Date of Status. Whenever a record is changed, this date is updated with the date of the change and a new record is added with a null Date of Status (DOS.) If the Status column contains an A (i.e., it is Active) the date of status should be null.
100
EXCEPTION_MESSAGE VARCHAR2 A description of the inconsistency in the vessel permit information.
100
USERNAME VARCHAR2 A Oracle user name for the person validating the vessel permit information.
100
EXCEPTION_DATE DATE The date that the inconsistency in the vessel permit information was detected.

Attribute Details

VESID

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

Vessel ID

General Data Type: VARCHAR2

TOP

CC ID: 27156
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

Type(s) of permits approved.

General Data Type: VARCHAR2

EDOP

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

Effective date of the first fishery permit issued for the record.

General Data Type: DATE

EXPDATE

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

Expiration date of the permit, which is based upon the vessel owner's date of birth. All permits expire at the same time, regardless of their issue date.

General Data Type: DATE

STATUS

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

Indicates the status of the permit. The permit can be in several different states, e.g., Active (A), Inactive (I), Expired (E), Renewed before the expiration date (R) or Transferred (T) Since there are multiple records for the same vessel, always check the most current record to obtain the most current information. The column DOS (i.e., Date of Status) can help you pick the most current record. Records with null DOS are generally the most current, otherwise you must select the maximum or highest date.

General Data Type: VARCHAR2

DOS

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

Date of Status. Whenever a record is changed, this date is updated with the date of the change and a new record is added with a null Date of Status (DOS.) If the Status column contains an A (i.e., it is Active) the date of status should be null.

General Data Type: DATE

EXCEPTION_MESSAGE

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

A description of the inconsistency in the vessel permit information.

General Data Type: VARCHAR2

USERNAME

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

A Oracle user name for the person validating the vessel permit information.

General Data Type: VARCHAR2

EXCEPTION_DATE

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

The date that the inconsistency in the vessel permit information was detected.

General Data Type: DATE

Catalog Details

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