Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Marine Mammal and Turtle Division > SEFSC Marine Mammal Projects > Marine Mammals Miami > Biscayne Bay Dolphin Photo ID System > Biscayne Bay Dolphin Photo ID System >

Table: USER_PROFILE

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7821  |  Updated: August 9, 2022  |  Published / External 

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