Table: VAS_SITE_VISIT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:24082 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This table contains vessels whose survey answers say it is not suitable for accommodating and observer with spection summary.
DescriptionThis table contains vessels whose survey answers say it is not suitable for accommodating and observer with spection summary.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
SITE_VISIT_SEQ
NUMBER |
Primary key sequence. |
SCHEDULED_SITE_VISIT_DATE
DATE |
The scheduled date for site visit. It is temporary schedule. |
ACTUAL_SITE_VISIT_DATE
DATE |
Date of actual site visit took place by NMFS |
USER_SEQ
NUMBER |
CAM_USER sequence number of the inspector acctually performed the vessel inspection. |
PORT_CODE
NUMBER |
Location where a inspection performed. Primary key from atl_lov_port_code table. |
SITE_VISIT_COMMENTS
VARCHAR2 |
Additional comment on determination. |
USER_SEQ_ASSIGNED
NUMBER |
CAM_USER sequence number of the inspector assigned to a vessel for inspection. |
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. |
VESSEL_ASSESSMENT_SEQ
NUMBER |
Vessel being inspected. Primary key sequence from vas_vessel_assessment. |
PORT_CODE_SCHEDULED
NUMBER |
Location where a assessment scheduled performed. Primary key from atl_lov_port_code table. |
SITE_VISIT_STATUS_SEQ
NUMBER |
Status of site visit activity. Primary key sequence from VAS_SITE_VISIT_STATUS. |
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_SITE_VISIT |
---|---|
Short Name: | VAS_SITE_VISIT |
Status: | Completed |
Abstract: |
This table contains vessels whose survey answers say it is not suitable for accommodating and observer with spection summary. |
Notes: |
Loaded by batch 5652, 03-17-2015 18:40 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NORPAC |
Description: |
This table contains vessels whose survey answers say it is not suitable for accommodating and observer with spection summary. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
SITE_VISIT_SEQ | NUMBER | Primary key sequence. | |
100
|
SCHEDULED_SITE_VISIT_DATE | DATE | The scheduled date for site visit. It is temporary schedule. | |
100
|
ACTUAL_SITE_VISIT_DATE | DATE | Date of actual site visit took place by NMFS | |
100
|
USER_SEQ | NUMBER | CAM_USER sequence number of the inspector acctually performed the vessel inspection. | |
100
|
PORT_CODE | NUMBER | Location where a inspection performed. Primary key from atl_lov_port_code table. | |
100
|
SITE_VISIT_COMMENTS | VARCHAR2 | Additional comment on determination. | |
100
|
USER_SEQ_ASSIGNED | NUMBER | CAM_USER sequence number of the inspector assigned to a vessel for inspection. | |
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
|
VESSEL_ASSESSMENT_SEQ | NUMBER | Vessel being inspected. Primary key sequence from vas_vessel_assessment. | |
100
|
PORT_CODE_SCHEDULED | NUMBER | Location where a assessment scheduled performed. Primary key from atl_lov_port_code table. | |
100
|
SITE_VISIT_STATUS_SEQ | NUMBER | Status of site visit activity. Primary key sequence from VAS_SITE_VISIT_STATUS. |
Attribute Details
SITE_VISIT_SEQ
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Primary key sequence. |
General Data Type: | NUMBER |
SCHEDULED_SITE_VISIT_DATE
Seq. Order: | 2 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The scheduled date for site visit. It is temporary schedule. |
General Data Type: | DATE |
ACTUAL_SITE_VISIT_DATE
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of actual site visit took place by NMFS |
General Data Type: | DATE |
USER_SEQ
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
CAM_USER sequence number of the inspector acctually performed the vessel inspection. |
General Data Type: | NUMBER |
Foreign Key Relations: |
CUST_AUTH.CAM_USERS |
PORT_CODE
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Location where a inspection performed. Primary key from atl_lov_port_code table. |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.ATL_LOV_PORT_CODE |
SITE_VISIT_COMMENTS
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional comment on determination. |
General Data Type: | VARCHAR2 |
USER_SEQ_ASSIGNED
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
CAM_USER sequence number of the inspector assigned to a vessel for inspection. |
General Data Type: | NUMBER |
Foreign Key Relations: |
CUST_AUTH.CAM_USERS |
RMD_CHANGED_BY
Seq. Order: | 8 |
---|---|
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: | 9 |
---|---|
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: | 10 |
---|---|
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: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comment for data change. |
General Data Type: | VARCHAR2 |
VESSEL_ASSESSMENT_SEQ
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Vessel being inspected. Primary key sequence from vas_vessel_assessment. |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.VAS_VESSEL_ASSESSMENT |
PORT_CODE_SCHEDULED
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Location where a assessment scheduled performed. Primary key from atl_lov_port_code table. |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.ATL_LOV_PORT_CODE |
SITE_VISIT_STATUS_SEQ
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Status of site visit activity. Primary key sequence from VAS_SITE_VISIT_STATUS. |
General Data Type: | NUMBER |
Foreign Key Relations: |
NORPAC.VAS_LOV_SITE_VISIT_STAT |
Catalog Details
Catalog Item ID: | 24082 |
---|---|
GUID: | gov.noaa.nmfs.inport:24082 |
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 |