In addition to the predefined time dimensions, you can set up your own custom time dimensions to reflect working patterns in your enterprise. For example: You can set up an additional daily frequency based on a fixed number of working days a year.
Custom time dimensions are available only to those localizations that have the PQP_CONTRACT_TYPES table enabled and accessible to users.
Use the Application Utilities Lookups window and the Table Structures window to enter custom time dimensions for historic rates.
In the Application Utilities Lookups window, create a new entry in the PQP_TIME_DIMENSIONS_FACTORS lookup.
For example, to define an additional Daily frequency based on a fixed number of working days a year, create the following entry:
| Code | Meaning | Description |
|---|---|---|
| WD | WORKING DAYS DIVISOR | Working Days per Year |
In the Table Structures window add a new column to the PQP_CONTRACT_TYPES table. Give the new column the same name as the meaning entry that you created in the previous step. For example, to amend the PQP_CONTRACT_TYPES table to accept your new Daily frequency, add a column called WORKING DAYS DIVISOR.
To define an element rate for your new custom time dimension, go back to the Application Utilities Lookup window and add your new lookup code to the PQP_TIME_DIMENSION lookup type.
For example, to define an element rate as Daily - Working rate, add this entry to the PQP_TIME_DIMENSION lookup. Use your previous lookup code (WD):
| Code | Meaning | Description |
|---|---|---|
| WD | Daily - Working | Daily rate based on the working days per year |
Save your work