Trends Fields Descriptions
Overview
Reports using the stored procedure DRC_DBSTrendFormatted_Rpt may display acronyms for various fields.
The descriptions for these fields are as follows:
Curr: Current date
- Sdly: Same Day Last year (If Calendar [Use for SDLY] = False, [Curr-365] else [same day of same sub of same period]).
- Sdly_dif : (Curr-Sdly)
- Sdly_p: Sdly_dif/Sdly
Sdlw: Same day last week (Date -7)
- Sdlw_dif (Curr-Sdlw)
- Sdlw_p
Sptd: Sub-period to date
- Sptdly: Subperiod to date last year
- Sply: All subperiod last year
- Sptdly_dif: (Sptd-Sptdly)
- Sprdly_p: Sptdly_dif/Sptdly
Sptdlw: Sub-period to date last week
- Sptdlw_dif = (Sptd – Sptdlw)
- Sptdlw_p
Ptd: Period to date
- Ptdly: Period to date Last Year
- Ply : All period last year
- Ptdly_dif = (Ptd-Ptdly)
- Ptdly_p
Ytd: year to date
- Ytdly: year to date last year (not true ytd but calendar ytd)
- Yly: All Year last year
- Ytdly_d = (Ytd-Ytdly)
- Ytdly_p
