Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: View: OLS_OBSERVER_CONTACT_V
Short Name: OLS_OBSERVER_CONTACT_V
Status: Completed
Notes:

Loaded by batch 3994, 01-03-2013 16:38

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: NORPAC

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
OBSERVER_SEQ NUMBER
67
FIRST_NAME VARCHAR2
67
LAST_NAME VARCHAR2
67
DATE_OF_BIRTH DATE
67
EMAIL_ADDRESS VARCHAR2
67
PHONE_NUMBER VARCHAR2

Attribute Details

OBSERVER_SEQ

CC ID: 84551
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
General Data Type: NUMBER

FIRST_NAME

CC ID: 84552
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

LAST_NAME

CC ID: 84553
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

DATE_OF_BIRTH

CC ID: 84554
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

EMAIL_ADDRESS

CC ID: 84555
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

PHONE_NUMBER

CC ID: 84556
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 17400
GUID: gov.noaa.nmfs.inport:17400
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-01-03 16:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18