SLDC Counter Fraud Work

CREATE TABLE sldc_counter_fraud_work (
  "organisationnamelabel" VARCHAR,
  "organisationuri" VARCHAR,
  "effectivedate" TIMESTAMP,
  "totaloccassionsfraudpower" BIGINT,
  "totalfraudemployeescount" BIGINT,
  "ftefraudemployeescount" BIGINT,
  "totalfraudspecialistscount" BIGINT,
  "ftefraudspecialistcount" DOUBLE,
  "fraudspentamount" BIGINT,
  "totalinvestigatedfraud" BIGINT,
  "totalidentifiedfraud" BIGINT,
  "valuefraud" BIGINT,
  "valuefraudrecovered" VARCHAR,
  "totalinvestigatedirregularities" BIGINT,
  "totalidentifiedirregularities" BIGINT,
  "valueirregularities" BIGINT,
  "valueirregularitiesrecovered" BIGINT
);