Open ajtucker opened 4 years ago
Due to a change in the dataset, stage 1 transform has been done to this ticket again. Sheets 1 and 3 had spec and transform is done accordingly. Sheets 2 and 4 didn't had spec and the tables in these sheets are pulled as such. All transformed data can be found in variable sheets_dictionary.
BA Data Spec Review 10/6/2020
This publication shape has changed with the most recent publication. Sheet 1 remains, sheet 2 is now Sheet 3. There are new sheets 2 and 4 giving time series information
[B12:B17 - Universal Credit Stage
New Claim/ Benefit Transfer - Advance New Claim or Benefit Transfer Budgeting - Advance Budgeting Change of Circumstances - Advance Change of Circumstances
Total - Advance Total
Add Measure Type column with values Advances] As the Measure type is Advance, the codelist items do not need the Advance