Upgrade Guide > Postupgrade Tasks for Siebel Applications >

Migrating Course Duration Information for Siebel Training

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

Environments: Production test, production.

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

When upgrading from a release prior to Siebel 7.7, course duration information for Siebel Training is not migrated. To display course duration information you must move course duration to an extension column.

To migrate course duration information

1. In Siebel Tools, add an extension column to S_PROD_INT_CRSE. Assign the column the same length and data type as S_SRC_EVT.DURATION_DESC.
2. Use an SQL command to transfer existing course duration data to the extension column.

   The SQL command should have the following form:

   update S_PROD_INT_CRSE a

   set a.<name of new extension column> = (select b.DURATION_DESC from S_SRC_EVT b)

   where a.par_row = b.row_ID)

3. Expose the extension column in the user interface.
4. (Optional) Create corresponding information in the S_PROD_INT_CRSE.CRSE_HOUR_NUM field.