Table: OLS_OBSERVER_CONTACT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12311 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |