GET_ABSENCE_COUNTS
This formula function can be used to calculate the number of absence entries against a person and return the total durations between a start date and end date passed as parameters.
Mandatory Contexts
This formula function does not require any contexts to return values.
Parameters
Parameter name | Data Type | Description |
---|---|---|
p_person_id | Number | Person id for whom absence entries durations and occurrences need to be fetched |
p_include_type_id | Number | Absence type id to be included |
p_exclude_type_id | Number | Absence type id to be excluded |
p_include_categor_id | Number | Absence category id to be included |
p_exclude_category_id | Number | Absence category id to be excluded |
p_include_reason_id | Number | Absence reason to be included |
p_exclude_reason_id | Number | Absence reason to be excluded |
p_start_date_from | Date | Absences that end on or after this date are included in the calculations |
p_start_date_to | Date | Absences that end on or before this date are included in the calculations |
p_duration_days | Number | Out parameter – sum of durations of absence entries that were recorded in Days |
p_duration_hours | Number | Out parameter – sum of durations of absence entries that were recorded in Hours |
p_duration_cal | Number | Out parameter – sum of durations of absence entries that were recorded in Calendar Days |
p_duration_weeks | Number | Out parameter – sum of durations of absence entries that were recorded in Weeks |
p_duration_months | Number | Out parameter – sum of durations of absence entries that were recorded in Months |
p_duration_years | Number | Out parameter – sum of durations of absence entries that were recorded in Years |
p_occurances | Number | Out parameter – count of absence entries |
Data Returned
Apart from the out parameters returned above, the return data for the formula function is a Number value of 0 in all cases.