Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SITE_VISIT_OUTCOME_SEQ
NUMBER
Primary sequence key
SITE_VISIT_SEQ
NUMBER
Required. PK from VAS_SITE_VISIT table.
ASSESS_POINT_SEQ
NUMBER
Required. Pk from VAS_ASSESS_POINT table.
SITE_VISIT_ASSESSMENT_NOTE
CLOB
Inspection comments provided by inspector.
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_SITE_VISIT_OUTCOME
Short Name: VAS_SITE_VISIT_OUTCOME
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

Rubric Score Primary Key? Name Type Description
100
Primary Key SITE_VISIT_OUTCOME_SEQ NUMBER Primary sequence key
100
SITE_VISIT_SEQ NUMBER Required. PK from VAS_SITE_VISIT table.
100
ASSESS_POINT_SEQ NUMBER Required. Pk from VAS_ASSESS_POINT table.
100
SITE_VISIT_ASSESSMENT_NOTE CLOB Inspection comments provided by inspector.
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

SITE_VISIT_OUTCOME_SEQ

CC ID: 193919
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

SITE_VISIT_SEQ

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

Required. PK from VAS_SITE_VISIT table.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.VAS_SITE_VISIT

ASSESS_POINT_SEQ

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

Required. Pk from VAS_ASSESS_POINT table.

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.VAS_LOV_ASSESS_POINT

SITE_VISIT_ASSESSMENT_NOTE

CC ID: 193920
Seq. Order: 4
Data Storage Type: CLOB
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Inspection comments provided by inspector.

General Data Type: CLOB

RMD_CHANGED_BY

CC ID: 193921
Seq. Order: 5
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: 193922
Seq. Order: 6
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: 193923
Seq. Order: 7
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: 193924
Seq. Order: 8
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: 24084
GUID: gov.noaa.nmfs.inport:24084
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