Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Marine Mammal and Turtle Division > SEFSC Marine Turtle > Miami Turtles Projects > Sea Turtle Stranding and Salvage Network > Marine turtle stranding data - Sea Turtle Stran... >

Table: USER_PROFILES

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:28404  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Lists Approved Users For The system

Description

Lists Approved Users For The system

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		no-comment
FULLNAME
VARCHAR2 		no-comment
USERNAME
VARCHAR2 		no-comment
PASSWORD
VARCHAR2 		no-comment
EMAIL
VARCHAR2 		no-comment
STATE_CODE
VARCHAR2 		no-comment
ROLE_ID
NUMBER 		no-comment
IS_ACTIVE
VARCHAR2 		no-comment

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: USER_PROFILES
Short Name: USER_PROFILES
Status: Completed
Abstract:

Lists Approved Users For The system
Notes:

Loaded by batch 7464, 10-29-2015 15:36

Entity Information

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

Lists Approved Users For The system

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ID NUMBER no-comment
100
 FULLNAME VARCHAR2 no-comment
100
 USERNAME VARCHAR2 no-comment
100
 PASSWORD VARCHAR2 no-comment
100
 EMAIL VARCHAR2 no-comment
100
 STATE_CODE VARCHAR2 no-comment
100
 ROLE_ID NUMBER no-comment
100
 IS_ACTIVE VARCHAR2 no-comment

Attribute Details

ID

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

no-comment
General Data Type: NUMBER

FULLNAME

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

no-comment
General Data Type: VARCHAR2

USERNAME

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

no-comment
General Data Type: VARCHAR2

PASSWORD

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

no-comment
General Data Type: VARCHAR2

EMAIL

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

no-comment
General Data Type: VARCHAR2

STATE_CODE

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

no-comment
General Data Type: VARCHAR2

ROLE_ID

CC ID: 240522
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

no-comment
General Data Type: NUMBER
Foreign Key Relations:

STSSN.ROLES

IS_ACTIVE

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

no-comment
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 28404
GUID: gov.noaa.nmfs.inport:28404
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2015-10-29 15:36+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-04-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-04-29