1 / 12

JHU School of Professional Studies (SPSBE)

JHU School of Professional Studies (SPSBE). Matrix SMS Letters. Letter Entity Naming Conventions. CommGroupRule COMM GROUP NAME ltrRulLetterRule LETTER NAME LETTER JHU_SPSBE_SMS_vwViewName. Notes.xls. COMM GROUP NAME. CommGroupRule. LETTER NAME LETTER. ltrRulLetterRule.

tuan
Télécharger la présentation

JHU School of Professional Studies (SPSBE)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. JHU School of Professional Studies (SPSBE) Matrix SMS Letters

  2. Letter Entity Naming Conventions CommGroupRule COMM GROUP NAME ltrRulLetterRule LETTER NAME LETTER JHU_SPSBE_SMS_vwViewName

  3. Notes.xls

  4. COMM GROUP NAME

  5. CommGroupRule

  6. LETTER NAME LETTER

  7. ltrRulLetterRule

  8. JHU_SPSBE_SMS_vwViewName

  9. View Advantages • Closer to ANSI SQL (T-SQL) • Comments • More flexibility in aliasing • UDFs and Case Statements • Performance • ??? • Abstraction of view plays into letter “Error Reporting”

  10. Alternate Letter: Error Checking • CommGroupRule_ErrorCheck

  11. Obstacles and Dead Ends • SPSBE Auto-Merge Tool Shelved • Users weren’t consistently able to use SMS letters • Maintenance Proved as hard as implementation

  12. Alternative Approaches • JHU Nursing Mail-Merge against Excel Approach (Updated by MS Query) • JHU ASEN PHP Auto-Merge Online Approach • JHSPH Crystal Reports Enterprise Approach

More Related