Query Defaults

SVTVMR DETAIL timespan file: Cycles 01-02
SVTVDR DETAIL timespan file: Cycles 01-02
User code selects yesterday’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ; (Both steps)
Derivations:
DATE
```
DATEPART(ENDTS)
```
SEQ

=1 for VMR file, =2 for VDR file

VTDMNTM, VTDAVTM, VTDMXTM, SVTVTDCT, SVTMNVTD, SVTAVVTD, SVTMXVTD, SVTVTDTM, and SVTVTD

Complex calculations in User Code step analyzing VMR and VDR records