Downtime Notice: Thursday, May 29 @ 2:00pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 6.0.2. Downtime Schedule May 29, 2025 2:00pm - 3:00pm Eastern / 11:00am - 12:00pm Pacific / 8:00am - 9:00am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: https://www.fisheri...
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_FRAME_ON_FILM

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

Summary

Description

Contains individual photo information. Child of mm_film, where roll data is stored.

Entity Information

Data Attribute / Type Description
DESCRIPTION
VARCHAR2(2000 BYTE) 		Comments on the frame
FILM_ID
NUMBER(6,0) 		Unique database identifier from mm_film representing a roll of film
FRAME_NUMBER
NUMBER(2,0) 		Roll of film frame number
PHOTO_DATE
DATE 		Date of photo
PHOTO_OBJECT_CODE
VARCHAR2(5 BYTE) 		Code number for photo subject
PHOTO_OBJECT_ID
NUMBER(6,0) 		Unique database identifier for photo subject
PHOTO_TIME
NUMBER(4,0) 		Time of photo
QUALITY_CODE
VARCHAR2(1 BYTE) 		Quality code assigned to the developed photograph
SEQUENCE_NUMBER
NUMBER(3,0) 		Sequential number per roll of film
SUBJECT
VARCHAR2(50 BYTE) 		Populated by the object_id and object_code
TAG_NUMBER
VARCHAR2(12 BYTE) 		If photo suject is a tagged specimen record tag number

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_FRAME_ON_FILM

Entity Information

Description:

Contains individual photo information. Child of mm_film, where roll data is stored.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 DESCRIPTION VARCHAR2(2000 BYTE) Comments on the frame
100
 FILM_ID NUMBER(6,0) Unique database identifier from mm_film representing a roll of film
100
 FRAME_NUMBER NUMBER(2,0) Roll of film frame number
100
 PHOTO_DATE DATE Date of photo
100
 PHOTO_OBJECT_CODE VARCHAR2(5 BYTE) Code number for photo subject
100
 PHOTO_OBJECT_ID NUMBER(6,0) Unique database identifier for photo subject
100
 PHOTO_TIME NUMBER(4,0) Time of photo
100
 QUALITY_CODE VARCHAR2(1 BYTE) Quality code assigned to the developed photograph
100
 SEQUENCE_NUMBER NUMBER(3,0) Sequential number per roll of film
100
 SUBJECT VARCHAR2(50 BYTE) Populated by the object_id and object_code
100
 TAG_NUMBER VARCHAR2(12 BYTE) If photo suject is a tagged specimen record tag number

Attribute Details

DESCRIPTION

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

Comments on the frame

FILM_ID

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

Unique database identifier from mm_film representing a roll of film

FRAME_NUMBER

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

Roll of film frame number

PHOTO_DATE

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

Date of photo

PHOTO_OBJECT_CODE

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

Code number for photo subject

PHOTO_OBJECT_ID

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

Unique database identifier for photo subject

PHOTO_TIME

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

Time of photo

QUALITY_CODE

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

Quality code assigned to the developed photograph

SEQUENCE_NUMBER

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

Sequential number per roll of film

SUBJECT

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

Populated by the object_id and object_code

TAG_NUMBER

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

If photo suject is a tagged specimen record tag number

Catalog Details

Catalog Item ID: 75175
GUID: gov.noaa.nmfs.inport:75175
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 21:36+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