daniel0397

UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "filedaccounts";
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "bankverification";
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "securemeet";
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "idu";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "filedaccounts";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "bankverification";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "securemeet";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "idu";
DELETE FROM `QED_1_CaseVersion_Stage` WHERE `StageId` = "filedaccounts";
DELETE FROM `QED_1_CaseVersion_Stage` WHERE `StageId` = "bankverification";

daniel0397

INSERT INTO `justcashflow`.`QED_Workflow_Stage`
VALUES ('idu','PEPs & Sanctions',7,0,'moduleIDU',1);

INSERT INTO `demo1`.`QED_Workflow_Stage`
VALUES ('idu','PEPs & Sanctions',7,0,'moduleIDU',1);

daniel0397

Model->getAuditMessage(){
  AppSimpleTaskPK
  SimpleTaskPK
  ProductPK
  Complete
  TaskText
  DateComplete
  SimpleTaskStatusPK
}

daniel0397

Model->getAuditMessage(){
  EBSLoanPK
  CasePK
  ProductSubTypePK
  LoanReference
  PaymentReference
  NextStageDue
  AdvisorPK
  StagePK
  MortgageSourcePK