Year over Year Variance Util displays values for a location and date and the previous years value. It then calculates a relative percent difference (variance) between the values. It allows for Result Comments to be entered to explain the variances.
In order to display the menu option you must insert the following record into the OPSROOT.GENERALSETTINGS table.
INSERT INTO GENERALSETTINGS VALUES ('DISPLAY_YEAR_OVER_YEAR_UTIL','YES')
abs(Current Value - Previous Value)/Previous Value * 100
If Show is set to Variables with % variance >= x the utility will display variables based on the following rules (i.e. is a Comment Required):
If a variable is calculated it is NOT SHOWN.
If a variable additional info field NEWVAR (VARDESC_I.NEWVAR) is set to any value the variable is NOT SHOWN
If a variables variance calculation is greater than entered threshold (default of 10) the variable is shown.
If Previous Value is No value (blank) and the Current Value has a value it is considered to have a variance > entered threshold and the variable is shown.
If Current Value is No value (blank) and the Previous Value has a value it is considered to have a variance > entered threshold and the variable is shown.
The YOYNULLEQZERO OPSROOT General Setting allows you to specify that No values (blanks) are treated as zeros. This is on by default. If this setting is set to '0', a Null will be considered > entered threshold if the other value is zero. If set to '1' or record is removed from GeneralSettings table, 0 and Null (blanks) will be considered equal.
INSERT INTO GENERALSETTINGS VALUES ('YOYNULLEQZERO' ,'0')
Status is RED when any variables with a variance greater than threshold do not have a result comment entered. Status turns Green when result comments are entered for all variables that have a variance greater than threshold.
The Utility will also display in the status bar the variable additional info fields FormOrder and FormForeColor (VarDesc_I.FormOrder, VarDesc_I.FormForeColor)
When Result Comments are saved, if the FACILITY_I.LocName_VRS_ATS field exists it will check that all required comments have been entered and will update the FACILITY_I.LocName_VRS_ATS with the current time and the FACILITY_I.LocName_VRS_AU with the currently logged in username.
LocName is replaced with Location Name selected. Example, if location is TEMPLATEWW then the fields would be: