Queries for Population Selection
The PeopleSoft system delivers some predefined queries and Equation Engine equations for use with the Population Selection process. This document provides a list of those queries and equations that it delivers as of the date of this publication. Check with your department or system administrator to determine if your institution has created other queries or equations that you should use, or if additional queries or equations have been provided since the date of this publication.
The queries and equations listed in this document should be used as examples of how to create your own. They do not necessarily correspond to real business process transactions.
Query Name |
Description |
Process |
---|---|---|
QA_CS_AA_PS_AARPTRQST |
Population Selection AA Report by Career |
Generate Report Requests (SAA_RPT_RQST app engine) |
SAA_RPT_ACADLEVEL |
AA Report Query by Acad Level |
Generate Report Requests (SAA_RPT_RQST app engine) |
SAA_RPT_ADVISOR |
AA Report Query by Advisor |
Generate Report Requests (SAA_RPT_RQST app engine) |
SAA_RPT_CAREER |
AA Report Query by Career |
Generate Report Requests (SAA_RPT_RQST app engine) |
SAA_RPT_PROGPLAN |
AA Report Query by Plan |
Generate Report Requests (SAA_RPT_RQST app engine) |
SAA_RPT_PROGRAM |
AA Report Query by Program |
Generate Report Requests (SAA_RPT_RQST app engine) |
SAA_RPT_STUDENT_GROUPS |
AA Report Query by Student Grp |
Generate Report Requests (SAA_RPT_RQST app engine) |
QA_CS_AD_PS_APPDEL_01 |
Population Selection query for batch Application Delete testing |
Application Delete by Batch (SAD_APP_DEL app engine) |
QA_CS_AD_PS_APPDEL_02 |
Population Selection query for batch Application Delete testing |
Application Delete by Batch (SAD_APP_DEL app engine) |
QA_CS_AD_PS_APPDEL_03 |
Population Selection query for batch Application Delete testing |
Application Delete by Batch (SAD_APP_DEL app engine) |
QA_CS_AD_PS_PROSDEL_01 |
Population Selection Query for Batch Prospect Delete Testing |
Prospect Delete by Batch (SAD_PRS_DEl app engine) |
QA_CS_AD_PS_PROSDEL_02 |
Population Selection Query for Batch Prospect Delete Testing |
Prospect Delete by Batch (SAD_PRS_DEl app engine) |
QA_CS_AD_PS_PROSDEL_03 |
Population Selection Query for Batch Prospect Delete Testing |
Prospect Delete by Batch (SAD_PRS_DEl app engine) |
QA_CS_AD_PS_PROSDEL_04 |
Population Selection Query for Batch Prospect Delete Testing |
Prospect Delete by Batch (SAD_PRS_DEl app engine) |
QA_CS_CC_EMS_APPL |
Population Selection Query for EMS Create Appl Eval |
Create and Maintain Evaluations (SCC_GE_MAINT app engine) |
QA_CS_CC_EMS_THESIS |
Population Selection Query for EMS Create Thesis Eval |
Create and Maintain Evaluations (SCC_GE_MAINT app engine) |
QA_CS_CC_EMS_UPD_DEL |
Population Selection Query for EMS Update Delete |
Create and Maintain Evaluations (SCC_GE_MAINT app engine) |
QA_CS_CC_NSLDS_UPD1 |
Population Selection Query for NSLDS Data Push |
NSLDS Data Push (SFA_NSLDSUPDS app engine) |
QA_CS_CC_NSLDS_UPD2 |
Population Selection Query for NSLDS Data Push |
NSLDS Data Push (SFA_NSLDSUPDS app engine) |
QA_CS_CC_NSLDS_UPD_DAY_BEFORE |
Population Selection Query for NSLDS Data Push |
NSLDS Data Push (SFA_NSLDSUPDS app engine) |
QA_CS_CC_NSLDS_UPD_WEEK_BEFORE |
Population Selection Query for NSLDS Data Push |
NSLDS Data Push (SFA_NSLDSUPDS app engine) |
QA_CS_CC_POP_ADM_PRSPCT_CAR |
Population Update Query for ADM_PRSPCT_CAR |
Population Selection Update where record set to ADM_PRSPCT_CAR (SCC_POP_UPD app engine) |
QA_CS_CC_POP_APPL_RCR_CA |
Population Update of Application Recruiter Category |
Population Selection Update where record set to ADM_APPL_RCR_CA (SCC_POP_UPD app engine) |
QA_CS_CC_POP_ASG_CITIZENSHIP |
Population Update Query for SFA_ASG_ORG_DTL |
Population Selection Update where record set to SFA_ASG_ORG_DTL (SCC_POP_UPD app engine) |
QA_CS_CC_POP_CARTERM |
Population Update of Student Career Term |
Population Selection Update where record set to STDNT_CAR_TERM (SCC_POP_UPD app engine) |
QA_CS_CC_POP_EA_PROC_STATUS |
Population Update Query for SFA_EASTAGE_DTL |
Population Selection Update where record set to SFA_EASTAGE_DTL (SCC_POP_UPD app engine) |
QA_CS_CC_POP_INSTREL |
Population Selection Query for Batch Prospect Delete Testing |
Population Selection Update where record set to PERS_INST_REL (SCC_POP_UPD app engine) |
QA_CS_CC_POP_LOAN_ORIG_DTL |
Population Update Query for LOAN_ORIG_DTL |
Population Selection Update where record set to LOAN_ORIG_DTL (SCC_POP_UPD app engine) |
QA_CS_CC_POP_PELL_CITIZENSHIP |
Population Update Query for PELL_ORIG_DTL |
Population Selection Update where record set to PELL_ORIG_DTL (SCC_POP_UPD app engine) |
QA_CS_CC_POP_PELL_ORIG_FIELDS |
Population Update Query for PELL_ORIGINATN |
Population Selection Update where record set to PELL_ORIGINATN (SCC_POP_UPD app engine) |
QA_CS_CC_POP_PKGVAR |
Population Update Query for STDNT_PKG_VAR |
Population Selection Update where record set to STDNT_AID_ATRBT (SCC_POP_UPD app engine) Population Selection Update where record set to STDNT_PKG_VAR (SCC_POP_UPD app engine) Population Selection Update where record set to INAS_PROF_EXT (SCC_POP_UPD app engine) Population Selection Update where record set to INAS_CALC_RECS (SCC_POP_UPD app engine) |
QA_CS_CC_POP_SLC_STUDENT |
Population Update Query for SFA_SLC_STUDENT |
Population Selection Update where record set to SFA_SLC_STUDENT (SCC_POP_UPD app engine) |
QA_CS_CC_POP_STDCAR |
Query for Population Update of STDNT_CAREER |
Population Selection Update where record set to STDNT_CAREER (SCC_POP_UPD app engine) |
QA_CS_CC_POP_STDEQUTN |
Population Update for STDNT_EQUTN_VAR |
Population Selection Update where record set to STDNT_EQUTN_VAR (SCC_POP_UPD app engine) |
QA_CS_CC_POP_STDNTAID |
Population Update Query for STDNT_AID_ATRBT |
Population Selection Update where record set to STDNT_AID_ATRBT (SCC_POP_UPD app engine) Population Selection Update where record set to STDNT_PKG_VAR (SCC_POP_UPD app engine) Population Selection Update where record set to INAS_PROF_EXT (SCC_POP_UPD app engine) Population Selection Update where record set to INAS_CALC_RECS (SCC_POP_UPD app engine) |
QA_CS_CC_POP_STDNT_FATERM |
Population Update Query for STDNT_FA_TERM |
Population Selection Update where record set to STDNT_FA_TERM (SCC_POP_UPD app engine) |
QA_CS_CC_POP_LOAN_DISBMNT |
Population Update for LOAN_DISBMNT |
Population Selection Update where record set to LOAN_DISBMNT (SCC_POP_UPD app engine) |
QA_CS_CC_POP_PELL_DISBMNT |
Population Update for PELL_DISBMNT |
Population Selection Update where record set to PELL_DISBMNT (SCC_POP_UPD app engine) |
QA_CS_CC_PS_3CENGINE_ADMA |
Population Selection and 3C Engine - ADMA |
3C Engine when Administrative Function is ADMA (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_ADMP |
Population Selection and 3C Engine - ADMP |
3C Engine when Administrative Function is ADMP (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_AVAK |
Population Selection and 3C Engine - AVAK |
3C Engine when Administrative Function is AVAK (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_AVIN |
Population Selection and 3C Engine - AVIN |
3C Engine when Administrative Function is AVIN (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_AVMS |
Population Selection and 3C Engine - AVMS |
3C Engine when Administrative Function is AVMS (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_AWRD |
Population Selection and 3C Engine - AWRD |
3C Engine when Administrative Function is AWRD (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_FINA |
Population Selection and 3C Engine - FINA |
3C Engine when Administrative Function is FINA (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_GENO |
Population Selection and 3C Engine -GENO |
3C Engine when Administrative Function is GEN for Organization (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_GENP |
Population Selection and 3C Engine -GENP |
3C Engine when Administrative Function is GEN for person (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_IHC |
Population Selection and 3C Engine -IHC |
3C Engine when Administrative Function is IHC (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_ISIR |
Population Selection and 3C Engine - ISIR |
3C Engine when Administrative Function is ISIR (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_LOAN |
Population Selection and 3C Engine - LOAN |
3C Engine when Administrative Function is LOAN (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_PROP |
Population Selection and 3C Engine - PROP |
3C Engine when Administrative Function is PROP (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_PROS |
Population Selection and 3C Engine - PROS |
3C Engine when Administrative Function is PROS (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_PSSV |
Population Selection and 3C Engine -PSSV |
3C Engine when Administrative Function is ADMA (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_RSTR |
Population Selection and 3C Engine -RSTR |
3C Engine when Administrative Function is PSSV (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_SFACO |
Population Selection and 3C Engine - SFAC Organization based |
3C Engine when Administrative Function is SFAC for organization (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_SFACP |
Population Selection and 3C Engine - SFAC Person Based |
3C Engine when Administrative Function is SFAC for person (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_SFBI |
Population Selection and 3C Engine - SFBI |
3C Engine when Administrative Function is SFBI (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_SFCO |
Population Selection and 3C Engine - SFCO |
3C Engine when Administrative Function is SFCO (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_SFIT |
Population Selection and 3C Engine - SFIT |
3C Engine when Administrative Function is SFIT (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_SFPA |
Population Selection and 3C Engine - SFPA |
3C Engine when Administrative Function is SFPA (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_SFRC |
Population Selection and 3C Engine - SFRC |
3C Engine when Administrative Function is SFRC (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_SFRF |
Population Selection and 3C Engine - SFRF |
3C Engine when Administrative Function is SFRF (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_SFTPO |
Population Selection and 3C Engine - SFTP Organization Based |
3C Engine when Administrative Function is SFTP for organization (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_SFTPP |
Population Selection and 3C Engine - SFTP Person Based |
3C Engine when Administrative Function is SFTP for person (3C ENGINE app engine) |
QA_CS_CC_PS_3CENGINE_STRM |
Population Selection and 3C Engine - STRM |
3C Engine when Administrative Function is STRM (3C ENGINE app engine) |
QA_CS_CC_PS_SI_ACADRECRUIT |
Population Selection for Service Indicators - Academic Recruits |
Mass Assign Service Indicator (SCC_SI_ASSN app engine) Mass Release Service Indicator (SCC_SI_RELS app engine) |
QA_CS_CC_PS_SI_ACADRECRUIT_P |
Population Selection for Service Indicators - Academic Recruits |
Mass Assign Service Indicator (SCC_SI_ASSN app engine) Mass Release Service Indicator (SCC_SI_RELS app engine) |
QA_CS_CC_PS_SI_AMOUNTDUE_ORG |
Population Selection for Service Indicators - Organization with Amounts Due |
Mass Assign Org Service Indicator (SCC_ORG_ASSN app engine) Mass Release Org Service Indicator (SCC_ORG_RELS app engine) |
QA_CS_CC_PS_SI_AMOUNTDUE_ORG_P |
Population Selection for Service Indicators - Organization with Amounts Due |
Mass Assign Org Service Indicator (SCC_ORG_ASSN app engine) Mass Release Org Service Indicator (SCC_ORG_RELS app engine) |
QA_CS_CC_PS_SRVCIND_ORGS |
Population Selection for Service Indicators - Organizations |
Mass Assign Org Service Indicator (SCC_ORG_ASSN app engine) Mass Release Org Service Indicator (SCC_ORG_RELS app engine) |
QA_CS_CC_PS_SRVCIND_PERS |
Population Selection for Service Indicators - Person |
Mass Assign Service Indicator (SCC_SI_ASSN app engine) Mass Release Service Indicator (SCC_SI_RELS app engine) |
QA_CS_CC_PS_STDNT_GRPS |
Population Selection - Student Groups |
Mass Contract Select (SSF_PS_TPC app engine) |
QA_CS_CC_PS_USER_SCTY_REPLACE |
Population Selection and User Security Replacement |
Mass User Security Replacement (SCC_SCRT_UPD app engine) |
QA_CS_FA_INSTPRESENT |
QA_CS_FA_INSTPRESENT |
Mass Packaging Select (SFA_BPKGSEL app engine) |
QA_CS_FA_ISIRPRESENT |
QA_CS_FA_ISIRPRESENT |
Mass Packaging Select (SFA_BPKGSEL app engine) |
QA_CS_FA_NEEDUPDT |
Test query for Need Summary Update |
Select Students for Need Summary Validation (FAPPKNSD COBOL SQL) |
QA_CS_FA_NEEDUPDT_FARPK0001 |
Test query for Need Summary Update |
Select Students for Need Summary Validation (FAPPKNSD COBOL SQL) |
QA_CS_FA_NEEDUPDT_FARPK0002 |
Test query for Need Summary Update |
Select Students for Repackaging (SFA_RPKGSEL app engine) |
QA_CS_FA_NEEDUPDT_FARPK0003 |
Test query for Need Summary Update |
Select Students for Repackaging (SFA_RPKGSEL app engine) |
QA_CS_FA_NEEDUPDT_FARPK0012 |
Test query for Need Summary Update |
Select Students for Repackaging (SFA_RPKGSEL app engine) |
QA_CS_FA_SAP |
Test Query for SAP Pop Selection |
Process SAP (SFA_SAP_BDRV app engine) |
QA_CS_FA_SFEA_UGRD |
QA_CS_FA_SFEA_UGRD |
SF External Award Feed (SSF_EXT_AWDS app engine) |
QA_CS_FA_USER_EDIT_MSG |
Test query for Population Selection for User Edit Messages |
Process User Edit Messages (SFA_EDIT_MSG app engine) |
QA_CS_FA_USER_EDIT_MSG |
Population Update Query for INAS_FED_EXT and INAS_PROF_EXT |
Population Selection Update where record set to INAS_FED_EXT (SCC_POP_UPD app engine) Population Selection Update where record set to INAS_PROF_EXT (SCC_POP_UPD app engine) |
QA_CS_SF_GROUPLINE |
Population Selection for Group Post Transactions |
Pop Select for Group Line (SSF_GRPS_POP app engine) |
QA_CS_SF_PYMTPLANS |
Population Selection for Specific Account Number |
Mass Contract Select (SSF_PS_TPC app engine) |
QA_CS_SF_WV_ASSIGN |
Population Selection for Mass Assign Student Waivers |
Student Waiver Pop Select (SSF_SWVR_PS app engine) |
QA_CS_SR_PS_TRAN_BY_PROGRAM |
Query for Population Selection testing |
Process Transcripts (SSR_TSRPT Oracle BI Publisher) |
SSR_CREATE_ACADPROJ |
Create Student Academic Project records |
Create Project Records (SSR_BAT_PRJ app engine) |
SSR_MLSTN_PROGPLAN |
Process Milestones query by plan |
Process Milestones (SSR_MLSTN_PR app engine) |
SSR_MLSTN_PROGRAM |
Process Milestones query by program |
Process Milestones (SSR_MLSTN_PR app engine) |
SSR_PERC_ACTION_LETTERS |
Population Selection and 3C Engine – SENR |
3C Engine when the Administrative Function is SENR (3C app engine) |
SSR_PERC_DROP_LETTERS |
Population Selection and 3C Engine – SENR |
3C Engine when the Administrative Function is SENR (3C app engine) |
SSR_PERC_DROP_PG_LETTERS |
Population Selection and 3C Engine – SENR |
3C Engine when the Administrative Function is SENR (3C app engine) |
SSR_PERC_DROP_WL_LETTERS |
Population Selection and 3C Engine – SENR |
3C Engine when the Administrative Function is SENR (3C app engine) |
SSR_PERC_WARN_LETTERS |
Population Selection and 3C Engine – SENR |
3C Engine when the Administrative Function is SENR (3C app engine) |
SSR_PERC_WARN_WL_LETTERS |
Population Selection and 3C Engine – SENR |
3C Engine when the Administrative Function is SENR (3C app engine) |
SSR_REQS_ACAD_GRP |
Post Enrollment Requirement query by Group |
Process Batch Post Enrollment Requirement Checking (SRRQPERC) Process Batch Drop Requests for Post Enrollment Requirements: Generate and Process Drops (SRRQDROP) or Generate Drop Transactions (SSR_REQS_DRP) Print Enrollment Requirement Rosters (SSR_REQS_RPT ) Purge Post Enrollment Requirement Data (SSR_REQS_PRG ) |
SSR_REQS_ACAD_ORG |
Post Enrollment Requirement query by Org |
Same as for SSR_REQS_ACAD_GRP |
SSR_REQS_CAMPUS |
Post Enrollment Requirement query by Campus |
Same as for SSR_REQS_ACAD_GRP |
SSR_REQS_CAREER |
Post Enrollment Requirement query by Career |
Same as for SSR_REQS_ACAD_GRP |
SSR_REQS_SESSION |
Post Enrollment Requirement query by Session |
Same as for SSR_REQS_ACAD_GRP |
SSR_REQS_SUBJECT |
Post Enrollment Requirement query by Subject |
Same as for SSR_REQS_ACAD_GRP |
SSR_REQS_SUBJECT_CATNBR |
Post Enrollment Requirement query by Subject Catalog Number |
Same as for SSR_REQS_ACAD_GRP |
SSR_REQS_TERM |
Post Enrollment Requirement query by Term |
Same as for SSR_REQS_ACAD_GRP |
SSR_TS_ACADLEVEL |
Transcript Query by Acad Level |
Process Transcripts (SSR_TSRPT Oracle BI Publisher) |
SSR_TS_ADVISOR |
Transcript Query by Advisor |
Process Transcripts (SSR_TSRPT Oracle BI Publisher) |
SSR_TS_CAREER |
Transcript Query by Career |
Process Transcripts (SSR_TSRPT Oracle BI Publisher) |
SSR_TS_PROGPLAN |
Transcript Query by Prog Plan |
Process Transcripts (SSR_TSRPT Oracle BI Publisher) |
SSR_TS_PROGRAM |
Transcript Query by Program |
Process Transcripts (SSR_TSRPT Oracle BI Publisher) |
SSR_TS_STUDENT_GRP |
Transcript Query by Stdnt Grp |
Process Transcripts (SSR_TSRPT Oracle BI Publisher) |