Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > Fisheries Sampling Branch > Pelagic Longline Observer Program > PELAGIC OBSERVER PROGRAM (POP). Catch/Effort d... >

Table: POP_BAITS_USED

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5328  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Bait Used Section of Haul Log

Description

Bait Used Section of Haul Log

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
BAITS_USED_KEY
NUMBER 		Primary Key
HAUL_LOG_KEY
NUMBER 		Haul Log Key
BAIT_NUMBER_USED
NUMBER 		Number Of Individual Baits Used
BAIT_WEIGHT
NUMBER 		Units are in LBS
BAIT_KIND
VARCHAR2 		Code that indicates the kind of bait used.
BAIT_TYPE
VARCHAR2 		Code that indicates the type of bait used
BAIT_CONDITION
VARCHAR2 		Code for the condition of the bait used.
CREATED_BY_USER_ID
VARCHAR2 		Created by whom
CREATED_DATE
DATE 		Created when
MODIFIED_BY_USER_ID
VARCHAR2 		Modified by whom
MODIFIED_DATE
DATE 		Modified when

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

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

Bait Used Section of Haul Log
Notes:

Loaded by batch 1683, 10-12-2007 05:01

Entity Information

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

Bait Used Section of Haul Log

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key BAITS_USED_KEY NUMBER Primary Key
100
 HAUL_LOG_KEY NUMBER Haul Log Key
100
 BAIT_NUMBER_USED NUMBER Number Of Individual Baits Used
100
 BAIT_WEIGHT NUMBER Units are in LBS
100
 BAIT_KIND VARCHAR2 Code that indicates the kind of bait used.
100
 BAIT_TYPE VARCHAR2 Code that indicates the type of bait used
100
 BAIT_CONDITION VARCHAR2 Code for the condition of the bait used.
100
 CREATED_BY_USER_ID VARCHAR2 Created by whom
100
 CREATED_DATE DATE Created when
100
 MODIFIED_BY_USER_ID VARCHAR2 Modified by whom
100
 MODIFIED_DATE DATE Modified when

Attribute Details

BAITS_USED_KEY

CC ID: 15664
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

Primary Key
General Data Type: NUMBER

HAUL_LOG_KEY

CC ID: 15663
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Haul Log Key
General Data Type: NUMBER

BAIT_NUMBER_USED

CC ID: 15662
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Number Of Individual Baits Used
General Data Type: NUMBER

BAIT_WEIGHT

CC ID: 15661
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Units are in LBS
General Data Type: NUMBER

BAIT_KIND

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

Code that indicates the kind of bait used.
General Data Type: VARCHAR2

BAIT_TYPE

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

Code that indicates the type of bait used
General Data Type: VARCHAR2

BAIT_CONDITION

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

Code for the condition of the bait used.
General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Created by whom
General Data Type: VARCHAR2

CREATED_DATE

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

Created when
General Data Type: DATE

MODIFIED_BY_USER_ID

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

Modified by whom
General Data Type: VARCHAR2

MODIFIED_DATE

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

Modified when
General Data Type: DATE

Catalog Details

Catalog Item ID: 5328
GUID: gov.noaa.nmfs.inport:5328
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 05:01+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