Letter Printed Data

Letter printed data is an option that you can set for standard letters configuration in PeopleSoft Campus Solutions under the following navigation:

  • Campus Community > Communications > Set up Communications > Standard Letter Table CS

Here is a screenshot for the delivered REC letter code:

rec-letter-printed-data.png

The delivered options are:

  • All
  • Name/Address Only
  • None

What does this mean? Well according to PeopleBooks this determines whether or not data for generated letters are stored in the communication section header PS_COMM_SCTN_HDR and data tables PS_COMM_SCTN_DATA.

This is the data you can view from:

  • Campus Community > Communications > Person Communications > Communication Letter Data

There is however a significant cost to storing All or even Name/Address Only data in these tables - the PS_COMM_SCTN_DATA will quickly blow out to millions of rows if you are generating communications on a regular basis.

So unless users are actually using the communication letter data pages and it serves some value, I would strongly recommend setting the letter printed data to None for all letter codes.

Here's a query to check all letters in Campus Solutions to see what option is set:

select
    ADMIN_FUNCTION,
    SCC_LETTER_CD,
    DESCR,
    (   
        select  XLATLONGNAME 
        from    PSXLATITEM XI
        where   FIELDNAME = 'LTR_PRINT_DATA_OPT'
        and     FIELDVALUE = SLT.LTR_PRINT_DATA_OPT
        and     EFFDT = (
                    select max(EFFDT)
                    from    PSXLATITEM
                    where   FIELDNAME = XI.FIELDNAME
                    and     FIELDVALUE = XI.FIELDVALUE
                    and     EFFDT <= sysdate
                )
    ) as LTR_PRINT_DATA_OPT
from PS_SCC_STN_LTR_TBL SLT
order by ADMIN_FUNCTION, SCC_LETTER_CD;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License