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

Summary

Abstract

Hold user information

Description

Hold user information

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
USER_NAME
VARCHAR2
Name
USER_PASSWORD
VARCHAR2
Password
HAS_DELETE
VARCHAR2
Can this user delete?
HAS_DATA_ENTRY
VARCHAR2
Can this user entry data
HAS_DATA_MANAGER
VARCHAR2
Is this user a data manager?
CREATED_BY_USER_ID
VARCHAR2
Created by whom
CREATED_DATE
DATE
Created when
MODIFIED_BY_USER_ID
VARCHAR2
Last modified by whom
MODIFIED_DATE
DATE
Last modified when

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

Hold user information

Notes:

Loaded by batch 1683, 10-12-2007 05:01

Entity Information

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

Hold user information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key USER_NAME VARCHAR2 Name
100
USER_PASSWORD VARCHAR2 Password
100
HAS_DELETE VARCHAR2 Can this user delete?
100
HAS_DATA_ENTRY VARCHAR2 Can this user entry data
100
HAS_DATA_MANAGER VARCHAR2 Is this user a data manager?
100
CREATED_BY_USER_ID VARCHAR2 Created by whom
100
CREATED_DATE DATE Created when
100
MODIFIED_BY_USER_ID VARCHAR2 Last modified by whom
100
MODIFIED_DATE DATE Last modified when

Attribute Details

USER_NAME

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

Name

General Data Type: VARCHAR2

USER_PASSWORD

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

Password

General Data Type: VARCHAR2

HAS_DELETE

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

Can this user delete?

General Data Type: VARCHAR2

HAS_DATA_ENTRY

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

Can this user entry data

General Data Type: VARCHAR2

HAS_DATA_MANAGER

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

Is this user a data manager?

General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Created by whom

General Data Type: VARCHAR2

CREATED_DATE

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

Created when

General Data Type: DATE

MODIFIED_BY_USER_ID

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

Last modified by whom

General Data Type: VARCHAR2

MODIFIED_DATE

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

Last modified when

General Data Type: DATE

Catalog Details

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