Slide Menu
Search Help Show/Hide Menu

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