Table: VAS_VESSEL_ASSESSMENT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:24085 | Updated: August 9, 2022 | Published / External
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
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 |