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

Table: POP_OBSERVERS

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5363  |  Updated: June 14, 2024  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Code Table for Observers

Description

Code Table for Observers

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
OBSERVER_INIT
VARCHAR2 		A character mnemonic for each observer
FIRST_NAME
VARCHAR2 		First Name
LAST_NAME
VARCHAR2 		Last Name
OBSERVER_TYPE
VARCHAR2 		Observer Type
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
TRIP_NUMBER_PREFIX
VARCHAR2 		Trip Number Prefix

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_OBSERVERS
Short Name: POP_OBSERVERS
Status: Completed
Abstract:

Code Table for Observers
Notes:

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

Entity Information

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

Code Table for Observers

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key OBSERVER_INIT VARCHAR2 A character mnemonic for each observer
100
 FIRST_NAME VARCHAR2 First Name
100
 LAST_NAME VARCHAR2 Last Name
100
 OBSERVER_TYPE VARCHAR2 Observer Type
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
100
 TRIP_NUMBER_PREFIX VARCHAR2 Trip Number Prefix

Attribute Details

OBSERVER_INIT

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

A character mnemonic for each observer
General Data Type: VARCHAR2

FIRST_NAME

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

First Name
General Data Type: VARCHAR2

LAST_NAME

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

Last Name
General Data Type: VARCHAR2

OBSERVER_TYPE

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

Observer Type
General Data Type: VARCHAR2

CREATED_BY_USER_ID

CC ID: 16450
Seq. Order: 5
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: 16449
Seq. Order: 6
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: 16448
Seq. Order: 7
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: 16447
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Modified when
General Data Type: DATE

TRIP_NUMBER_PREFIX

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

Trip Number Prefix
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5363
GUID: gov.noaa.nmfs.inport:5363
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-12 05:01+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2024-06-14 13:53+0000
Metadata Record Published: 2024-06-14
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