Search Help Show/Hide Menu
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 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