Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Standardization of permits > Dealer Management System > Standardization Of Dealers >

Table: DMS_USERS

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7305  |  Updated: August 9, 2022  |  Published / External 
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