Siebel Database Upgrade Guide > Postupgrade Tasks for Siebel Applications >

Upgrading the Test Status in Siebel Training


Upgrades from: Siebel 6.x, 7.0.x, & 7.5.x.

Environments: Production test, production.

Platforms: MS Windows, UNIX, IBM z/OS.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

As of Siebel 7.7, completed tests can have one of two statuses:

  • Completed-Passed
  • Completed-Failed

In previous releases, completed tests had only one status: Completed.

If you want to revise existing data to reflect the new completion statuses, you can write a script to revise the records. The script should use the following logic:

  • If at least one test has reached the maximum attempts and not been passed, mark the status as CompletedFailed.
  • If all tests have been passed at least once, mark the status as CompletedPassed. Not all test attempts have to be cleared. If there were three attempts allowed and the student failed on the first two but passed on the third attempt, this is acceptable.
  • If at least one test has not been attempted, then there should be no change in the status of the registration. So, if a course had a Course Survey associated to it, and if the user had not attempted it yet, its status cannot go to CompletedPassed.
  • Else CompletedFailed takes precedence over CompletedPassed.
Related Topics

Upgrade Planning for Siebel Employee Relationship Management (ERM)

Siebel Database Upgrade Guide