Below 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. a Jobs Report.
See custom jobs report vs. a custom job segments report for more information.
| Custom Report Field | Field Definition | Field Example(s) |
| Job ID | The unique identifier associated with each job and automatically generated by Absence & Substitute. | job-3hsm5m4mx121z |
| Job Status | The Job Status denotes the stage of a job and has 5 main options. | Open, Filled, No Substitute Required, Pending Approval, Cancelled |
| Job Classification Id | The unique identifier associated with the job classification automatically generated by Absence & Substitute. | jcl-2tfn3p3xhyl38 |
| Job Classification Name | The Classification of the Job. | Teacher, Paraprofessional, Administration, Janitor |
| Job Start Date | The 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 Timestamp | Exact start time of the employee's absence. | 2019-03-01T07:30:00.0000000-08:00 |
| Job Substitute Start Timestamp | Exact start time of the substitute's job. | 2019-03-01T07:30:00.0000000-08:00 |
| Job End Date | The 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 Timestamp | Exact end time of the employee's absence. | 2019-03-01T15:30:00.0000000-08:00 |
| Job Substitute End Timestamp | Exact end time of the substitute's job. | 2019-03-01T15:30:00.0000000-08:00 |
| Job First Day of Month | The first date of the month the job starts in. | 3/1/2019 |
| Job Last Day of Month | The last date of the month the job ends in. | 3/31/2019 |
| Job Duration | The total number of hours and minutes associated with an employee's absence (does not subtract unpaid break). In decimal format. | 8.75 |
| Job Paid Duration | The total number of hours and minutes that are deducted from an employee's entire absence (includes all days of absence) and automatically substracting unpaid breaks. In decimal format. | 8.75 |
| Job Unpaid Duration | The 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 Duration | The 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 Duration | The 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 Duration | The 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 Count | The number of calendar days associated with an absence. | 2 |
| Job Segment Id | The Job Segments unique identifier, which is automatically generated by Absence & Substitute. | jl-2r12gdtguztqw |
| Job Segment Position Id | The Job Segment's unique Position identifier, which is automatically generated by Absence & Substitute. | jp-1hxog3jfwdgmk |
| Job Segment Position Name | The Job Position associated with each job segment. | 4th Grade Teacher |
| Job Segment Site Name | The name of each site under the organization | Cascade Elementary |
| Job Segment Schedule Name | The name of the schedule associated with each job segment. | Full day |
| Job Segment Reason Id | The unique identifier (which is automatically generated by Absence & Substitute) for the Leave Reason in the Job Segment. | jr-o8gr8eqridbn |
| Job Segment Reason Name | The name of the absence reason associated with each job segment. | Professional Development |
| Job Segment Reason Requires Approval | A verification of whether or not the Absence Reason requires approval. | TRUE |
| Job Segment Reason Payroll Code | The Absence Reason's unique payroll code. | 124E53563466798 |
| Job Segment Date | The calendar date that the Job Segment occurs on. | 9/1/2019 |
| Job Segment Start Timestamp | The exact start time of the employee's absence for the Job Segment. | 2019-03-01T07:30:00.0000000-08:00 |
| Job Segment Substitute Start Timestamp | The exact start time of the substitute's job for the Job Segment. | 2019-03-01T15:30:00.0000000+00:00 |
| Job Segment End Timestamp | The exact end time of the employee's absence for the Job Segment. | 2019-03-01T15:30:00.0000000-08:00 |
| Job Segment Substitute End Timestamp | The 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 Month | The first date of the month the Job Segment is in. | 3/1/2019 |
| Job Segment Last Day of Month | The last date of the month the Job Segment is in. | 3/31/2019 |
| Job Segment Duration | Amount of time in hours that the employee's absence in the Job Segment will cover. | 7.5 |
| Job Segment Paid Duration | The 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 Duration | The total amount of time that is associated with an employee's break time during the absence. In decimal format. | 0.5 |
| Job Segment Substitute Duration | The amount of time in hours that the substitute's job in the Job Segment will cover. | 7.5 |
| Job Segment Substitute Paid Duration | The 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 Duration | The total amount of unpaid substitute time for each segment of a job. In decimal format. | 0 |
| Job Segment Substitute Arrival Status | Arrival status of the substitute | Awaiting Arrival, Arrived, No Show |
| Organization Name | The name of the Organization that the absence is posted under. | Watercrest School District |
| Employee Id | The unique identifier (that is automatically generated by Absence & Substitute) for the employee's account. | usr-32fcy9ry1v935 |
| Employee Personnel Id | A unique identifier for the employee's account. Often their Payroll ID. | SLYNN23456 |
| Employee First Name | The first name of the employee. | Stacy |
| Employee Last Name | The last name of the employee. | Lynn |
| Substitute Id | The unique identifier (that is automatically generated by Absence & Substitute) for the substitute's account. | usr-xtrbp66jozmy |
| Substitute Personnel Id | A unique identifier for the substitute's account. Often their payroll ID. | RROE57984 |
| Substitute First Name | The substitute's first name. | Richard |
| Substitute Last Name | The substitute's last name. | Roe |