Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

List Of AUthorized Users For The Dealer Management System

Description

List Of AUthorized Users For The Dealer Management System

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ROLE_CODE
VARCHAR2
9999 for administrator, 1000 for quality assurance, 2000 reports only
USER_NAME
VARCHAR2
Name Of User
USER_PWD
VARCHAR2
User Password
EMAIL
VARCHAR2
User email address
PHONE_NBR
VARCHAR2
User Phone
NOTES
VARCHAR2
Extra Notes On User
USER_ID
VARCHAR2
Oracle Id Of The User

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: Table: DMS_USERS
Short Name: DMS_USERS
Status: Completed
Abstract:

List Of AUthorized Users For The Dealer Management System

Notes:

Loaded by batch 2163, 03-26-2008 16:04

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: DMS
Description:

List Of AUthorized Users For The Dealer Management System

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ROLE_CODE VARCHAR2 9999 for administrator, 1000 for quality assurance, 2000 reports only
100
USER_NAME VARCHAR2 Name Of User
100
USER_PWD VARCHAR2 User Password
100
EMAIL VARCHAR2 User email address
100
PHONE_NBR VARCHAR2 User Phone
100
NOTES VARCHAR2 Extra Notes On User
100
Primary Key USER_ID VARCHAR2 Oracle Id Of The User

Attribute Details

ROLE_CODE

CC ID: 27985
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

9999 for administrator, 1000 for quality assurance, 2000 reports only

General Data Type: VARCHAR2

USER_NAME

CC ID: 27986
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Name Of User

General Data Type: VARCHAR2

USER_PWD

CC ID: 27987
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: No
Status: Active
Description:

User Password

General Data Type: VARCHAR2

EMAIL

CC ID: 27988
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

User email address

General Data Type: VARCHAR2

PHONE_NBR

CC ID: 27989
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

User Phone

General Data Type: VARCHAR2

NOTES

CC ID: 27990
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Extra Notes On User

General Data Type: VARCHAR2

USER_ID

CC ID: 27991
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active
Description:

Oracle Id Of The User

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7305
GUID: gov.noaa.nmfs.inport:7305
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-03-26 16:04+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-06
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-06