Slide Menu
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu

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