Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
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_HOOKS_DEFINED

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5351  |  Updated: August 9, 2022  |  Published / External 

Item Identification

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

Used to lookup Hook Type Based on Brand and Model
Notes:

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

Entity Information

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

Used to lookup Hook Type Based on Brand and Model

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key HOOK_DEFINED_KEY NUMBER Primary Key
100
 HOOK_BRAND VARCHAR2 The Brand Of Hooks Used.
100
 HOOK_TYPE VARCHAR2 TheType Of Hooks Used.
100
 HOOK_MODEL VARCHAR2 Model Of Hook
100
 CREATED_BY_USER_ID VARCHAR2 Who created the record
100
 CREATED_DATE DATE When was the record created
100
 MODIFIED_BY_USER_ID VARCHAR2 Who last modified the record
100
 MODIFIED_DATE DATE When was the record last modified

Attribute Details

HOOK_DEFINED_KEY

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

Primary Key
General Data Type: NUMBER

HOOK_BRAND

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

The Brand Of Hooks Used.
General Data Type: VARCHAR2

HOOK_TYPE

CC ID: 16372
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: No
Status: Active
Description:

TheType Of Hooks Used.
General Data Type: VARCHAR2

HOOK_MODEL

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

Model Of Hook
General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Who created the record
General Data Type: VARCHAR2

CREATED_DATE

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

When was the record created
General Data Type: DATE

MODIFIED_BY_USER_ID

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

Who last modified the record
General Data Type: VARCHAR2

MODIFIED_DATE

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

When was the record last modified
General Data Type: DATE

Catalog Details

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