Number formatting for objects that are not collection objects. See spreadsheet.
WA (digital media): 6 object records.
mfp (Main Photo File): 164 object records.
OH (oral histories): 5 object records.
FP (film program photographs): 943 object records.
noncollection (all items not in the collection but which are nonetheless tracked on OC, such as exhibition materials).
All loan numbers for objects should are formatted: "IL0001.0001."
ARTIFACT CLASS / WORK TYPE / COLLECTION CATEGORY:
Artifact Class and Work Type appear in a single cell in each object record row in the excel doc reports from OC. They cannot be sorted separately.
Many objects have "artifact class" but have not been assigned a work type. When this the case, only the "artifact class" appears in the "artifact class/work type" cell in the report. For this reason, it's impossible to determine based on the reporting function how many objects have a classification for "Artifact Class" and yet lack a classification in "Work Type."
Because "artifact class" is a controlled list, it is impossible to not choose a value for artifact class. The default choice is "*Undetermined." Over 13,000 records have this default classification. Most of these records also lack classification for "collection category" (see below).
Because "collection category" is a controlled list, it is impossible to not choose a value for collection category. The default choice is "*Not yet assigned." About 13,000 records have this default classification. Most of these records also lack classification for "artifact class" and "work type."
EXTENT:
Thousands of records still have no extent. It is impossible to automate this, since there is no guarantee that all, or even the majority, of the records have an extent of "1."
ATTRIBUTES
The following attributes fields are available for inclusion in reports run on OBJECTS. These are: Category, Components, Copyright date, Copyright holder, Copyright Statement, Creation date, Credit line, Dimensions (in), Display Date, Extent, Format, Manufacturer, Material, Other physical details, Photo credit, Publication date, Publisher, Serial number, Subcategory, Subject, Technique
The following attributes fields are a part of the database structure but are NOT available in reports run on OBJECTS. These are: Color, Color/BW, Country, Creator, Date of birth, Date of death, Director, Distributor, Form, Genre, Historical notes, Key, Label and caption, Language, Licensor, Medium, Network/Cable service, Place name, Principle cast, Production company, Production date, Release date, Running dates, Running time. Most of these attributes are in use in other data sets (Entities, Occurrences, etc). It is unknown whether or not any object records have data in any of these fields, but it is unlikely (the database structure probably does not allow it).
All attribute fields are repeatable. When exporting this data via the OC "reporting" function, however, each object record has only one cell per attribute field. In cases in which a field has been repeated in an object record, both pieces of data will appear in a single cell separated by a semicolon.