Database Structure for MASTER Field Type Width Decimal Places 1. INT_NO C 4 2. NO_TAPES C 2 3. LOND N 4 0 4. LONM N 3 0 5. LONS N 3 0 6. LATD N 3 0 7. LATM N 3 0 8. LATS N 3 0 9. DATE D 8 10. CITY C 30 11. STATE C 2 12. INTRVIEWER C 20 13. COUNTY C 2 14. INT_STATE C 2 15. SECTOR C 2 16. URBAN C 1 17. RES_YOUTH C 30 18. AGE_SPAN C 2 19. AGE_ENG C 2 20. ENG_AB_VER C 1 21. SP_AB_VERB C 1 22. CHILD_LANG C 2 23. OTHER_LANG C 20 24. SP_SPOUSE C 1 25. SP_CHILDRN C 1 26. SP_WORK C 1 27. SP_FRIENDS C 1 28. SP_YRS_STD C 2 29. YRS_SP_CNT C 2 30. READ_SP C 1 31. WRITE_SP C 1 32. PREF_SP_TV C 1 33. SPTV_HR_WK C 2 34. PREF_SP_RD C 1 35. SPRADIO_WK C 2 36. ADJLOND N 3 0 37. ADJLONM N 2 0 38. ADJLONS N 2 0 39. ADJLATD N 2 0 40. ADJLATM N 2 0 41. ADJLATS N 2 0 42. LONGDEC N 11 6 43. LATDEC N 9 6 44. LOCATION C 15 45. LOC_ST C 2 46. PARAGOGIC C 1 47. PALATAL C 1 48. ASPIRATION C 1 1. INT_NO (Field 1) Type : Character Value : User Entered Field Mask : 9999 Mask Override Allowed : Yes Auto Increment Field : Increment for each new record Required Field : Yes User Defined Prompt : Please check hardcopy before entering number. Posting : No Auto Advance : No Lookup : No 2. NO_TAPES (Field 2) Type : Character Value : User Entered Field Mask : 99 Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : No 3. LOND (Field 3) Type : Numeric Value : User Entered Minimum Value : 103 Maximum Value : 108 Default Value : Value Default Expression : 106 Required Field : Yes User Defined Prompt : Read the Map! Posting : No Auto Advance : No 4. LONM (Field 4) Type : Numeric Value : User Entered Minimum Value : 0 Maximum Value : 59 Posting : No Auto Advance : No 5. LONS (Field 5) Type : Numeric Value : User Entered Minimum Value : 0 Maximum Value : 59 Posting : No Auto Advance : No 6. LATD (Field 6) Type : Numeric Value : User Entered Minimum Value : 31 Maximum Value : 39 Default Value : Value Default Expression : 36 Posting : No Auto Advance : No 7. LATM (Field 7) Type : Numeric Value : User Entered Minimum Value : 0 Maximum Value : 59 Posting : No Auto Advance : No 8. LATS (Field 8) Type : Numeric Value : User Entered Automatic Capitalization Mode : Capitalize first letter of each word in the field Minimum Value : 0 Maximum Value : 59 Posting : No Auto Advance : No 9. STATE (Field 11) Type : Character Value : User Entered Automatic Capitalization Mode : Capitalize entire field Field Mask : aa Posting : No Auto Advance : No Lookup : No 10. INTRVIEWER (Field 12) Type : Character Value : User Entered Automatic Capitalization Mode : Capitalize entire field Posting : No Auto Advance : No Lookup : No 11. COUNTY (Field 13) Type : Character Value : User Entered Automatic Capitalization Mode : Capitalize entire field Field Mask : aa Required Field : Expression Posting : No Auto Advance : No Lookup : Yes Lookup Source : Database Lookup Validation Mode : Exists Lookup Exceptions Allowed : No Lookup Location : 3 Lookup Display Rows : 10 Lookup Auto Popup : Yes Lookup Database : county Lookup Link Index : bycounty Lookup Layout Choice Field Filled Field Display Width COUNTY Y 15 CODE COUNTY Y 2 ST INT_STATE Y 2 SECTOR SECTOR Y 2 12. INT_STATE (Field 14) Type : Character Value : User Entered Mask Override Allowed : Yes Skip Rule Expression : len(trim(INT_STATE))>1 Posting : No Auto Advance : No Lookup : No 13. SECTOR (Field 15) Type : Character Value : User Entered Automatic Capitalization Mode : Capitalize entire field Field Mask : 99 Mask Override Allowed : Yes Skip Rule Expression : len(trim(SECTOR))>0 Posting : No Auto Advance : No Lookup : No 14. URBAN (Field 16) Type : Character Value : User Entered Automatic Capitalization Mode : Capitalize entire field Field Mask : a Mask Override Allowed : Yes Field Validation : URBAN$'YN ?yn' User Defined Prompt : Leave blank, if question was not asked Posting : No Auto Advance : No Lookup : No 15. AGE_SPAN (Field 18) Type : Character Value : User Entered Field Mask : 99 Mask Override Allowed : Yes User Defined Prompt : Enter 1 for native speaker, 0 for never learned. Posting : No Auto Advance : No Lookup : No 16. AGE_ENG (Field 19) Type : Character Value : User Entered Field Mask : 99 Mask Override Allowed : Yes User Defined Prompt : Enter 1 for native speaker, 0 for never learned Posting : No Auto Advance : No Lookup : No 17. ENG_AB_VER (Field 20) Type : Character Value : User Entered Field Mask : 9 Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : Yes Lookup Source : Database Lookup Validation Mode : Exists Lookup Exceptions Allowed : Yes Lookup Location : 3 Lookup Display Rows : 4 Lookup Auto Popup : Yes Lookup Database : range3 Lookup Layout Choice Field Filled Field Display Width NUMBER ENG_AB_VER Y 1 ABILITY Y 16 18. SP_AB_VERB (Field 21) Type : Character Value : User Entered Field Mask : 9 Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : Yes Lookup Source : Database Lookup Validation Mode : Exists Lookup Exceptions Allowed : Yes Lookup Location : 3 Lookup Display Rows : 4 Lookup Auto Popup : Yes Lookup Database : range3 Lookup Layout Choice Field Filled Field Display Width NUMBER SP_AB_VERB Y 1 ABILITY Y 16 19. CHILD_LANG (Field 22) Type : Character Value : User Entered Automatic Capitalization Mode : Capitalize entire field Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : No 20. OTHER_LANG (Field 23) Type : Character Value : User Entered Automatic Capitalization Mode : Capitalize entire field Mask Override Allowed : Yes User Defined Prompt : Enter other languages used in following ratings. Posting : No Auto Advance : No Lookup : No 21. SP_SPOUSE (Field 24) Type : Character Value : User Entered Field Mask : 9 Mask Override Allowed : Yes User Defined Prompt : Compare English/other language use to Spanish. Posting : No Auto Advance : No Lookup : Yes Lookup Source : Database Lookup Validation Mode : Exists Lookup Exceptions Allowed : Yes Lookup Location : 3 Lookup Display Rows : 6 Lookup Auto Popup : Yes Lookup Database : range5 Lookup Layout Choice Field Filled Field Display Width NUMBER SP_SPOUSE Y 1 LANG_USE Y 14 22. SP_CHILDRN (Field 25) Type : Character Value : User Entered Field Mask : 9 Mask Override Allowed : Yes User Defined Prompt : Compare English/other language use to Spanish. Posting : No Auto Advance : No Lookup : Yes Lookup Source : Database Lookup Validation Mode : Exists Lookup Exceptions Allowed : Yes Lookup Location : 3 Lookup Display Rows : 6 Lookup Auto Popup : Yes Lookup Database : range5 Lookup Layout Choice Field Filled Field Display Width NUMBER SP_CHILDRN Y 1 LANG_USE Y 14 23. SP_WORK (Field 26) Type : Character Value : User Entered Field Mask : 9 Mask Override Allowed : Yes User Defined Prompt : Compare English/other language use to Spanish. Posting : No Auto Advance : No Lookup : Yes Lookup Source : Database Lookup Validation Mode : Exists Lookup Exceptions Allowed : Yes Lookup Location : 3 Lookup Display Rows : 6 Lookup Auto Popup : Yes Lookup Database : range5 Lookup Layout Choice Field Filled Field Display Width NUMBER SP_WORK Y 1 LANG_USE Y 14 24. SP_FRIENDS (Field 27) Type : Character Value : User Entered Field Mask : 9 Mask Override Allowed : Yes User Defined Prompt : Compare English/other language use with Spanish. Posting : No Auto Advance : No Lookup : Yes Lookup Source : Database Lookup Validation Mode : Exists Lookup Exceptions Allowed : Yes Lookup Location : 3 Lookup Display Rows : 6 Lookup Auto Popup : Yes Lookup Database : range5 Lookup Layout Choice Field Filled Field Display Width NUMBER SP_FRIENDS Y 1 LANG_USE Y 14 25. SP_YRS_STD (Field 28) Type : Character Value : User Entered Field Mask : 99 Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : No 26. YRS_SP_CNT (Field 29) Type : Character Value : User Entered Field Mask : 99 Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : No 27. READ_SP (Field 30) Type : Character Value : User Entered Field Mask : 9 Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : Yes Lookup Source : Database Lookup Validation Mode : Exists Lookup Exceptions Allowed : Yes Lookup Location : 3 Lookup Display Rows : 4 Lookup Auto Popup : Yes Lookup Database : range3 Lookup Layout Choice Field Filled Field Display Width NUMBER READ_SP Y 1 ABILITY Y 16 28. WRITE_SP (Field 31) Type : Character Value : User Entered Field Mask : 9 Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : Yes Lookup Source : Database Lookup Validation Mode : Exists Lookup Exceptions Allowed : Yes Lookup Location : 3 Lookup Display Rows : 4 Lookup Auto Popup : Yes Lookup Database : range3 Lookup Layout Choice Field Filled Field Display Width NUMBER WRITE_SP Y 1 ABILITY Y 16 29. PREF_SP_TV (Field 32) Type : Character Value : User Entered Automatic Capitalization Mode : Capitalize entire field Field Mask : a Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : No 30. SPTV_HR_WK (Field 33) Type : Character Value : User Entered Field Mask : 99 Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : No 31. PREF_SP_RD (Field 34) Type : Character Value : User Entered Automatic Capitalization Mode : Capitalize entire field Field Mask : a Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : No 32. SPRADIO_WK (Field 35) Type : Character Value : User Entered Field Mask : 99 Mask Override Allowed : Yes Posting : No Auto Advance : No Lookup : No 33. LONGDEC (Field 42) Type : Numeric Value : Calculated Calculated Expression : -1*(ADJLOND+ADJLONM/60+ADJLONS/3600) Posting : No Auto Advance : No 34. LATDEC (Field 43) Type : Numeric Value : Calculated Calculated Expression : ADJLATD+ADJLATM/60+ADJLATS/3600 Posting : No Auto Advance : No