Table: OLS_LOV_EMPLOYER
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:12292 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
List of Companies certified as observer providers. Observers are trained, certified and equiped by NMFS, however are employed by private staffing companies.
DescriptionList of Companies certified as observer providers. Observers are trained, certified and equiped by NMFS, however are employed by private staffing companies.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
EMPLOYER_CODE
VARCHAR2 |
Three letter acronym forced to all caps representing a unique observer contractor - This value is inherited from the old observer logistics system. |
NAME
VARCHAR2 |
Mixed Case company name (DBA) for an observer contractor. |
EMPLOYER_TYPE
VARCHAR2 |
Alpha Code Domain identifying the observer contractors relationship with NMFS (D - Direct, C - Contractor, S - Subcontractor) |
ADDRESS
VARCHAR2 |
Street address for an observer contractor. |
CITY
VARCHAR2 |
Address - City |
STATE
VARCHAR2 |
US State Code |
ZIP
VARCHAR2 |
US Postal Code |
ACTIVE_FLAG
VARCHAR2 |
Boolean indicater for currently operating |
MANAGER
VARCHAR2 |
Company Contact for observer affairs. |
EMAIL
VARCHAR2 |
Primary email adderss for manager. |
PHONE
NUMBER |
Primary phone number for manager |
FAX
NUMBER |
Primary fax number for observer contracting firm. |
NOTES
VARCHAR2 |
Notes regarding observer contractor or procedures. |
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_LOV_EMPLOYER |
---|---|
Short Name: | OLS_LOV_EMPLOYER |
Status: | Completed |
Abstract: |
List of Companies certified as observer providers. Observers are trained, certified and equiped by NMFS, however are employed by private staffing companies. |
Notes: |
Loaded by batch 3083, 04-19-2012 13:25 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
List of Companies certified as observer providers. Observers are trained, certified and equiped by NMFS, however are employed by private staffing companies. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
EMPLOYER_CODE | VARCHAR2 | Three letter acronym forced to all caps representing a unique observer contractor - This value is inherited from the old observer logistics system. |
100
|
NAME | VARCHAR2 | Mixed Case company name (DBA) for an observer contractor. | |
100
|
EMPLOYER_TYPE | VARCHAR2 | Alpha Code Domain identifying the observer contractors relationship with NMFS (D - Direct, C - Contractor, S - Subcontractor) | |
100
|
ADDRESS | VARCHAR2 | Street address for an observer contractor. | |
100
|
CITY | VARCHAR2 | Address - City | |
100
|
STATE | VARCHAR2 | US State Code | |
100
|
ZIP | VARCHAR2 | US Postal Code | |
100
|
ACTIVE_FLAG | VARCHAR2 | Boolean indicater for currently operating | |
100
|
MANAGER | VARCHAR2 | Company Contact for observer affairs. | |
100
|
VARCHAR2 | Primary email adderss for manager. | ||
100
|
PHONE | NUMBER | Primary phone number for manager | |
100
|
FAX | NUMBER | Primary fax number for observer contracting firm. | |
100
|
NOTES | VARCHAR2 | Notes regarding observer contractor or procedures. |
Attribute Details
EMPLOYER_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Three letter acronym forced to all caps representing a unique observer contractor - This value is inherited from the old observer logistics system. |
General Data Type: | VARCHAR2 |
NAME
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mixed Case company name (DBA) for an observer contractor. |
General Data Type: | VARCHAR2 |
EMPLOYER_TYPE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Alpha Code Domain identifying the observer contractors relationship with NMFS (D - Direct, C - Contractor, S - Subcontractor) |
General Data Type: | VARCHAR2 |
ADDRESS
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Street address for an observer contractor. |
General Data Type: | VARCHAR2 |
CITY
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Address - City |
General Data Type: | VARCHAR2 |
STATE
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
US State Code |
General Data Type: | VARCHAR2 |
ZIP
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
US Postal Code |
General Data Type: | VARCHAR2 |
ACTIVE_FLAG
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Boolean indicater for currently operating |
General Data Type: | VARCHAR2 |
MANAGER
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Company Contact for observer affairs. |
General Data Type: | VARCHAR2 |
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Primary email adderss for manager. |
General Data Type: | VARCHAR2 |
PHONE
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 16 |
Scale: | 0 |
Status: | Active |
Description: |
Primary phone number for manager |
General Data Type: | NUMBER |
FAX
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 16 |
Scale: | 0 |
Status: | Active |
Description: |
Primary fax number for observer contracting firm. |
General Data Type: | NUMBER |
NOTES
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Notes regarding observer contractor or procedures. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 12292 |
---|---|
GUID: | gov.noaa.nmfs.inport:12292 |
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 |