'Pointing Hand' Census Database

Data Fields Definition

Data Field Description Edit Permission
ID Internal system Identifier for each record System
Source Name of DB User who enters a record. System
Cover Front The bitmap (.jpg, .bmp. .gif, .png) image of the front side of the cover. Preferred scan is 300dpi Contributor
Cover Back The bitmap (.jpg, .bmp. .gif, .png) image of the back or reverse side of the cover. Preferred scan is 300dpi Contributor
PostmarkYear 4 digit number representing the postmark year if known. Has to be between 1700 and 2050 Contributor
PostmarkMonth 2 digit number representing the postmark month if known. Has to be between 1 and 12 Contributor
PostmarkDay 2 digit number representing the postmark day if known. Has to be between 1 and 31 Contributor
PostmarkCity Field for the postmark city name Contributor
PostmarkState Field that holds postmark state name Contributor
PostmarkCountry Field that holds postmark country name Contributor
CoverType Field that holds cover type System
Released Field that holds released state of the record (reviewed and/or viewable to public), must be either 'Yes' or 'No' Admin
Comments Field that holds any free form comments Contributor
FingerStyle Field that holds Finger style - 'Stamp', 'Label', 'Handdrawn' Contributor
ReturnToType Field that holds - 'Return To Writer', 'Return To Sender' Contributor
OtherAuxMarkings Field that holds additional Auxiliary markings, separated by comma Contributor
FingerDirection Field that holds - 'Points Left', 'Points Right' Contributor
FingerColor Field that holds color of Finger marking Contributor
FingerYear 4 digit number representing the Finger year if known. Has to be between 1700 and 2050 Contributor
FingerMonth 2 digit number representing the Finger month if known. Has to be between 1 and 12 Contributor
FingerDay 2 digit number representing the Finger day if known. Has to be between 1 and 31 Contributor
FingerCity Field that holds Finger city name Contributor
FingerState Field that holds Finger state name Contributor
DestCity Field that holds destination city name Contributor
DestState Field that holds destination state name Contributor