Delivered Application Diagnostic Campus Solutions Plug-Ins

These tables list the diagnostic plug-ins delivered by product.

Academic Advisement

Plug-In Name and Description	Required Parameters	Provides a diagnosis of...
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

Plug-In Name and Description

Required Parameters

Provides a diagnosis of...

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

Campus Community

Plug-In Name and Description	Required Parameters	Provides a diagnosis of...
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.

Plug-In Name and Description

Required Parameters

Provides a diagnosis of...

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.

Financial Aid

Plug-In Name and Description	Required Parameters	Provides a diagnosis of...
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.

Plug-In Name and Description

Required Parameters

Provides a diagnosis of...

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.

Student Financials

Plug-In Name and Description	Additional Parameters	Provides a diagnosis of...
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.