Table: VERS_ASSOCIATE_TYPES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34233 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table lists the available associate types used by the VERS Web Portal; similar to Oracle roles
DescriptionTable lists the available associate types used by the VERS Web Portal; similar to Oracle roles
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
ASSOCIATE_TYPE
VARCHAR2 |
Associate type code |
ASSOCIATE_TYPE_DESCR
VARCHAR2 |
Associate type code description |
ASSOCIATE_RULE
VARCHAR2 |
Code governing associate data access; P='Program', ASSOCIATE_TYPE is able to access data for trips reported by vessels within a specified program; V='Vessel', ASSOCIATE_TYPE is able to access data for trips reported by a specified vessel; (null), ASSOCIATE_TYPE is only able to access data for trips reported while they were the operator |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: VERS_ASSOCIATE_TYPES |
---|---|
Short Name: | VERS_ASSOCIATE_TYPES |
Status: | Completed |
Abstract: |
Table lists the available associate types used by the VERS Web Portal; similar to Oracle roles |
Notes: |
Loaded by batch 9189, 08-11-2016 10:02 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | FVTR |
Description: |
Table lists the available associate types used by the VERS Web Portal; similar to Oracle roles |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
ASSOCIATE_TYPE | VARCHAR2 | Associate type code |
100
|
ASSOCIATE_TYPE_DESCR | VARCHAR2 | Associate type code description | |
100
|
ASSOCIATE_RULE | VARCHAR2 | Code governing associate data access; P='Program', ASSOCIATE_TYPE is able to access data for trips reported by vessels within a specified program; V='Vessel', ASSOCIATE_TYPE is able to access data for trips reported by a specified vessel; (null), ASSOCIATE_TYPE is only able to access data for trips reported while they were the operator |
Attribute Details
ASSOCIATE_TYPE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Associate type code |
General Data Type: | VARCHAR2 |
ASSOCIATE_TYPE_DESCR
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Associate type code description |
General Data Type: | VARCHAR2 |
ASSOCIATE_RULE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code governing associate data access; P='Program', ASSOCIATE_TYPE is able to access data for trips reported by vessels within a specified program; V='Vessel', ASSOCIATE_TYPE is able to access data for trips reported by a specified vessel; (null), ASSOCIATE_TYPE is only able to access data for trips reported while they were the operator |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 34233 |
---|---|
GUID: | gov.noaa.nmfs.inport:34233 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-08-11 10:02+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-08-23 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-08-23 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-08-23 |