Return to Navigation

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)