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:
Here is a screenshot for the delivered
REC letter code:
The delivered options are:
- Name/Address Only
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
This is the data you can view from:
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;