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

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:17374  |  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_ID
VARCHAR2
ACCOUNT_STATUS
VARCHAR2
APP_CODE
VARCHAR2
APP_SEQ
NUMBER
APP_NAME
VARCHAR2
USER_TYPE_CODE
VARCHAR2
LOV_USER_TYPE_SEQ
NUMBER
USER_LAST_EDITED_ON_DATE
TIMESTAMP(4)
PASSWORD_CHANGED_TIMESTAMP
TIMESTAMP(4) WITH LOCAL TIME Z
LAST_LOGIN_TIMESTAMP
TIMESTAMP(4)
USER_X_USERTYPE_SEQ
NUMBER
PARENT_USER_SEQ
NUMBER
PRIMARY_EMAIL
VARCHAR2
FIRST_NAME
VARCHAR2
MIDDLE_INITIAL
VARCHAR2
LAST_NAME
VARCHAR2

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: APP_USER_MATRIX_V
Short Name: APP_USER_MATRIX_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_ID VARCHAR2
67
 ACCOUNT_STATUS VARCHAR2
67
 APP_CODE VARCHAR2
67
 APP_SEQ NUMBER
67
 APP_NAME VARCHAR2
67
 USER_TYPE_CODE 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
 LAST_LOGIN_TIMESTAMP TIMESTAMP(4)
67
 USER_X_USERTYPE_SEQ NUMBER
67
 PARENT_USER_SEQ NUMBER
67
 PRIMARY_EMAIL VARCHAR2
67
 FIRST_NAME VARCHAR2
67
 MIDDLE_INITIAL VARCHAR2
67
 LAST_NAME VARCHAR2

Attribute Details

USER_SEQ

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

USER_ID

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

ACCOUNT_STATUS

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

APP_CODE

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

APP_SEQ

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

APP_NAME

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

USER_TYPE_CODE

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

LOV_USER_TYPE_SEQ

CC ID: 84179
Seq. Order: 8
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: 84180
Seq. Order: 9
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: 84181
Seq. Order: 10
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

LAST_LOGIN_TIMESTAMP

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

USER_X_USERTYPE_SEQ

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

PARENT_USER_SEQ

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

PRIMARY_EMAIL

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

FIRST_NAME

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

MIDDLE_INITIAL

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

LAST_NAME

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

Catalog Details

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