Siebel Hospitality Guide > Managing Hospitality Reports > Process of Converting the Banquet Event Order Report to a 12-Hour Format >

Configuring the STHeader Calculated Field


STHeader is a calculated text field in the Banquet Event Order Report. STHeader combines the Service Start Time, Function Type, and Function Space or Location field values from your Siebel application. In STHeader, by default, StartTimeRep is the Function Time field in 24-hour format (00:00 to 23:59). You can replace StartTimeRep with SSTimeCalc, which is the Function Time field in 12-hour format (00:00 AM to 11:59 PM). SSTimeCalc identifies pre-noon times as AM and post-noon times as PM in all languages.

To replace the 24-hour time value display in STHeader with a 12-hour time display, follow this procedure.

This task is a step in Process of Converting the Banquet Event Order Report to a 12-Hour Format.

To configure the STHeader calculated field

  1. Open Siebel Tools.
  2. In the Object Explorer, select Business Component and query for TNT SHM Order Item.
  3. In the TNT SHM Order Item business component, query for the STHeader field.

    The calculated value field appears as follows:

    '[Start Time Rep] + IIf ([Function Type] IS NOT NULL, ' '+[Function Type],'') + IIf ([RFS] IS NOT NULL , ' '+[RFS], '')'

  4. In the calculated value field, replace [Start Time Rep] with [SSTimeCalc].

    The value now appears as follows:

    '[SSTimeCalc] + IIf ([Function Type] IS NOT NULL, ' '+[Function Type],'') + IIf ([RFS] IS NOT NULL , ' '+[RFS], '')'

  5. Compile the TNT SHM Order Item business component to the SRF file.
Siebel Hospitality Guide Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.