Geeks on Campus

Another amazing bgsu blog

First Pop Update

Posted by jeggent on January 12, 2011

Now that Fall grades are posted, we are updating our Pell 2 offers.  However this often causes the Pell 1 offer to change when the student was not full time in Summer (our header term).  So I have used a Pop Update process to mark all of the Pell 1 awards (for students with Pell 2) as locked.  Here is a brief outline of the steps needed to do a Population Update.

  1. You need for your User ID to have access to update the record.  “Set Up SACR > Security > Secure Student Administration > User ID > Population Update Security”
  2. The field to be updated must be associated with the record.  “Set Up SACR > System Administration > Utilities > Population Update > Population Update Setup”
  3. Write the query to select the population to update.  Don’t forget to join in the correct bind record, they are different for each record.  For the STDNT_AWARDS record the bind record is SCCPU_STAWD_BND.
  4. Set up the Pop Update run control. “Set Up SACR > System Administration > Utilities > Population Update > Population Update Process”
    • If you cannot find your query here than you probably do not have the correct bind record on your query.
  5. Run the process.

Here are all the records and fields that can currently be updated with Pop Update and the bind record for the records.

  • Record (bind record)
    • Field
  • ADM_APPL_RCR_CA (SCCPU_APRCR_BND)
    • RECRUIT_SUB_CAT
  • ADM_PRSPCT_CAR (SCCPU_PRSCR_BND)
    • FIN_AID_INTEREST
    • HOUSING_INTEREST
  • INAS_CALC_RECS (SCCPU_STDNT_BND)
    • CALC_STATUS
  • INAS_FED_EXT (SCCPU_STDNT_BND)
    • BUDGET_DURATION_A
    • BUDGET_DURATION_N
  • INAS_PROF_EXT (SCCPU_STDNT_BND)
    • PE_BDGT_DUR_A
    • PE_BDGT_DUR_N
  • ISIR_CONTROL (SCCPU_ISIRC_BND)
    • CORRECTION_STATUS
  • LOAN_ORIG_DTL (SCCPU_LNORD_BND)
    • LOAN_PROC_STAT
  • PELL_ORIGINATN (SCCPU_PELOR_BND)
    • PELL_ORIG_STATUS
    • PELL_TRANS_STAT
    • UPDATE_PELL_ORG
  • PELL_ORIG_DTL (SCCPU_PELOD_BND)
    • SFA_COD_CITZN_STAT
  • PERS_INST_REL (SCCPU_PERS_BND)
    • Looks like most fields
  • SFA_ASG_ORG_DTL (SCCPU_ASGOD_BND)
    • SFA_COD_CITZN_STAT
  • SFA_EASTAGE_DTL (SCCPU_EADTL_BND)
    • SFA_EA_PROC_STAT
  • SFA_SLC_STUDENT (SCCPU_SLCST_BND)
    • SFA_SLC_P_ATT_IND
  • STDNT_AID_ATRBT (SCCPU_STDNT_BND)
    • 31 fields including…
    • AID_APP_STATUS
    • FA_SS_AWD_SECURITY
    • FA_SS_INQ_SECURITY
    • LN_EXIT_INTER_STAT
    • LN_INTERVW_STAT
    • PROCESSING_STATUS
    • QA_SELECTED
    • QA_VERF_SELECT
    • SAT_ACADEMIC_PRG
    • SFA_REVIEW_STATUS
    • VERIFICATION_STATUS
    • VERIF_STATUS_CODE
  • STDNT_AWARDS (SCCPU_STAWD_BND)
    • LOCK_AWARD_FLAG
    • SFA_EA_INDICATOR
  • STDNT_CAREER (SCCPU_STDCR_BND)
    • SAA_SYNCHRONIZE
  • STDNT_CAR_TERM (SCCPU_CARTM_BND)
    • COUNTRY
    • ELIG_TO_ENROLL
    • EXT_ORG_ID
    • FORM_OF_STUDY
    • OVRD_BILL_UNITS
    • OVRD_INIT_ADD_FEE
    • OVRD_INIT_ENR_FEE
    • OVRD_TUIT_GROUP
    • PROJ_BILL_UNT
    • STUDY_AGREEMENT
    • TUIT_CALC_REQ
  • STDNT_EQUTN_VAR (SCCPU_EQUTN_BND)
    • VARIABLE_CHAR1-10
    • VARIABLE_FLAG1-10
    • VARIABLE_NUM1-10
  • STDNT_FA_TERM (SCCPU_FATRM_BND)
    • BUDGET_REQUIRED
    • FA_STATS_CALC_REQ
  • STDNT_PKG_VAR (SCCPU_STDNT_BND)
    • RATING_CMP1-20
    • RATING_CMP_VALUE1-20
    • VARIABLE_CHAR1-10
    • VARIABLE_FLAG1-10
    • VARIABLE_NUM1-10

Process in pictures
(click for full size)

Good luck with Pop Update.

Leave a Reply

Your email address will not be published. Required fields are marked *