Table: FVTR_TRIP_CATEGORIES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34269 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table lists the valid VTR trip categories
DescriptionTable lists the valid VTR trip categories
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
TRIP_CATEGORY
NUMBER |
Trip category code |
TRIP_CATEGORY_DESCR
VARCHAR2 |
Trip category code description |
COLLECT_NUM_ANGLERS
NUMBER |
Flag used to indicate whether the category type requires the collection of the number of anglers on the trip, 0 = not required, 1 = required |
BEGIN_DATE
DATE |
Date when the TRIP_CATEGORY code became available for use |
END_DATE
DATE |
Date when the TRIP_CATEGORY was discontinued |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: FVTR_TRIP_CATEGORIES |
---|---|
Short Name: | FVTR_TRIP_CATEGORIES |
Status: | Completed |
Abstract: |
Table lists the valid VTR trip categories |
Notes: |
Loaded by batch 9190, 08-11-2016 16:37 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | FVTR |
Description: |
Table lists the valid VTR trip categories |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
TRIP_CATEGORY | NUMBER | Trip category code | |
100
|
TRIP_CATEGORY_DESCR | VARCHAR2 | Trip category code description | |
100
|
COLLECT_NUM_ANGLERS | NUMBER | Flag used to indicate whether the category type requires the collection of the number of anglers on the trip, 0 = not required, 1 = required | |
100
|
BEGIN_DATE | DATE | Date when the TRIP_CATEGORY code became available for use | |
100
|
END_DATE | DATE | Date when the TRIP_CATEGORY was discontinued |
Attribute Details
TRIP_CATEGORY
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Trip category code |
General Data Type: | NUMBER |
TRIP_CATEGORY_DESCR
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 80 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Trip category code description |
General Data Type: | VARCHAR2 |
COLLECT_NUM_ANGLERS
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Flag used to indicate whether the category type requires the collection of the number of anglers on the trip, 0 = not required, 1 = required |
General Data Type: | NUMBER |
BEGIN_DATE
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when the TRIP_CATEGORY code became available for use |
General Data Type: | DATE |
END_DATE
Seq. Order: | 5 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when the TRIP_CATEGORY was discontinued |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 34269 |
---|---|
GUID: | gov.noaa.nmfs.inport:34269 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-08-11 16:37+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-08-23 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-08-23 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-08-23 |