Slide Menu
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu

Item Identification

Title: View: OLS_LOV_EMPLOYER
Short Name: OLS_LOV_EMPLOYER
Status: Completed
Notes:

Loaded by batch 3994, 01-03-2013 16:38

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: CUST_AUTH

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
EMPLOYER_CODE VARCHAR2
67
NAME VARCHAR2
67
EMPLOYER_TYPE VARCHAR2
67
ADDRESS VARCHAR2
67
CITY VARCHAR2
67
STATE VARCHAR2
67
ZIP VARCHAR2
67
ACTIVE_FLAG VARCHAR2
67
MANAGER VARCHAR2
67
EMAIL VARCHAR2
67
PHONE NUMBER
67
FAX NUMBER
67
NOTES VARCHAR2

Attribute Details

EMPLOYER_CODE

CC ID: 84458
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

NAME

CC ID: 84459
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

EMPLOYER_TYPE

CC ID: 84460
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

ADDRESS

CC ID: 84461
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

CITY

CC ID: 84462
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

STATE

CC ID: 84463
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

ZIP

CC ID: 84464
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

ACTIVE_FLAG

CC ID: 84465
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

MANAGER

CC ID: 84466
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

EMAIL

CC ID: 84467
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

PHONE

CC ID: 84468
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 16
Scale: 0
Status: Active
General Data Type: NUMBER

FAX

CC ID: 84469
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 16
Scale: 0
Status: Active
General Data Type: NUMBER

NOTES

CC ID: 84470
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 17393
GUID: gov.noaa.nmfs.inport:17393
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-01-03 16:38+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18