NTD Standard Report

The NTD Standard Report gathers service data for NTD reporting. The report is similar to the Trip Hours and Trip Miles Productivity standard reports. At the bottom of the report, a summary is listed about the options used, date or date ranges selected, and the user who generated the report.

Table 1. NTD Standard Report Parameters
Parameter	Description
Type	Schedule type.
Date/Weekday	Specifies whether the report is for specific dates or days of the week. Choose the option appropriate for the schedule type: Date. Specify a From Date and To Date for the report (for example, 10/10/19 to 10/15/19). Weekday. Specify a From Day and To Day for the report (for example, Monday to Friday).
From Route	First route in the report.
To Route	Last route in the report.
Revenue	Select any of the following to exclude from revenue hours and distances: Exclude Lunches Exclude Breaks
Distance	If Calculate is selected, distances are based on PASS calculated distances. If Full Odometers is selected, actual odometer readings are used. The Full Odometers option is not recommended unless you have mobile data to ensure complete odometer readings. If Partial Odometers is selected, the report uses odometer readings when they are available and calculated distances when odometer readings are not available.
Total	Select any of the following to exclude from total distance and total time: Exclude Lunches Exclude Breaks
Pull out/in use sort time	If selected, the selected sort time is used as the pull out/in time.
First Pickup/Last DropOff use sort time	First pick-ups normally use the actual arrival time and last drop-offs normally use the actual departure time (overriding the selected sort time method). If selected, the system will use the selected sort time (for example, Est Time) for the first pick-up and last drop-off.
Sort Time	Sort order used in the report: Est Time. Estimated time. Est Time Lock. Est Time Lock is the Est Time (if any) that is manually typed into the Schedule Editor. The Schedule Editor tries to honor this time but cannot always do so. As a result, Est Time and Est Time Lock values can differ. Actual Arrive Time. Actual arrival time. Actual Depart Time. Actual departure time. Note: The Sort Time should be set to the Est Time or the time that is entered in the Schedule Editor. For example, do not sort on actual arrive time if you have not entered these times.
Break Threshold (Minutes)	Time in minutes a break must exceed to be removed from the service calculations. For example, if the Break Threshold is set at 60 and an out-of-service break takes 90 minutes, the break will be excluded from service time. A 15 minute out-of-service break would not be excluded.
Enhanced Break Calc	If selected, the break duration is calculated from the last drop before the break to the first pick after the break. If cleared, the break time is computed from the break arrive time to the break depart time.
Exclude exception days	If selected, the report will ignore days marked as exception days (for example, holidays that run on Sunday service). For more information about exception days, see the PASS System Administrator and User Guide.
Max Dis/Rte	Maximum distance for a single route. If the total distance of a route is greater than this value, it is considered an error and set to 0.
Providers	If All is selected, records for all providers appear in the report. If All is cleared, select individual providers from the list. The options available to you depend on provider security.
Funding Sources	If All is selected, the report includes data for all funding sources. If All is cleared, select funding sources from the list.
Treat Exception Days As	If exception days (typically holidays) are included, select how they should be treated in report calculations: Weekday Saturday Sunday
Run Type	Run types to include in the report: EvsFlex (Flex run) Para Taxi
ADA Funding Sources	If All is selected, the report includes data on line 19 for all funding sources. If not all funding sources count as ADA trips, clear All and choose only those funding sources that may be used for ADA trips. Note: Not all funding sources that pay for trips are considered ADA (for example, a contract with a Senior Center outside of the ADA service area).
Para Service	Choose the paraservice for the report from the list.
Fare Type	Fare types in the report.
Passenger Type	If All is selected, records for all passenger types are included. If All is cleared, select a passenger type (for example, CLI or COM) for the report from the list.
Use NTD Definitions	Use NTD Definitions Select to ignore all other parameter options and use NTD (National Transit Database) definitions. If a schedule has no scheduled, arrived, or performed trips, it will not be included as a service day in the daily averages. To conform to NTD definitions, the report works in the following way: AVL breaks are ignored. Perform times are used for pull-outs, drop-offs, and breaks. ETD is used if there is no ActualPerformTime. Arrive times are used for pick-ups an pull-ins. ETA is used if there is no ActualArriveTime. Time from pull-out to first pick-up is included in Total time only. Time from first pick-up after a pull-out or break to the last drop-off before the next pull-in or break is included in both Total time and Revenue time. Time from drop-off immediately before a break to the completion of the break is not included in either Total time or Revenue time. Distance from drop-off immediately before a break to the completion of the break is not included in either Total miles or Revenue miles. Time from break completion to pick-up is not included in either Total time or Revenue time. Time from last drop-off to pull-in is included in Total time only. If there is a break between last drop-off and pull-in, the time after last drop-off is not included in either Total time or Revenue time. *Note that calculations for miles and hours may differ slightly from manually calculated values. This occurs because the report rounds numbers during the intermediate steps of the calculation instead of rounding the final calculated value.