ISAR Database record structure This is the structure used for the Rodden-ISAR Database Mark Pottenger (last revised 7/31/87) 512 byte records (including any needed CR/LF or other end markers) 1 Name 30 Last, First for people Alphabetizing order for other things 31 Place 30 61 Calendar Code 1 B Buddhist C Chinese G Gregorian (g if converted from other) H Hebrew I Indian J Julian M Moslem N Japanese(Nipponese) 62 ID for cross-references within database uses next 6 fields: 62 Year 5 (- astronomical dates used instead of BC) 67 Month 2 69 Day 2 71 Hour 2 73 Minute 2 75 Second 2 or Duplicate ID Overflow (A, B, C, etc.) 77 Zone 6 Format: -##:## (+/- hours & minutes) West positive, East negative. 83 Time Type 1 Codes: 0=standard, 1=daylight, 2=war, 3=local mean, 4=double summer, 5=sundial, 6=Sidereal Time, 7=MC, 8=ASC, 9=Sunrise, A=Sunset, B=Solar (Sun on 1st house cusp), C=Ephemeris Time, D=Noon For codes 0-5, recorded time is of type specified. For codes 6-D, recorded time is standard, but original data was of type. 84 Zone & Type Source 1 (encode as a-p) 1 = Birth certificate, 2 = Hospital records, 3 = Mother's memory, 4 = Father's memory, 5 = Other relative's memory, 6 = Personal memory, 7 = Home records (baby book, bible, etc.), 8 = Other contemporary source, 9 = Biography, 10 = Other published, 11 = Rectified, 12 = Psychic/Intuition, 13 = Published Horoscope, 14 = Other, 15 = Unknown, 16 = looked up later 85 Latitude 5 Format: ##D## (degrees direction minutes) I for direction if invalid (not entered) 90 Longitude 6 Format: ###D## (same as lat) 96 Rodden Rating 2 Codes: AA, A, B, C, DD AA birth certificate or other written source A from person B Biography or autobiography C Caution DD Dirty Data or Source of birth data: (encode as a-o) 1 = Birth certificate, 2 = Hospital records, 3 = Mother's memory, 4 = Father's memory, 5 = Other relative's memory, 6 = Personal memory, 7 = Home records (baby book, bible, etc.), 8 = Other contemporary source, 9 = Biography, 10 = Other published, 11 = Rectified, 12 = Psychic/Intuition, 13 = Published Horoscope, 14 = Other, 15 = Unknown + Accuracy of birth time: (enclode as a-i) 1 = One minute/recorded/clock, 2 = Five minutes, 3 = Fifteen minutes, 4 = Half hour, 5 = One hour, 6 = Two hours, 7 = Six hours, 8 = Twelve hours, 9 = No records available 98 Gender 1 F Female, M Male, N None, O Other, U Unknown 99 Publication 1 P Published, U Unpublished 100 Confidentiality 1 P Public figure, C Category, N Name not to be released 101 Reserved space (1 byte for later use) 102 Source/Collection 3 Initials for whose collection data is from. 105 Collection type 2 1 = General/nonspecific, 2 = Specific Health Problem, 3 = Profession/Vocation, 4 = Mundane/geography, 5 = Mundane/finance, 6 = Mundane/disaster, 7 = Mundane/other, 8 = Horse, 9 = Dog, 10 = Cat, 11 = Other animal, ?? 107 Entry Date 6 (MMDDYY) 113 Last Update Date 6 (MMDDYY) 119 Entry Verified 1 (Y/N) 120 Update Verified 1 (Y/N) 121 Category Count 2 Category postings start at byte 129 in record. Category notes start at byte 129 + (Category Count * 7) + (Relations Count * 20) in record. 123 Relations Count 2 Relation postings start at byte 129 + (Category Count * 7) in record. 125 Notes start 3 Byte position within record where text notes start. 128 Carriage return (ASCII 13) This is the end of the fixed section: 128 bytes. All remaining entries are variable in number or length or both. 129 Categories 7 each Codes: first 6 characters: Rodden codes (1-200R, 2-110R, 3-100, etc.) Alternate: anyone else's coding system, with a last character to say whose. 7th character: flag "(" for presense of parenthetical note later. Carriage return (ASCII 13) Relations 5+15 each Codes: 5 characters = Rodden codes ([4-x] plus any needed extensions) 15 characters = ID (described above) for other person Carriage return (ASCII 13) Category Notes (variable, 20 characters maximum inside parentheses) One entry in parentheses for each flagged category earlier, in same order. Recognize entry by "(" & ")". Carriage return (ASCII 13) Alternate birth data for dirty data (any item present uses same format as main section at beginning of record, followed by source in parentheses). Original form of standardized birth data is also recorded here. *S followed by full description of source of main data give names of subsidiary collections here *D followed by date (source) date starts with calendar code as above *T followed by time (source) *P followed by latitude & longitude (source) *Z followed by time zone (source) *Y followed by time type (source) *L followed by reference to Literature (places published) Carriage return (ASCII 13) Notes (variable: remaining bytes in record) Text 512 Carriage Return (ASCII 13).