Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Observer Restructure (ODDS) > AFSC/FMA/Observer Declare and Deploy (Resturctu... >

View: ODDS_REGISTERED_USER_V

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:18864  |  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
USER_SEQ
NUMBER
USER_TYPE
VARCHAR2
ACTIVE_USER
VARCHAR2
ODDS_USER_ID
VARCHAR2
FIRST_NAME
VARCHAR2
MIDDLE_INITIAL
VARCHAR2
LAST_NAME
VARCHAR2
SALTED
VARCHAR2
EMPLOYER_CODE
VARCHAR2
LAST_LOGIN_DATE
TIMESTAMP(4)
PARENT_USER_SEQ
NUMBER
IS_PW_TEMPORARY
VARCHAR2
PRIMARY_EMAIL
VARCHAR2
PRIMARY_PHONE
VARCHAR2
APP_CODE
VARCHAR2
APP_SEQ
NUMBER
APP_NAME
VARCHAR2
LOV_USER_TYPE_SEQ
NUMBER
USER_LAST_EDITED_ON_DATE
TIMESTAMP(4)
PASSWORD_CHANGED_TIMESTAMP
TIMESTAMP(4) WITH LOCAL TIME Z
USER_X_USERTYPE_SEQ
NUMBER
VESSEL_CONTACT_SEQ
NUMBER

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: ODDS_REGISTERED_USER_V
Short Name: ODDS_REGISTERED_USER_V
Status: Completed
Notes:

Loaded by batch 4561, 04-30-2013 18:33

Entity Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 USER_SEQ NUMBER
67
 USER_TYPE VARCHAR2
67
 ACTIVE_USER VARCHAR2
67
 ODDS_USER_ID VARCHAR2
67
 FIRST_NAME VARCHAR2
67
 MIDDLE_INITIAL VARCHAR2
67
 LAST_NAME VARCHAR2
67
 SALTED VARCHAR2
67
 EMPLOYER_CODE VARCHAR2
67
 LAST_LOGIN_DATE TIMESTAMP(4)
67
 PARENT_USER_SEQ NUMBER
67
 IS_PW_TEMPORARY VARCHAR2
67
 PRIMARY_EMAIL VARCHAR2
67
 PRIMARY_PHONE VARCHAR2
67
 APP_CODE VARCHAR2
67
 APP_SEQ NUMBER
67
 APP_NAME VARCHAR2
67
 LOV_USER_TYPE_SEQ NUMBER
67
 USER_LAST_EDITED_ON_DATE TIMESTAMP(4)
67
 PASSWORD_CHANGED_TIMESTAMP TIMESTAMP(4) WITH LOCAL TIME Z
67
 USER_X_USERTYPE_SEQ NUMBER
67
 VESSEL_CONTACT_SEQ NUMBER

Attribute Details

USER_SEQ

CC ID: 108065
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
General Data Type: NUMBER

USER_TYPE

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

ACTIVE_USER

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

ODDS_USER_ID

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

FIRST_NAME

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

MIDDLE_INITIAL

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

LAST_NAME

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

SALTED

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

EMPLOYER_CODE

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

LAST_LOGIN_DATE

CC ID: 108066
Seq. Order: 10
Data Storage Type: TIMESTAMP(4)
Max Length: 11
Required: No
Primary Key: No
Scale: 4
Status: Active
General Data Type: TIMESTAMP(4)

PARENT_USER_SEQ

CC ID: 108067
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
General Data Type: NUMBER

IS_PW_TEMPORARY

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

PRIMARY_EMAIL

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

PRIMARY_PHONE

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

APP_CODE

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

APP_SEQ

CC ID: 108072
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

APP_NAME

CC ID: 108073
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 100
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

LOV_USER_TYPE_SEQ

CC ID: 108074
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

USER_LAST_EDITED_ON_DATE

CC ID: 108075
Seq. Order: 19
Data Storage Type: TIMESTAMP(4)
Max Length: 11
Required: Yes
Primary Key: No
Scale: 4
Status: Active
General Data Type: TIMESTAMP(4)

PASSWORD_CHANGED_TIMESTAMP

CC ID: 108077
Seq. Order: 20
Data Storage Type: TIMESTAMP(4) WITH LOCAL TIME Z
Max Length: 11
Required: No
Primary Key: No
Scale: 4
Status: Active
General Data Type: TIMESTAMP(4) WITH LOCAL TIME Z

USER_X_USERTYPE_SEQ

CC ID: 108078
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
General Data Type: NUMBER

VESSEL_CONTACT_SEQ

CC ID: 108079
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 18864
GUID: gov.noaa.nmfs.inport:18864
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-04-30 18:33+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