Absence Policy in Schedule Summary Report
Posted: Tue Jul 22, 2014 1:42 pm
We're trying to pull Schedule Summary Reports with Absence Policy details.
Example, we've got a single day where there are a mix of unpaid & paid absences and we'd like to pull a report differentiating between them.
We're trying to pull 1 day, Full Name, Date, Absence Policy, Start, End Times...
Filtered by Absent Schedule Status, No Grouping, sorted by Full Name.
The Absence Policy field comes up all ZEROs...??? (And zero is not the absency_policy ID from the absence_policy table either... If it was the absency_policy table ID, we'd see 4.)
The attachments show how we're pulling the report along with the results.
Example, we've got a single day where there are a mix of unpaid & paid absences and we'd like to pull a report differentiating between them.
We're trying to pull 1 day, Full Name, Date, Absence Policy, Start, End Times...
Filtered by Absent Schedule Status, No Grouping, sorted by Full Name.
The Absence Policy field comes up all ZEROs...??? (And zero is not the absency_policy ID from the absence_policy table either... If it was the absency_policy table ID, we'd see 4.)
The attachments show how we're pulling the report along with the results.