Table: VAS_VESSEL_ASSESSMENT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:24085 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |