National Student Clearinghouse Reporting

Summary

Label

Description

Label

Description

Business Process

National Student Clearinghouse reporting

Module

Student Records, Financial Aid

Description

This tutorial goes over the steps required to submit the NSC report.  File are to be sent to IT to be transmitted to NSC.



Configuration:

Instructions

Instructions

1

Setup NSC Branch Table Configuration 

Navigate to Main Menu > Setup SACR > Product Related > Student Records > Enrollment Reporting Codes > NSC Branch Table

One branch needs to be created by college:

  • 10 = City

  • 20 = Mesa

  • 30 = Miramar

This is required in order to only pull students for that enrollment file.  This only needs to be setup once.

2

Define Statistics Type

Records and Enrollment > Enrollment Reporting > Consolidated Statistics > Define Statistics Type

Instructions:

Instructions

Instructions

1

First step is to define the statistics period.  This will need to be done for each submission to NSC.

Records and Enrollment > Enrollment Reporting > Consolidated Statistics > Define Statistics Period

Set the Trigger to be Consolidation Date and use the “As of Date” to be the run date (typically the day you run the report). 

The snapshot date is the same as the "As of Date"

Select only the careers which will be sent in this period’s report. SDCCD will send 3 branch reports each will be its own unique period.

2

Process Consolidated Statistics:

Records and Enrollment > Enrollment Reporting > Consolidated Statistics > Process Consolidated Stats

Process the Consolidated Statistics – the first run for a term set like above. All runs should be like: *Changed this setting to Consolidation Mode of Overwrite.  – subsequent runs, will need to have the Prev Stats NSC period from the last run for this term indicated so status changes will be indicated.

3

Run – Take Term Snapshot first when complete then

Select SRPCCONA   COBOL SQL process

4

Run Consolidated Statistics process.

Records and Enrollment > Enrollment Reporting > Consolidated Statistics > Process Consolidated Stats

Select SRPCCONP   COBOL SQL process

STDNT_CONS_STAT Record will be populated.

5

Run the report – Always use the Standard Report (except when sending graduating students records). Degree Verify is NOT a delivered process to NSC.

Records and Enrollment > Enrollment Reporting > NSC Report

  • Enter in the following:

    • Address = MAIL_HOME

    • FICE Code = 001273

    • Output file: /psft/cust/cs/CSPRD/outbound/student_records/nsc/NSC

Hit Run use the second custom process:

6

FTP to clearinghouse.

Run the below query to see the results generated for each campus.

Query
Select Count(Distinct A.Emplid), A.Acad_Stats_Period, A.Acad_Career, A.Strm, A.Campus From Ps_Stdnt_Cons_Stat A Group By A.Acad_Stats_Period, A.Acad_Career, A.Strm, A.Campus