Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

Table: EDC_PERSON

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6856  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Physical Location
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table listing persons and their roles for the entry and edit of economic data

Description

Table listing persons and their roles for the entry and edit of economic data

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
PERSON_ID
NUMBER 		Sequential Key to this table
EMAIL
VARCHAR2 		Email address of the person
FIRST_NAME
VARCHAR2 		First name of person
LAST_NAME
VARCHAR2 		Last Name Of The person
TITLE
VARCHAR2 		Title of the person (Mr. Dr, MRS etc)
PWD
VARCHAR2 		Password of the person
IS_ADMIN_FLAG
NUMBER 		DOes the person have the role and responsibility of being an administrator for this system.
IS_ACTIVE_FLAG
NUMBER 		Is the role of the person in question active
LU
DATE 		Date Record was last updated
ORACLE_USER_ID
VARCHAR2 		Oracle userid of the person

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

Table listing persons and their roles for the entry and edit of economic data
Notes:

Loaded by batch 2043, 12-20-2007 08:10

Physical Location

Organization: Southeast Fisheries Science Center
City: Miami
State/Province: FL
Country: USA

Entity Information

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

Table listing persons and their roles for the entry and edit of economic data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key PERSON_ID NUMBER Sequential Key to this table
100
 EMAIL VARCHAR2 Email address of the person
100
 FIRST_NAME VARCHAR2 First name of person
100
 LAST_NAME VARCHAR2 Last Name Of The person
100
 TITLE VARCHAR2 Title of the person (Mr. Dr, MRS etc)
100
 PWD VARCHAR2 Password of the person
100
 IS_ADMIN_FLAG NUMBER DOes the person have the role and responsibility of being an administrator for this system.
100
 IS_ACTIVE_FLAG NUMBER Is the role of the person in question active
100
 LU DATE Date Record was last updated
100
 ORACLE_USER_ID VARCHAR2 Oracle userid of the person

Attribute Details

PERSON_ID

CC ID: 24541
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Sequential Key to this table
General Data Type: NUMBER

EMAIL

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

Email address of the person
General Data Type: VARCHAR2

FIRST_NAME

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

First name of person
General Data Type: VARCHAR2

LAST_NAME

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

Last Name Of The person
General Data Type: VARCHAR2

TITLE

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

Title of the person (Mr. Dr, MRS etc)
General Data Type: VARCHAR2

PWD

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

Password of the person
General Data Type: VARCHAR2

IS_ADMIN_FLAG

CC ID: 24547
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

DOes the person have the role and responsibility of being an administrator for this system.
General Data Type: NUMBER

IS_ACTIVE_FLAG

CC ID: 24548
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Is the role of the person in question active
General Data Type: NUMBER

LU

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

Date Record was last updated
General Data Type: DATE

ORACLE_USER_ID

CC ID: 24550
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Oracle userid of the person
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6856
GUID: gov.noaa.nmfs.inport:6856
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-20 08:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+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