Metadata Rubric

100%

6 / 6

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_SITE_VISIT

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:24082 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This table contains vessels whose survey answers say it is not suitable for accommodating and observer with spection summary.

Description

This table contains vessels whose survey answers say it is not suitable for accommodating and observer with spection summary.

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.

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.

No Child Items for this record.

No contact information is available for this record.

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

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 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.

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.

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

CC ID: 193898

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

CC ID: 193901

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

CC ID: 193902

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

CC ID: 193892

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

CC ID: 193895

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

CC ID: 193903

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

CC ID: 193893

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

CC ID: 193904

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

CC ID: 193905

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

CC ID: 193899

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

CC ID: 193900

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

CC ID: 193897

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

CC ID: 193894

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

CC ID: 193896

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 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

Table: VAS_SITE_VISIT

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

SITE_VISIT_SEQ

SCHEDULED_SITE_VISIT_DATE

ACTUAL_SITE_VISIT_DATE

USER_SEQ

PORT_CODE

SITE_VISIT_COMMENTS

USER_SEQ_ASSIGNED

RMD_CHANGED_BY

RMD_TS_CHANGED

RMD_ACTION

RMD_CHANGE_COMMENT

VESSEL_ASSESSMENT_SEQ

PORT_CODE_SCHEDULED

SITE_VISIT_STATUS_SEQ

Catalog Details