|
Based on (table.column) |
Type |
Column alias |
Localised english name |
Comment |
|
Calculated columns |
|
|
|
|
|
Nr. of Activities / Budget * 100 |
C |
CalculatedColumn2 |
Achieved (%) |
If the associate has performed 20 activities and the budget was 20 then 100 is displayed. Underperformance will yield a number less than 100, and performing more activites than the budget will yield a number higher than 100. |
|
Nr. of Activities - Budget |
C |
CalculatedColumn |
Deviation |
Under performance will yield a negative number. Performance better than budget will yield a positive number indicating the number of activities over budget. |
|
Categories |
|
|
|
|
|
person.firstname, person.lastname |
E |
PersonName(Last,First) |
Person Name (Last,First) |
Name of associate |
|
usergroup.name |
E |
UsergroupName(Persons) |
Person's group |
The associates primary usergroup |
|
|
|
|
|
|
|
Values |
|
|
|
|
|
appointment.appointment_id, appointment.associate_id, appointment.activedate, appointment.registered, appointment.private, appointment.document_id, appointment.task_idx |
E |
Nr. of Activities |
No of activities |
The nr. of activites for the given period and associate |
|
|
|
|
|
|
|
Budget value |
|
|
|
|
|
BA Input Module.data |
E |
Budget |
Budget |
The budget for the given period and associate |
|
|
|
|
|
|
|
Dates |
|
|
|
|
|
BA Time Table |
P |
StartDate |
Start date |
Start of the month |
|
appointment.activeDate |
E |
Activedate(Year) |
Active date (Year) |
Active date in format YYYY |
|
appointment.activeDate |
E |
Activedate(Quarter) |
Active date (Quarter) |
Active date in format Q |
|
appointment.activeDate |
E |
Activedate(Month) |
Active date (Month) |
Active date in format MM |
|
appointment.activeDate |
E |
Activedate(Year-Quarter) |
Active date (Year-Quarter) |
Active date in format YYYY-QQ |
|
appointment.activeDate |
E |
Activedate(Year-Month) |
Active date (Year-Month) |
Active date in format YYYY-MM |
|
|
|
|
|
|
|
Parameters |
|
|
|
|
|
associate.associate_id |
P |
AssociateId |
AssociateId |
May be used for column based filtering |
|
associate.group_idx |
P |
UsergroupId(Persons) |
UsergroupId(Persons) |
May be used for column based filtering |
