Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Economic Data Collections for Gulf of Mexico &... > Economic Data Collection for Gulf of Mexico Sou... >

Table: USER_PROFILE

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

Summary

Abstract

The control table used to identify users to the system and record their passwords.

Description

The control table used to identify users to the system and record their passwords.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
USERNAME
VARCHAR2 		The oracle id of the system user
PASSWORD
VARCHAR2 		The password of the user.
CREATED_BY_USER_ID
VARCHAR2 		An application controlled field showing the userid of the person inserting a record
CREATED_DATE
DATE 		An application controlled field showing the date and time the record was inserted into the Oracle table
MODIFIED_BY_USER_ID
VARCHAR2 		The userid of the last person to edit the data
MODIFIED_DATE
DATE 		The date of the last update to the record

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

The control table used to identify users to the system and record their passwords.
Notes:

Loaded by batch 1643, 10-10-2007 10:43

Entity Information

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

The control table used to identify users to the system and record their passwords.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key USERNAME VARCHAR2 The oracle id of the system user
100
 PASSWORD VARCHAR2 The password of the user.
100
 CREATED_BY_USER_ID VARCHAR2 An application controlled field showing the userid of the person inserting a record
100
 CREATED_DATE DATE An application controlled field showing the date and time the record was inserted into the Oracle table
100
 MODIFIED_BY_USER_ID VARCHAR2 The userid of the last person to edit the data
100
 MODIFIED_DATE DATE The date of the last update to the record

Attribute Details

USERNAME

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

The oracle id of the system user
General Data Type: VARCHAR2

PASSWORD

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

The password of the user.
General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

An application controlled field showing the userid of the person inserting a record
General Data Type: VARCHAR2

CREATED_DATE

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

An application controlled field showing the date and time the record was inserted into the Oracle table
General Data Type: DATE

MODIFIED_BY_USER_ID

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

The userid of the last person to edit the data
General Data Type: VARCHAR2

MODIFIED_DATE

CC ID: 15406
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date of the last update to the record
General Data Type: DATE

Catalog Details

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