Slide Menu
Jump to Section...
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
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: ODDS_REGISTERED_USER_V

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:17392  |  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 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
 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: 84436
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

USER_TYPE

CC ID: 84437
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: 84438
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: 84439
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: 84440
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: 84441
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: 84442
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

SALTED

CC ID: 84443
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: 84444
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: 84445
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: 84446
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

IS_PW_TEMPORARY

CC ID: 84447
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: 84448
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: 84449
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: 84450
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: 84451
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
General Data Type: NUMBER

APP_NAME

CC ID: 84452
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: 84453
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
General Data Type: NUMBER

USER_LAST_EDITED_ON_DATE

CC ID: 84454
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: 84455
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: 84456
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
General Data Type: NUMBER

VESSEL_CONTACT_SEQ

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

Catalog Details

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