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

Summary

Abstract

System profile/security table

Description

System profile/security table

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER
Sequential Key/Code
USERNAME
VARCHAR2
Oracle Userid/Usercode
PASSWORD
VARCHAR2
Encoded Password
PARTNER_CODE
VARCHAR2
Foreign Key To Partner Table
SECURITY_LEVEL_ID
NUMBER
Code To Indicate Privileges Of The Indicated User
FIRST_NAME
VARCHAR2
Data Manger/User First Name
LAST_NAME
VARCHAR2
Data Manager/User Last Name
ORGANIZATION
VARCHAR2
Organization Associated With User/Manager
TELEPHONE
VARCHAR2
Telephone Numer Associated With User/Manager
EMAIL
VARCHAR2
Electronic Mail Address of User/Manager
CREATED_DATE
DATE
Control Column Indicating WHen This Record Was Created
UPLOADED_DATE
DATE
Control Column To Indicate When Record as Last Uploaded
MODIFIED_DATE
DATE
Control COlumn Indiccating When This Record Was Last Modified

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:

System profile/security table

Notes:

Loaded by batch 2223, 08-11-2008 14:27

Entity Information

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

System profile/security table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER Sequential Key/Code
100
USERNAME VARCHAR2 Oracle Userid/Usercode
100
PASSWORD VARCHAR2 Encoded Password
100
PARTNER_CODE VARCHAR2 Foreign Key To Partner Table
100
SECURITY_LEVEL_ID NUMBER Code To Indicate Privileges Of The Indicated User
100
FIRST_NAME VARCHAR2 Data Manger/User First Name
100
LAST_NAME VARCHAR2 Data Manager/User Last Name
100
ORGANIZATION VARCHAR2 Organization Associated With User/Manager
100
TELEPHONE VARCHAR2 Telephone Numer Associated With User/Manager
100
EMAIL VARCHAR2 Electronic Mail Address of User/Manager
100
CREATED_DATE DATE Control Column Indicating WHen This Record Was Created
100
UPLOADED_DATE DATE Control Column To Indicate When Record as Last Uploaded
100
MODIFIED_DATE DATE Control COlumn Indiccating When This Record Was Last Modified

Attribute Details

ID

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

Sequential Key/Code

General Data Type: NUMBER

USERNAME

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

Oracle Userid/Usercode

General Data Type: VARCHAR2

PASSWORD

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

Encoded Password

General Data Type: VARCHAR2

PARTNER_CODE

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

Foreign Key To Partner Table

General Data Type: VARCHAR2

SECURITY_LEVEL_ID

CC ID: 30992
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Code To Indicate Privileges Of The Indicated User

General Data Type: NUMBER

FIRST_NAME

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

Data Manger/User First Name

General Data Type: VARCHAR2

LAST_NAME

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

Data Manager/User Last Name

General Data Type: VARCHAR2

ORGANIZATION

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

Organization Associated With User/Manager

General Data Type: VARCHAR2

TELEPHONE

CC ID: 30988
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Telephone Numer Associated With User/Manager

General Data Type: VARCHAR2

EMAIL

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

Electronic Mail Address of User/Manager

General Data Type: VARCHAR2

CREATED_DATE

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

Control Column Indicating WHen This Record Was Created

General Data Type: DATE

UPLOADED_DATE

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

Control Column To Indicate When Record as Last Uploaded

General Data Type: DATE

MODIFIED_DATE

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

Control COlumn Indiccating When This Record Was Last Modified

General Data Type: DATE

Catalog Details

Catalog Item ID: 7821
GUID: gov.noaa.nmfs.inport:7821
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-08-11 14:27+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