[Campusce] SF Query

[CampusCE integrated with PeopleSoft]

Christy Campbell at Clark College shared this query that she uses to get information about payments for CampusCE classes.

QCS_SA_PAYMENTS_TYPE_DATE - Stdnt Amt Paid, Payment Type – This is the query that I had updated so that when we pull this and use as our CNED deposit for the day, it will shows us the information that is pushed from Campus CE telling us the what kind of payment it is.

This query would also be very useful for identifying payments that post and should be reviewed (PO, Escrow) to determine if the payment needs to be reversed or other follow-up needed.

700000000800 is the CampusCE Payment Type.
600000000800 is the Discount.



Susan Maxwell
Program Manager - ctcLink College Advisor
Project Manager - CampusCE to PeopleSoft Integration
360 704-4302
[cid:a0c2e3a9-5439-4ba1-8a2d-48cfa732a754]  [cid:f3129043-85b0-46c5-bd99-da3b2a6b0d08]   [cid:50238acb-9838-45ff-816c-0ab2c004d72f]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/mailman/private/campusce_lists.ctc.edu/attachments/20220503/bc4fa9b4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-5sx1kgnv.jpg
Type: image/jpeg
Size: 4365 bytes
Desc: Outlook-5sx1kgnv.jpg
URL: <http://lists.ctc.edu/mailman/private/campusce_lists.ctc.edu/attachments/20220503/bc4fa9b4/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-uboon5ec.png
Type: image/png
Size: 31924 bytes
Desc: Outlook-uboon5ec.png
URL: <http://lists.ctc.edu/mailman/private/campusce_lists.ctc.edu/attachments/20220503/bc4fa9b4/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-m5l35bsf.png
Type: image/png
Size: 54535 bytes
Desc: Outlook-m5l35bsf.png
URL: <http://lists.ctc.edu/mailman/private/campusce_lists.ctc.edu/attachments/20220503/bc4fa9b4/attachment-0001.png>