Custom report glossary of terms

This is a list of all Custom Report fields including a definition and examples of each field. Common fields for reconciliations and payroll integrations have also been highlighted in bold. 

For reconciling, we suggest creating a Job Segments report vs.  Jobs Report. Click here for more information.


Custom Report FieldField DefinitionField Example(s)
Job IDThe unique identifier associated with each job and automatically generated by Absence & Substitute.job-3hsm5m4mx121z
Job StatusThe Job Status denotes the stage of a job and has 5 main options.Open, Filled, No Substitute Required, Pending Approval, Cancelled
Job Segment Substitute Arrival Status
The Job Confirmation denotes where a substitute arrived on site for the job or was a no show.Awaiting Arrival, Arrived, No Show
Job Classification IdThe unique identifier associated with the job classification automatically generated by Absence & Substitute.jcl-2tfn3p3xhyl38
Job Classification NameThe Classification of the Job.Teacher, Paraprofessional, Administration, Janitor
Job Start DateThe starting date of the absence. If it's a multi-day job, it is the first date in the multi-day absence.3/1/2019
Job Start TimestampExact start time of the employee's absence.2019-03-01T07:30:00.0000000-08:00
Job Substitute Start TimestampExact start time of the substitute's job.2019-03-01T07:30:00.0000000-08:00
Job End DateThe ending date of the absence. If it's a multi-day job, it is the last date in the multi-day absence.3/1/2019
Job End TimestampExact end time of the employee's absence.2019-03-01T15:30:00.0000000-08:00
Job Substitute End TimestampExact end time of the substitute's job.2019-03-01T15:30:00.0000000-08:00
Job First Day of MonthThe first date of the month the job starts in.3/1/2019
Job Last Day of MonthThe last date of the month the job ends in.3/31/2019
Job DurationThe total number of hours and minutes associated with an employee's absence (does not subtract unpaid break). In decimal format.8.75
Job Paid DurationThe total number of hours and minutes that are deducted from an employee's entire absence (includes all days of absence) and automatically subtracting unpaid breaks. In decimal format.8.75
Job Unpaid DurationThe total number of hours and minutes that are associated with the break time of an employee's entire absence (includes all days of the absence). In decimal format.0
Job Substitute DurationThe total number of hours and minutes associated with a substitute's entire job (includes all days of the job) and does not subtract breaks. In decimal format.8
Job Substitute Paid DurationThe total number of hours and minutes the substitute is paid for the entire job (includes all days of the job) and automatically subtracts unpaid breaks. In decimal format.8
Job Substitute Unpaid DurationThe total number of hours and minutes that are associated with the break time of a substitute's entire job (includes all breaks for all days). In decimal format.0.25
Job Day CountThe number of calendar days associated with an absence.2
Job Segment IdThe Job Segments unique identifier, which is automatically generated by Absence & Substitute.jl-2r12gdtguztqw
Job Segment Payroll CodeThe Job Segment's unique Payroll Code. Automatically added to a job segment when the absence is created and is derived from either the absence employee profile or the absence reason depending on organization setup. Can be overridden on the job itself prior to export. 124E533466798000000
Job Segment Position IdThe Job Segment's unique Position identifier, which is automatically generated by Absence & Substitute.jp-1hxog3jfwdgmk
Job Segment Position NameThe Job Position associated with each job segment.4th Grade Teacher
Job Segment Site IdThe unique identifier (that is automatically generated by Absence & Substitute) of the Site that is in the Job Segmentste-11khlt3jkbuu9
Job Segment Site NameThe name of the Site associated with each job segment.Green River High School
Job Segment Schedule NameThe name of the schedule associated with each job segment.Full day
Job Segment Reason IdThe unique identifier (which is automatically generated by Absence & Substitute) for the Leave Reason in the Job Segment.jr-o8gr8eqridbn
Job Segment Reason NameThe name of the absence reason associated with each job segment.Professional Development
Job Segment Reason Requires ApprovalA verification of whether or not the Absence Reason requires approval.True
Job Segment Reason Payroll CodeThe Absence Reason's unique payroll code.124E53563466798
Job Segment DateThe calendar date that the Job Segment occurs on.3/1/2019
Job Segment Start TimestampThe exact start time of the employee's absence for the Job Segment.2019-03-01T07:30:00.0000000-08:00
Job Segment Substitute Start TimestampThe exact start time of the substitute's job for the Job Segment.2019-03-01T15:30:00.0000000+00:00
Job Segment End TimestampThe exact end time of the employee's absence for the Job Segment.2019-03-01T15:30:00.0000000-08:00
Job Segment Substitute End TimestampThe exact end time for the substitute's job for the Job Segment.2019-03-01T23:30:00.0000000+00:00
Job Segment First Day of MonthThe first date of the month the Job Segment is in.3/1/2019
Job Segment Last Day of MonthThe last date of the month the Job Segment is in.3/31/2019
Job Segment DurationAmount of time in hours that the employee's absence in the Job Segment will cover.7.5
Job Segment Paid DurationThe total amount of time that is deducted from an employee's absence for each job segment of a job (unpaid "Breaks" are automatically subtracted). In decimal format.7.5
Job Segment Unpaid DurationThe total amount of time that is associated with an employee's break time during the absence. In decimal format.0.5
Job Segment Substitute DurationThe amount of time in hours that the substitute's job in the Job Segment will cover.7.5
Job Segment Substitute Paid DurationThe total amount of time a substitute is paid for each segment of a job (unpaid "Breaks" are automatically subtracted). In decimal format.7.5
Job Segment Substitute Unpaid DurationThe total amount of unpaid substitute time for each segment of a job. In decimal format.0.
Organization IdThe unique identifier (that is automatically generated by Absence & Substitute) for the Organization that the absence is posted under.org-55tkpnbk8rrq
Organization NameThe name of the Organization that the absence is posted under.Watercrest School District
Employee Payroll CodeThe employee's unique payroll code.10E24150089000000000
Employee IdThe unique identifier (that is automatically generated by Absence & Substitute) for the employee's account.usr-32fcy9ry1v935
Employee Personnel IdA unique identifier for the employee's account. Often their Payroll ID.SLYNN23456
Employee First NameThe first name of the employee.Stacy
Employee Last NameThe last name of the employee.Lynn
Substitute IdThe unique identifier (that is automatically generated by Absence & Substitute) for the substitute's account.usr-xtrbp66jozmy
Substitute Personnel IdA unique identifier for the substitute's account. Often their payroll ID.RROE57984
Substitute First NameThe substitute's first name.Richard
Substitute Last NameThe substitute's last name.Roe

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.