The contents of these files were output by the 'A4DOC' documentation application included with the Alpha 4 software package. These files describe the field definitions and rules for the principle tables underlying the Spanish dialect database.
The following abbreviations are used by Alpha 4 for field type definitions. (Each abbreviation may not be represented in the table definitions included in this project.):
C - character/text
N - numeric
D - date
L - logical
M - memo (long text)
Four of the tables include field definitions only:
GRAMMAR.TXT
LEXICON.TXT
RANGE3.TXT
RANGE5.TXT
Three of the tables include field definitions as well as validation and lookup rules for various fields. It should be noted that 'MASTER.TXT' and 'RESPONSE.TXT' are the primary tables upon which the joined table views 'SPANDIAL.SET' and 'SPANGRAM.SET' were based. As such, they are also fundamental to the work flow described by the 'SPANDIAL.APP' and 'VERIFY.APP' applications:
COUNTY.TXT
MASTER.TXT
RESPONSE.TXT
At the researchers' request and to protect the privacy of the New Mexico-Colorado Spanish Survey consultants and interviewees, the following fields have been removed from the original 'MASTER.DBF' database. Where necessary, field descriptions have been included in parenthesis.
- last
- first
- sex
- addr1
- addr2
- zip
- phone
- birthplace
- age
- yrs_at_res (years at current residence)
- fathers_bp (father's birthplace)
- mothers_bp
- spouses_bp
- no_children (number of children)
- ed_yrs_att (years of schooling)
- spou_s_ab (interviewer's assessment of consultant's Spanish ability)
- desc_sp_ab (interviewer's assessment of consultant childrens' Spanish ability)
- sp_ab_ass (interviewer's assessment of consultant spouse's Spanish ability)
- eng_accent (interviewer's assessment of consultant's English accent when speaking Spanish)
- eng_ab_ass (interviewer's assessment of consultant's English ability)
- sp_accent (interviewer's assessment of consultant's Spanish accent when speaking English)
- house (interviewer's assessment of home value)
- furnishing (interviewer's assessment of value of home furnishings)
- yard (interviewer's assessment of value of yard furnishings)
- automobile (interviewer's assessment of automobile value)
- clothing (interviewer's assessment of value of clothing)
- other_man (interviewer's observation of other manifestations of wealth)
- wealth (interviewer's assessment of overall wealth)
- income
- sp_lit (interviewer's assessment of evident Spanish literacy)
- eng_lit (interviewer's assessment of evident English literacy)
- intervwloc (interviewer's observations on site)
- int_setting (interviewer's observations of setting)
- other_int (other notes regarding the interview)
- tran_span (transcriber's assessment of consultant's Spanish reading ability)
- tr_sp_ab (transcriber's assessment of consultant's Spanish speaking ability)
- tr_eng_ab (transcriber's assessment of consultant's English speaking ability)