NLD: SJT Recommendations For Campus Solutions 9.2 And The Use Of The CITIZENSHIP Table
(Doc ID 2986303.1)
Last updated on FEBRUARY 12, 2024
Applies to:
PeopleSoft Enterprise CS Campus Community - Version 9.2 and laterInformation in this document applies to any platform.
Goal
The delivered queries that reference the security table need to be reviewed and fixed.
To list the problematic queries, run this SQL SELECT:
- Verify any Campus Community owned query is not viewable following the navigation below.
- Navigate: Menu > Reporting Tools > Query > Query Manager.
- Search for Campus Community queries listed in the above sql select.
Which yields these 19 queries:
- QA_CS_CC_EMS_PERSON_DATA
- QA_SR_BR_IDENTIFICATION
- SAD_CA_REM_STD_WC_NLD
- SAD_POP_CAS_CREATE_STUDENT
- SSR_CS_RVF_BY_STUDENT_ID
- SSR_IAMCALC_NO_RSLTS
- SSR_IAMCALC_WITH_RESITS
- SSR_IAM_ANONID_BY_CAR_TERM
- SSR_IAM_ANONID_BY_INST_TERM
- SSR_IAM_ANONID_BY_ORG_TERM
- SSR_IAM_ANONID_EO_BY_CAR_PRD
These query search records require the SJT tables:
- 'EMPLMT_SRCH_GBL'
- 'EMPLMT_SRCH_QRY'
- 'PERALL_SEC_QRY'
- 'PERS_SRCH_QRY'
- 'POI_SEC_QRY'
- 'POSTN_SRCH_QRY'
So in addition to the above 19, there are these 7 CS queries:
- CARPLAN_CAREER_PLAN
- CARTRAIN
- CARTRAIN_CAREER_PLAN_TRAINING
- QA_CS_CC_COMMGEN_XTR_GEN
- SRCBDS1
- SRCBDS2
- SRCBDS3
- SSR_IAM_ANONID_EO_BY_INST_PRD
- SSR_IAM_ANONID_EO_BY_ORG_PRD
- SSR_IAM_ENR_BY_INST_TERM
- SSR_IAM_RESIT_EVAL_BY_INST
- SSR_IAM_RESIT_EVAL_BY_PERIOD
- SSR_IAM_RESIT_EVAL_BY_STUDENT
- SSR_IAM_RESIT_EVAL_BY_TERM
- SSR_IAM_RSLT_PST_EXAM_ONLY
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |