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 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 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 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 subtracting 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 Payroll Code | The 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 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 Id | The unique identifier (that is automatically generated by Absence & Substitute) of the Site that is in the Job Segment | ste-11khlt3jkbuu9 |
| Job Segment Site Name | The name of the Site associated with each job segment. | Green River High School |
| 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. | 3/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. |
| Organization Id | The unique identifier (that is automatically generated by Absence & Substitute) for the Organization that the absence is posted under. | org-55tkpnbk8rrq |
| Organization Name | The name of the Organization that the absence is posted under. | Watercrest School District |
| Employee Payroll Code | The employee's unique payroll code. | 10E24150089000000000 |
| 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 |