Siebel Global Deployment Guide > Deploying with Global Time Zone >

Enabling Custom Date-time Fields and Columns for UTC

Some date-time fields (and their underlying columns) in Siebel Business Applications are enabled for UTC. Applicable fields include fields that are manually populated through entering date-time data and fields that the system populates by generating a date-time stamp. If you create custom date-time fields and columns that will store UTC data, you must enable them for UTC, so that data entered in these fields is consistent with data entered in other UTC-enabled date-time fields.

See also About UTC Data Conversion and related topics in About Global Time Zone and Universal Time Coordinated (UTC).

If you configure additional date-time columns for UTC, you need to add these columns to the file utc_columns.inp. This input file tells the UTC conversion utility which columns need to be converted to UTC. Do this before you run the UTC conversion utility, which is described in Converting Historical Data to UTC.

For more information about configuring column and field object definitions, see Using Siebel Tools.

To enable custom date-time fields for UTC

  • In Siebel Tools, set properties for each applicable column object definition and its associated field object definition:
    1. For the column, set the Physical Type property to UTC Date Time.
    2. For the field, set the Type property to DTYPE_UTCDATETIME.

      If the Universal Time Coordinated system preference is set to TRUE, after you compile your changes these custom date-time fields will be enabled for UTC.

Siebel Global Deployment Guide Copyright © 2007, Oracle. All rights reserved.