{"layouts":{"none":{"type":6,"views":["default"]},"default":{"type":6,"views":["default"]}},"tableTree":{"type":"journalEntry","as":6,"relations":[{"type":"customReportN","as":1114,"filters":[{"label":"appUserId","type":"equal","field":{"name":"appUserId","type":"field","source":1114},"value":{"name":"appUserIdCreator","type":"field","source":6}}],"tableId":1100},{"type":"appUser","as":0,"relations":[{"type":"customReportN","as":1130,"filters":[{"label":"Creator (ID)","type":"equal","field":{"name":"appUserIdCreator","type":"field","source":1130},"value":{"name":"id","type":"field","source":0}}],"tableId":1104},{"type":"appRoles","as":10020},{"type":"personInfo","as":1,"relations":[{"type":"streetAddress","as":100,"relations":[{"type":"country","as":101}],"filters":[{"label":"streetAddressType (ID)","type":"equal","field":{"name":"streetAddressTypeId","type":"field","source":100},"value":2}]},{"type":"rContactTag","as":10001}]},{"type":"customReportN","as":1087,"filters":[{"label":"ID","type":"equal","field":{"name":"id","type":"field","source":0},"value":{"name":"appUserId","type":"field","source":1087}}],"tableId":1102}]},{"type":"rEntityJournalEntry","as":7,"relations":[{"type":"job","as":8,"relations":[{"type":"rJobTag","as":10003}]},{"type":"personInfo","as":9,"relations":[{"type":"customFieldN","as":10,"relations":[{"type":"sf","as":26,"tableId":26}],"tableId":2}]}]},{"type":"rEntityJournalEntry","as":20},{"type":"journalEntryJobPerson","as":23}]},"filters":[{"type":"notEqual","field":{"name":"id","type":"field","source":10020},"value":247},{"type":"nullable","field":{"name":"appUserId","type":"field","source":1114},"value":false,"useTransferOptimization":false},{"label":"User Active","type":"equal","field":{"name":"isEnabled","type":"field","source":0},"value":1},{"type":"in","field":{"as":"journalActionTypeCondition","name":"journalActionTypeId","type":"field","source":6},"value":[1,6,7]},{"type":"in","field":{"as":"journalEntryTypeCondition","name":"journalEntryTypeId","type":"field","source":6},"value":[1,2,4,5,9,14,15]},{"label":"Date","type":"between","field":[{"name":"date","label":"Date","type":"field","source":6},{"name":"dateSent","type":"field","source":1130},{"name":"date","type":"field","source":1087}],"value":[{"relativedate":"today - 1 month"},{"relativedate":"tomorrow"}],"userModifiable":true},{"label":"Country of Recruiter","type":"in","field":{"as":"country","name":"countryAvailable","type":"field","source":100},"value":[],"userModifiable":true},{"label":"User","type":"equal","field":{"as":"user","name":"personInfo","type":"field","source":0},"value":null,"userModifiable":true},{"label":"Tag","type":"like","field":[{"name":"name","type":"field","source":10001},{"name":"name","type":"field","source":10003}],"value":null,"userModifiable":true,"fieldsFilterLogic":"OR"},{"type":"nullable","field":{"name":"id","type":"field","source":101},"value":false,"userModifiable":true},{"type":"nullable","field":{"name":"contactId","type":"field","source":0},"value":false,"userModifiable":true}],"views":{"default":{"type":"simpleTable","title":"Activity-Report-Base","groupBys":[{"as":"autoGeneratedGroupAlias0","name":"contactId","label":"Recruiter","type":"field","source":0},{"as":"autoGeneratedGroupAlias1","name":"id","label":"Country of Rec.","type":"field","source":101}],"cols":[{"as":"person","name":"personInfo","label":"Recruiter","type":"field","source":0},{"as":"countryName","name":"name","label":"Country of Rec.","type":"field","source":101},{"as":"col12000","name":"countDistinct","label":"Emails Sent","type":"function","params":[{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalEntryTypeId","type":"field","source":20},14]},{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalActionTypeId","type":"field","source":6},1]},{"name":"contactId","type":"field","source":9},null]},null]}]},{"as":"col13000","name":"countDistinct","label":"Notes Added","type":"function","params":[{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalEntryTypeId","type":"field","source":20},1]},{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalActionTypeId","type":"field","source":6},1]},{"name":"contactId","type":"field","source":9},null]},null]}]},{"as":"tasksCreated","name":"countDistinct","label":"Tasks Created","type":"function","params":[{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalEntryTypeId","type":"field","source":20},2]},{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalActionTypeId","type":"field","source":6},1]},{"name":"contactId","type":"field","source":9},null]},null]}]},{"as":"col8000","name":"countDistinct","label":"People Created","type":"function","params":[{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalEntryTypeId","type":"field","source":6},9]},{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalActionTypeId","type":"field","source":6},1]},{"name":"contactId","type":"field","source":9},null]},null]}]},{"as":"col11000","name":"countDistinct","label":"People steps updates","type":"function","params":[{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalEntryTypeId","type":"field","source":6},4]},{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalActionTypeId","type":"field","source":6},1]},{"name":"contactId","type":"field","source":9},null]},null]}]},{"as":"countJobs","name":"countDistinct","label":"Folders created","type":"function","params":[{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalActionTypeId","type":"field","source":6},1]},{"name":"id","type":"field","source":8},null]}]},{"as":"peopleDCPSAccepted","name":"countDistinct","label":"DPCS Accepted","type":"function","params":[{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalEntryTypeId","type":"field","source":6},9]},{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"name":"journalActionTypeId","type":"field","source":6},1]},{"name":"if","type":"function","params":[{"name":"in","type":"function","params":[{"name":"schemaFieldOptionId","type":"field","source":26},79,80,81,82,83,84,87,88,89,86,1097]},{"name":"contactId","type":"field","source":9},null]},null]},null]}]},{"as":"msgOpened","name":"countDistinct","label":"Messages Opened","type":"function","params":[{"name":"journalEntryId","type":"field","source":1130}]},{"as":"contactsMovedToHired","name":"countDistinct","label":"Contacts Moved to Hired","type":"function","params":[{"name":"if","type":"function","params":[{"name":"equal","type":"function","params":[{"as":"jobPersonworkflowStatus","name":"workflowStatusId","type":"field","source":23},5]},{"name":"contactId","type":"field","source":23},null]}]},{"as":"daysLoggedIn","name":"loggedTime","label":"Days Logged In","options":{"precision":2},"type":"field","source":1087},{"as":"confidential","name":"string","type":"literal","value":"Confidential"}]}},"expressions":[]}