Summary
The People+Place database is a customised relational database, created in Microsoft Access, and designed to store, display, search and analyse historical occupancy data about Individuals and Buildings or Places in which they lived or worked. While its primary aim is to link archaeological assemblages with the houses, shops and pubs from which they were excavated and the people who lived and worked there, it also serves the needs of historians or heritage managers undertaking site-specific or neighbourhood research. The People+Place database has three major features: (1) It has the capacity to hold data from many different types of historical sources, encompassing Birth Certificates, Council Rates records, newspaper articles and manuscripts that mention a particular building, occupant or landlord. (2) It records both this ‘raw’ data and summarised biographies about people and places, enabling future users to verify the information presented to them. (3) It tracks filial and other relationships between individuals linked to the study area, including marriages, parents and siblings, business partnerships and friendships.
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
SourceID
|
ID number automatically allocated to each bibliographic entry. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
AuthorSurname
|
Surname of the main author. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
AuthorFirstName
|
First name or initial of the main author. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
OtherAuthorSeparator
|
The punctuation or words that should separate the primary author and the co-author, or the first of several co-authors, eg ',', 'and', or 'in association with' |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Other Authors
|
Full names of other authors, with firstname first, eg 'Jane Smith'. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Title
|
The full title of the published document or report, or a description of an excerpt or other work. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Publisher
|
Name of the publisher or client. If a client, include 'for': eg, 'for Jo Smith Pty Ltd'. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PublishedIn
|
Place of publication. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PublishedDate
|
Year of publication or the year a report was released. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Vol
|
Number of volumes included in this entry. (Each volume in a series may be given its own entry.) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Volume or Series Details
|
Details of the series (if this is one volume from a larger series) or all the volumes (if all volumes in a series are included in this record). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PageFrom
|
If an article or excerpt from a larger document, the first page number of this excerpt. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PageTo
|
If an article or excerpt from a larger document, the last page number of this excerpt. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Datefrom
|
Earliest date that information in this document refers to. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateTo
|
Latest date that information in this document refers to. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Source
|
The place or places where this document is held. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
RefNo
|
The reference number or name to retrieve this document from the source selected. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
SourceType
|
The type of information contained in this document: either primary or secondary. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Format
|
Format of physical document, eg 'photocopies of newspapers', 'book', 'box of photographs'. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DocumentType
|
Type of document: 'official', 'post-office directory', 'excavation report' etc |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Comments
|
Any additional comments about the work. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Entered by
|
Name of the person who entered the information about this document into this form. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date when the information about this document was entered into People+Place. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Enteredby
|
Login name of the person who entered the record into People+Place. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
The latest date on which the record was modified using the Biblio form. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last modified the record using the Biblio form. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
BuildingID
|
ID number automatically allocated to each Building. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
SiteName
|
The archaeological site on which the building was excavated (where relevant). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BldgName
|
The primary name by which the Building will be listed, this is usually the most recent or common street address (eg 1 Carahers Lane). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
OtherName
|
Other names by which the Building is referred to historical documentation or recent reports, eg 'The Massey Terraces' |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
FormerAddresses
|
Former street addresses of this building. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BldgCode
|
A unique code allocated to each building, used to sort all buildings by street address and on reports where there is not sufficient space to show the full Building Name. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
StreetNo
|
The number of the house. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
StreetName
|
The name of the street. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Section
|
The Section (or block) number on which the house is situated. This appears on official survey plans. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
LotNumber
|
The lot number within the Section or block. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
ConstructionDate
|
The year the buliding was constructed. (Use of circa is OK.) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DemolitionDate
|
The year the buliding was demolished. (Use of circa is OK.) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
HouseOwners
|
The name(s) of the original owner(s) of the building, where known. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Builder
|
The name(s) of the original builder(s) of the building, where known. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Occupants
|
The name(s) of the original occupant(s) of the building, where known. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Description
|
Description of the building etc known from historical or archaeological sources. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
NoOfFloors
|
Number of floors, if known. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
NoRooms
|
Number of rooms, if known. |
DOUBLE |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DwellingType
|
Dwelling type, at time of construction |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Additional notes or comments about the building and/or its owners/occupiers/builders. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BibliographicReferences
|
References for relevant reports and documents that discuss this building. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Trench
|
For excavated buildings only, the Trench in which it was recovered. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
ArchaeologicalEvidence
|
For excavated buildings only, details of the archaeological remains of the building. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
ExcavSheetRef
|
For excavated buildings only, the excavation plans in which the building appears. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
ContextNo
|
For excavated buildings only, key context numbers associated with the building. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date on which the Building's record was created in the People+Place database. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who created the Building's record in the People+Place database. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date on which the Building's record was last updated or modified using the Buildings Register. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last updated or modified the Building's form using the Buildings Register. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
IndividualID
|
ID number automatically allocated to each Individual. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Title
|
Individual's Title, eg Mr, Mrs or Miss (if known). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Surname
|
Individual's Surname. Use the most common or best-known spelling, or the last known surname for married women. Alternative spellings and names can be entered in the 'Other Surnames' field. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Forename
|
Individual's first name. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MaidenName
|
If the individual is a married woman, enter her maiden name here (if known) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
OtherMarriedNames
|
If the individual is a woman who has married more than once, enter her former married names here (if known) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
OtherSurnames
|
If the individual's surname has multiple spellings, enter the variations here. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Occupation
|
The Occupation(s) of the Individual, if known |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Born
|
The year the individual was born, if known |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Died
|
The year the individual died, if known |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Sex
|
Whether the Individual is male or female |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Married
|
Whether the Individual is married. If yes give the year of marriage in the following format: 'Yes: 1858' |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Children?
|
Whether the Individual has children. If yes, give the number in the following format: 'Yes: 1'. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Immigrant
|
Whether the Individual was an Immigrant to Australia. If yes, give the year they arrived in the following format: 'Yes: 1862'. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Birthplace
|
Where the Individual was born, if known. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EthnicGroup
|
The Ethnic Grouping of the Individual and/or their family (eg, English, Scottish, Chinese), if known. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Religion
|
The religious denomination of the Individual and/or their family, if known. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Literate
|
Whether or not the Individual was literate, if known. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Biography
|
Include here any known biographical notes about the Individual's life. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Include here any notes about the Individual's record, concerns or justification for the inclusion of particular information. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date on which the Individual's record was created in the People+Place database. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who created the Individual's record in the People+Place database. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date on which the Individual's record was last updated or modified using the Individuals Register. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last updated or modified the Individual's form using the Individuals Register. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
BirthsRecordID
|
ID number automatically allocated to each Birth record |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IndividualID
|
The Individual referred to in this Birth Certificate or Baptism Register. Pick from list. Double-click to add an Individual to the list |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Surname
|
The Surname of the Individual exactly as it appears on the Birth Certificate or Baptism Register (ie including mispellings) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Given Name
|
The forename of the Individual exactly as it appears on the Birth Certificate or Baptism Register (ie including mispellings) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Sex
|
Whether male or female |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Date of Birth
|
Date of Birth as listed on the Certificate |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateofBaptism
|
Date of Baptism, if given |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
RegNo
|
Registration Number as it appears on the Certificate |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PlaceofRegistration
|
The place where the child's birth was registered. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Father
|
Father's name as it appears on the Certificate (ie including mispellings), if given. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
FathersAge
|
Father's age as it appears on the Certificate, if given. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
FathersBirthPlace
|
Father's place of birth as it appears on the Certificate, if given. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Father'sOccupation
|
Father's occupation as it appears on the Certificate, if given. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
FatherPreviousIssueLiving
|
The father's surviving children from previous marriages |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
FatherPreviousIssueDeceased
|
The father's deceased children from previous marriages |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Mother
|
Mother's name as it appears on the Certificate (ie including mispellings), if given. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MothersAge
|
Mother's age as it appears on the Certificate, if given. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MothersBirthPlace
|
Mother's place of birth as it appears on the Certificate, if given. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
WhenMarried
|
Date or year when the child's parents married, if given |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
WhereMarried
|
Place where the child's parents married, if given |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MotherPreviousIssueLiving
|
The mother's surviving children from previous marriages |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MotherPreviousIssueDeceased
|
The mother's deceased children from previous marriages |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Residence
|
Where the parents are currently residing |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
InformantName
|
Name of the person who supplied the information for the registration |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
InformantDescription
|
Relationship of the Informant to the family |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
InformantResidence
|
Where the Informant currently resides |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PresentatBirth
|
Names of individuals present at the birth, if given |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Witnesses
|
Witnesses |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Nurse
|
Attending nurse |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Denomination
|
Religious Denomination of the family |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Parish
|
Parish in which they family lives |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Minister
|
Name of minister |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Registrar
|
Name of the Registrar who processed the form |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
RegYear
|
Registration Year |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
VolRef
|
Volume reference for the certificate |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Index Year
|
Index Year |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
District
|
District in which the child was born |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Country
|
County in which the child was born |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Use this field to make any necessary notes about the Certificate or its database record. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Birth Record was created. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who created the Birth Record. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date the Birth Record was last updated or modified using the Births form. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who modified the Birth Record using the Births form. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
Age
|
Age at time of death |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DeathRecordID
|
ID number automatically allocated to each Death record |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IndividualID
|
The Individual referred to in this Death Certificate. Pick from list. Double-click to add an Individual to the list |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
RegNo
|
Registration Number |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Surname
|
Surname of the deceased exactly as it appears on the Death Certificate (ie including mispellings) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Given Name
|
Forename of the deceased exactly as it appears on the Death Certificate (ie including mispellings) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Date
|
Date of death |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Place
|
Place of death |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Occupation
|
Occupation of the deceased |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
CauseOfDeath
|
Illness or condition that caused death |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DurationLastIllness
|
Length of time that the deceased had been suffering from their fatal illness/injuries |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MedicalAttendant
|
Medical attendant by whom the death was certified |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MedicalAttendantLastSeen
|
When Medical Attendant last saw the deceased |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Mother
|
The deceased's mother |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Father
|
The deceased's father |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Informant
|
Signature, description and residence of informant |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
InformantID
|
If the Informant is stored in the People+Place database, you can select their name from this list |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
WhenBuried
|
Date the deceased was buried |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
WhereBuried
|
Place where the deceased was buried |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Undertaker
|
Name of the undertaker |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Minister
|
Name of the minister |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Witnesses
|
Names of any witnesses, if given |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PlaceOfBirth
|
Place where the deceased was born |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
TimeAustnColonies
|
Time spent in the Australian colonies |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MarriageWhere
|
Where the deceased was married |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MarriageAge
|
The age of the deceased when they married |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MarriageSpouse
|
Name of the deceased's spouse |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Issue
|
Issue in order of birth and age at parent's death |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Index Year
|
Year of the Index in which the entry appears |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Denomination
|
Religious Denomination of the deceased |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Parish
|
Parish in which the deceased lived |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
VolRef
|
Volume Reference |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
RegYear
|
Registration Year |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Use this field to make any necessary notes about the Certificate or its database record. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Death Record was entered into People+Place. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who entered the Death Record into People+Place. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
The latest date on which the Death Record was modified using the Deaths form. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last modified the Death Record using the Deaths form |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
WifeStatus
|
Wife's marital status |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PlaceOfRegistration
|
Place of Registration |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MarriageRecordID
|
ID number automatically allocated to each Marriage record |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
HusbandID
|
Unique ID of the husband as stored in the People+Places database. Pick from list. Double-click to add an Individual to the list |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
WifeID
|
Unique ID of the wife as stored in the People+Places database. Pick from list. Double-click to add an Individual to the list |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
RegNo
|
Registration number |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
RegYear
|
Registration Year |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
VolumeNumber
|
Volume Number |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateofMarriage
|
Date of Marriage |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
HusbandFirstName
|
Husband's forename as it appears on the Certificate (ie including spelling mistakes) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
HusbandSurname
|
Husband's Surname as it appears on the Certificate (ie including spelling mistakes) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
HusbandStatus
|
Husband's marital status |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
HusbandBirthPlace
|
Husband's place of birth |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
HusbandOccupation
|
Husband's Rank or Profession |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
HusbandAge
|
Age of Husband at Time of Marriage |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
HusbandUsualResidence
|
Husband's usual residence |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
NameofHusband'sFather
|
Husband's father |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
NameofHusband'sMother
|
Husband's mother |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Husand'sFather'sOccupation
|
Husand's father's occupation |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
WifeFirstName
|
Wife's First Name as it appears on the Certificate (ie including spelling mistakes) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
WifeSurname
|
Wife's Surname or Maiden Name as it appears on the Certificate (ie including spelling mistakes) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
WifeBirthPlace
|
Wife's place of birth |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
WifeOccupation
|
Wife's Rank or Occupation |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
WifeAge
|
Age of Wife at Time of Marriage |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Wife'sUsualResidence
|
Wife's usual place of residence at the time of marriage |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
NameofWife'sFather
|
Wife's father |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
NameofWife'sMother
|
Wife's mother |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Wife'sFather'sOccupation
|
Wife's father's occupation |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
ChildrenfromFormerMarriage
|
Children Living and dead by Each Former Marriage |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Witnesses
|
Name of Witnesses to the marriage |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Minister
|
Minister's name |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Parish
|
Town and Church |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Denomination
|
Religion |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Annotations
|
Annotations made on the Certificate |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Use this field to make any necessary notes about the Certificate or its database record. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Marriage Record was entered into the People+Place database |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who entered the record |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date that the record was last modified while using the Marriages form. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last modified the record while using the Marriages form. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
DirectoriesRecordID
|
ID number automatically allocated to each Directory Listing. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IndividualID
|
The Individual most likely to be referred to in this Directory Listing. Pick from list. Double-click to add an Individual to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BuildingID
|
The Building most likely to be referred to in this Directory Listing. Pick from list. Double-click to add a Building to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IBcode
|
A Code automatically allocated once an Individual and/or Building has been selected. This represents the Individual ID and Building ID numbers. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
SourceID
|
The bibliographic reference for the source of this Directory Listing. Pick from list. Double-click to add an item to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Year
|
Year in which the Directory was listed. (NB even if the Source includes the year, you must repeat it in the 'Year' field to enable sorting.) |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Block
|
The section in which the house appears in the Directory. (Each block was separated in directories by cross streets marked as 'Here lies Cribbs' Lane'.) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
StreetName
|
The name of the street given in the original listing, transcribed exactly as it appears (ie including mispellings) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
StreetNo
|
The number of the house given in the original listing. Note house numbers changed frequently so these may differ from the no. listed in the 'Building' field. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Title
|
The title (eg Mrs, Miss, Dr) of the Individual exactly as it appears in the original listing (ie including mispellings), where given |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
FirstName
|
The forename of the Individual exactly as it appears in the original listing (ie including mispellings), where given |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Surname
|
The Surname of the Individual exactly as it appears in the original listing (ie including mispellings). For companies, place Company name here. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Occupation
|
The Occupation of the Individual exactly as it appears in the original listing, where given |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PageRef
|
The page on which the Directory listing appears |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Include here any notes about the listing or concerns, or justification, for the allocation of this listing to an Individual or Building. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Listing was created. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who created the record. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date the Listing was last updated or modified using the Directories form. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who modified the record using the Directories form. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
InsolvencyID
|
Unique ID number, automatically allocated to each Insolvency Record |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
InsolvRecordNo
|
The Insolvency File number as it appears on the original documents. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IndividualID
|
The Individual most likely to be referred to in this Insolvency Record. Pick from list. Double-click to add an Individual to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BuildingID
|
The Building most likely to be referred to in this Insolvency Record. Pick from list. Double-click to add a Building to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
SourceID
|
The bibliographic reference for the source of this Insolvency Record. Pick from list. Double-click to add an item to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Surname
|
The Surname of the Individual exactly as it appears in the original record (ie including mispellings). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
First Name
|
The forename of the Individual exactly as it appears in the original record (ie including mispellings). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Address
|
The address of the Individual exactly as it appears in the original record (ie including mispellings). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Occupation
|
The Occupation of the Individual exactly as it appears in the original record. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
InsolvDate
|
Date the Individual filed for insolvency. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
InventDate
|
Date that the inventory of the Individual's possessions was taken. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Inspector
|
Name of the inspector who made the inventory, if given. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Insolv Type
|
Type of insolvency claim (eg voluntary or compulsory). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
In Debt
|
Total debts that the Individual had accrued. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Owed
|
Total of amounts owed to the Individual. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Furniture Value
|
Total estimated value of the Individual's furnishings. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Apparel Value
|
Total estimated value of the Individual's clothing and apparel. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Other value
|
Total estimated value of the other items belonging to the Individual, as listed in the inventory. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Additional notes relevant to the record. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Insolvency record was entered into the People+Place database. (The date will appear automatically each time a new record is created.) |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who entered the record into the People+Place database. (The name will appear automatically each time a new record is created.) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date on which the Insolvency record was last updated or modified using the Insolvency form. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last updated or modified using the Insolvency form. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
EnteredBy
|
Login name of the person who entered the record into the People+Place database. (The name will appear automatically each time a new record is created.) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date on which the Insolvency Inventory record was last updated or modified using the Insolvency form. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
InventoryRecordNo
|
ID number automatically allocated to each item in the Inventory. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
InsolvencyID
|
The Insolvency ID number. (If entering the Inventory from the main Insolvency form, this number will be copied automatically from the main part of the form.) |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
InsolvNo
|
The Insolvency File number as it appears on the original documents. (If entering the Inventory from the main Insolvency form, this number will be copied automatically from the main part of the form.) |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Room
|
Room in which the item was recorded |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Item
|
Name of the item |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Quantity
|
Number of items |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Unclear
|
Check box to note whether the notations were unclear and therefore the transcription is uncertain. |
BOOLEAN |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Additional notes relevant to the record. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Inventory item was entered into the People+Place database. (The date will appear automatically each time a new record is created.) |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last updated or modified the Insolvency Inventory record using the Insolvency form. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
ManuscriptRecordID
|
ID number automatically allocated to each Manuscript record |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IndividualID
|
The Individual most likely to be referred to in this Manuscript record. Pick from list. Double-click to add an Individual to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BuildingID
|
The Building most likely to be referred to in this Manuscript Record. Pick from list. Double-click to add a Building to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
SourceID
|
The bibliographic reference for the source of this Manuscript. Pick from list. Double-click to add an item to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
ArchivesRef
|
The catalogue number or other referece used by the Library or Archives to identify this manuscript (or its source). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PageFrom
|
The first or only page of the volume in which this Manuscript record appears. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
PageTo
|
The last page on which this Manuscript record appears. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateFrom
|
The date on which this Manuscript record was created, or for records produced over a period of time, the date the record was started. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateTo
|
For records produced over a period of time, the date the record was last amended. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateNotes
|
Field to include details of approximate or estimated dates etc. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Detail
|
The transcript or summary of the Manuscript record. Enclose direct quotes in quotation marks. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Additional Comments about the Manuscript record or allocation of Individual or Building IDs. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Manuscript record was entered into the People+Place database. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who created the record. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date the Manuscript record was last updated or modified using the Manuscripts form. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last updated or modified the record using the Manuscripts form. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
RateRecordID
|
ID number automatically allocated to each Rates record. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
SourceID
|
The bibliographic reference for the source of this Rates record. Pick from list. Double-click to add an item to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IndividualID
|
The Individual most likely to be the Person Rates in this rates assessment record. Pick from list. Double-click to add an Individual to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IndividualName
|
Name of Person Rated, as it appears on the original record (ie showing mis-spelling where relevant). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
OwnerID
|
The Individual most likely to be the Owner or Landlord noted in this rates assessment record. Pick from list. Double-click to add an Individual to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
OwnerOrLandlord
|
Name of the Owner or Landlord, as it appears on the original record (ie showing mis-spelling where relevant). |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
StreetName
|
The name of the street given in the original listing, transcribed exactly as it appears (ie including mis-spellings), NB street names changed often so these may differ from the street listed in the 'Building' field. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
StreetNo
|
The number of the house given in the original rates assessment. Note house numbers changed frequently so these may differ from the no. listed in the 'Building' field. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BuildingID
|
The Building most likely to be referred to in this Rates Assessment Record. Pick from list. Double-click to add a Building to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IBcode
|
A Code automatically allocated once the Rated Person and/or Building has been selected. This represents the Individual ID and Building ID numbers. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IBcodeOwner
|
A Code automatically allocated once the Owner and/or Building has been selected. This represents the Individual ID and Building ID numbers. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Year
|
Year of assessment |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BldgUse
|
Primary use of the building (i.e. house, warehouse or shop) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BuildingMaterial
|
The building's primary fabric (i.e. brick, stone, timber) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BuildingRoofingMaterials
|
Type of roofing material (i.e. slate, shingles) |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
NoOfFloors
|
Number of floors |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
NoOfRooms
|
Number of rooms |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Rating
|
Nett value fixed by Court of Quarter Sessions |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Comments
|
Comments made on the rates assessment book |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Include here any notes about the listing or concerns, or justification, for the allocation of this listing to an Individual or Building. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Rates record was entered into the People+Place database. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who created the record. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date the Rates record was last updated or modified using the Rates form. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last updated or modified the record using the Rates form. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
IndividualID
|
ID number of the Individual linked to the Family |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
FamilyLinkID
|
ID number automatically allocated to each Family Link Record, ie each record for which an Individual is linked to a Family name |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
FamilyID
|
Unique ID number allocated to each Family |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Include here any notes about the Family Link record or concerns, or justification, for the allocation of this Individual to this Family |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Family Link record was entered into the People+Place database. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who created the Family Link record in the People+Place database. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date the Family Link record was last updated or modified using the Family Associations tab on the Individuals Register |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last updated or modified the Family Link record using the Family Associations tab on the Individuals Register
Login name of the person who last updated or modified the Occupancy Record using the Occupancy Owner form.
|
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
RelationshipID
|
ID number automatically allocated to each Relationship |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IndividualID
|
ID number of the first Individual in the relationship. They are the subject, ie Individual 1 is the wife of Individual 2. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
RelationshipType
|
Description of the relationship, ie wife, sister, brother-in-law |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
RelationshipTo
|
ID number of the second Individual in the relationship. They are the object, ie Individual 1 is the wife of Individual 2. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Include here any notes about the Relationship or concerns, or justification, for the allocation of Individuals |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Relationship record was entered into the People+Place database. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who created the Relationship Record in the People+Place database. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date the Relationship Record was last updated or modified using the Relationships tab of the Individuals Register |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last updated or modified the Relationship Record using the Relationships tab of the Individuals Register
Login name of the person who last updated or modified the Occupancy Record using the Occupancy Owner form.
|
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
IndContextID
|
ID number automatically allocated to each Link between an Individual and a stratigraphic context. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IndividualID
|
ID number of the Individual associated with this stratigraphic context. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Site
|
The site from which the stratigraphic context was recovered, as it appears in the EAMC Archaeology Database. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UnitAndArea
|
The Context Number of the stratigraphic context associated with this Individual, as it appears in the EAMC Archaeology Database. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
MasterContext
|
The Master Context group to which the stratigraphic context was allocated, as it appears in the EAMC Archaeology Database. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
ConfidenceLevel
|
The degree of confidence with which this stratigraphic context has been associated with this Individual. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Add here any notes about the association between this Individual and the stratigraphic context. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Column Name |
Data Type |
Type |
Category |
Coding Sheet |
Ontology |
Search |
OccupancyRecordID
|
ID number automatically allocated to each recorded period of ownership or occupancy. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IBcode
|
A Unique code representing the Individual ID and Building ID numbers. Added automatically, but editable. Add ‘a’, ‘b’, ‘c’ to the end of the Code to distinguish between multiple occupancy periods for the an Individual in the same Building at a later time. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
BuildingID
|
The Building owned or occupied by the Individual in this record. Pick from list. Double-click to add an Individual to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
IndividualID
|
The Individual who owned or occupied the Building in this record. Pick from list. Double-click to add an Individual to the list. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
OccupantType
|
The type of occupation/ownership, eg 'Owner', 'Occupant' |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateFrom
|
The first known year of occupation or ownership, according to current research. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateTo
|
The last known year of occupation or ownership, according to current research. |
BIGINT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Notes
|
Add here any notes about this period of ownership/occupancy. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
Verified
|
Whether or not the record has been reviewed and Verified. Once Verified, a record will not be affected by the automatic upload features of People+Place. |
BOOLEAN |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateEntered
|
Date the Occupancy Link record was entered into the People+Place database. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
EnteredBy
|
Login name of the person who created the Occupancy Link in the People+Place database. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
DateUpdated
|
Date the Occupancy Link was last updated or modified using the Occupancy Link screen. |
DATETIME |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|
UpdatedBy
|
Login name of the person who last updated or modified the Occupancy Link using the Occupancy Link screen. |
TEXT |
Uncoded Value
|
uncategorized |
none
|
none
|
true
|