Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Custom User Authentication > AFSC/FMA/CAMS Data Objects >

View: OLS_OBSERVER

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

Item Identification

Title: View: OLS_OBSERVER
Short Name: OLS_OBSERVER
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
 OBSERVER_SEQ NUMBER
67
 FIRST_NAME VARCHAR2
67
 LAST_NAME VARCHAR2
67
 MIDDLE_NAME VARCHAR2
67
 LAST_PHYSICAL_DATE DATE
67
 REHIRE_STATUS_CODE VARCHAR2
67
 RESUME_ON_FILE_FLAG VARCHAR2
67
 CREATE_DATE DATE
67
 LAST_UPDATE_DATE DATE
67
 LAST_UPDATED_BY VARCHAR2
67
 CON_AGREE_DATE DATE
67
 LETTER_UNDERSTAND_DATE DATE
67
 DATE_OF_BIRTH DATE
67
 SEX_CODE VARCHAR2

Attribute Details

OBSERVER_SEQ

CC ID: 84471
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
General Data Type: NUMBER

FIRST_NAME

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

LAST_NAME

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

MIDDLE_NAME

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

LAST_PHYSICAL_DATE

CC ID: 84475
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

REHIRE_STATUS_CODE

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

RESUME_ON_FILE_FLAG

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

CREATE_DATE

CC ID: 84478
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

LAST_UPDATE_DATE

CC ID: 84479
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

LAST_UPDATED_BY

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

CON_AGREE_DATE

CC ID: 84481
Seq. Order: 11
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

LETTER_UNDERSTAND_DATE

CC ID: 84482
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

DATE_OF_BIRTH

CC ID: 84483
Seq. Order: 13
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
General Data Type: DATE

SEX_CODE

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

Catalog Details

Catalog Item ID: 17394
GUID: gov.noaa.nmfs.inport:17394
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