Table: ODDS_USER_VESSEL
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:18868 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Table: ODDS_USER_VESSEL |
---|---|
Short Name: | ODDS_USER_VESSEL |
Status: | Completed |
Abstract: |
This entity represents the intersection of a registered user, particularly vessel owners or captains to a fishing vessel which is participating in the program. This table functions as a reference for the application for those instances where trips are logged or edited by vessel owners or captains. Trigger code on the odds trip plan log identifies the user by type and when appropriate validates its existance here. NMFS staff and Enforcement (Call Center) staff are of a different user type and validated directly to the ODDS_Registered_User_V. |
Notes: |
Loaded by batch 4561, 04-30-2013 18:33 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
This entity represents the intersection of a registered user, particularly vessel owners or captains to a fishing vessel which is participating in the program. This table functions as a reference for the application for those instances where trips are logged or edited by vessel owners or captains. Trigger code on the odds trip plan log identifies the user by type and when appropriate validates its existance here. NMFS staff and Enforcement (Call Center) staff are of a different user type and validated directly to the ODDS_Registered_User_V. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ODDS_USER_VESSEL_SEQ | NUMBER | primary key sequence | |
100
|
VESSEL_SEQ | NUMBER | vessel seq in ATL_LOV_VESSEL | |
100
|
USER_SEQ | NUMBER | user sequence that belongs with vessel |
Attribute Details
ODDS_USER_VESSEL_SEQ
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
primary key sequence |
General Data Type: | NUMBER |
VESSEL_SEQ
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
vessel seq in ATL_LOV_VESSEL |
General Data Type: | NUMBER |
USER_SEQ
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
user sequence that belongs with vessel |
General Data Type: | NUMBER |
Foreign Key Relations: |
CUST_AUTH.CAM_USERS |
Catalog Details
Catalog Item ID: | 18868 |
---|---|
GUID: | gov.noaa.nmfs.inport:18868 |
Metadata Record Created By: | Doug Turnbull |
Metadata Record Created: | 2013-04-30 18:33+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-18 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-18 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-18 |