Table: DNF_REASON_LIST
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:28538 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: DNF_REASON_LIST |
---|---|
Short Name: | DNF_REASON_LIST |
Status: | Completed |
Abstract: |
The list of reasons that no fishing occurred during a given month. Boat repair, illness etc. |
Notes: |
Loaded by batch 7533, 11-05-2015 16:10 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | CCL |
Description: |
The list of available dialects supported by the system. Dialect allow the system to use different words for the same species and gear. Such as Spanish and English or various dilects of either. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
DNF_REASON_CD | VARCHAR2 | Primary key for this table. | |
100
|
DNF_REASON_NM | VARCHAR2 | The reason for Did Not Fish logbook. User defined. | |
100
|
IS_ENABLED | NUMBER | Is the value enabled for use. | |
100
|
LU_DT | DATE | Last update date. | |
100
|
LU_USER_ID | NUMBER | Last update user. | |
100
|
DNF_REASON_DESC | VARCHAR2 | Description of the reason |
Attribute Details
DNF_REASON_CD
CC ID: 246921
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Primary key for this table. |
General Data Type: | VARCHAR2 |
DNF_REASON_NM
CC ID: 246922
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 60 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The reason for Did Not Fish logbook. User defined. |
General Data Type: | VARCHAR2 |
IS_ENABLED
CC ID: 246923
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Is the value enabled for use. |
General Data Type: | NUMBER |
LU_DT
CC ID: 246924
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Last update date. |
General Data Type: | DATE |
LU_USER_ID
CC ID: 246925
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Last update user. |
General Data Type: | NUMBER |
DNF_REASON_DESC
CC ID: 246926
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 256 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description of the reason |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 28538 |
---|---|
GUID: | gov.noaa.nmfs.inport:28538 |
Metadata Record Created By: | Joshua Bennett |
Metadata Record Created: | 2015-11-05 16:10+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-06 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-06 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-06 |