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

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.

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