Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > North Pacific (NORPAC) Groundfish and Halibut O... > AFSC/FMA/Observer Logistics System (OLS) >

Table: OLS_LOV_EMPLOYER

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:12292 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

List of Companies certified as observer providers. Observers are trained, certified and equiped by NMFS, however are employed by private staffing companies.

Description

List of Companies certified as observer providers. Observers are trained, certified and equiped by NMFS, however are employed by private staffing companies.

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.

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

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 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.

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	EMAIL	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.

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

CC ID: 65169

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

CC ID: 65170

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

CC ID: 65171

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

CC ID: 65172

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

CC ID: 65173

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

CC ID: 65174

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

CC ID: 65175

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

CC ID: 65176

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

CC ID: 65177

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

EMAIL

CC ID: 65178

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

CC ID: 65179

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

CC ID: 65180

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

CC ID: 65181

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 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

Table: OLS_LOV_EMPLOYER

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

EMPLOYER_CODE

NAME

EMPLOYER_TYPE

ADDRESS

CITY

STATE

ZIP

ACTIVE_FLAG

MANAGER

EMAIL

PHONE

FAX

NOTES

Catalog Details