National Student Clearinghouse Reporting
Summary
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 | |
---|---|
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:
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 | |
---|---|
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
Hit Run use the second custom process: |
6 | FTP to clearinghouse. Run the below query to see the results generated for each campus. QuerySelect 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 |