0050 Bridge Critical Finding

0050 Bridge Critical Finding

Migration Path

• PON_CRITICALFINDING -> EventLibrary
• PON_CRITICALFINDING_LOG -> BridgeCricialFinding
• PON_CRITICALFINDING_LOG -> CriticalFindingLog
• PON_CRITICALFINDING_LINK -> CriticalFindingEventLink
• PON_CRITICALFINDING_LINK -> CriticalFindingTask

Data Considerations

• Duplicates
• Null Data Replacement - See SQL

Other Notes

• PON_CRITICALFINDING_LOG -> BridgeCriticalFinding
  • Fields required to be NOT NULL for data to migrate:
    • CRITICAL_FINDING_ID
    • CONTACTEDDATE
    • DESCRIPTION
  • STATUS <> 5
• PON_CRITICALFINDING_LOG -> CriticalFindingLog
  • Fields required to be NOT NULL for data to migrate:
    • CREATEUSERKEY
    • CREATEDATETIME
• PON_CRITICALFINDING_LINK -> CriticalfindingEventLink
  • Fields required to be NOT NULL for data to migrate:
    • COMPLETESEVENT_GD
    • COMPLETESEVENTTYPE_GD
  • COMPLETESEVENTTYPE_TD <> “Work candidate” or “Project”
• PON_CRITICALFINDING_LINK -> CriticalFindingTask
  • Fields required to be NOT NULL for data to migrate:
    • ASSIGNED_GD
    • PON_CRITICALFINDING_EVNTTYPE_GD
    • DUEDATE
  • PON_CRITICALFINDING_EVNTTYP_GD <> “Work candidate” or “Project”