Paddy's Market

Creator(s): Penny Crook; Tim Murray

Year: 2006

Summary

Artefact and context data from the Paddy's Market excavation in 1993. Records were compiled and assessed by not modified by the EAMC team. The original catalogue was prepared by Godden Mackay Logan and Wendy Thorp.

Cite this Record

Paddy's Market. Penny Crook, Tim Murray. 2006 ( tDAR id: 407305) ; doi:10.6067/XCV8CV4KTS

This Resource is Part of the Following Collections

Restricted Access Some or all of this resource's attached file(s) are not publicly accessible.

Data Set Structure

Measurement Column
Count Column
Coded Column
Filename Column
Integration Column (has Ontology)

Table Information: Artefacts

Column Name Data Type Type Category Coding Sheet Ontology Search
UpdatedBy The log-on name of the person who modified the record while using the Artefacts Form.
TEXT  Uncoded Value uncategorized none none true
IDNumber Unique identification number allocated to each artefact. For all artefacts catalogued prior to 2001 this is the 'original' number and appears on the bag.
DOUBLE  Uncoded Value uncategorized none none true
CatalogueNumber The IDNumber preceded by an abbreviated Site code. This allows multiple catalogues each numbered 1 to ~ to be combined in the same database. All labels printed from 2001 onwards show the Catalogue Number rather than IDNumber. (Added by the EAMC)
TEXT  Uncoded Value uncategorized none none true
Site The excavation site code, often including the year of excavation, eg CUGL1994
TEXT  Uncoded Value uncategorized none none true
Unit The stratigraphic Unit from which the artefact was excavated, eg B101. (From the original CUGL catalogue)
TEXT  Uncoded Value uncategorized none none true
UnitArea A sub-strata of the Unit, ie a grid square within a Unit (eg B101/B1). The 'UnitArea' as defined in the original CUGL catalogue.
TEXT  Uncoded Value uncategorized none none true
UnitandArea The full stratigraphic Unit reference for the deposit from which the artefact was recovered
TEXT  Uncoded Value uncategorized none none true
PhaseA The first Site Phase to which the stratigraphic Unit from which the artefact was recovered may be dated. (From the original CUGL catalogue)
DOUBLE  Uncoded Value uncategorized none none true
BoneNoFrag DOUBLE  Uncoded Value uncategorized none none true
PhaseB The last Site Phase to which the stratigraphic Unit from which the artefact was recovered may be dated. (From the original CUGL catalogue)
DOUBLE  Uncoded Value uncategorized none none true
Activity The pre-defined, broad functional Activity group to which the artefact was likely to belong. Activity is the first of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came).
TEXT  Uncoded Value uncategorized none none true
ActivityQ A checkbox to be ticked when the allocated Activity group is considered tentative or speculative. (Added by the EAMC)
BOOLEAN  Uncoded Value uncategorized none none true
Function The pre-defined, Function group to which the artefact was likely to belong. Function is the second of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came).
TEXT  Uncoded Value uncategorized none none true
FunctionQ A checkbox to be ticked when the allocated Function group is considered tentative or speculative. (Added by the EAMC)
BOOLEAN  Uncoded Value uncategorized none none true
DateTo Numeric field recording the last year of the period in which the artefact may have been manufactured.
BIGINT  Uncoded Value uncategorized none none true
Subfunction The pre-defined, a more specific functional group to which the artefact was likely to belong. Function is the second of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came).
TEXT  Uncoded Value uncategorized none none true
SubfunctionQ A checkbox to be ticked when the allocated Subfunction group is considered tentative or speculative. (Added by the EAMC)
BOOLEAN  Uncoded Value uncategorized none none true
Arteclass Broad Artefact Class for each artefact (eg Glass, Ceramic, Building Material).
TEXT  Uncoded Value uncategorized none none true
Material Specific Material class for each artefact (eg Fine Earthenware, Porcelain).
TEXT  Uncoded Value uncategorized none none true
MaterialQ BOOLEAN  Uncoded Value uncategorized none none true
CeramicBody The specific fabric of a ceramic vessel (eg 'Creamware', where 'Fine Earthenware' appears in the Material field). (From the original LV and FGH-YRP catalogues. In the CUGL system the Ceramic Body is described via the Type Series.)
TEXT  Uncoded Value uncategorized none none true
Integrity Describes the Integrity or completeness of sherd within one bag by recording the relationship of elements within that bag.
TEXT  Uncoded Value uncategorized none none true
Percentage Estimated percentage of the total vessel or piece that the elements in the bag represent.
TEXT  Uncoded Value uncategorized none none true
Quantity The number of sherds or individual elements in the bag, regardless of whether they conjoin to form a whole piece.
DOUBLE  Uncoded Value uncategorized none none true
Images TEXT  Uncoded Value uncategorized none none true
Form Description of the profile of the original vessel or part there of (eg base or rim), as determined from the surviving sherd (eg 'everted rim', 'London-profile' for a tea cup).
TEXT  Uncoded Value uncategorized none none true
Shape Description of the section of vessel, as determined from the sherd (eg 'round' for a teacup, 'oval' for a platter etc)
TEXT  Uncoded Value uncategorized none none true
Portion The part of the vessel that artefact derived. Eg the 'stem' of a pipe, or 'rim' of tea cup.
TEXT  Uncoded Value uncategorized none none true
Decoration The method of applying the decoration (eg 'transfer-print', 'hand-painted' etc)
TEXT  Uncoded Value uncategorized none none true
DecorationPlacement The face(s) of the vessel or sherd on which the decoration appears. This aids the identification of function, eg decoration appears on the 'concave' face of plates and saucers; teacups are 'double-sided'. (Added by the EAMC, Nov 2002)
TEXT  Uncoded Value uncategorized none none true
Colour The colour(s) of the decoration on the vessel (eg 'red' transfer-print, or the body of an undecorated vessel or object (eg 'olive-green' glass).
TEXT  Uncoded Value uncategorized none none true
Pattern The name of a known pattern or decorative style (eg ‘Lachlander’ pipe; ‘Willow’ plate), or general description (eg ‘Scenic’; 'Floral') if the precise pattern name is not known.
TEXT  Uncoded Value uncategorized none none true
TechniqueManuf The technological process by which the artefact was manufactured, eg 'hand-thrown', 'moulded', 'blown'.
TEXT  Uncoded Value uncategorized none none true
Modifictns Changes to the artefact occurring after its manufacture, while in use or after discard and deposition, excluding breakage, eg 'mended', 'inscribed'.
TEXT  Uncoded Value uncategorized none none true
IDMarks Function or purpose of any mark found on an artefact, as described in the Transcript field, eg 'Manufacturer's mark', 'Slogan'.
TEXT  Uncoded Value uncategorized none none true
Transcript Direct transcription of any text found on the artefact; gaps or speculative text should be enclosed in square parentheses: [ and ].
TEXT  Uncoded Value uncategorized none none true
RecordAdmin Memo field to record any alterations made to Artefact Record since the initial phases of cataloguing and data entry.
TEXT  Uncoded Value uncategorized none none true
MakerID Dedicated field for the name of the Maker, as identified from basemarks, unique patterns, etc. This field contained a unique identifier for each maker, stored in the ListOfMakers table. (Added by the EAMC; Feb 2002)
BIGINT  Uncoded Value uncategorized none none true
DistributorID Dedicated field for the name of the Distributor, as identified from basemarks, unique patterns, etc. This field contained a unique identifier for each distributor, stored in the ListOfMakers table. (Added by the EAMC; Feb 2002)
BIGINT  Uncoded Value uncategorized none none true
Lengthinmm Actual or estimated length of the vessel from which the sherd derives, in mm. This field does not record the length of sherds in their current state.
DOUBLE  Uncoded Value uncategorized none none true
Widthinmm Actual or estimated width or diameter of the vessel from which the sherd derives, in mm. This field does not record the width of sherds in their current state.
DOUBLE  Uncoded Value uncategorized none none true
Heightinmm Actual or estimated height of the vessel from which the sherd derives, in mm. This field does not record the height of sherds in their current state.
DOUBLE  Uncoded Value uncategorized none none true
Thickinmm Thickness of a specific part of the vessel from which the sherd derives, in mm. Eg base or body thickness.
DOUBLE  Uncoded Value uncategorized none none true
Tilestrike For CUGL Building Materials only. (From the original CUGL catalogue)
TEXT  Uncoded Value uncategorized none none true
TSName Name of the Type Series to which the artefact has been allocated, eg 'TP Earthenware Blue'.
TEXT  Uncoded Value uncategorized none none true
TSNo The Specific Number in the Type group described in the TS Name field, to which the artefact has been allocated, 'TP Earthenware Blue 12'.
DOUBLE  Uncoded Value uncategorized none none true
TSDetails Whether the artefact is the first representative Type (‘T’), or a ‘Repeat’ (‘R’) of that sub-Type.
TEXT  Uncoded Value uncategorized none none true
DateFrom Numeric field recording the artefact’s date of manufacture, or the first year of the period in which the artefact may have been manufactured.
BIGINT  Uncoded Value uncategorized none none true
DateNote Text field for additional notes regarding the Dates To and From that cannot be accommodated in those numeric fields.
TEXT  Uncoded Value uncategorized none none true
Provenance The country or town where the artefact was made.
TEXT  Uncoded Value uncategorized none none true
WeightGrms Weight of all sherds in the bag (in grams).
DOUBLE  Uncoded Value uncategorized none none true
Condition Brief description of the condition of the artefact. (From the original LV and FGH-YRP catalogues.)
TEXT  Uncoded Value uncategorized none none true
Conservation Brief description of any treatment applied to the artefact in order to conserve it. (From the original LV and FGH-YRP catalogues.)
TEXT  Uncoded Value uncategorized none none true
Notes General notes about the artefact.
TEXT  Uncoded Value uncategorized none none true
References Bibliographic references for any piece of information provided in the record.
TEXT  Uncoded Value uncategorized none none true
BoxNumber The number of the box in which the artefact is stored.
TEXT  Uncoded Value uncategorized none none true
VesselIDno Identification number to represent sherds recovered from different contexts (and hence in different bags) that conjoin to form a single object. (Added by the EAMC, 2001)
BIGINT  Uncoded Value uncategorized none none true
MNVID Identification number to group artefacts that potentially are part of the same vessel, for the purposes of Minimum Vessel Counts (MVC) only. (Added by the EAMC, Feb 2003)
DOUBLE  Uncoded Value uncategorized none none true
MNVQty Minimum number of vessels or objects represented by the MNVID. (Added by the EAMC, Feb 2003)
BIGINT  Uncoded Value uncategorized none none true
MNVNotes Field to contain notes relating to the grouping of the artefact(s) under the chosen MNVID. (Added by the EAMC, Feb 2003)
TEXT  Uncoded Value uncategorized none none true
MNVtocheck Administrative checkbox to indicate that the artefact must be inspected to verify the MVC. (100% complete vessels do not require physical verification for the purpose of MVC counts.) (Added by the EAMC, Feb 2003)
BOOLEAN  Uncoded Value uncategorized none none true
MNVverified Administrative checkbox to indicate that the MNVID and MNVQty for this artefact have been verified. (Added by the EAMC, Feb 2003)
BOOLEAN  Uncoded Value uncategorized none none true
SpecialFindNo The Special Find Number allocated to some artefacts during excavation. (Added by the EAMC to track the SF numbers in the FGH catalogue)
BIGINT  Uncoded Value uncategorized none none true
MatchingSetID Unique Identification number to group artefacts that potentially formed part of a matching set. (Added by the EAMC, Feb 2003)
BIGINT  Uncoded Value uncategorized none none true
MatchingSetType Whether the Matching Set is considered 'Complementary' or an exact match.
TEXT  Uncoded Value uncategorized none none true
OriginalContext Field containing the stratigraphic Unit as it was when imported into the database. Several FGH Units were originally mistyped and referred to unknown strata. These were corrected in order to link to Contexts table; and the original data retained..
TEXT  Uncoded Value uncategorized none none true
SplitFrom For bags split after the initial phase of cataloguing, this field records the original Catalogue Number.
BIGINT  Uncoded Value uncategorized none none true
LabelPrinted Administrative checkbox to indicate whether a label has been printed for the artefact.
BOOLEAN  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the Artefacts Form.
DATETIME  Uncoded Value uncategorized none none true
QRNotes Notes field used by the EAMC team during the Quality Review Assessment.
TEXT  Uncoded Value uncategorized none none true
QRChecked Administrative check box used to mark all artefact checked during the Quality Review Assessment.
BOOLEAN  Uncoded Value uncategorized none none true
QRProblem Any Problem with the artefact record identified during the Quality Review Assessment.
TEXT  Uncoded Value uncategorized none none true
QRAssess Overall Assessment of the extent of Problems identified during the Quality Review Assessment.
TEXT  Uncoded Value uncategorized none none true
SpeciesName TEXT  Uncoded Value uncategorized none none true
SkeletalElGroup TEXT  Uncoded Value uncategorized none none true
SkeletalEl TEXT  Uncoded Value uncategorized none none true
BoneNoComp DOUBLE  Uncoded Value uncategorized none none true
BoPortName TEXT  Uncoded Value uncategorized none none true
BoPortPerc TEXT  Uncoded Value uncategorized none none true
BoCondName TEXT  Uncoded Value uncategorized none none true
BoCondDesc TEXT  Uncoded Value uncategorized none none true
BoCondAss TEXT  Uncoded Value uncategorized none none true
BoAttriTyp TEXT  Uncoded Value uncategorized none none true
BoAttriTLC TEXT  Uncoded Value uncategorized none none true
BoAttriTAS TEXT  Uncoded Value uncategorized none none true
BoAgeInGLC TEXT  Uncoded Value uncategorized none none true
BOAgeInGST TEXT  Uncoded Value uncategorized none none true
BoneRelativeAge Relative age of animal, ie mature or juvenile.
TEXT  Uncoded Value uncategorized none none true
BoneAnimalSide Left, right or centre of animal, eg the left or right femur.
TEXT  Uncoded Value uncategorized none none true
TeethTooth TEXT  Uncoded Value uncategorized none none true
TeethCond TEXT  Uncoded Value uncategorized none none true
ButchLocat TEXT  Uncoded Value uncategorized none none true
ButchType TEXT  Uncoded Value uncategorized none none true
ButchOrien TEXT  Uncoded Value uncategorized none none true
AnimalSize TEXT  Uncoded Value uncategorized none none true
AniMaxSize DOUBLE  Uncoded Value uncategorized none none true
Seed TEXT  Uncoded Value uncategorized none none true
Organic TEXT  Uncoded Value uncategorized none none true
ShellScien TEXT  Uncoded Value uncategorized none none true
ShellCommn TEXT  Uncoded Value uncategorized none none true
ShellNoCom DOUBLE  Uncoded Value uncategorized none none true
ShellNoFra DOUBLE  Uncoded Value uncategorized none none true
ShellNoLid DOUBLE  Uncoded Value uncategorized none none true
ShellNoBas DOUBLE  Uncoded Value uncategorized none none true
ShellCond TEXT  Uncoded Value uncategorized none none true
Mineral TEXT  Uncoded Value uncategorized none none true

Table Information: Contexts

Column Name Data Type Type Category Coding Sheet Ontology Search
Site Site code
TEXT  Uncoded Value uncategorized none none true
MasterContext Overarching Context Number allocated to a group of stratigraphic contexts or Units deposited as part of the same event, but excavated separately (added by EAMC, 2002)
TEXT  Uncoded Value uncategorized none none true
Unit Trench or area number of the stratigraphic context or feature
TEXT  Uncoded Value uncategorized none none true
UnitArea Specific unit number of the stratigraphic context or feature
TEXT  Uncoded Value uncategorized none none true
UnitandArea Full unit code including Trench and Unit Number, and Site if required to distinguish from other contexts.
TEXT  Uncoded Value uncategorized none none true
UnitCode Unique code incorporating Site and Unit number
TEXT  Uncoded Value uncategorized none none true
AreaAlph Alpha ref or square for gridded occupation deposits, eg 'A' for square 'A1'
TEXT  Uncoded Value uncategorized none none true
AreaNo Numerical ref of square for gridded occupation deposits, eg '1' for square 'A1'
TEXT  Uncoded Value uncategorized none none true
Spit Spit number, where relevant
BIGINT  Uncoded Value uncategorized none none true
ContextType1 The broad category of strata, eg 'Fill', 'Service feature', 'Structural element'
TEXT  Uncoded Value uncategorized none none true
ContextType2 The specific kind of context eg 'Fill - cesspit', 'Service feature - drain', etc
TEXT  Uncoded Value uncategorized none none true
BldgPhase TEXT  Uncoded Value uncategorized none none true
BldgCode Code of the building with which this Unit is associated.
TEXT  Uncoded Value uncategorized none none true
BldgCodeNotes Additional notes about bldg code, where necessary
TEXT  Uncoded Value uncategorized none none true
BldgArea The Area of the Building in which this Unit or feature was revealed.
TEXT  Uncoded Value uncategorized none none true
Location The part of the site where this Unit or feature was revealed. This is designed to allow for Units or features revealed in the locale of a building bu could not be associated with the Building itself (ie it may have been earlier or later).
TEXT  Uncoded Value uncategorized none none true
Description Brief description of context
TEXT  Uncoded Value uncategorized none none true
Notes More detailed notes about the Unit.
TEXT  Uncoded Value uncategorized none none true
ExcavationPhase Phase of the site's excavation during which the context was dug; added largely to cater for FGH
TEXT  Uncoded Value uncategorized none none true
ExcavatedBy Name of the excavator, where known
TEXT  Uncoded Value uncategorized none none true
ExcavatedDate Date excavation began, where known
DATETIME  Uncoded Value uncategorized none none true
Below The Unit above the current Unit, ie the current Unit is Below Unit X
TEXT  Uncoded Value uncategorized none none true
Above The Unit below the current Unit, ie the current Unit is Above Unit X
TEXT  Uncoded Value uncategorized none none true
SameAs Other Units identified during excavation to be the same as the current Unit.
TEXT  Uncoded Value uncategorized none none true
Disturbed Whether or not the Unit or feature has been disturbed by later deposition (added by the EAMC)
BOOLEAN  Uncoded Value uncategorized none none true
ConjoinsWith Other Units identified as containing sherds that conjoin with artefacts in the current Unit.
TEXT  Uncoded Value uncategorized none none true
Priority1 Priority for detailed cataloguing as identified for the CUGL assemblage. (For the CUGL catalogue only.)
BIGINT  Uncoded Value uncategorized none none true
Priority2 Priority for detailed cataloguing as identified for the CUGL assemblage. (For the CUGL catalogue only.)
BIGINT  Uncoded Value uncategorized none none true
Phase1 The earliest Site Phase in which the Unit or feature may have been created
BIGINT  Uncoded Value uncategorized none none true
Phase2 The latest Site Phase in which the Unit or feature may have been created
BIGINT  Uncoded Value uncategorized none none true
PhaseNotes Notes about the phasing of the Unit or feature.
TEXT  Uncoded Value uncategorized none none true
MinDate TPQ, or the earliest minimum year in which the Unit or feature may have been created, as determined by the artefact with the latest minimum manufacture date
TEXT  Uncoded Value uncategorized none none true
MinDateNotes Notes regarding the determination of the TPQ.
TEXT  Uncoded Value uncategorized none none true
MaxDate TAQ, or the latest maximum year in which the Unit or feature may have been created, usually determined by the minimum date of the strata above this Unit.
TEXT  Uncoded Value uncategorized none none true
MaxDateNotes Notes regarding the determination of the TAQ.
TEXT  Uncoded Value uncategorized none none true
DateNotes General notes about dating the Unit or feature.
TEXT  Uncoded Value uncategorized none none true
Volume Volume of the Unit, if provided on the Context Sheet.
DOUBLE  Uncoded Value uncategorized none none true
Reference Bibliographic reference for the Unit or feature.
TEXT  Uncoded Value uncategorized none none true
Plans Plans showing the Unit or feature.
TEXT  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the Contexts Form.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the Contexts Form.
DATETIME  Uncoded Value uncategorized none none true
Colour Colour of the deposit (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Texture Texture of the deposit (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Moisture Moisture level of the deposit (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Components Components within the deposit (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Length Length of the deposit or feature (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Width Width of the deposit or feature (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Diameter Diameter of the deposit or feature (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
HeightOrDepth Height or depth of the deposit or feature (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true

Table Information: CurrentSite

Column Name Data Type Type Category Coding Sheet Ontology Search
CurrentSite TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfActivities

Column Name Data Type Type Category Coding Sheet Ontology Search
Notes TEXT  Uncoded Value uncategorized none none true
ActivityID BIGINT  Uncoded Value uncategorized none none true
Activity TEXT  Uncoded Value uncategorized none none true
Description TEXT  Uncoded Value uncategorized none none true
OtherNames TEXT  Uncoded Value uncategorized none none true
Source TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfArtefactClasses

Column Name Data Type Type Category Coding Sheet Ontology Search
ArteclassID BIGINT  Uncoded Value uncategorized none none true
Arteclass TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofColours

Column Name Data Type Type Category Coding Sheet Ontology Search
ColourID BIGINT  Uncoded Value uncategorized none none true
ColourName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofContextTypes

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
context type 1 TEXT  Uncoded Value uncategorized none none true
context type 2 TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofDecorations

Column Name Data Type Type Category Coding Sheet Ontology Search
DecorationID BIGINT  Uncoded Value uncategorized none none true
DecorationName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofFormProfiles

Column Name Data Type Type Category Coding Sheet Ontology Search
FormID BIGINT  Uncoded Value uncategorized none none true
FormName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofFormSections

Column Name Data Type Type Category Coding Sheet Ontology Search
SectionShapeID BIGINT  Uncoded Value uncategorized none none true
SectionShapeName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofFunctions

Column Name Data Type Type Category Coding Sheet Ontology Search
FunctionID BIGINT  Uncoded Value uncategorized none none true
OldFunctionID BIGINT  Uncoded Value uncategorized none none true
Activity TEXT  Uncoded Value uncategorized none none true
FunctionName TEXT  Uncoded Value uncategorized none none true
SampleSubfunctions TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofIDMarks

Column Name Data Type Type Category Coding Sheet Ontology Search
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
MarkID BIGINT  Uncoded Value uncategorized none none true
IDMarkName TEXT  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofMakers

Column Name Data Type Type Category Coding Sheet Ontology Search
MakerID BIGINT  Uncoded Value uncategorized none none true
MakerName TEXT  Uncoded Value uncategorized none none true
MakerType M for Maker, D for Distributor
TEXT  Uncoded Value uncategorized none none true
ProductType TEXT  Uncoded Value uncategorized none none true
MakerProvinence TEXT  Uncoded Value uncategorized none none true
MakerDates TEXT  Uncoded Value uncategorized none none true
MakerNotes TEXT  Uncoded Value uncategorized none none true
References TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfMaterials

Column Name Data Type Type Category Coding Sheet Ontology Search
MaterialID BIGINT  Uncoded Value uncategorized none none true
MaterialName TEXT  Uncoded Value uncategorized none none true
ArtefactClass TEXT  Uncoded Value uncategorized none none true
ArtefactClassID BIGINT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofModifications

Column Name Data Type Type Category Coding Sheet Ontology Search
ModificationID BIGINT  Uncoded Value uncategorized none none true
ModificationName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfPatterns

Column Name Data Type Type Category Coding Sheet Ontology Search
PatternID BIGINT  Uncoded Value uncategorized none none true
PatternName TEXT  Uncoded Value uncategorized none none true
PatternType TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfPortions

Column Name Data Type Type Category Coding Sheet Ontology Search
PortionID BIGINT  Uncoded Value uncategorized none none true
PortionName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofProvenance

Column Name Data Type Type Category Coding Sheet Ontology Search
ProvenanceID BIGINT  Uncoded Value uncategorized none none true
ProvenanceName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofRemovalReasons

Column Name Data Type Type Category Coding Sheet Ontology Search
RemovalReasonID BIGINT  Uncoded Value uncategorized none none true
RemovalReasonType TEXT  Uncoded Value uncategorized none none true
RemovalReason TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfSites

Column Name Data Type Type Category Coding Sheet Ontology Search
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true
SiteID BIGINT  Uncoded Value uncategorized none none true
SiteCode TEXT  Uncoded Value uncategorized none none true
SiteName TEXT  Uncoded Value uncategorized none none true
CatalogueNumberPrefix TEXT  Uncoded Value uncategorized none none true
Address TEXT  Uncoded Value uncategorized none none true
SiteOwner TEXT  Uncoded Value uncategorized none none true
Excavator TEXT  Uncoded Value uncategorized none none true
Year/s TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofSkeletalElements

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
skeletal element TEXT  Uncoded Value uncategorized none none true
area of body TEXT  Uncoded Value uncategorized none none true
Activity TEXT  Uncoded Value uncategorized none none true
Use TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofSubfunctions

Column Name Data Type Type Category Coding Sheet Ontology Search
SubfunctionID BIGINT  Uncoded Value uncategorized none none true
SubfunctionName TEXT  Uncoded Value uncategorized none none true
Order BIGINT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
FunctionID BIGINT  Uncoded Value uncategorized none none true
ActivityID BIGINT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofTechniques

Column Name Data Type Type Category Coding Sheet Ontology Search
TechniqueManufID BIGINT  Uncoded Value uncategorized none none true
TechniqueName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: Phases

Column Name Data Type Type Category Coding Sheet Ontology Search
PhaseID Unique ID number allocated to each database record of a Site Phase
BIGINT  Uncoded Value uncategorized none none true
Site Site Code
TEXT  Uncoded Value uncategorized none none true
PhaseNo The number allocated to each Phase by the excavators
BIGINT  Uncoded Value uncategorized none none true
PhaseCode Code combing the Site and Phase No, to distinguish phases from each site in the database
TEXT  Uncoded Value uncategorized none none true
PhaseName The name allocated to each Phase by the excavators
TEXT  Uncoded Value uncategorized none none true
DateFrom The minimum year allocated to each Phase by the excavators
TEXT  Uncoded Value uncategorized none none true
DateTo The maximum year allocated to each Phase by the excavators
TEXT  Uncoded Value uncategorized none none true
Notes Description of the Phase
TEXT  Uncoded Value uncategorized none none true

Table Information: Type Series

Column Name Data Type Type Category Coding Sheet Ontology Search
Notes General notes about this subgroup
TEXT  Uncoded Value uncategorized none none true
Site Must match the site code in the artefacts database
TEXT  Uncoded Value uncategorized none none true
Project Specify project if not part of the original catalogue, ie EAMC.
TEXT  Uncoded Value uncategorized none none true
Arteclass Artefact Class
TEXT  Uncoded Value uncategorized none none true
TSName Name of this Type Series group
TEXT  Uncoded Value uncategorized none none true
TSNo Number of the subgroup within Type Series group
BIGINT  Uncoded Value uncategorized none none true
ArtID ID number of the artefact selected as the representative Type ('T') for this Type Group.
TEXT  Uncoded Value uncategorized none none true
ArtefactID ID number of the artefact selected as the representative Type ('T') for this Type Group.
BIGINT  Uncoded Value uncategorized none none true
Description Description of this subgroup
TEXT  Uncoded Value uncategorized none none true
Colour/pattern Colour or pattern name, where appropriate
TEXT  Uncoded Value uncategorized none none true
Portion The portion of artefact defined by this subgroup, where appropriate (eg pushup bases for bottle groups)
TEXT  Uncoded Value uncategorized none none true
Dimensions Dimensions of artefacts as defined by this subgroup, where appropriate
TEXT  Uncoded Value uncategorized none none true
TS abbrev Abreviation of the TS Name, used in cataloguing, where known (eg AW for Aerated Waters')
TEXT  Uncoded Value uncategorized none none true
Maker Name of Maker defined by this subgroup, where appropriate
TEXT  Uncoded Value uncategorized none none true
Provenance Provenance or place made, as defined by this subgroup, where appropriate
TEXT  Uncoded Value uncategorized none none true
From The earliest production date of artefacts defined by this subgroup, where known
BIGINT  Uncoded Value uncategorized none none true
To The latest production date of artefacts defined by this subgroup, where known
BIGINT  Uncoded Value uncategorized none none true
Photographed Whether or not the representative Type ('T') for this subgroup has been photographed.
BOOLEAN  Uncoded Value uncategorized none none true
EnteredBy The date the database record was created.
TEXT  Uncoded Value uncategorized none none true
DateEntered The log-on name of the person who created the record.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The last date on which any field in this record was modified while using the List Form.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The log-on name of the person who modified the record while using the List Form.
DATETIME  Uncoded Value uncategorized none none true

Data Table Relationships:

Type Local Table Foreign Table Column Relationships
MANY_TO_ONE Artefacts Contexts Site Site UnitandArea UnitandArea
MANY_TO_ONE Phases Contexts PhaseNo Phase2
MANY_TO_ONE Artefacts Type Series TSNo TSNo Site Site TSName TSName
MANY_TO_ONE Phases Contexts PhaseNo Phase1

Spatial Coverage

min long: 151.204; min lat: -33.88 ; max long: 151.205; max lat: -33.879 ;

Record Identifiers

Site Code(s): PM

TDAR ID(s): 6878

FAIMS ID(s): repo.fedarch.org/dataset/6878

Notes

General Note: The post-ex team comprised: Co-ordinator: Wendy Thorp; Ceramics: Mafalda Rossi, Graham Wilson, Wendy Thorp; Glass & bottle stoppers: Martin Carney; Building Materials: Anthony Lowe and Jenni Lindbergh; Metal: Rachel Sparks; Other activity categories: Wendy Thorp, Margaret O’Hea; Leather: Graham Wilson; Animal bone & shell: Dominic Steele; Soil samples: Roy Lawrie; Entological advice: John McDonald; Palynological: Mike McPhail; Conservation: Sue Frost and Coenrad Haartman.

Rights & Attribution: © EAMC Industry Partners 2012

File Information

  Name Size Creation Date Date Uploaded Access
eamc_pm.mdb 30.61mb Aug 20, 2016 11:53:46 AM Confidential