Campus Solutions 3C Engine The 3C engine is an application engine program that picks up on triggers set on PeopleSoft records and fields (in real time or batch mode) and assigns 3Cs events (typically communications in the form of letters). First, here's a summary of some 3Cs related terminology Term Explanation 3Cs Checklists, Comments, Communications 3C Event This is what gets assigned. It can be any of the 3Cs to either a person or an organisation. An example of a 3C event is adding a collections letter to a student’s communication. 3C Trigger The conditions which will cause a 3C event to occur. For example, a program completion (COMP) row added as a program action to a student’s academic program/plan data. 3C Trigger Prompt Table Fancy name for defining which prompt/edit values are allowed for a particular PeopleSoft field (e.g. use the Institutions table to validate input into the Institutions field) 3C Groups Used to group access to events and define security. A 3C event will not be applied if the user who caused the 3C trigger (e.g. completing a student) is not in the 3C event group (limits who can cause 3C events). 3c Trigger Results This is the page used to view trigger results if the have been implemented in batch mode. These are the 3C events that will be processed by the 3C application engine program to assign communications (or checklists / comments). Note real time Triggers use PeopleCode and instantly update communications without displaying anything on this page. The 3Cs engine including events and triggers are new to CS89. The 3C engine can be used to automatically assign checklists, comments and communications, reducing the amount of manual intervention (or customisations) needed to automate the use of 3Cs throughout the system. Useful Navigation: Campus Community -> 3C Engine -> Set Up 3C Engine 3C Event definitions Trigger prompt table for trigger field prompts Event 3C Groups (for security) Trigger definitions Also includes: 3C Trigger results – to check the outcome of batch triggers Run 3C Engine – run the 3C Application Engine Set Up SACR -> Security -> Secure Student Administration -> User ID 3C Group security. Used to add the 3C groups to your operator ID. Credit History Credit history is a PeopleSoft Campus Solutions Student Financials COBOL process. It goes through student accounts, checks for any overdue amounts and adds or updates the credit history table (PS_CREDIT_HISTORY). The process also ages overdue amounts for accounts, and after a certain period of time this may then go into collections. As the process goes through student financial accounts it can take a very long time to run and is usually batched to run overnight. The navigation to run credit history is: Student Financials > Collections > Process Credit History There is also a page to review what has been processed by credit history: Student Financials > Collections > Review Credit History The process is run by selecting an appropriate business unit and aging set. Business units are part of core student financials configuration. The navigation for aging set configuration is: Set Up SACR > Product Related > Student Financials > Collections > Aging Set Mass Change PeopleSoft Campus Solutions provides a functionality known as mass change which allows online development of batch processing SQL. Mass change is used in a number of delivered areas of Campus Solutions including: User Profile Management and creation 3C Engine (Communications/Checklists/Comments) Mass change security is defined using mass change operator security which is a misnomer. Mass change security is in fact associated with permission lists. You can use the following query to determine the role and permission lists associated with a mass change template. Note that mass change security is based on the primary permission list of the user logged into the system. If your primary permisison list doesn't have the mass change security you require, you will not be able to access the mass change templates regardless of whether they are in other permission lists in your user profile. select RC.ROLENAME, RC.CLASSID, MOS.MC_TEMPLATE_ID from PS_MC_OPR_SECURITY MOS inner join PSROLECLASS RC on MOS.OPRID = RC.CLASSID order by RC.ROLENAME 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: 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; Tables The following is a list of some of the key campus solutions records grouped by functional area. This is by no means a complete list, but hopefully it proves to be a handy reference. Please comment if you have any other table suggestions. Campus Community Person PS_PERSON Core person data including birth and death information PS_PERS_DATA_EFFDT Core person data history includes martial status and gender PS_PERSONAL_DATA Snapshot bio/demo data PS_PER_POI_TYPE Person of Interest (POI) Type PS_PER_POI_TRANS Person of Interest (POI) History Identification PS_CITIZENSHIP Citizenship data PS_SCC_CITIZ_HIST Citizenship history PS_CITIZEN_PSSPRT Citizenship passport data PS_DIVERS_ETHNICITY Ethnicity data PS_DIVERSITY Ethnicity diversity data PS_PERS_NID National ID data PS_EXTERNAL_SYSKEY External system data (key) PS_EXTERNAL_SYSTEM External system data PS_PER_ORG_ASGN Organisational relationships PS_SCC_PERSON_AUS Australian Tax File Number Data PS_SCC_CHESSN_AUS Australian CHESSN Data Biographic/Demographic PS_ADDRESSES Address history PS_EMAIL_ADDRESSES Email addresses PS_NAMES Names history PS_PERSONAL_PHONE Phone & Fax data 3Cs (Communications, Checklists and Comments) PS_COMMUNICATION Communication data PS_PERSON_CHECKLST Checklist data PS_PERSON_COMMENT Comment data PS_VAR_DATA_[AF] Variable data. Replace [AF] with administrative function e.g. SPRG PS_LAST_3CS_TBL Tracks the last SEQ_3C value for a student Campus Event Planning (and Meetings) PS_CAMPUS_EVENT Campus Event PS_EVENT_MTG Campus Event Meeting Service Indicators PS_SRVC_IND_DATA Service indicator data PS_SRVC_IN_RSN_TBL Service indicator reason PS_AUDIT_SRVC_IND Service indicator audit Curriculum Management Course data PS_CRSE_CATALOG Course catalog PS_CRSE_COMPONENT Course components PS_CRSE_OFFER Course offerings PS_CRSE_EQUIV_TBL Course equivalencies PS_CRSE_LST_HDR_SF Course list header PS_CRSE_LST_DTL_SF Course list details PS_CRSE_TOPICS Course topics Class data PS_CLASS_TBL Class data PS_CLASS_ASSOC Class associations PS_CLASS_ATTENDNCE Class attendance PS_CLASS_COMPONENT Class components PS_CLASS_INSTR Class instructors PS_CLASS_MTG_PAT Class meeting patterns PS_CLASS_NOTES Class notes Records and Enrolment Term Activation and History PS_STDNT_CAREER Student career PS_STDNT_CAR_TERM Student career term activation PS_SSR_HECS_ELEC Australian-specific HECS Loan Election PS_STDNT_SESSION Student session PS_TRNS_CRSE_SCH Transfer credit school PS_TRNS_CRSE_TERM Transfer credit course term PS_TRNS_OTHR_MODEL Other transfer credits model PS_TRNS_OTHR_TERM Other transfer credits term PS_TRNS_TEST_MODEL Test transfer credits model PS_TRNS_TEST_TERM Test transfer credits term Program/Plan PS_ACAD_PROG Student program data PS_ACAD_PLAN Student plan data PS_SSR_ACADPRG_AUS Australian-specific student program data Enrolment PS_STDNT_ENRL Student enrolments PS_CLASS_TBL_SE_VW View that combines student enrolment & class setup data PS_SSR_STDENRL_AUS Australian-specific student enrolment data PS_ENRL_REQ_HEADER Enrolment request header PS_ENRL_REQ_DETAI Enrolment request detail PS_SSR_STDENRL_AUS Australian Student Enrolment data Graduation/Degrees PS_ACAD_DEGR Student degree data PS_ACAD_DEGR_PLAN Student degree plan data PS_ACAD_DEGR_HONS Student degree honours data Student Groups PS_STDNT_GRPS Student group data PS_STDNT_GRPS_HIST Student group history Grade Book PS_STDNT_GRADE_DTL Student's grades detail PS_LAM_CLASS_ACTV Class assignments information Set Up SACR Institution structure PS_INSTITUTION_TBL Institution setup PS_CAMPUS_TBL Campus setup PS_CAMPUS_LOC_TBL Campus location setup PS_HOME_CAMPUS_TBL Home campus setup PS_ACAD_GROUP_TBL Academic group setup PS_ACAD_ORG_TBL Academic organisation setup PS_SSR_ACD_ORG_AUS Australian-specific Academic organisation setup Academic career PS_ACAD_CAR_TBL Academic career setup PS_ACAD_CAR_PTRS Academic career pointers setup PS_CATLG_CAR_TBL Academic career level setup PS_ACAD_CAL_TABLE Academic career calendar setup PS_HOLIDAY_TBL Holiday setup Programs, Plans and Degrees PS_ACAD_PROG_TBL Academic program setup PS_ACAD_PROG_OWNER Academic program owner setup PS_SSR_ACD_PRG_AUS Australian-specific academic program setup PS_SSR_PRG_CD_TBL Academic program code setup PS_ACAD_PLAN_TBL Academic plan setup PS_DEGREE_TBL Degree setup PS_SSR_ACDPRGT_AUS Australian Academic Program TAC setup PS_SSR_ACD_PLN_AUS Australian Academic Plan setup Term and Session PS_TERM_TBL Term setup PS_TERM_VAL_TBL Term Values PS_SESSION_TBL Term session setup PS_SESS_TIME_PEROD Session time periods Load/Level Rules PS_LVL_LD_RULE_TBL Academic level/load rules setup PS_ACAD_LEVEL_TBL Academic level setup PS_ACAD_LOAD_TBL Academic load setup PS_ACAD_LOAD2_TBL Academic load for statistics setup PS_SSR_LVLLOAD_AUS Australian specific load/level rules setup PS_SSR_ACADLOD_AUS Australian Academic Load setup Grading PS_GRADE_TBL Grade setup PS_GRADE_BASIS_TBL Grading basis setup PS_GRD_BASE_CHOICE Grading basis choice setup PS_GRADESCHEME_TBL Grading scheme setup PS_SSR_GRADE_FLAG Grading flag setup Security Student Records Security PS_SCRTY_TBL_INST Institution security PS_SCRTY_TBL_ACAD Academic organisation security PS_SCRTY_TBL_CAR Academic career security PS_SCRTY_TBL_PLAN Academic plan security PS_SCRTY_TBL_PROG Academic program security PS_SCRTY_ADM_ACTN Admissions action security PS_SCRTY_PROG_ACTN Program action security PS_SCRTY_APPL_CTR Application centre security PS_SCRTY_RECR_CTR Recruiting centre security PS_OPR_GRP_3C_TBL 3Cs operator group security PS_ENRL_ACCESS_GRP Enrolment access group security PS_ENRMT_OVRD_TBL Enrolment override security by enrolment access ID PS_SCRTY_TBL_SRVC Service indicator security PS_SCRTY_TSCRPT Transcript type security PS_SAD_TEST_SCTY Test ID security Student Financials Security PS_SEC_ISET_OPR Operator Institution set security PS_SEC_UNITSF_OPR Operator Business unit security PS_SEC_SETID_OPR Operator SetID security Student Admissions/Recruiting Applicants PS_ADM_APP_CAR_SEQ Application career sequence (stores next available career nbr) PS_ADM_APPL_DATA Application data PS_ADM_APPL_PLAN Application plan PS_ADM_APPL_PROG Application program PS_SAD_APL_PRG_AUS Australian-specific application program data PS_ADM_APPL_RCR_CA Recruiting category Prospects PS_ADM_PRSPCT_CAR Prospect career PS_ADM_PRSPCT_PLAN Prospect plan PS_ADM_PRSPCT_PROG Prospect program Student Financials Accounts PS_ACCOUNT_SF Student account PS_ITEM_SF Student account items PS_ITEM_LINE_SF Student account item lines PS_ITEM_XREF Student item cross reference PS_PAYMENT_TBL Student payments PS_QUICK_POST_TBL Quick post setup PS_QUICK_POST_ERR Quick post errors PS_ADM_APPL_DEP Calculated deposit fees (e.g. student housing, tuition deposit) as distinct from full charges Billing BI_BILL_HEADER Billing Invoice Header BI_BILLING_LINE Billing Line BI_BILL_MESSAGE Bill Messages BI_STD_REQ_TBL Billing Standard Request Table BI_BILL_ERROR Billing Errors Credit History and Collections PS_CREDIT_HISTORY Student Credit history PS_COLLECTION_SF Student collections PS_COLL_LTR_ITEM Dunning/collection letters PS_COLLECT_EFFORT Student collections recovery effort data Cashiering CSH_BD_CSH_TBL Business Date Cashier Table CSH_BD_CSH_OPEN Business Date Cashier Open Table CSH_BD_REG_OPEN Business Date Register Open Table CSH_BD_REG_TBL Business Date Register Table CSH_OFF_RECEIPT Cashier Office Receipts CSH_OFF_RCPT_L Cashier Office Receipt Line CSH_OFF_RCPT_T Cashier Office Receipt Tender CSH_OFF_TBL Cashiering Office Table GL Interface SF_ACCTG_LN SF Accounting Line SF_ACCTG_ERROR SF Quick Posting Error Table Group Post GROUP_CONT_INFO Control Group Info GROUP_LINE Group Line Information/Check Item Types ITEM_TYPE_TBL Item Type Table ITEM_ACCT_TYPE Valid Account Types GL_INTERFACE General Ledger Interface Optional Fees OPT_FEE_STDNT Optional Fees by Student OPT_FEE_TBL Optional Fees Table OPT_FEE_TERM Optional Fee Terms OPT_FEE_VAL Optional Fee Values Refunds REFUND_HDR Refund Header REFUND_DTL Refund Detail REFUND_CHECK Refund Check Information REFUND_WL Refund Work List Term Fee Setup TERM_FEE_TBL Term Fee Table TERM_FE_CD_TBL Term Fee Code Table TERM_SF_CD_TBL Term Sub Fee Code Table TERM_SUBFEE_TBL Term Sub Fee Table Third Party Contracts (TPCs) / Deferral Contracts / Payment Plans TP_CHARGES Third Party Allowable Charges TP_CONTRACT Third Party Contracts TP_STUDENT Third Party Student TP_STDNT_CHRG Third Party Allowable Charges Student Tuition Calc TUIT_CALC_TBL Tuition Calc Table CALC_MESSAGES Tuition Calc Error/Warn Messages OPT_FEE_STDNT Optional Fees by Student Tuition Group Setup SEL_GROUP_TBL Selector Group Table SEL_GROUP_CRITR Selector Group Criteria GROUP_FEE_TBL Group Fee Table Tuition Group Criteria Setup SEL_CRITER_TBL Group Selector Criteria SEL_CRITR_TBL Group Selector Criteria SEL_VALUE_TBL Selector Values Table Waiver Setup WAIVER_CODE_TBL Waiver Code Table WAIVER_GRP_DTL Waiver Group Detail Table WAIVER_GRP_TBL Waiver Group Table WAIVER_TBL Waver Table 1098-T Reporting SF_1098_DTL_SF SF 1098T Detail Record SF_1098_ITEM SF 1098T Item Details