Table: USER_PROFILE
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5290 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
The control table used to identify users to the system and record their passwords.
DescriptionThe control table used to identify users to the system and record their passwords.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
USERNAME
VARCHAR2 |
The oracle id of the system user |
PASSWORD
VARCHAR2 |
The password of the user. |
CREATED_BY_USER_ID
VARCHAR2 |
An application controlled field showing the userid of the person inserting a record |
CREATED_DATE
DATE |
An application controlled field showing the date and time the record was inserted into the Oracle table |
MODIFIED_BY_USER_ID
VARCHAR2 |
The userid of the last person to edit the data |
MODIFIED_DATE
DATE |
The date of the last update to the record |
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: |
The control table used to identify users to the system and record their passwords. |
Notes: |
Loaded by batch 1643, 10-10-2007 10:43 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | EC_SRV_GS |
Description: |
The control table used to identify users to the system and record their passwords. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
USERNAME | VARCHAR2 | The oracle id of the system user | |
100
|
PASSWORD | VARCHAR2 | The password of the user. | |
100
|
CREATED_BY_USER_ID | VARCHAR2 | An application controlled field showing the userid of the person inserting a record | |
100
|
CREATED_DATE | DATE | An application controlled field showing the date and time the record was inserted into the Oracle table | |
100
|
MODIFIED_BY_USER_ID | VARCHAR2 | The userid of the last person to edit the data | |
100
|
MODIFIED_DATE | DATE | The date of the last update to the record |
Attribute Details
USERNAME
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
The oracle id of the system user |
General Data Type: | VARCHAR2 |
PASSWORD
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The password of the user. |
General Data Type: | VARCHAR2 |
CREATED_BY_USER_ID
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
An application controlled field showing the userid of the person inserting a record |
General Data Type: | VARCHAR2 |
CREATED_DATE
Seq. Order: | 4 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
An application controlled field showing the date and time the record was inserted into the Oracle table |
General Data Type: | DATE |
MODIFIED_BY_USER_ID
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The userid of the last person to edit the data |
General Data Type: | VARCHAR2 |
MODIFIED_DATE
Seq. Order: | 6 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date of the last update to the record |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 5290 |
---|---|
GUID: | gov.noaa.nmfs.inport:5290 |
Metadata Record Created By: | Lee M Weinberger |
Metadata Record Created: | 2007-10-10 10:43+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-07 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-07 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-07 |