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
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
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
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 |