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

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