Slide Menu
Search Help Show/Hide Menu

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: Lee M Weinberger
Metadata Record Last Modified: 2021-04-29 15:30+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year