System Administrator Scenarios › How to Create a Custom Object › Create Attributes › Create a Time-varying Attribute

Create a Time-varying Attribute

Create a time-varying attribute to allow users to enter information that changes over time. For example, use a time-varying attribute to track resource allocation (as a percentage) over the lifecycle of a project task.

Note: Use only alphanumeric and underscore (_) characters when entering a unique ID for a time-varying attribute. Also, avoid SQL reserved words such as SELECT or STRING.

Follow these steps:

1. Open Administration, and from Studio, click Objects.
2. Click the name of the object.
3. Click Attributes.
4. Click New.
5. Complete the requested information. The following fields require explanation:

   Partition

   Specifies the partition to associate with the attribute.

   Partition Association Mode

   Specifies which partitions can include the attribute, in addition to the selected partition.

   Data Type

   Defines the data type for the field. Select Time-varying.

   Time-varying Data Units

   Specifies the unit that the time-scaled value represents, such as a number value, a monetary value, or a percentage.

   A fiscal time-scaled value that is created with a time-varying data unit set to Money has its currency code set to the system currency.

   When you create an instance of this fiscal time-scaled value, the currency code is set to the home currency of the associated financial entity.

   Time-varying Unit Conversion

   Specifies whether the time-varying data units are for each hour or for each second.

   Time-varying Date Constraints

   Defines time constraints to limit the range of data that is received for the attribute and improve processing performance. You can enter dates that override these dates. If you do not select a value, the default values include the widest available range.

6. For a multi currency system with money as the time-varying data unit, select one of the following options to specify the currency code location and a currency code for the attribute:
   • Attribute has its own currency code field. Select the default currency code for this option.
   • Reference another attribute of this object. Select the field that contains the currency code for this option.
7. Save your changes.

Back to Top