Slide Menu
Search Help Show/Hide Menu

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: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07