sample rating metrics from CDC message

gistfile1.txt

{
	"type": "update",
	"msg": {
		"env_id": "af44d7ff-c069-482b-aee8-82f0a562ca99",
		"env_name": "HPi EMEA Prod",
		"database": "HPiProd",
		"sql_dns": "HPiProdSQL.traxtech.com",
		"table": "EXCEPTIONS",
		"updated_date": "2017-08-07T18:15:14Z",
		"is_delete": false,
		"last_in_transaction": false
	},
	"data": {
		"SCACException": false,
		"ReadyForPayment": true,
		"HoldForReprocessing": false,
		"CreditRequested": false,
		"DuplicateException": false,
		"CustomerReview": false,
		"TraxReview": false,
		"IsDeleted": false,
		"CREATEDATE": "2017-06-02T05:43:14.260",
		"FB_AMT": 0.07,
		"MappingException": false,
		"PrecedenceException": false,
		"BillingException": false,
		"RCRD_POSTED_DTM": "2017-08-07T10:02:26.000",
		"AccrualException": false,
		"FB_CURRENCY_QUAL": "EUR",
		"BAT_ID": "BACH1000681002159720000",
		"EX_TYPE_CODE": "RP",
		"DataException": false,
		"FinancialException": false,
		"Unprocessed": false,
		"AwaitingValidation": false,
		"FB_ID": "FBLL1000681002159720597",
		"HoldForVerification": false,
		"InvoiceHold": true,
		"UPDATEDATE": "2017-08-07T11:15:14.270",
		"FB_APP_CURRENCY_QUAL": "EUR",
		"CostAllocationException": false,
		"RCRD_ASOF_DTM": "2017-08-07T10:02:26.000",
		"INV_ID": "INVC1000681002159720001",
		"FB_APP_AMT": 0.07,
		"Suspended": false,
		"RulesError": false
	},
	"published_at": "2017-08-07T18:25:57.251Z"
}