Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 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_RELEASE_TYPE

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

Summary

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
RELEASE_TYPE_SEQ
NUMBER 		Primary key sequence number.
RELEASE_TYPE_CODE
VARCHAR2 		Release type code. "C" for conditional, "P" for permanent.
RELEASE_TYPE_DESC
VARCHAR2 		Description of the release type.
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_RELEASE_TYPE
Short Name: VAS_LOV_RELEASE_TYPE
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 RELEASE_TYPE_SEQ NUMBER Primary key sequence number.
100
 RELEASE_TYPE_CODE VARCHAR2 Release type code. "C" for conditional, "P" for permanent.
100
 RELEASE_TYPE_DESC VARCHAR2 Description of the release type.
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

RELEASE_TYPE_SEQ

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

Primary key sequence number.
General Data Type: NUMBER

RELEASE_TYPE_CODE

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

Release type code. "C" for conditional, "P" for permanent.
General Data Type: VARCHAR2

RELEASE_TYPE_DESC

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

Description of the release type.
General Data Type: VARCHAR2

RMD_CHANGED_BY

CC ID: 193881
Seq. Order: 4
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: 193882
Seq. Order: 5
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: 193883
Seq. Order: 6
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: 193884
Seq. Order: 7
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: 24080
GUID: gov.noaa.nmfs.inport:24080
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