{"jobIds":["8c12ac56-affd-48d2-b3f9-a0996eea00df","b7514a64-f9a7-4f56-9f33-2202b9b92ca3","8060dcc7-0266-40b6-90f1-63557559277f","a6e63c94-67f1-46b3-8244-4346654628fd"],"results":[{"jobId":"8c12ac56-affd-48d2-b3f9-a0996eea00df","result":{"data":{"descriptor":{"Select":[{"Kind":2,"Value":"M0","Name":"MetaData.DataCurrentAsOf"}],"Version":2},"dsr":{"Version":2,"MinorVersion":1,"DS":[{"N":"DS0","PH":[{"DM0":[{"S":[{"N":"M0","T":1}],"M0":"Data as of 2/1/2022"}]}],"IC":true,"HAD":true,"Msg":[{"Code":"IgnoredDataReductionAlgorithm","Severity":"Warning","Message":"A data reduction algorithm was specified but the corresponding grouping does not exist. The data reduction will be ignored for primary, secondary, intersection and scoped."}]}]}}}},{"jobId":"a6e63c94-67f1-46b3-8244-4346654628fd","result":{"data":{"descriptor":{"Select":[{"Kind":1,"Depth":0,"Value":"G0","GroupKeys":[{"Source":{"Entity":"ERAP2","Property":"FamilySize"},"Calc":"G0","IsSameAsSelect":true}],"Name":"ERAP2.FamilySize"},{"Kind":2,"Value":"M0","Format":"\\$#,0;(\\$#,0);\\$#,0","Name":"CountNonNull(ERAP2.rent)"},{"Kind":2,"Value":"M1","Format":"\\$#,0;(\\$#,0);\\$#,0","Name":"CountNonNull(ERAP2.total_back_rent_amount)"},{"Kind":2,"Value":"M2","Name":"CountNonNull(ERAP2.EraspApplicationId)"},{"Kind":2,"Value":"M3","Min":["A0"],"Max":["A1"],"Aggregates":[{"Ids":["A0"],"Aggregate":{"Min":{}}},{"Ids":["A1"],"Aggregate":{"Max":{}}}],"Name":"CountNonNull(ERAP2.ApplicationNumber)"}],"Expressions":{"Primary":{"Groupings":[{"Keys":[{"Source":{"Entity":"ERAP2","Property":"FamilySize"},"Select":0}],"Member":"DM0"}]}},"Version":2},"dsr":{"Version":2,"MinorVersion":1,"DS":[{"N":"DS0","S":[{"N":"A0","T":4},{"N":"A1","T":4}],"C":[261,19354],"PH":[{"DM0":[{"S":[{"N":"G0","T":1},{"N":"M0","T":3},{"N":"M1","T":3},{"N":"M2","T":4},{"N":"M3","T":4}],"C":[" 1","2447.940374082877","8336.9813320243866",19354,19354]},{"C":[" 2","2143.0735281058519","9480.5857925583878",11261,11261]},{"C":[" 3","1752.4012186865268","7396.40444549763",7385,7385]},{"C":[" 4","1689.8690633245383","6478.3402490105545",6064,6064]},{"C":[" 5","1708.1649166151947","6763.9128042001239",3238,3238]},{"C":[" 6","1746.6493993993995","6519.3435660660671",1332,1332]},{"C":[" 7","1863.8030973451328","7340.2823230088488",452,452]},{"C":[" 8+","2256.8812260536397","8622.3010727969358",261,261]}]}],"IC":true,"HAD":true}]}}}},{"jobId":"8060dcc7-0266-40b6-90f1-63557559277f","result":{"data":{"descriptor":{"Select":[{"Kind":1,"Depth":0,"Value":"G0","GroupKeys":[{"Source":{"Entity":"ERAP2","Property":"ApplicationType"},"Calc":"G0","IsSameAsSelect":true}],"Name":"ERAP2.ApplicationType"},{"Kind":1,"Depth":0,"Value":"G1","GroupKeys":[{"Source":{"Entity":"ERAP2","Property":"EligibilityStatus"},"Calc":"G1","IsSameAsSelect":true}],"Name":"ERAP2.EligibilityStatus"},null,{"Kind":2,"Value":"M0","Name":"CountNonNull(ERAP2.EraspApplicationId)"}],"Expressions":{"Primary":{"Groupings":[{"Keys":[{"Source":{"Entity":"ERAP2","Property":"ApplicationType"},"Select":0},{"Source":{"Entity":"ERAP2","Property":"EligibilityStatus"},"Select":1}],"Member":"DM0"}]}},"Limits":{"Primary":{"Id":"L0","Top":{"Count":1000}}},"Version":2},"dsr":{"Version":2,"MinorVersion":1,"DS":[{"N":"DS0","PH":[{"DM0":[{"S":[{"N":"G0","T":1,"DN":"D0"},{"N":"G1","T":1,"DN":"D1"},{"N":"M0","T":4}],"C":[0,0,60439]},{"C":[1,37513],"R":2},{"C":[0,1,8099]},{"C":[1,7100],"R":2}]}],"IC":true,"HAD":true,"ValueDicts":{"D0":["Tenant","Landlord"],"D1":["Eligible","Pending Review"]}}]}}}},{"jobId":"b7514a64-f9a7-4f56-9f33-2202b9b92ca3","result":{"data":{"descriptor":{"Select":[{"Kind":2,"Value":"M0","Format":"\\$#,0;(\\$#,0);\\$#,0","Name":"ERAP2.PmtInProgress"},{"Kind":2,"Value":"M1","Name":"CountNonNull(ERAP2.ApplicationNumber)"}],"Version":2},"dsr":{"Version":2,"MinorVersion":1,"DS":[{"N":"DS0","PH":[{"DM0":[{"S":[{"N":"M0","T":3},{"N":"M1","T":4}],"C":[220669769.23,113151]}]}],"IC":true,"HAD":true}]}}}}]}