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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data View

Data Attribute / Type Description
OBSERVER_SEQ
NUMBER
FIRST_NAME
VARCHAR2
LAST_NAME
VARCHAR2
MIDDLE_NAME
VARCHAR2
LAST_PHYSICAL_DATE
DATE
REHIRE_STATUS_CODE
VARCHAR2
RESUME_ON_FILE_FLAG
VARCHAR2
CREATE_DATE
DATE
LAST_UPDATE_DATE
DATE
LAST_UPDATED_BY
VARCHAR2
CON_AGREE_DATE
DATE
LETTER_UNDERSTAND_DATE
DATE
DATE_OF_BIRTH
DATE
SEX_CODE
VARCHAR2

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