Table: OLS_OBS_EMERGENCY_CONTACT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12318 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This entity represents the list of people who ought to be contacted in the event of any critical event during an observer deployment.
DescriptionThis 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |