Invantive EstateIn this screen you can register and change reporting time units.
Open Form
A reporting time unit is a breakdown of time-dependent data in a time range.
The registration of reporting time units is a typical activity for application developers. See the warning under Application Development.
The meaning of the entry fields is:
Code |
The code used to refer to the reporting time unit. |
Description |
The description. |
Sort Order |
A numeric value on which the reporting time units are sorted when they are shown in a list box in a screen. |
Presentation mask |
A pattern describing how a date must be shown. The presentation mask consists of a number of characters, of which each character describes exactly one character in the presentation. The following characters are possible in the presentation mask: •‘YYYY’: the year in four figures. •‘MM̕’ the number of the month in two digits. •‘DD̕’ the number of the day in two digits. •‘YY’: the last two digits of the year. •‘RR’: The last two digits of the year. The first 2 digits of the year will be determined by the current date of the database server and the figures provided. Four rules will be applied: ▪If the provided year is between 00 and 49 and the current year is between 00 and 49 than the century will be the same as the current century. For example, if the provided year is 15 and the current year is 2005, the result will be 2015. ▪If the provided year is between 50 and 99 and the current year is between 00 and 49 than the century is the current century minus one. For example, if the provided year is 75 and the current year is 2005, the result will be 1975. ▪If the provided year is between 00 and 49 years and the current year is between 50 and 99 than the century is the current century plus one. For example, if the provided year is 15 and the current year is 2075, then the result will be 2115 ▪If the provided year is between 50 and 99 years and the current year between 50 and 99 than the century is the same as the current century. For example, if the provided year is 55 years and the current year 2075, the result will be 2055. •‘RRR’: The year in four-digits whereby the first 2 digits of the year will be determined with the current date on the database server and the figures provided. Four rules will be applied (see ‘RR’). •‘IW̕’: The week number of the year based on the ISO 8601 standard. •etc. (see SQL language reference Oracle). |
