Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_CUSTODY_SAMPLE_STATUS

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75165  |  Updated: May 21, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Control table containing a description of and instructions for each type of status in which a sample may be found, for example, on display, in storage, educational use, etc.

Entity Information

Data Attribute / Type Description
BEGIN_DATE
DATE 		Effective date of the status record.
CODE
VARCHAR2(2 BYTE) 		One- or two-letter code representing the status of the sample.
DESCRIPTION
VARCHAR2(100 BYTE) 		Description of the status of the sample.
END_DATE
DATE 		Retirement date of the status record.
ID
NUMBER(6,0) 		Unique identifier of the status record.
INSTRUCTIONS
VARCHAR2(100 BYTE) 		Instructions for the data entry person on what information to record, pertinent to the sample.

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

Entity Information

Description:

Control table containing a description of and instructions for each type of status in which a sample may be found, for example, on display, in storage, educational use, etc.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 BEGIN_DATE DATE Effective date of the status record.
100
 CODE VARCHAR2(2 BYTE) One- or two-letter code representing the status of the sample.
100
 DESCRIPTION VARCHAR2(100 BYTE) Description of the status of the sample.
100
 END_DATE DATE Retirement date of the status record.
100
 ID NUMBER(6,0) Unique identifier of the status record.
100
 INSTRUCTIONS VARCHAR2(100 BYTE) Instructions for the data entry person on what information to record, pertinent to the sample.

Attribute Details

BEGIN_DATE

CC ID: 1374247
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Effective date of the status record.

CODE

CC ID: 1374248
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

One- or two-letter code representing the status of the sample.

DESCRIPTION

CC ID: 1374249
Data Storage Type: VARCHAR2(100 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Description of the status of the sample.

END_DATE

CC ID: 1374250
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Retirement date of the status record.

ID

CC ID: 1374251
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier of the status record.

INSTRUCTIONS

CC ID: 1374252
Data Storage Type: VARCHAR2(100 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Instructions for the data entry person on what information to record, pertinent to the sample.

Catalog Details

Catalog Item ID: 75165
GUID: gov.noaa.nmfs.inport:75165
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 18:21+0000
Metadata Record Last Modified By: Daniel Woodrich
Metadata Record Last Modified: 2025-05-21 19:12+0000
Metadata Record Published: 2025-05-21
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year