Internal data types

The PPM system provides the following internal data types. These cannot be changed.

Data type

Example
(Description)

Units or scaling levels

Units (Description)

BOOLEAN

"true"

-

-

TEXT

"Example text"
String

-

-

TEXTPAIR

"Text 1\Text 2"
2 strings separated by a
backslash

 

LEVEL1SCALE
LEVEL2SCALE

 

Rough level
Detailed level

LONG

"-231456789"
Integers

-

-

DOUBLE

"3.1428"
Floating point numbers separated by a
decimal point

-

-

DAY

"24.03.2003"
Date in the format
dd.MM.yyyy



DAYSCALE
WEEKSCALE
MONTHSCALE
QUARTERSCALE
YEARSCALE

No unit, but levels of accuracy:
correct to day
correct to week
correct to month
correct to quarter
correct to year

TIME

"01.01.2002 08:15:23"
Date and time in the format
dd.MM.yyyy hh:mm:ss

The data type is identical to the data types DATE and TIMESTAMP



SECONDSCALE
MINUTESCALE
HOURSCALE
DAYSCALE
WEEKSCALE
MONTHSCALE
QUARTERSCALE
YEARSCALE

No unit, but levels of accuracy:
correct to second
correct to minute
correct to hour
correct to day
correct to week
correct to month
correct to quarter
correct to year

TIMEOFDAY

"12:41:56"
Time of the day in format hh:mm:ss



SECOND_OF_DAY
_SCALE
MINUTE_OF_DAY
_SCALE
HOUR_OF_DAY
_SCALE

No unit, but levels of accuracy:
correct to second

correct to minute

correct to hour

TIMESPAN

"23 SECOND"
Time span

SECOND
MINUTE
HOUR
DAY
WEEK
MONTH
YEAR

Second
Minute
Hour
Day
Week
Month
Year

FACTORY TIMESPAN

"23 FACTORY_HOUR"
Time span based on the factory calendar. Only the pure working time is taken into account.

FACTORY_SECOND
FACTORY_MINUTE
FACTORY_HOUR
FACTORY_DAY
FACTORY_WEEK
FACTORY_MONTH
FACTORY_YEAR

Person-second
Person-minute
Person-hour
Person-day
Person-week
Person-month
Person-year

FREQUENCY

"86400 PER_DAY"
Number per unit of time

PER_SECOND
PER_MINUTE
PER_HOUR
PER_DAY
PER_WEEK
PER_MONTH
PER_YEAR

per second
per minute
per hour
per day
per week
per month
per year

PERCENTAGE

"63 PERCENT"
Percentage

PERCENT
VALUE_ONLY

Percent
no unit (factor display)

For the time-based data types, the base unit is always seconds. The PERCENTAGE data type does not have a base unit.

Warning

The TEXTPAIR data type is used internally by PPM to process binary query results (e.g., process type group\process type). This data type is not suitable for direct data exchange, as the backslash (\) separator is replaced by the slash (/) character when importing an XML file.