If your procedure requires an input variable, please carefully read this section. In order to allow the user to select certain data values for input as procedure variables, Scolo uses special input values to request data from the user in a dialog.

Below is a list of input variables that can be used with Scolo. These values are added to the database in the table ‘ReportVariables’. Each variable that you want to have the user select needs to have a record in this table associated with the custom report record you create. The record in the ‘ReportVariables’ table needs to use the variable name exactly as noted below. See the section for creating custom report records in the database.

Database Variable	Description
$$DATE$$	Request the input of a date. The procedure will be called with the date in the format of YYYY-MM-DD (ie. 2017-02-05).
$$START_DATE$$	Request the input of a start date that is used with an end date, $$END_DATE$$ variable. The procedure will be passed with the date in the format of YYYY-MM-DD (ie. 2017-02-05).
$$END_DATE$$	Request the user select an end date that is used with start date ($$START_DATE$$) to create a span of dates. The procedure will be passed with the date in the format of YYYY-MM-DD (ie. 2017-02-05).
$$TIME$$	Require the user to input a specific time to be used by your procedure. The time value will be passed to the procedure in the format of HH:MM:SS (ie. 08:39:00).
$$COMPRESSOR$$	The user will be asked to select a specific compressor from a drop down list of all compressors currectly configured in Scolo.
$$PUMP$$	The user will be asked to select a specific pump from a drop down list of all the pumps currectly configured in Scolo.
$$OTHER_EQUIPMENT$$	The user will be asked to select a specific piece of equipment from a drop down list of all equipment in the category of ‘Other Equipment’ currectly configured in Scolo.
$$REGION$$	The user will be asked to select a specific region from a drop down list of all regions configured in Scolo.
$$TRAIL$$	The user will be asked to select a specific trail from a drop down list of all trails configured in Scolo.
$$HYDRANT$$	The user will be asked to select a specific hydrant from a drop down list of all hydrants configured in Scolo.
$$PIPE$$	The user will be asked to select a specific pipe record from a drop down list of all pipe configured in Scolo.
$$VALVE_HOUSE$$	The user will be asked to select a specific valve house from a drop down list of all valve houses configured in Scolo.
$$VALVE$$	The user will be asked to select a specific valve from a drop down list of all valves configured in Scolo.
$$GUN$$	The user will be asked to select a specific gun from a drop down list of all snowmaking guns configured in Scolo.
$$HYDRANT_MFG$$	The user will be asked to select a specific water hydrant manufacturer from a drop down list of all water hydrant manufacturers configured in Scolo.
$$HYDRANT_MODEL$$	The user will be asked to select a specific water hydrant model from a drop down list of all water hydrant models configured in Scolo.
$$HYDRANT_AIR_BRAND$$	The user will be asked to select a specific air hydrant brand from a drop down list of all air hydrant brands configured in Scolo.
$$HYDRANT_AIR_TYPE$$	The user will be asked to select a specific air hydrant type from a drop down list of all air hydrant types configured in Scolo.
$$GUN_MFG$$	The user will be asked to select a specific gun manufacturer from a drop down list of all snowmaking gun manufacturers configured in Scolo.
$$GUN_MODEL$$	The user will be asked to select a specific gun model from a drop down list of all snowmaking gun models configured in Scolo.
$$HNODE$$	The user will be asked to select a specific hydrant that has a hNode controller from a drop down list of all hNode automatic controllers configured in Scolo.
$$USER$$	The user will be asked to select a specific user from a drop down list of all users configured in Scolo.
$$USER_PERMISSIONS$$	The user will be asked to select a specific user permission type from a drop down list of all user permission types.