Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Contact information for an observer.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
OBSERVER_CONTACT_SEQ
NUMBER
Sequence generated uniquie identifier of a contact record.
OBSERVER_SEQ
NUMBER
A unique number that identifies a specific observer.
ADDRESS_LINE_1
VARCHAR2
First line of street Address or POBox
ADDRESS_LINE_2
VARCHAR2
Second optional line of an address.
CITY
VARCHAR2
Address City
STATE_CODE
VARCHAR2
State or Province of Address
COUNTRY
VARCHAR2
Address Country
POSTAL_CODE
VARCHAR2
US or other postal code.
EMAIL_ADDRESS
VARCHAR2
Contact Email Address
PHONE_NUMBER
VARCHAR2
Country Code, City Code and Phone number for this contact record.
FRIMARY_CONTACT_FLAG
VARCHAR2
Binary indicator of Primary Contact Record. Only one record may be identified a primary at any time.
BEGIN_EFFECTIVE_DATE
DATE
Date record becomes effective
END_EFFECTIVE_DATE
DATE
Date record ought to be retired.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: OLS_OBSERVER_CONTACT
Short Name: OLS_OBSERVER_CONTACT
Status: Completed
Notes:

Loaded by batch 3083, 04-19-2012 13:25

Entity Information

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

Contact information for an observer.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key OBSERVER_CONTACT_SEQ NUMBER Sequence generated uniquie identifier of a contact record.
100
OBSERVER_SEQ NUMBER A unique number that identifies a specific observer.
100
ADDRESS_LINE_1 VARCHAR2 First line of street Address or POBox
100
ADDRESS_LINE_2 VARCHAR2 Second optional line of an address.
100
CITY VARCHAR2 Address City
100
STATE_CODE VARCHAR2 State or Province of Address
100
COUNTRY VARCHAR2 Address Country
100
POSTAL_CODE VARCHAR2 US or other postal code.
100
EMAIL_ADDRESS VARCHAR2 Contact Email Address
100
PHONE_NUMBER VARCHAR2 Country Code, City Code and Phone number for this contact record.
100
FRIMARY_CONTACT_FLAG VARCHAR2 Binary indicator of Primary Contact Record. Only one record may be identified a primary at any time.
100
BEGIN_EFFECTIVE_DATE DATE Date record becomes effective
100
END_EFFECTIVE_DATE DATE Date record ought to be retired.

Attribute Details

OBSERVER_CONTACT_SEQ

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

Sequence generated uniquie identifier of a contact record.

General Data Type: NUMBER

OBSERVER_SEQ

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

A unique number that identifies a specific observer.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.OLS_OBSERVER

ADDRESS_LINE_1

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

First line of street Address or POBox

General Data Type: VARCHAR2

ADDRESS_LINE_2

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

Second optional line of an address.

General Data Type: VARCHAR2

CITY

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

Address City

General Data Type: VARCHAR2

STATE_CODE

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

State or Province of Address

General Data Type: VARCHAR2

COUNTRY

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

Address Country

General Data Type: VARCHAR2

POSTAL_CODE

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

US or other postal code.

General Data Type: VARCHAR2

EMAIL_ADDRESS

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

Contact Email Address

General Data Type: VARCHAR2

PHONE_NUMBER

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

Country Code, City Code and Phone number for this contact record.

General Data Type: VARCHAR2

FRIMARY_CONTACT_FLAG

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

Binary indicator of Primary Contact Record. Only one record may be identified a primary at any time.

General Data Type: VARCHAR2

BEGIN_EFFECTIVE_DATE

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

Date record becomes effective

General Data Type: DATE

END_EFFECTIVE_DATE

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

Date record ought to be retired.

General Data Type: DATE

Catalog Details

Catalog Item ID: 12311
GUID: gov.noaa.nmfs.inport:12311
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2012-04-19 13:25+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-09-26
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-09-26
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-09-26