DAACS :: Artifact Query 5: Select Artifact Attributes by Artifact Type

AQ1:	Basic Inventory

AQ2:	Detailed Inventory

AQ3:	Detailed Inventory for chosen level of aggregation by site
AQ3a:	Context
AQ3b:	Feature Type
AQ3c:	Feature Number
AQ3d:	Unit Type
AQ3e:	Stratigraphic Group
AQ3f:	Phase
AQ3g	Feature Group Number
AQ3h	Quadrat ID

AQ4:	View All Artifact Attributes by Artifact Category

AQ5:	Select Artifact Attributes by Artifact Category

ARTIFACT QUERY 5: Select Artifact Attributes by Artifact Type
This query has the potential to produce very large data sets and therefore should only be attempted through a high-speed internet conntection.

NOTE: You will be given the opportunity to Choose a Site on the next screen.

Artifact Query 5: Select Artifact Attributes by Category This query allows you to choose which fields you'd like to see for a specific artifact type. You select the project, artifact type, and the artifact attributes you would like to see for that artifact type. You may also subset the ceramic, glass, and all other artifact data by specific wares, materials and forms. In addition to choosing the site and artifact type, this query allows you to choose specific context(s) or Unit Type(s) or Feature Number(s) or Feature Type (s) or Stratigraphic Group(s) or Phase(s) from which you'd like to view data.		When viewed by context(s), the data are ordered by: Context All artifact fields selected by the user. When viewed by Feature Type(s), the data are ordered by: Feature Type Context All artifact fields selected by the user. When viewed by Feature Number(s), the data are ordered by: Feature Number Context All artifact fields selected by the user. When viewed by Unit Type(s), the data are ordered by: Unit Type Context All artifact fields selected by the user. When viewed by Stratigraphic Group(s), the data are ordered by: DAACS Stratigraphic Group Context All artifact fields selected by the user. When viewed by Unit Type(s), the data are ordered by: DAACS Phase Context All artifact fields selected by the user.

		Artifact Types and Fields from which the User can select:

		Beads:

		Project Name Context Deposit Type Feature Type Feature Group Number Feature Number DAACS Stratigraphic Group DAACS Phase Artifact ID Quantity as Count Completeness Material Manufacturing Technique Structure Form Shape End Treatment Heat Treated? Color Number of Facets Diaphaneity Post Manufacturing Modification Patination Weathered/Eroded Burned? Length Width Height Weight Size of Perforation I Size of Perforation II Mended Conservation Images Notes Casing Layer (from tblBeadCasing) Color (from tblBeadCasing) Bead Decoration (from tblBeadDecTech) Applied Color Decoration Notes

		Buckles:

		Project Name Context Deposit Type Feature Type Feature Group Number Feature Number DAACS Stratigraphic Group DAACS Phase Artifact ID Quantity as Count Buckle Type Completeness Frame Plating Weight Marks Burned Conservation Mended? Post Manufacturing Modification Images Notes Buckle Part (from tblBuckleForm) Material (from tblBuckleForm) Manufacturing Technique (from tblBuckleForm) Shape (from tblBuckleForm) Element (from tblBuckleForm) Length (from tblBuckleForm) Width (from tblBuckleForm) Decorative Technique (from tblBuckleDecTech) Decorative Motif (from tblBuckleDecTech)

		Buttons:

		Project Name Context Deposit Type Feature Type Feature Group Number Feature Number DAACS Stratigraphic Group DAACS Phase Artifact ID Quantity as Count Completeness Manufacturing Technique Button Type Button Shape Face Material Material Button Color Eye Shank Style Shank Material Shank Condition Appearance Burned Conservation Post Manufacturing Modification Conservation Backstamp Length Width Height Weight Images Notes Decoration Jewel/Inlay Applied Color Decorative Motif

		Ceramics:

		Project Name Context Deposit Type Feature Type Feature Group Number Feature Number DAACS Stratigraphic Group DAACS Phase Artifact ID Quantity as Count Material Manufacturing Technique Ware Vessel Category Form Mended Form Completeness Exterior Glaze Type Exterior Color Interior Glaze Type Interior Color Paste Inclusions (from tblCeramicPasteInclusions) Interior/Exterior (from tblCeramicDecTech) Location of Decoration (from tblCeramicDecTech) Decorative Technique (from tblCeramicDecTech) Applied Color (from tblCeramicDecTech) Stylistic Element (from tblCeramicDecTech) Decorative Motif (from tblCeramicDecTech)Pattern Name Pattern Reference Stylistic Genre BaseMark Base Mark Reference Base Mark Color Sherd Thickness Maximum Sherd Measurement Sherd Weight Rim Length Rim Diameter Mended Rim Diameter Use Wear Location (from tblCeramicUseWear) Use Wear Pattern (from tblCeramicUseWear) Use Wear Type (from tblCeramicUseWear) Oxidized Vs Reduced Burned Post Manufacturing Modification Images Notes

		Fields Returned for All Other Artifacts:

		Users will be able to select which authority terms they'd like to see from the Material and Form fields (i.e. subset by Material and Form). Project Name Context Deposit Type Feature Type Feature Group Number Feature Number DAACS Stratigraphic Group DAACS Phase Artifact ID Quantity as Count Category Form Material (fromtblGenArtifactMaterial) Manufacturing Technique (fromtblGenArtifactMaterial) Completeness Decorative Technique (from tblGenArtifactDecTech) Applied Color (from tblGenArtifactDecTech) Notes on Decoration (from tblGenArtifactDecTech) Nail Head Type Nail End Type Nail Modification Nail Length Mended Post Manufacturing Modification Burned Length Width Height Weight Marks Notes about Marks Conservation Images Notes

		Glass:

		Users will be able to select which authority terms they'd like to see from the Material and Form fields (i.e. subset by Material and Form). Project Name Context Deposit Type Feature Type Feature Group Number Feature Number DAACS Stratigraphic Group DAACS Phase Artifact ID Quantity as Count Material Color Vessel Category Form Completeness Manufacturing Technique Mold Type Bottle Element (from tblGlassBottle) Bottle Shape (from tblGlassBottle) Element Manufacturing Technique (from tblGlassBottle) Bottle Treatment (from tblGlassBottle) Element Height (from tblGlassBottle) Element Diameter (from tblGlassBottle) Decorative Technique (from tblGlassBottle) Applied Color (from tblGlassDecTech) Stylistic Element (from tblGlassDecTech) Glass Mark (from tblGlassMark) Mark Location (from tblGlassDecTech) Pontil Mark Type Total Container Height Stemware Body Shape Stemware Foot Shape Stem Shape Stem Length Use Wear Weathered Burned Patination Solarization Sherd Size Sherd Thickness Sherd Weight Length of Rim Rim Diameter Mended Rim Diameter Conservation Post Manufacturing Modification Mended? Images Notes

		Tobacco Pipes:

		Project Name Context Deposit Type Feature Type Feature Group Number Feature Number DAACS Stratigraphic Group DAACS Phase Artifact ID Completeness Material Paste Color (from munsedcolor) Paste Inclusions Manufacturing Technique Glaze Type Glaze Color (from munappcolor) Bowl Form Bowl Base Type Mouthpiece Form Stem Length Exterior Stem Diameter Bore Diameter, metric Bore Diameter, 64ths Bowl Height Bowl Volume Maximun Bowl Diameter Bowl Rim Diameter Weight Mended Conservation Decorative Motif (fromtblTobPipeDecMot Mark Type Mark Location Pipe Text Frame Motif (tblTobaccoPipeTextMark) First Name (tblTobaccoPipeTextMark) Last Name (tblTobaccoPipeTextMark) Place Name (tblTobaccoPipeTextMark) Slogan (tblTobaccoPipeTextMark) Mark Notes (tblTobaccoPipeTextMark) Post Manufacturing Modifications (pmm) Images Notes

		Utensils:

		Project Name Context Deposit Type Feature Type Feature Group Number Feature Number DAACS Stratigraphic Group DAACS Phase Artifact ID Completeness Form Part (from tblUtensilSpecifics) Shape (from tblUtensilSpecifics) Manufacturing Technique (from tblUtensilSpecifics) Material (from tblUtensilSpecifics) Length of Part (from tblUtensilSpecifics) Width of Part (from tblUtensilSpecifics) Height of Part (from tblUtensilSpecifics) Plating Handle Decoration Number of Fork Tines Utensil Length Utensil Width Utensil Weight Burned? Marks Conservation Mended? Post Manufacturing Modification (pmm) Images Notes