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

Summary

Abstract

This entity represents the list of people who ought to be contacted in the event of any critical event during an observer deployment.

Description

This entity represents the list of people who ought to be contacted in the event of any critical event during an observer deployment.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
EMERGENCY_CONTACT_SEQ
NUMBER
Sequence generated unique identifier of this emergency contact record
OBSERVER_SEQ
NUMBER
A unique number that identifies a specific observer.
NAME
VARCHAR2
Full name of contact
RELATIONSHIP
VARCHAR2
Relationship to Observer.
ADDRESS_LINE_1
VARCHAR2
First line of street Address or PO Box
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.
BEGIN_EFFECTIVE_DATE
DATE
Date record becomes effective
END_EFFECTIVE_DATE
DATE
Date record ought to be retired.
FRIMARY_CONTACT_FLAG
VARCHAR2
Binary indicator of Primary Contact Record.

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_OBS_EMERGENCY_CONTACT
Short Name: OLS_OBS_EMERGENCY_CONTACT
Status: Completed
Abstract:

This entity represents the list of people who ought to be contacted in the event of any critical event during an observer deployment.

Notes:

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

Entity Information

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

This entity represents the list of people who ought to be contacted in the event of any critical event during an observer deployment.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key EMERGENCY_CONTACT_SEQ NUMBER Sequence generated unique identifier of this emergency contact record
100
OBSERVER_SEQ NUMBER A unique number that identifies a specific observer.
100
NAME VARCHAR2 Full name of contact
100
RELATIONSHIP VARCHAR2 Relationship to Observer.
100
ADDRESS_LINE_1 VARCHAR2 First line of street Address or PO Box
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
BEGIN_EFFECTIVE_DATE DATE Date record becomes effective
100
END_EFFECTIVE_DATE DATE Date record ought to be retired.
100
FRIMARY_CONTACT_FLAG VARCHAR2 Binary indicator of Primary Contact Record.

Attribute Details

EMERGENCY_CONTACT_SEQ

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

Sequence generated unique identifier of this emergency contact record

General Data Type: NUMBER

OBSERVER_SEQ

CC ID: 65326
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

NAME

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

Full name of contact

General Data Type: VARCHAR2

RELATIONSHIP

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

Relationship to Observer.

General Data Type: VARCHAR2

ADDRESS_LINE_1

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

First line of street Address or PO Box

General Data Type: VARCHAR2

ADDRESS_LINE_2

CC ID: 65330
Seq. Order: 6
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: 65331
Seq. Order: 7
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: 65332
Seq. Order: 8
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: 65333
Seq. Order: 9
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: 65334
Seq. Order: 10
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: 65335
Seq. Order: 11
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: 65336
Seq. Order: 12
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

BEGIN_EFFECTIVE_DATE

CC ID: 65337
Seq. Order: 13
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: 65338
Seq. Order: 14
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

FRIMARY_CONTACT_FLAG

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

Binary indicator of Primary Contact Record.

General Data Type: VARCHAR2

Catalog Details

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