{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sales 2022_23 bulk upload spec"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sales 2022_23 bulk upload spec","index":0,"n_rows":414,"n_cols":6,"rows_kept":414,"cut":false,"hidden":false,"merged":[[387,3,389,3],[387,4,389,4],[302,4,342,4],[344,4,384,4],[259,5,299,5],[300,5,301,5],[302,5,342,5],[344,5,384,5],[259,1,299,1],[259,2,299,2],[302,1,342,1],[302,2,342,2],[344,1,384,1],[344,2,384,2],[1,5,4,5],[5,1,7,1],[8,2,10,2],[8,1,10,1],[40,1,51,1],[40,2,51,2],[40,5,51,5],[5,2,7,2],[13,1,17,1],[13,2,17,2],[13,5,17,5],[18,1,22,1],[18,2,22,2],[13,4,22,4],[18,5,22,5],[23,1,27,1],[23,2,27,2],[23,4,27,4],[23,5,27,5],[72,1,77,1],[72,2,77,2],[72,4,77,4],[28,4,39,4],[40,4,51,4],[52,5,71,5],[72,5,77,5],[300,1,301,1],[300,2,301,2],[259,4,299,4],[300,3,301,3],[300,4,301,4],[249,5,252,5],[253,1,258,1],[249,4,252,4],[28,1,39,1],[28,2,39,2],[28,5,39,5],[52,1,71,1],[52,2,71,2],[52,4,71,4],[107,1,108,1],[107,2,108,2],[107,3,108,3],[107,4,108,4],[109,1,110,1],[109,2,110,2],[109,3,110,3],[109,4,110,4],[113,1,115,1],[113,2,115,2],[113,4,127,4],[80,5,82,5],[87,4,93,4],[94,4,97,4],[94,1,97,1],[94,2,97,2],[83,5,85,5],[98,1,106,1],[98,2,106,2],[98,4,106,4],[78,3,79,3],[78,4,79,4],[80,1,82,1],[80,2,82,2],[87,1,93,1],[87,2,93,2],[83,1,85,1],[83,2,85,2],[80,4,85,4],[151,1,154,1],[151,2,154,2],[151,4,154,4],[146,1,147,1],[148,1,149,1],[148,2,149,2],[148,3,149,3],[109,5,110,5],[111,1,112,1],[111,2,112,2],[111,3,112,3],[111,4,112,4],[111,5,112,5],[146,2,147,2],[146,3,147,3],[116,2,118,2],[119,1,121,1],[119,2,121,2],[122,1,124,1],[122,2,124,2],[125,1,127,1],[125,2,127,2],[116,1,118,1],[128,1,131,1],[128,2,131,2],[128,4,135,4],[132,1,135,1],[132,2,135,2],[137,1,142,1],[137,2,142,2],[137,4,142,4],[143,1,145,1],[143,2,145,2],[143,4,145,4],[176,5,182,5],[177,1,182,1],[177,2,182,2],[177,4,182,4],[155,5,162,5],[163,1,165,1],[163,2,165,2],[163,4,165,4],[163,5,175,5],[172,1,175,1],[172,2,175,2],[172,4,175,4],[155,1,162,1],[155,2,162,2],[155,4,162,4],[188,4,192,4],[193,1,194,1],[193,2,194,2],[193,4,195,4],[183,5,194,5],[186,1,187,1],[183,4,184,4],[186,4,187,4],[188,1,192,1],[188,2,192,2],[186,2,187,2],[183,1,184,1],[183,2,184,2],[206,1,207,1],[206,2,207,2],[206,4,207,4],[206,5,207,5],[196,5,197,5],[198,1,205,1],[198,2,205,2],[198,5,205,5],[198,4,205,4],[212,2,216,2],[212,4,216,4],[210,5,219,5],[217,1,218,1],[223,1,224,1],[223,2,224,2],[223,3,224,3],[220,1,222,1],[220,2,222,2],[220,4,222,4],[212,1,216,1],[217,2,218,2],[217,4,218,4],[210,1,211,1],[210,2,211,2],[210,4,211,4],[223,5,224,5],[220,5,222,5],[249,1,252,1],[249,2,252,2],[253,2,258,2],[253,4,258,4],[230,1,234,1],[230,2,234,2],[230,4,234,4],[226,1,227,1],[226,2,227,2],[226,4,229,4],[228,1,229,1],[228,2,229,2],[136,5,154,5],[128,5,135,5],[395,5,398,5],[395,4,398,4],[395,2,398,2],[395,1,398,1],[408,3,410,3],[408,4,410,4],[8,4,10,4],[8,5,10,5],[87,5,93,5],[94,5,97,5],[98,5,106,5],[107,5,108,5],[113,5,127,5],[241,5,248,5],[253,5,258,5],[235,2,236,2],[235,4,236,4],[226,5,237,5],[235,1,236,1],[241,1,248,1],[241,2,248,2],[241,4,248,4]]}
[null,"Bulk upload field number","Question","Responses","Allowable entries","Can be null?"]
[null,1,"What is the purchaser code?","This is how you usually refer to this buyer on your own systems.\nUsed with date of sale (fields 2 - 4) to identify individual logs and check for duplicates.","Alphanumeric, punctuation can be used as long as not the field separator.\nMax 9 digits.","No"]
[null,2,"What is the day of the sale completion date? - DD","Sale date - day DD","Numeric, range 1 - 31"]
[null,3,"What is the month of the sale completion date? - MM","Sale date - month MM","Numeric, range 1 - 12"]
[null,4,"What is the year of the sale completion date? - YY","Sale date - year YY","Numeric, range 19 - 23"]
[null,5,"[BLANK]"]
[]
[]
[null,6,"Was the buyer interviewed for any of the answers you will provide on this log?","Value labels:","Numeric, range 1 - 2","Yes"]
[null,null,null,"2 = Yes"]
[null,null,null,"1 = No"]
[null,7,"Age of Buyer 1","Age of buyer 1 (lead purchaser)","Numeric.\nRange 15 - 110 or text (upper case 'R')","Yes, if buyer not interviewed "]
[null,"8 to 12","Ages of Person 2-6","Ages of other household members (persons 2 to 6).","Numeric\nRange 1-110 or text (upper case 'R')\nMust be >= 16 if working situation = 1-8 or 0\nMust be <16 if working situation = 9","Yes: if sex, relationship and economic status for this person are also null"]
[null,13,"Gender identity of Buyer 1","Value labels:","Text, upper case 'F' 'M' 'X' or 'R' (text qualifier accepted)","Yes, if buyer not interviewed "]
[null,null,null,"F = Female"]
[null,null,null,"M = Male"]
[null,null,null,"X = Non Binary"]
[null,null,null,"R = Buyer prefers not to say"]
[null,"14 to 18","Gender identity of Persons 2 - 6","Value labels:",null,"Yes, only if age, relationship and working situation for this buyer are also null."]
[null,null,null,"F = Female"]
[null,null,null,"M = Male"]
[null,null,null,"X = Non Binary"]
[null,null,null,"R = Person prefers not to say"]
[null,"19 to 23","Relationship to Buyer 1 or Persons 2 - 6","Value labels:","Text, upper case 'P' 'C' 'X' 'R' (text qualifier accepted)","Yes, only if age, relationship and working situation for this person are also null."]
[null,null,null,"P = Partner"]
[null,null,null,"C = Child"]
[null,null,null,"X = Other"]
[null,null,null,"R = Person prefers not to say"]
[null,24,"Working situation of Buyer 1","Value labels:","Numeric, range 0 - 10","Yes, if buyer not interviewed "]
[null,null,null,"1 = Full-time - 30 hours a week or more"]
[null,null,null,"2 = Part-time - Less than 30 hours a week"]
[null,null,null,"3 = In government training into work, such as New Deal"]
[null,null,null,"4 = Jobseeker"]
[null,null,null,"5 = Retired"]
[null,null,null,"6 = Not seeking work"]
[null,null,null,"7 = Full-time student"]
[null,null,null,"8 = Unable to work because of long-term sickness or disability"]
[null,null,null,"9 = Child under 16"]
[null,null,null,"0 = Other"]
[null,null,null,"10 = Buyer prefers not to say"]
[null,"25 to 29","Working situation of Persons 2 - 6","Value labels:","Numeric, range 0 - 10\nMust be 9 if age<16","Yes, only if age, gender identity and relationship for this person are also null."]
[null,null,null,"1 = Full-time - 30 hours a week or more"]
[null,null,null,"2 = Part-time - Less than 30 hours a week"]
[null,null,null,"3 = In government training into work, such as New Deal"]
[null,null,null,"4 = Jobseeker"]
[null,null,null,"5 = Retired"]
[null,null,null,"6 = Not seeking work"]
[null,null,null,"7 = Full-time student"]
[null,null,null,"8 = Unable to work because of long-term sickness or disability"]
[null,null,null,"9 = Child under 16"]
[null,null,null,"0 = Other"]
[null,null,null,"10 = Person prefers not to say"]
[null,30,"What is buyer 1's ethnic group?","Value labels:","Numeric, range 0 - 17","Yes, if buyer not interviewed "]
[null,null,null,"1 = White: English, Scottish, Welsh, Northern Irish, British"]
[null,null,null,"2 = White: Irish"]
[null,null,null,"3 = White: Other"]
[null,null,null,"4 = Mixed: White and Black Caribbean"]
[null,null,null,"5 = Mixed: White and Black African"]
[null,null,null,"6 = Mixed: White and Asian"]
[null,null,null,"7 = Mixed: Other"]
[null,null,null,"8 = Asian or Asian British: Indian"]
[null,null,null,"9 = Asian or Asian British : Pakistani"]
[null,null,null,"10 = Asian or Asian British: Bangladeshi"]
[null,null,null,"11 = Asian or Asian British:  Other"]
[null,null,null,"12 = Black or Black British: Caribbean"]
[null,null,null,"13 = Black or Black British : African"]
[null,null,null,"14 = Black or Black British : Other"]
[null,null,null,"15 = Chinese"]
[null,null,null,"16 = Other ethnic group: Other "]
[null,null,null,"17 = Buyer prefers not to say"]
[null,null,null,"18 = White: Gypsy/Irish Traveller"]
[null,null,null,"19 = Other ethnic group: Arab "]
[null,31,"What is buyer 1's nationality?","Value labels:","Numeric, range 12 - 13 or 17 - 19","Yes, if buyer not interviewed "]
[null,null,null,"12 = Any other country"]
[null,null,null,"13 = Buyer prefers not to say"]
[null,null,null,"17 = Republic of Ireland"]
[null,null,null,"18 = United Kingdom"]
[null,null,null,"19 = European Economic Area (EEA) country, excluding Ireland"]
[null,32,"What is buyer 1's gross annual income?","Numeric in pounds. Rounded to the nearest pound.","Numeric, range 0 - 99999 ","Yes, if buyer not interviewed "]
[null,33,"What is buyer 2's gross annual income?",null,null,"Yes, if age, sex, relationship and economic status of this person are null"]
[null,34,"Was buyer 1's income used for a mortgage application?","Value labels:","Numeric, 1-2","No"]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,35,"Was buyer 2's income used for a mortgage application?","Value labels:",null,"Yes, if there was only one buyer"]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,36,"What is the total amount the buyers had in savings before they paid any deposit for the property?","Numeric in pounds. Rounded to the nearest £10.","Numeric, range 0 - 99990","Yes, if buyer not interviewed "]
[null,37,"Have any of the purchasers previously owned a property?","Value labels:","Numeric, range 1 - 3","Yes, if buyer not interviewed "]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,null,null,"3 = Don't Know"]
[]
[]
[]
[null,38,"[BLANK]"]
[]
[]
[]
[null,39,"What was buyer 1's previous tenure?","Value labels:","Numeric, range 1 - 7 or 9","Yes, if buyer not interviewed "]
[null,null,null,"1 = Local authority tenant"]
[null,null,null,"2 = Private registered provider (PRP) or houasing association tenant"]
[null,null,null,"3 = Private tenant"]
[null,null,null,"4 = Tied home or renting with job"]
[null,null,null,"5 = Owner occupier"]
[null,null,null,"6 = Living with family or friends"]
[null,null,null,"7 = Temporary accomodation"]
[null,null,null,"9 = Other"]
[null,40,"What is the local authority of buyer 1's last settled home?","9 character ONS code, beginning 'E'","9 characters, alphanumeric\n(text qualifier required)","No"]
[]
[null,41,"Part 1 of postcode of buyer 1's last settled home","Part 1 of postcode for the location of the previous settled accommodation.\nCombined with field 42, it should be a postcode which lies within the local authority given in field 40. ","2-4 characters, alphanumeric\n(text qualifier required)","Only if field 43 = 1"]
[]
[null,42,"Part 2 of postcode of buyer 1's last settled home","Part 2 of postcode for the location of the previous settled accommodation.\nCombined with field 41, it should be a postcode which lies within the local authority given in field 40. ","3 characters, alphanumeric\n(text qualifier required)","Only if field 43 = 1"]
[]
[null,43,"Do you know the postcode of buyer 1's last settled home?","Value labels:","Numeric, range 1 or null\n(text qualifier accepted)","Yes"]
[null,null,null,"1 = Yes"]
[null,null,null,"Null = No"]
[null,44,"Was the buyer registered with their PRP (HA)?","Value labels:"]
[null,null,null,"1 = Yes"]
[null,null,null,"Null = No"]
[null,45,"Was the buyer registered with the local authority?","Value labels:"]
[null,null,null,"1 = Yes"]
[null,null,null,"Null = No"]
[null,46,"Was the buyer registered with a Help to Buy agent?","Value labels:"]
[null,null,null,"1 = Yes"]
[null,null,null,"Null = No"]
[null,47,"Was the buyer registered with another PRP (HA)?","Value labels:"]
[null,null,null,"1 = Yes"]
[null,null,null,"Null = No"]
[null,48,"Does anyone in the household consider themselves to have a disability?","Value labels:","Numeric, range 1 - 3","Yes, if buyer not interviewed "]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,null,null,"3 = Don’t know"]
[null,49,"Does anyone in the household use a wheelchair?","Value labels:"]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,null,null,"3 = Don’t know"]
[null,50,"How many bedrooms does the property have?","Number of bedrooms. For a bedsit, enter 1.","Numeric, range 1 - 9","No"]
[null,51,"What type of unit is the property?","Value labels:","Numeric, range 1 - 4 or 9"]
[null,null,null,"1 = Flat or maisonette"]
[null,null,null,"2 = Bedsit"]
[null,null,null,"3 = House"]
[null,null,null,"4 = Bungalow"]
[null,null,null,"9 = Other"]
[null,52,"Which type of bulding is the property?","Value labels:","Numeric, range 1 or 2"]
[null,null,null,"1 = Purpose built"]
[null,null,null,"2 = Converted from previous residential or non-residential property"]
[null,53,"What is the local authority of the property?","9 character ONS code, beginning with 'E'.","9 characters, alphanumeric"]
[{"$nulls":4},"(text qualifier required)"]
[null,54,"Part 1 of postcode of property","Part 1 of postcode for the location of the property.\nCombined with field 55, it should be a postcode which lies within the local authority given in field 53. ","2-4 characters, alphanumeric"]
[{"$nulls":4},"(text qualifier required)"]
[null,55,"Part 2 of postcode of property","Part 2 of postcode for the location of the property.\nCombined with field 54, it should be a postcode which lies within the local authority given in field 53. ","3 characters, alphanumeric\n(text qualifier required)"]
[null,56,"Is the property built or adapted to wheelchair user standards?","Value labels:","Numeric, range 1 - 3"]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,null,null,"3 = Don’t know"]
[null,57,"What is the type of shared ownership sale?","Value labels:","Numeric, range 2, 16, 18, 24, 28 or 30-31","Yes, if one of fields 76 or 84 are not null"]
[null,null,null,"2 = Shared Ownership"]
[null,null,null,"16 = Home Ownership for people with Long-term Disabilities (HOLD)"]
[null,null,null,"18 = Social HomeBuy - shared ownership purchase"]
[null,null,null,"24 = Older Persons Shared Ownership"]
[null,null,null,"28 = Rent to Buy - Shared Ownership"]
[null,null,null,"30 = Shared Ownership - 2021 model lease"]
[null,null,null,"31 = Right to Shared Ownership"]
[null,58,"Is this a resale?","Value labels:","Numeric, range 1 or 2","Yes, if field 113 = 2 or 3"]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,59,"What is the day of the practical completion or handover date?","Practical completion or handover date - day DD","Numeric, range 1 - 31"]
[null,60,"What is the month of the practical completion or handover date?","Practical completion or handover date - month MM","Numeric, range 1 - 12"]
[null,61,"What is the day of the exchange of contracts date?","Practical completion or handover date - year YY","Numeric, range 19 -23"]
[null,62,"What is the day of the practical completion or handover date?","Exchange of contracts date - day DD","Numeric, range 1 - 31"]
[null,63,"What is the month of the practical completion or handover date?","Exchange of contracts date - month MM","Numeric, range 1 - 12"]
[null,64,"What is the year of the practical completion or handover date?","Exchange of contracts date - year YY","Numeric, range 19 -23"]
[null,65,"Was the household re-housed under a local authority nominations agreement?","Value labels:","Numeric, range 1 - 3"]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,null,null,"3 = Don't Know"]
[null,66,"How many bedrooms did the buyer's previous property have?","Number of bedrooms. For a bedsit, enter 1.","Numeric, range 1 - 9","Yes, if field 113 = 2 or 3\nOR\nfield 39 = 3 - 7 or 9"]
[null,67,"What was the type of the buyer's previous property?","Value labels:","Numeric, range 1 - 4 or 9"]
[null,null,null,"1 = Flat/Maisonette"]
[null,null,null,"2 = Bedsit"]
[null,null,null,"3 = House"]
[null,null,null,"4 = Bungalow"]
[null,null,null,"9 = Other"]
[null,68,"What was the full purchase price?","Market value before any discount, for 100% of the equity of the property.","Numeric, range 0 - 999999","Yes, if field 113 = 2 or 3"]
[null,null,null,"Numeric in pounds. Rounded to the nearest pound."]
[null,69,"What was the initial percentage equity stake purchased?","This is the initial stake purchased.","Numeric, range 0 - 100"]
[null,70,"What is the mortgage amount?","Enter the amount of mortgage agreed with the mortgage lender. Exclude any deposits or cash payments.","Numeric, range 0 - 999999"]
[null,null,null,"Numeric in pounds. Rounded to the nearest pound."]
[null,71,"Does this include any extra borrowing?","This is 'Yes' if the mortgage includes borrowing beyond the purchase price of the property","Numeric, range 1 - 3"]
[null,null,null,"Value labels:"]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,null,null,"3 = Don't Know"]
[null,72,"How much was the cash deposit paid on the property?","Full amount paid by purchaser, not funded by the mortgage .ie. the difference between the cost of the equity and the mortgage.","Numeric, range 0 - 999999"]
[null,null,null,"Numeric in pounds. Rounded to the nearest pound."]
[null,73,"How much cash discount was given through Social Homebuy?","Numeric in pounds. Rounded to the nearest pound.",null,"Yes, if field 57 is null, 2, 16, 24 or 26"]
[null,74,"What is the basic monthly rent?","Rent element only. Numeric in pounds (to 2 decimal places)","Numeric, in the form xxxx.xx","Yes, if field 113 = 2 or 3"]
[null,75,"What are the total monthly leasehold charges for the property?","Includes service charges, management charges. Exclude rent. Numeric in pounds (to 2 decimal places)","Numeric, in the form xxxx.xx"]
[null,76,"What is the type of discounted ownership sale?","Value labels:","Numeric, range 8, 9, 14, 21, 22, 27 or 29","Yes, if field 113 = 1 or 3"]
[null,null,null,"8 = Right to Acquire (RTA)"]
[null,null,null,"14 = Preserved Right to Buy (PRTB)"]
[null,null,null,"27 = Voluntary Right to Buy"]
[null,null,null,"9 = Right to Buy (RTB)"]
[null,null,null,"29 = Rent to Buy - Full ownership"]
[null,null,null,"21 = Social HomeBuy - for outright purchase"]
[null,null,null,"22 = Any other Equity loan scheme"]
[null,77,"What was the full purchase price?","Market value before any discount, for 100% of the equity of the property.","Numeric, range 0 - 999999","Yes, if field 76 is null"]
[null,null,null,"Numeric in pounds. Rounded to the nearest pound."]
[null,78,"What was the amount of any loan, grant, discount or subsidy given?","For all schemes apart from RTB and PRTB.","Numeric, range 8000 - 16000","Yes, if field 76 is null, 9 or 14"]
[null,79,"What was the percentage discount?","For RTB and PRTB schemes. If discount is capped, enter capped %","Numeric, range 0 - 100","Yes, if field 76 is null, 8, 21 or 22"]
[null,80,"What is the mortgage amount?","Enter the amount of mortgage agreed with the mortgage lender. Exclude any deposits or cash payments.","Numeric, range 0 - 999999","Yes, if field 113 = 1 or 3"]
[null,null,null,"Numeric in pounds. Rounded to the nearest pound."]
[null,81,"Does this include any extra borrowing?","This is 'Yes' if the mortgage includes borrowing beyond the purchase price of the property","Numeric, range 1 - 3"]
[null,null,null,"Value labels:"]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,null,null,"3 = Don't Know"]
[null,82,"How much was the cash deposit paid on the property?","Full amount paid by purchaser, not funded by the mortgage .ie. the difference between the cost of the equity and the mortgage. Exclude any grant or loan","Numeric, range 0 - 999999"]
[null,null,null,"Numeric in pounds. Rounded to the nearest pound."]
[null,83,"What are the total monthly leasehold charges for the property?","Enter monthly charges on leasehold sales. Includes service charges, management charges. Exclude rent. Numeric in pounds (to 2 decimal places)","Numeric, in the form xxxx.xx"]
[null,84,"What is the type of outright sale?","Value labels:","Numeric, range 10 or 12","Yes, if field 113 = 1 or 2"]
[null,null,null,"10 = Outright"]
[null,null,null,"12 = Other sale"]
[null,85,"If 'other', what is the 'other' type?","Enter the name of the Sale type","alphanumeric","Yes, if field 84 is null or 10"]
[{"$nulls":4},"(text qualifier required)"]
[null,86,"[BLANK]"]
[null,87,"What is the full purchase price?","Market value before any discount, for 100% of the equity of the property.","Numeric, range 0 - 999999","Yes, if field 113 = 1 or 2"]
[null,null,null,"Numeric in pounds. Rounded to the nearest pound."]
[null,88,"What is the mortgage amount?","Enter the amount of mortgage agreed with the mortgage lender. Exclude any deposits or cash payments."]
[null,null,null,"Numeric in pounds. Rounded to the nearest pound."]
[null,89,"Does this include any extra borrowing?","This is 'Yes' if the mortgage includes borrowing beyond the purchase price of the property","Numeric, range 1 - 3"]
[null,null,null,"Value labels:"]
[null,null,null,"1 = Yes"]
[null,null,null,"2 = No"]
[null,null,null,"3 = Don't Know"]
[null,90,"How much was the cash deposit paid on the property?","Full amount paid by purchaser, not funded by the mortgage .ie. the difference between the cost of the equity and the mortgage. Exclude any grant or loan","Numeric, range 0 - 999999"]
[null,null,null,"Numeric in pounds. Rounded to the nearest pound."]
[null,91,"What are the total monthly leasehold charges for the property?","Enter monthly charges on leasehold sales. Includes service charges, management charges. Exclude rent. Numeric in pounds (to 2 decimal places)","Numeric, in the form xxxx.xx"]
[null,92,"Which organisation owned this property before the sale?","The owning organisations's CORE ID code.","Numeric, up to 7 digits","No"]
[null,93,"Username","The CORE username of the account this sale log should be assigned to. If left null, the sale log will be assigned to the account used to upload the log.","Alphanumeric, except for commas","Yes"]
[null,94,"[BLANK]"]
[null,95,"Has the buyer ever served in the UK Armed Forces and for how long?","A regular is somebody who has served in the Royal Navy, the Royal Marines, the Royal Air Force or army full time and does not include reserve forces.","Numeric, range 3 - 8","No"]
[null,null,null,"Value labels:"]
[null,null,null,"3 = Buyer prefers not to say"]
[null,null,null,"4 = Still serving"]
[null,null,null,"5 = They left up to and including 2 years ago"]
[null,null,null,"6 = They left more than 2 years ago"]
[null,null,null,"7 = Never served"]
[null,null,null,"8 = Don't know"]
[null,96,"[BLANK]"]
[]
[]
[]
[null,97,"Are any of the buyers a spouse or civil partner of a UK Armed Forces regular who died in service within the last 2 years?","A regular is somebody who has served in the Royal Navy, the Royal Marines, the Royal Air Force or army full time and does not include reserve forces.","Numeric range 4 - 7","No"]
[null,null,null,"Value labels:"]
[null,null,null,"4 = Yes"]
[null,null,null,"5 = No"]
[null,null,null,"6 = Buyer prefers not to say"]
[null,null,null,"7 = Don't know"]
[null,98,"What is the name of the mortgage lender? - Shared ownership","Value labels:","Numeric Range 1 - 40","Yes, if field 113 = 2 or 3"]
[null,null,null,"1 = Atom Bank"]
[null,null,null,"2 = Barclays Bank plc"]
[null,null,null,"3 = Bath Building Society"]
[null,null,null,"4 = Buckinghamshire Building Society"]
[null,null,null,"5 = Cambridge Building Society"]
[null,null,null,"6 = Coventry Building Society"]
[null,null,null,"7 = Cumberland Building Society"]
[null,null,null,"8 = Darlington Building Society"]
[null,null,null,"9 = Dudley Building Society"]
[null,null,null,"10 = Ecology Building Society"]
[null,null,null,"11 = Halifax"]
[null,null,null,"12 = Hanley Economic Building Society"]
[null,null,null,"13 = Hinckley and Rugby Building Society"]
[null,null,null,"14 = Holmesdale Building Society"]
[null,null,null,"15 = Ipswich Building Society"]
[null,null,null,"16 = Leeds Building Society"]
[null,null,null,"17 = Lloyds Bank"]
[null,null,null,"18 = Mansfield Building Society"]
[null,null,null,"19 = Market Harborough Building Society"]
[null,null,null,"20 = Melton Mowbray Building Society"]
[null,null,null,"21 = Nationwide Building Society"]
[null,null,null,"22 = Nat West"]
[null,null,null,"23 = Nedbank Private Wealth"]
[null,null,null,"24 = Newbury Building Society"]
[null,null,null,"25 = OneSavings Bank"]
[null,null,null,"26 = Parity Trust"]
[null,null,null,"27 = Penrith Building Society"]
[null,null,null,"28 = Pepper Homeloans"]
[null,null,null,"29 = Royal Bank of Scotland"]
[null,null,null,"30 = Santander"]
[null,null,null,"31 = Skipton Building Society"]
[null,null,null,"32 = Teachers Buiding Society"]
[null,null,null,"33 = The co-operative Bank"]
[null,null,null,"34 = Tipton and Coseley Building Society"]
[null,null,null,"35 = TSB"]
[null,null,null,"36 = Ulster Bank"]
[null,null,null,"37 = Virgin Money"]
[null,null,null,"38 = West Bromwich Building Society"]
[null,null,null,"39 = Yorkshire Building Society"]
[null,null,null,"40 = Other"]
[null,99,"If 'other', what is the name of the mortgage lender?","Enter the name of the other lender not listed.","Alphanumeric","Yes, if field 113 = 2 or 3\nOR\nif field 98 is not 40"]
[]
[null,100,"What is the name of the mortgage lender? - Discounted ownership","Value labels:","Numeric Range 1 - 40","Yes, if field 113 = 1 or 3"]
[null,null,null,"1 = Atom Bank"]
[null,null,null,"2 = Barclays Bank plc"]
[null,null,null,"3 = Bath Building Society"]
[null,null,null,"4 = Buckinghamshire Building Society"]
[null,null,null,"5 = Cambridge Building Society"]
[null,null,null,"6 = Coventry Building Society"]
[null,null,null,"7 = Cumberland Building Society"]
[null,null,null,"8 = Darlington Building Society"]
[null,null,null,"9 = Dudley Building Society"]
[null,null,null,"10 = Ecology Building Society"]
[null,null,null,"11 = Halifax"]
[null,null,null,"12 = Hanley Economic Building Society"]
[null,null,null,"13 = Hinckley and Rugby Building Society"]
[null,null,null,"14 = Holmesdale Building Society"]
[null,null,null,"15 = Ipswich Building Society"]
[null,null,null,"16 = Leeds Building Society"]
[null,null,null,"17 = Lloyds Bank"]
[null,null,null,"18 = Mansfield Building Society"]
[null,null,null,"19 = Market Harborough Building Society"]
[null,null,null,"20 = Melton Mowbray Building Society"]
[null,null,null,"21 = Nationwide Building Society"]
[null,null,null,"22 = Nat West"]
[null,null,null,"23 = Nedbank Private Wealth"]
[null,null,null,"24 = Newbury Building Society"]
[null,null,null,"25 = OneSavings Bank"]
[null,null,null,"26 = Parity Trust"]
[null,null,null,"27 = Penrith Building Society"]
[null,null,null,"28 = Pepper Homeloans"]
[null,null,null,"29 = Royal Bank of Scotland"]
[null,null,null,"30 = Santander"]
[null,null,null,"31 = Skipton Building Society"]
[null,null,null,"32 = Teachers Buiding Society"]
[null,null,null,"33 = The co-operative Bank"]
[null,null,null,"34 = Tipton and Coseley Building Society"]
[null,null,null,"35 = TSB"]
[null,null,null,"36 = Ulster Bank"]
[null,null,null,"37 = Virgin Money"]
[null,null,null,"38 = West Bromwich Building Society"]
[null,null,null,"39 = Yorkshire Building Society"]
[null,null,null,"40 = Other"]
[null,101,"If 'other', what is the name of the mortgage lender?","Enter the name of the other lender not listed.","Alphanumeric","Yes, if field 113 = 1 or 3\nOR\nif field 100 is not 40"]
[null,102,"What is the name of the mortgage lender? - Outright sale","Value labels:","Numeric Range 1-40","Yes, if field 113 = 1 or 2"]
[null,null,null,"1 = Atom Bank"]
[null,null,null,"2 = Barclays Bank plc"]
[null,null,null,"3 = Bath Building Society"]
[null,null,null,"4 = Buckinghamshire Building Society"]
[null,null,null,"5 = Cambridge Building Society"]
[null,null,null,"6 = Coventry Building Society"]
[null,null,null,"7 = Cumberland Building Society"]
[null,null,null,"8 = Darlington Building Society"]
[null,null,null,"9 = Dudley Building Society"]
[null,null,null,"10 = Ecology Building Society"]
[null,null,null,"11 = Halifax"]
[null,null,null,"12 = Hanley Economic Building Society"]
[null,null,null,"13 = Hinckley and Rugby Building Society"]
[null,null,null,"14 = Holmesdale Building Society"]
[null,null,null,"15 = Ipswich Building Society"]
[null,null,null,"16 = Leeds Building Society"]
[null,null,null,"17 = Lloyds Bank"]
[null,null,null,"18 = Mansfield Building Society"]
[null,null,null,"19 = Market Harborough Building Society"]
[null,null,null,"20 = Melton Mowbray Building Society"]
[null,null,null,"21 = Nationwide Building Society"]
[null,null,null,"22 = Nat West"]
[null,null,null,"23 = Nedbank Private Wealth"]
[null,null,null,"24 = Newbury Building Society"]
[null,null,null,"25 = OneSavings Bank"]
[null,null,null,"26 = Parity Trust"]
[null,null,null,"27 = Penrith Building Society"]
[null,null,null,"28 = Pepper Homeloans"]
[null,null,null,"29 = Royal Bank of Scotland"]
[null,null,null,"30 = Santander"]
[null,null,null,"31 = Skipton Building Society"]
[null,null,null,"32 = Teachers Buiding Society"]
[null,null,null,"33 = The co-operative Bank"]
[null,null,null,"34 = Tipton and Coseley Building Society"]
[null,null,null,"35 = TSB"]
[null,null,null,"36 = Ulster Bank"]
[null,null,null,"37 = Virgin Money"]
[null,null,null,"38 = West Bromwich Building Society"]
[null,null,null,"39 = Yorkshire Building Society"]
[null,null,null,"40 = Other"]
[null,103,"If 'other', what is the name of the mortgage lender?","Enter the name of the other lender not listed.","Alphanumeric","Yes, if field 113 = 1 or 2\nOR\nif field 102 is not 40"]
[null,104,"Were the buyers receiving any of these housing-related benefits immediately before buying this property?","Value labels:\n1 = Neither housing benefit or Universal Credit housing element\n2 =  Housing benefit\n3 =  Universal Credit housing element\n4 =  Don't know","Numeric range 1 - 4","No"]
[null,105,"What is the length of the mortgage in years? - Shared ownership","Enter number of years rounded to the nearest year  - value should not exceed 60"," Integer <=60","Yes, if field 113 = 2 or 3"]
[null,106,"What is the length of the mortgage in years? - Discounted ownership",null,null,"Yes, if field 113 = 1 or 3"]
[null,107,"What is the length of the mortgage in years? - Outright sale",null,null,"Yes, if field 113 = 1 or 2"]
[null,108,"How long have the buyers been living in the property before the purchase? - Discounted ownership","Enter number of years rounded to the nearest year  - value should not exceed 80"," Integer <=80","Yes, if field 113 = 1 or 3"]
[null,109,"Are there more than two joint purchasers of this property?","Value labels:\n1 = Yes\n2 = No\n3 = Don't know","Numeric range 1 - 3","Yes, if field 116 = 2"]
[null,110,"How long have the buyers been living in the property before the purchase? - Shared ownership","Enter number of years rounded to the nearest year  - value should not exceed 80"," Integer <=80","Yes, if field 113 = 2 or 3"]
[null,111,"Is this a staircasing transaction?","Value labels:\n1 = Yes\n2 = No\n3 = Don't know","Numeric range 1 - 3","Yes, if field 113 = 2 or 3"]
[null,112,"Data Protection question","4 = Yes (to denote purchaser(s) are aware of the Data Protetcion Agreement).","Numeric range 1 only","No"]
[null,113,"Was this purchase made through an ownership scheme?","Value labels:","Numeric, range 1 - 3","No"]
[null,null,null,"1 = Shared ownership"]
[null,null,null,"2 = Discounted ownership"]
[null,null,null,"3 = Outright sale"]
[null,114,"Is the buyer a company?","Value labels:\n1 = Yes\n2 = No","Numeric, range 1 - 2","Yes, if field 113 = 1 or 2"]
[null,115,"Will the buyers live in the property?","Value labels:\n1 = Yes\n2 = No","Numeric, range 1 - 2","Yes, if field 113 = 1 or 2"]
[null,116,"Is this a joint purchase?","Value labels:\n1 = Yes\n2 = No","Numeric, range 1 - 2","No"]
[null,117,"Will buyer 1 live in the property?","Value labels:\n1 = Yes\n2 = No","Numeric, range 1 - 2","No"]
[null,118,"Will buyer 2 live in the property?","Value labels:\n1 = Yes\n2 = No","Numeric, range 1 - 2","Yes, if field 116 = 2"]
[null,119,"Besides the buyers, how many people will live in the property?","Enter number from 0 to 5.","Numeric, range 0 - 5","No"]
[null,120,"What percentage of the property has been bought in this staircasing transaction?","Enter % as a whole number. For example, enter 10% as 10.","Numeric, range 0 - 100","Yes, if field 113 = 2 or 3"]
[null,121,"What percentage of the property does the buyer now own in total?","Enter % as a whole number. For example, enter 10% as 10.","Numeric, range 0 - 100","Yes, if field 113 = 2 or 3"]
[null,122,"What was the rent type of the buyer's previous property?","Value labels:\n1 = Social Rent\n2 = Affordable Rent\n3 = London Affordable Rent\n9 = Other\n10 = Don't know","Numeric, range 1 - 3 or 9 - 10","Yes, if field 113 = 2 or 3\nOR\nif field 39 = 3 - 9"]
[null,123,"Was a mortgage used for the purchase of this property? - Shared ownership","Value labels:\n1 = Yes\n2 = No","Numeric, range 1 - 2","Yes, if field 113 = 2 or 3"]
[null,124,"Was a mortgage used for the purchase of this property? - Discounted ownership",null,null,"Yes, if field 113 = 1 or 3"]
[null,125,"Was a mortgage used for the purchase of this property? - Outright sale",null,null,"Yes, if field 113 = 1 or 2"]
[null,126,"Is income for Purchaser 1 unknown","1 = Yes\nNULL = No","Numeric, range 1","Yes"]
[null,127,"Is income for Purchaser 2 unknown","1 = Yes\nNULL = No","Numeric, range 1","Yes"]
[null,128,"Is saving for Purchaser(s) unknown","1 = Yes\nNULL = No","Numeric, range 1","Yes"]