MM_CUSTODY_SAMPLE_TYPE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75166 | Updated: May 21, 2025 | Published / External
Entity Information
| Description: |
Control table containing the types of samples that may be represented on the Biological Sample Chain of Custody Form. |
|---|
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
BEGIN_DATE | DATE | Effective date of the sample type. | |
|
100
|
CODE | VARCHAR2(2 BYTE) | One- or two-letter code representing the type of sample. | |
|
100
|
DESCRIPTION | VARCHAR2(100 BYTE) | Description of the type of sample. | |
|
100
|
END_DATE | DATE | Retirement date of the sample type. | |
|
100
|
ID | NUMBER(6,0) | Unique identifier of the sample type. |
Attribute Details
BEGIN_DATE
CC ID: 1374253
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Effective date of the sample type. |
CODE
CC ID: 1374254
| Data Storage Type: | VARCHAR2(2 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
One- or two-letter code representing the type of sample. |
DESCRIPTION
CC ID: 1374255
| Data Storage Type: | VARCHAR2(100 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Description of the type of sample. |
END_DATE
CC ID: 1374256
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Retirement date of the sample type. |
ID
CC ID: 1374257
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique identifier of the sample type. |
Catalog Details
| Catalog Item ID: | 75166 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:75166 |
| Metadata Record Created By: | Rachel Wuest |
| Metadata Record Created: | 2025-03-06 18:23+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 |