Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Observer Restructure (ODDS) > Vessel Assessment Logging System (VALS) > AFSC/FMA/Vessel Assessment Logging >

Table: VAS_VESSEL_ASSESSMENT

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:24085  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
VESSEL_ASSESSMENT_SEQ
NUMBER 		Primary sequence key.
VESSEL_SEQ
NUMBER 		Primary sequence key from ATL_LOV_VESSEL table. Mandatory field
DETERMINATION_DATE
DATE 		Date when NMFS determined if the vessel is suitable for accomodating observer or not.
DETERMINATION_REASON
VARCHAR2 		Inspection result determined after inspection. "Suitable for Accomodating Observer", "Unsuitable for Accomodating Observer"
RELEASE_TYPE_SEQ
NUMBER 		Primary sequence key from VAS_LOV_RELEASE_TYPE table.
COND_RELEASE_EXPIRE_DATE
DATE 		Date when the conditional release expired. For release type "P" and "N" expiration date should be null, for type "C" it must be provided.
CR_REQUESTED_DATE
DATE 		Date when conditiona release requested submitted from vessel owner. Required field.
ASSESSMENT_STATUS_SEQ
NUMBER 		Primary sequence key from VAS_LOV_ASSESSMENT_STATUS table.
USER_SEQ
NUMBER 		Staff who made final decision on determination. Foreign key to CUST_AUTH.CAM_USERS.
SUBMIT_BY_USER_SEQ
NUMBER 		User who create vessel assessment . Foreign key to CUST_AUTH.CAM_USERS.
RMD_CHANGED_BY
VARCHAR2 		The user who changed the record lastly.
RMD_TS_CHANGED
TIMESTAMP(6) 		The date and time on which the record was changed lastly.
RMD_ACTION
VARCHAR2 		last action performed on the record. I for Insert, U for Update, R for Revert and D for Delete. Delete only recorded on history record.
RMD_CHANGE_COMMENT
VARCHAR2 		Comment for data change.
COND_RELEASE_EFFECTIVE_DATE
DATE 		Date when the conditional release begins to take effect.
FISHING_YEAR
NUMBER 		4-digit year for fishing.
FISHING_TIME_INTERVAL
NUMBER 		Fishing time interval for vessel selection vessels.
VESSEL_SAMPLE_PLAN_SEQ
NUMBER 		primary key of ODDS_VESSEL_SAMPLE_PLAN.
DETERM_REASON_CATEGORY_CODE
VARCHAR2 		Determination reason category code, fk from VAS_LOV_DETERM_REASON_CTGRY.
MAXIMUM_CREW_CAPACITY
NUMBER 		Maximum number of crews the vessel can hold.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Item Identification

Title: Table: VAS_VESSEL_ASSESSMENT
Short Name: VAS_VESSEL_ASSESSMENT
Status: Completed
Notes:

Loaded by batch 5652, 03-17-2015 18:40

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key VESSEL_ASSESSMENT_SEQ NUMBER Primary sequence key.
100
 VESSEL_SEQ NUMBER Primary sequence key from ATL_LOV_VESSEL table. Mandatory field
100
 DETERMINATION_DATE DATE Date when NMFS determined if the vessel is suitable for accomodating observer or not.
100
 DETERMINATION_REASON VARCHAR2 Inspection result determined after inspection. "Suitable for Accomodating Observer", "Unsuitable for Accomodating Observer"
100
 RELEASE_TYPE_SEQ NUMBER Primary sequence key from VAS_LOV_RELEASE_TYPE table.
100
 COND_RELEASE_EXPIRE_DATE DATE Date when the conditional release expired. For release type "P" and "N" expiration date should be null, for type "C" it must be provided.
100
 CR_REQUESTED_DATE DATE Date when conditiona release requested submitted from vessel owner. Required field.
100
 ASSESSMENT_STATUS_SEQ NUMBER Primary sequence key from VAS_LOV_ASSESSMENT_STATUS table.
100
 USER_SEQ NUMBER Staff who made final decision on determination. Foreign key to CUST_AUTH.CAM_USERS.
100
 SUBMIT_BY_USER_SEQ NUMBER User who create vessel assessment . Foreign key to CUST_AUTH.CAM_USERS.
100
 RMD_CHANGED_BY VARCHAR2 The user who changed the record lastly.
100
 RMD_TS_CHANGED TIMESTAMP(6) The date and time on which the record was changed lastly.
100
 RMD_ACTION VARCHAR2 last action performed on the record. I for Insert, U for Update, R for Revert and D for Delete. Delete only recorded on history record.
100
 RMD_CHANGE_COMMENT VARCHAR2 Comment for data change.
100
 COND_RELEASE_EFFECTIVE_DATE DATE Date when the conditional release begins to take effect.
100
 FISHING_YEAR NUMBER 4-digit year for fishing.
100
 FISHING_TIME_INTERVAL NUMBER Fishing time interval for vessel selection vessels.
100
 VESSEL_SAMPLE_PLAN_SEQ NUMBER primary key of ODDS_VESSEL_SAMPLE_PLAN.
100
 DETERM_REASON_CATEGORY_CODE VARCHAR2 Determination reason category code, fk from VAS_LOV_DETERM_REASON_CTGRY.
100
 MAXIMUM_CREW_CAPACITY NUMBER Maximum number of crews the vessel can hold.

Attribute Details

VESSEL_ASSESSMENT_SEQ

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

Primary sequence key.
General Data Type: NUMBER

VESSEL_SEQ

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

Primary sequence key from ATL_LOV_VESSEL table. Mandatory field
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ATL_LOV_VESSEL

DETERMINATION_DATE

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

Date when NMFS determined if the vessel is suitable for accomodating observer or not.
General Data Type: DATE

DETERMINATION_REASON

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

Inspection result determined after inspection. "Suitable for Accomodating Observer", "Unsuitable for Accomodating Observer"
General Data Type: VARCHAR2

RELEASE_TYPE_SEQ

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

Primary sequence key from VAS_LOV_RELEASE_TYPE table.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.VAS_LOV_RELEASE_TYPE

COND_RELEASE_EXPIRE_DATE

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

Date when the conditional release expired. For release type "P" and "N" expiration date should be null, for type "C" it must be provided.
General Data Type: DATE

CR_REQUESTED_DATE

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

Date when conditiona release requested submitted from vessel owner. Required field.
General Data Type: DATE

ASSESSMENT_STATUS_SEQ

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

Primary sequence key from VAS_LOV_ASSESSMENT_STATUS table.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.VAS_LOV_ASSESSMENT_STAT

USER_SEQ

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

Staff who made final decision on determination. Foreign key to CUST_AUTH.CAM_USERS.
General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_USERS

SUBMIT_BY_USER_SEQ

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

User who create vessel assessment . Foreign key to CUST_AUTH.CAM_USERS.
General Data Type: NUMBER
Foreign Key Relations:

CUST_AUTH.CAM_USERS

RMD_CHANGED_BY

CC ID: 193933
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

The user who changed the record lastly.
General Data Type: VARCHAR2

RMD_TS_CHANGED

CC ID: 193934
Seq. Order: 12
Data Storage Type: TIMESTAMP(6)
Max Length: 11
Required: No
Primary Key: No
Scale: 6
Status: Active
Description:

The date and time on which the record was changed lastly.
General Data Type: TIMESTAMP(6)

RMD_ACTION

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

last action performed on the record. I for Insert, U for Update, R for Revert and D for Delete. Delete only recorded on history record.
General Data Type: VARCHAR2

RMD_CHANGE_COMMENT

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

Comment for data change.
General Data Type: VARCHAR2

COND_RELEASE_EFFECTIVE_DATE

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

Date when the conditional release begins to take effect.
General Data Type: DATE

FISHING_YEAR

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

4-digit year for fishing.
General Data Type: NUMBER

FISHING_TIME_INTERVAL

CC ID: 193939
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Fishing time interval for vessel selection vessels.
General Data Type: NUMBER

VESSEL_SAMPLE_PLAN_SEQ

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

primary key of ODDS_VESSEL_SAMPLE_PLAN.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.ODDS_VESSEL_SAMPLE_PLAN

DETERM_REASON_CATEGORY_CODE

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

Determination reason category code, fk from VAS_LOV_DETERM_REASON_CTGRY.
General Data Type: VARCHAR2
Foreign Key Relations:

NORPAC.VAS_LOV_DETERM_REASON_C

MAXIMUM_CREW_CAPACITY

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

Maximum number of crews the vessel can hold.
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 24085
GUID: gov.noaa.nmfs.inport:24085
Metadata Record Created By: Julie A Blair
Metadata Record Created: 2015-03-17 18:40+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