Delivered Application Diagnostic Campus Solutions Plug-Ins

SAA_STUDENT_INFO: retrieves all data used to process a DPR for a student.

An employee ID is a required parameter for the diagnostic tool to return valid information.

The SAA_STUDENT_INFO application package retrieves the requirement terms from ACAD_PROG, ACAD_PLAN, and ACAD_SUBPLAN records for a student. It also retrieves the following current records for a student:

• ACAD_PROG

• ACAD_PLAN

• ACAD_SUBPLAN

• STDNT_ENRL

• TRNS_EXTR_VW

• TEST_EXTR_VW

• OTHR_EXTR_VW

The application package retrieves the following appropriate records for a student:

• RG_GRP_TBL

• RQ_GRP_DETL_TBL

• RQ_MAIN_TBL

• RQ_LINE_TBL

• RQ_LN_DETL_TBL

• CLST_MAIN_TBL

• CLST_DETL_TBL

SCC_EMPLID_VALIDATN: retrieves all data needed to investigate problems creating a new emplid.

None

• Selects MAX Emplid from PERS_DATA_EFFDT.

• Selects EMPLID_LAST_EMPL from INSTALLATION.

• Counts number of records in PERS_DATA_EFFDT with EMPLID of "NEW".

SCC_SEVIS_REG_EVENT: retrieves all data needed to investigate problems when registration events don't trigger for SEVIS students.

The following parameters are required for the diagnostic tool to return valid information:

• EmplID of Student.

• SEVIS School ID.

• OprID from Batch Submission.

• Run Control ID from Batch Submission.

• Queries I20_FORM to verify a records exists and displays "Y" if the value of SEV_FUNDING_VERIFY is "Y".

• Queries SEV_MST_ADDR to verify no inactive records for the student.

• Queries SEV_MST_ADDR to verify no inactive records for the student.

• Queries SEV_MST_REG to verify no inactive records for the student.

• Verifies a valid row exists in RUNCTL_CCSEVCMP.

• Verifies ASOF_DATE in RUNCTL_CCCMPTRM is less than today's date.

• Verifies student has a record in SEV_MST_REG matching the term value in RUNCTL_CCCMPTRM.

• Verifies student has a record in STDNT_CAR_TERM matching the term value in RUNCTL_CCCMPTRM.

• Verifies student has a record in STDNT_ENRL matching the term value in RUNCTL_CCCMPTRM.

SFA_FA_TERM: retrieves all data needed to investigate problems creating new FA-Term records.

These are the parameters required for the diagnostic tool to return valid information.

• Emplid of Student

• Institution

• Student Career

• Term

• Aid Year

• Oprid

• Queries against STDNT_CAR_TERM to get FA flags from that record.

• Queries against STDNT_CAR_TERM to get FA flags from that record.

• Student's aid year activation.

• FA Term setup for aid year/career. Queries FATRMP_CAR_TRM to verify the term is defined.

• Gets values from FA Term Drivers Setup. Queries RUN_CTL_FATDVRS for values.

• Student's admissions and records activation and effective date. Queries STUDENT_AID to verify correct record exists.

• Expected student's grad term. Queries ADM_APPL_PROG and ACAD_PROG for the student.

• Gets Session Code, Session Code Census Date, FA Term Census Date and FA Term Locked flag.

• SESSION_CODE and CENSUS_DT from SESSION_TBL, FA_CENSUS_DATE and LOCK_FATERM from FATRMP_CAR_TRM.

• Displays FA_ELIGIBILITY and FA_STATS_CALC_REQ for all records in STDNT_CAR_TERM for the student.

• Displays all records in STDNT_FATU_DRV for the student.

SFA_PKG_DATA: retrieves all data needed to investigate problems creating FA packaging records.

These are the parameters required for the diagnostic tool to return valid information:

• Emplid of Student

• Institution

• Student Career

• Term

• Aid Year

• Oprid

• Batch Sequence Number

• Data in PKG_BATCH_AWD, PKG_BATCH_DISB, STDNT_AWD_PKG, STDNT_PKG_DISB, STDNT_AWARDS, STDNT_AWRD_DISB.

• Queries against PKG_BATCH_AWD, PKG_BATCH_DISB, STDNT_AWD_PKG, STDNT_PKG_DISB, STDNT_AWARDS, STDNT_AWRD_DISB for the student.

• Temp packaging tables matching data in actual packaging tables.

SFA_PKG_DATA: retrieves all data needed to investigate problems creating FA packaging records. Continued.

• Data in DISB_SPLIT_CD, DISB_ID_SPLIT, DISB_PLAN_TBL, and DISB_ID_TBL. Queries against these tables for codes used when processing the student.

• Data in STDNT_AGGR_LIFE and STDNT_AGGR_SCHL. Display totals from SFA_AGGR_BALANCE and EXPECTED_AWARD.

SSF_PAYMENT: retrieves all data needed to investigate problems with posting payments in Student Financials.

• Business Unit

• Emplid of Student

• Item Number

• Payment ID Number

• Queries against PS_PAYMENTS_TBL to display the CHARGE_PRIORITY and STRM.

• Queries against ITEM_SF to get the item term for the charge.

• Queries against Charge Priority Tree to retrieve the SETID, TREE NAME, and TREE NODE for the charge priority.

• Queries against the PMT_CHRG_PRIOR and PMT_CHRG_TBL to get the nodes in the charge priority list.

• Queries against the PMT_CHRG_PRIOR and PMT_CHRG_TBL to get the pay future term, pay prior term, and pay future year flags.

• Queries against ITEM_SF to retrieve a payment's unpaid balance.

• Queries against ITEM_SF to retrieve a charge's unpaid balance.

SSF_REFUNDING: retrieves all data needed to investigate problems with refunding a charge.

• Business Unit

• Emplid of Student

• Item Number

• Payment ID Number

• Queries against ITEM_SF to get the item's outstanding balance, EFFDT, number of days encumbered, earning code if a refund, type of payment if a refund.

• Queries against the setup table to determine the maximum and minimum refund amount, determine if debit balances are allowed to be refunded, determine if item type is marked as refundable and if a paygroup is associated with it.

• Queries POSTED_DATE, PAYMENT_METHOD from PAYMENT_TBL to determine the posted date and if it is a credit card transaction.

• Queries ACCOUNT_BALANCE from ACCOUNT_TOT_VW for the student's overall balance.