Trends Fields Descriptions

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