Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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_LOV_ASSESS_POINT

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:24078  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

List of inspection check points for evaludating if a vessel is suitable for accommodating observer or not.

Description

List of inspection check points for evaludating if a vessel is suitable for accommodating observer or not.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ASSESS_POINT_SEQ
NUMBER 		Primary sequence key of VAS_LOV_ASSESS_POINT.
POINT_NAME
VARCHAR2 		Name of an inspection point
POINT_DESCRIPTION
VARCHAR2 		Description of an inspection point.
SEQUENCE_UNDER_A_CATEGORY
NUMBER 		Item sequence under one category.
ASSESS_CRITERIA_SEQ
NUMBER 		Primary key seqeunce value from VAS_LOV_ASSESS_CRITERIA.
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.

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_LOV_ASSESS_POINT
Short Name: VAS_LOV_ASSESS_POINT
Status: Completed
Abstract:

List of inspection check points for evaludating if a vessel is suitable for accommodating observer or not.
Notes:

Loaded by batch 5652, 03-17-2015 18:40

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NORPAC
Description:

List of inspection check points for evaludating if a vessel is suitable for accommodating observer or not.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ASSESS_POINT_SEQ NUMBER Primary sequence key of VAS_LOV_ASSESS_POINT.
100
 POINT_NAME VARCHAR2 Name of an inspection point
100
 POINT_DESCRIPTION VARCHAR2 Description of an inspection point.
100
 SEQUENCE_UNDER_A_CATEGORY NUMBER Item sequence under one category.
100
 ASSESS_CRITERIA_SEQ NUMBER Primary key seqeunce value from VAS_LOV_ASSESS_CRITERIA.
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.

Attribute Details

ASSESS_POINT_SEQ

CC ID: 193867
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Primary sequence key of VAS_LOV_ASSESS_POINT.
General Data Type: NUMBER

POINT_NAME

CC ID: 193868
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 200
Required: Yes
Primary Key: No
Status: Active
Description:

Name of an inspection point
General Data Type: VARCHAR2

POINT_DESCRIPTION

CC ID: 193869
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Description of an inspection point.
General Data Type: VARCHAR2

SEQUENCE_UNDER_A_CATEGORY

CC ID: 193870
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Item sequence under one category.
General Data Type: NUMBER

ASSESS_CRITERIA_SEQ

CC ID: 193866
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Primary key seqeunce value from VAS_LOV_ASSESS_CRITERIA.
General Data Type: NUMBER
Foreign Key Relations:

NORPAC.VAS_LOV_ASSESS_CRITERIA

RMD_CHANGED_BY

CC ID: 193871
Seq. Order: 6
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: 193872
Seq. Order: 7
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: 193873
Seq. Order: 8
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: 193874
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Comment for data change.
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 24078
GUID: gov.noaa.nmfs.inport:24078
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