Configure MINUTES_CALCULATOR Field Type

You can configure a field ID as MINUTES_CALCULATOR field type. This field type enables the Minutes Calculator menu to open the Duration Calculator Browser from menu. This browser allows you enter the time in hours, day, weeks, months, or year, and then converts the time to minutes/seconds. Alternatively, you can select duration band and value, if available. To configure the new field ID as MINUTES_CALCULATOR field type, the following configurations are required in the database table CMN_FIELD_CONFIGURATION:

Table 1-12 Configurations for Field Type MINUTES_CALCULATOR

Column	Sample Value	Description
ENTERPRISE_ID	3	Current Enterprise ID
FIELD_TYPE_ID	7	MINUTES_CALCULATOR
FIELD_ID	30000000	Field ID entered in the table CMN_FIELDS.
KEY	DVB_SEC	Enter the Return Type text. See Table 1-13. This is a mandatory column.
VALUE	1	Enter the Return Type ID. See Table 1-13. This is a mandatory column.

For more information, see:

• Supported Return Type Texts and IDs (Key/Value):
  The Duration Calculator browser returns one the following texts as per the return type configured against the new field ID to the Advance Condition Editor page.