Table: OBSERVERS
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:9756 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: OBSERVERS |
|---|---|
| Short Name: | OBSERVERS |
| Status: | Completed |
| Abstract: |
The observers table is at the intersection of the ATL and Domestic data sets. As the redevelopment of the NORPAC system extends into observer logistics this object may change in name and structure. |
| Notes: |
Loaded by batch 2390, 06-30-2009 16:11 |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
| UNCONTROLLED | |
| None | AFSC |
| None | ATL |
| None | ATLAS |
| None | BYCATCH |
| None | FMA |
| None | GROUNDFISH |
| None | NORPAC |
| None | OBSERVER |
Spatial Keywords
| Thesaurus | Keyword |
|---|---|
| UNCONTROLLED | |
| None | AI |
| None | ALEUTIAN ISLANDS |
| None | BERING SEA |
| None | BS |
| None | BSAI |
| None | GOA |
| None | GULF OF ALASKA |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | NORPAC |
| Description: |
This table contains information about a specific observer. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
OBSERVER_JOIN | NUMBER | A unique number that identifies a specific observer. |
|
100
|
LAST_NAME | VARCHAR2 | The last name of the observer. | |
|
100
|
MIDDLE_NAME | VARCHAR2 | The middle name of the observer. | |
|
100
|
FIRST_NAME | VARCHAR2 | The first name of the observer. | |
|
100
|
EMAIL_ADDRESS | VARCHAR2 | The e-mail address of the observer. | |
|
100
|
HOLD_LEVEL2_CERTIFICATION_FLAG | VARCHAR2 | A one-digit alpha code. Y = Yes, the observer has Level 2 status; N = No, the observer does not have Level 2 status. | |
|
100
|
REHIRE_STATUS | VARCHAR2 | A two-digit alpha code indicating the rehire status of the observer. EL = eligible for rehire; NE = not eligible for rehire; NA = not applicable (hasn't gone out yet). | |
|
100
|
SEX | VARCHAR2 | The sex of the observer. M = Male; F = Female; U = Unknown. | |
|
100
|
DATE_OF_BIRTH | DATE | The date of the observer's birth. | |
|
100
|
PERMANENT_ADDRESS | VARCHAR2 | The permanent street address of the observer. | |
|
100
|
PERMANENT_CITY | VARCHAR2 | The permanent city address of the observe | |
|
100
|
PERMANENT_STATE | VARCHAR2 | The permanent state address of the observer | |
|
100
|
PERMANENT_ZIPCODE | VARCHAR2 | The permanent zipcode of the observer. | |
|
100
|
PERMANENT_PHONE | NUMBER | The permanent phone number of the observe | |
|
100
|
PREVIOUS_NAME | VARCHAR2 | Any previous name of the observer. | |
|
100
|
RESUME_ON_FILE | VARCHAR2 | A one-digit alpha code indicating whether the observer's resume is on file or not. Y = Yes; N = No. | |
|
100
|
LAST_PHYSICAL_DATE | DATE | The date of the observer's last physical. | |
|
100
|
ARCHIVED_FILE | VARCHAR2 | A one-digit alpha code indicating whether the observer's file is present or not. Y = Yes; N = No. | |
|
100
|
PHOTO_PRESENT | VARCHAR2 | A one-digit alpha code indicating whether the observer's photo is on file or not. Y = Yes; N = No. | |
|
100
|
CREATE_DATE | DATE | Date record was input into database. | |
|
100
|
CREATED_BY | VARCHAR2 | Person who loaded data into database. | |
|
100
|
LAST_UPDATE_DATE | DATE | Date data record was last altered. First entered in December 2003. | |
|
100
|
LAST_UPDATED_BY | VARCHAR2 | Person who last altered data record. First entered in December 2003. |
Attribute Details
OBSERVER_JOIN
CC ID: 39012
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | Yes |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
A unique number that identifies a specific observer. |
| General Data Type: | NUMBER |
LAST_NAME
CC ID: 39007
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The last name of the observer. |
| General Data Type: | VARCHAR2 |
MIDDLE_NAME
CC ID: 39011
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The middle name of the observer. |
| General Data Type: | VARCHAR2 |
FIRST_NAME
CC ID: 39005
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 15 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The first name of the observer. |
| General Data Type: | VARCHAR2 |
EMAIL_ADDRESS
CC ID: 39004
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The e-mail address of the observer. |
| General Data Type: | VARCHAR2 |
HOLD_LEVEL2_CERTIFICATION_FLAG
CC ID: 39006
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
A one-digit alpha code. Y = Yes, the observer has Level 2 status; N = No, the observer does not have Level 2 status. |
| General Data Type: | VARCHAR2 |
REHIRE_STATUS
CC ID: 39020
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
A two-digit alpha code indicating the rehire status of the observer. EL = eligible for rehire; NE = not eligible for rehire; NA = not applicable (hasn't gone out yet). |
| General Data Type: | VARCHAR2 |
| Foreign Key Relations: |
NORPAC.REHIRE_STATUS_CODES |
SEX
CC ID: 39022
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The sex of the observer. M = Male; F = Female; U = Unknown. |
| General Data Type: | VARCHAR2 |
DATE_OF_BIRTH
CC ID: 39003
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The date of the observer's birth. |
| General Data Type: | DATE |
PERMANENT_ADDRESS
CC ID: 39013
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The permanent street address of the observer. |
| General Data Type: | VARCHAR2 |
PERMANENT_CITY
CC ID: 39014
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The permanent city address of the observe |
| General Data Type: | VARCHAR2 |
PERMANENT_STATE
CC ID: 39016
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The permanent state address of the observer |
| General Data Type: | VARCHAR2 |
PERMANENT_ZIPCODE
CC ID: 39017
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The permanent zipcode of the observer. |
| General Data Type: | VARCHAR2 |
PERMANENT_PHONE
CC ID: 39015
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 10 |
| Scale: | 0 |
| Status: | Active |
| Description: |
The permanent phone number of the observe |
| General Data Type: | NUMBER |
PREVIOUS_NAME
CC ID: 39019
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Any previous name of the observer. |
| General Data Type: | VARCHAR2 |
RESUME_ON_FILE
CC ID: 39021
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
A one-digit alpha code indicating whether the observer's resume is on file or not. Y = Yes; N = No. |
| General Data Type: | VARCHAR2 |
LAST_PHYSICAL_DATE
CC ID: 39008
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The date of the observer's last physical. |
| General Data Type: | DATE |
ARCHIVED_FILE
CC ID: 39000
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
A one-digit alpha code indicating whether the observer's file is present or not. Y = Yes; N = No. |
| General Data Type: | VARCHAR2 |
PHOTO_PRESENT
CC ID: 39018
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
A one-digit alpha code indicating whether the observer's photo is on file or not. Y = Yes; N = No. |
| General Data Type: | VARCHAR2 |
CREATE_DATE
CC ID: 39002
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date record was input into database. |
| General Data Type: | DATE |
CREATED_BY
CC ID: 39001
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Person who loaded data into database. |
| General Data Type: | VARCHAR2 |
LAST_UPDATE_DATE
CC ID: 39010
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date data record was last altered. First entered in December 2003. |
| General Data Type: | DATE |
LAST_UPDATED_BY
CC ID: 39009
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Person who last altered data record. First entered in December 2003. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 9756 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:9756 |
| Metadata Record Created By: | Doug Turnbull |
| Metadata Record Created: | 2009-06-30 16:11+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 |