Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: USER_PROFILE
Short Name: USER_PROFILE
Status: Completed
Abstract:

Gives Username , Password and prefered defaults

Notes:

Loaded by batch 2007, 12-03-2007 11:22

Entity Information

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

Gives Username , Password and prefered defaults

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key USERNAME VARCHAR2 TIPONLINE user name
100
PASSWORD VARCHAR2 TIPONLINE (encoded) Password
100
AGENCY_ID NUMBER Agency Code Assocaited With User
100
DEFAULT_SAMPLE_STATE_ID VARCHAR2 Default Sample State Id
100
DEFAULT_LANDING_STATE_ID VARCHAR2 Default Landings State Id
100
DEFAULT_TERMINATION_TYPE_ID NUMBER Default Termination Code Id
100
DEFAULT_FISHING_MODE_ID NUMBER Default Fishing Mode Id
100
DEFAULT_LICENCE_AGENCY_ID NUMBER Default License Agency Id
100
DEFAULT_TICKET_AGENCY_ID NUMBER Default Ticket Agency Id
100
DEFAULT_INFORMATION_SOURCE_ID NUMBER Default Information Source Id
100
DEFAULT_INTERVIEW_TYPE_ID NUMBER Defauly Interview Type Id
100
CREATED_BY_USER_ID VARCHAR2 User creating Record
100
CREATED_DATE DATE Date/Time stamp of record creation
100
MODIFIED_BY_USER_ID VARCHAR2 User modifying record
100
MODIFIED_DATE DATE Date/Time stamp of when record was modifed
100
DEFAULT_AGENT_ID VARCHAR2 Default Agency Id
100
AGENT_CODE CHAR Agent Code
100
DEFAULT_REGION_ID NUMBER Default Region Id
100
DEFAULT_LENGTH_TYPE_ID1 NUMBER Default Lenght Type Id
100
DEFAULT_LENGTH_UNIT_ID1 NUMBER Default Length Unit Id
100
DEFAULT_BIAS_TYPE_ID NUMBER Default Bias Type ID
100
DEFAULT_NUMBER_OF_VESSELS NUMBER Default Number Of Vessels To Be displayed in list
100
NBR_OBSERVATION_RECORD_INSERT NUMBER The Default Number Of Observation Records To Be Inserted
100
DEFAULT_LENGTH_INCREMENT NUMBER Default Length Increment

Attribute Details

USERNAME

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

TIPONLINE user name

General Data Type: VARCHAR2

PASSWORD

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

TIPONLINE (encoded) Password

General Data Type: VARCHAR2

AGENCY_ID

CC ID: 23513
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Agency Code Assocaited With User

General Data Type: NUMBER

DEFAULT_SAMPLE_STATE_ID

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

Default Sample State Id

General Data Type: VARCHAR2

DEFAULT_LANDING_STATE_ID

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

Default Landings State Id

General Data Type: VARCHAR2

DEFAULT_TERMINATION_TYPE_ID

CC ID: 23516
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Default Termination Code Id

General Data Type: NUMBER

DEFAULT_FISHING_MODE_ID

CC ID: 23517
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Default Fishing Mode Id

General Data Type: NUMBER

DEFAULT_LICENCE_AGENCY_ID

CC ID: 23518
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Default License Agency Id

General Data Type: NUMBER

DEFAULT_TICKET_AGENCY_ID

CC ID: 23519
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Default Ticket Agency Id

General Data Type: NUMBER

DEFAULT_INFORMATION_SOURCE_ID

CC ID: 23520
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Default Information Source Id

General Data Type: NUMBER

DEFAULT_INTERVIEW_TYPE_ID

CC ID: 23521
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Defauly Interview Type Id

General Data Type: NUMBER

CREATED_BY_USER_ID

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

User creating Record

General Data Type: VARCHAR2

CREATED_DATE

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

Date/Time stamp of record creation

General Data Type: DATE

MODIFIED_BY_USER_ID

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

User modifying record

General Data Type: VARCHAR2

MODIFIED_DATE

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

Date/Time stamp of when record was modifed

General Data Type: DATE

DEFAULT_AGENT_ID

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

Default Agency Id

General Data Type: VARCHAR2

AGENT_CODE

CC ID: 23527
Seq. Order: 17
Data Storage Type: CHAR
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

Agent Code

General Data Type: CHAR

DEFAULT_REGION_ID

CC ID: 23528
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Default Region Id

General Data Type: NUMBER

DEFAULT_LENGTH_TYPE_ID1

CC ID: 23529
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Default Lenght Type Id

General Data Type: NUMBER

DEFAULT_LENGTH_UNIT_ID1

CC ID: 23530
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Default Length Unit Id

General Data Type: NUMBER

DEFAULT_BIAS_TYPE_ID

CC ID: 23531
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Default Bias Type ID

General Data Type: NUMBER

DEFAULT_NUMBER_OF_VESSELS

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

Default Number Of Vessels To Be displayed in list

General Data Type: NUMBER

NBR_OBSERVATION_RECORD_INSERT

CC ID: 23533
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

The Default Number Of Observation Records To Be Inserted

General Data Type: NUMBER

DEFAULT_LENGTH_INCREMENT

CC ID: 23534
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Default Length Increment

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 6700
GUID: gov.noaa.nmfs.inport:6700
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-03 11:22+0000
Metadata Record Last Modified By: Lee M Weinberger
Metadata Record Last Modified: 2021-11-04 13:14+0000
Metadata Record Published: 2021-11-04
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-11-05