Navigation: Reporting Tools > Query > Query Viewer

The following queries can be used to identify data that may cause NSC reporting errors. Review these queries prior to generating an NSC report and, if necessary, correct data errors. Regularly reviewing QARS Reports and correcting QARS errors will also reduce NSC reporting errors.

In addition to reviewing results from the queries listed above, consider running the Term Withdrawal process before beginning the NSC reporting process. This is to ensure that students who have withdrawn from all classes are correctly reported to NSC and do not “disappear” from the NSC report.

Finally, be sure that the Waitlist Purge process has been run before the Census Date! The waitlist must be purged every term after the waitlist process finishes running and before the Census date. Failure to purge the waitlist will increase the reported enrollment load for waitlisted students.

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

1. The Define Statistics Period search page displays.
2. Using Find Existing Value or Add a New Value, enter the Academic Institution and Academic Statistics Period. New statistics periods must be defined for each NSC report and should not be reused for multiple NSC reports.  It is recommended to use a naming convention that is term specific, for example:
   • 2163_1 (Early Enrollment)
   • 2163_2 (10th Day of the Term/ First of Term report)
   • 2163_3 (Mid Quarter/ Subsequent of Term report)
   • 2163_4 (End of Term Subsequent of Term report)

3. For each new Academic Statistics Period, enter the following information, then Save.
   • Description: Use a detailed description to easily tell the difference between different academic statistics periods.
   • Statistics Period Type: NS (NSC Reporting Type).
   • Academic Load Rule: Term Load Rule Applies.
   • Consolidation Trigger: Consolidation Date.
   • As of Date: Records that are effective as of the As of Date will be included in the NSC report calculations. Generally, the As of Date is the date that the report is being generated ("today's date"). For End of Term reports, set this date to the last day of the term.
   • Aid Year: This is the Financial Aid Year that the reported term takes place in.
   • Academic Career: UGRD.
   • Term: The current term.
   • Snapshot Date: The snapshot date looks at the student's status on that date during the reported term. The snapshot date should be before or equal to the As of Date and cannot be before the term start date or after the term end date. For most reports, the snapshot date will be the date the report is being generated (generally, "today's date"). When generating an End of Term report, the snapshot date should be set to the last day of the term.

Navigation: Records and Enrollment > Enrollment Reporting > Consolidated Statistics > Process Consolidate Statistics

1. The Consolidate Statistics run control ID search page displays.
2. Select the Add a New Value tab.
3. Enter Run Control ID. It is advised to use a new run control ID for each Academic Statistics Period. Consider using a descriptive naming convention that references the Academic Statistics Period to make it easier to review the number of run control IDs that will be created over time.
4. Select Add.
5. The Consolidated Statistics page displays.

6. At the top of the page, enter the following information:
   • Academic Institution
   • Academic Statistics Period: Enter the current Academic Statistics Period defined in the previous steps.
   • Prev Stats NSC: For the first report of the term, leave this field blank. For subsequent reports, enter the previously reported Academic Statistics Period.
   • Consolidation Mode: For the first report of the term, use a Consolidation Mode of "Insert." For subsequent reports, use "Overwrite."
   • Commit Frequency: Set this value to 300 for faster processing. If left as 1, the process will take several hours to run to completion.
7. In the NSC Options section, enter the following information according to your institution's local business process:
   • Enrollment Status Date Options: There are two Enrollment Status Date Options:
     • Use Term Begin Date or Academic Load Change Date (Legacy): This is the default selection and the selection that will be in Production for each college when Image 29 is installed. As long as this is selected, there will be no changes to the way that the enrollment status date is calculated. (Note: "Legacy" does not refer to the pre-ctcLink Legacy HP-UX system. In this case, "Legacy" refers to the NSC processing logic used by PeopleSoft prior to Image 29.)
     • Use the Date the Enrollment Status was Determined: This selection activates the new NSC processing logic. When selected, the Terms with Missing Enrollment Status Data table becomes available. Term categories listed in this table are ignored by the Consolidate Academic Statistics process when there is no enrollment status. For example, listing "Summer" term categories will cause the NSC reporting process to ignore all terms with a Term Category value of "Summer Term," allowing for students who do not enroll in summer terms to be reported without a break in enrollment.
       • Term Categories are configured on the Term/ Session Table (Set Up SACR > Foundation Tables > Term Setup > Term Session Table). Starting with Summer 2245, Summer terms have a Term Category value of "Summer Term."
   • Student with Multiple Plans on Same CIP Code Keys: If the Consolidate by NSC Five-Point Match Criteria checkbox is selected, all program/ plan stacks that share the same Five Point Match criteria (CIP Code, credential level, program length, program length unit, program weeks in Title IV academic year) will be reported as one program. This box should generally be left unchecked.
   • Leave of Absence Option: Options in this section control how the Program Start Date is reported for students who return from a leave of absence (have a program/ plan stack with an "RLOA" row). Select the value that complies with your institution's Leave of Absence policy.
     • Use Return from LOA Date: The student's RLOA date will be used as the program start date. This is the default selection and matches the pre-Image 29 report logic.
     • Use Active Program Start Date: The program start date will match the start date of the program/ plan stack.
     • If Return Within % Days: This field is required when Use Active Program Start Date is selected. If the student returns from a leave of absence within the number of days specified in this field, the process will report the student's current active program/plan stack start date as the program start date. "9999" can be entered into this field if the start date of the program/ plan stack should always be reported as the program start date.
8. In the Student Career Term Snapshot Input Parameters section, enter the following information:
   • Academic Career: UGRD.
   • Term: The term being reported.
   • Overwrite: If checked, the Take Term, Statistics Snapshot process will delete and replace all data rows from the temporary holding table for students that have data for the academic career, term, and snapshot date combination. Check this box if the Take Term Statistics Snapshot process needs to be rerun; otherwise, leave this box blank.
9. There are two Consolidated Statistics processes that need to be run.
   • First, run the Take Term Statistics Snapshot (SRPCCONA) process. Click Run, select the Take Term Statistics Snapshot (SRPCCONA) checkbox, then click OK. Click the Process Monitor button to return to the Process Monitor. Use the Refresh button to refresh the Process Monitor and see the status of the Take Term Statistics Snapshot process. Wait until the Take Term Statistics Snapshot process runs to completion (Success, Posted) before moving to the next step.
   • After the Take Term Statistics Snapshot process has run to completion, run the Consolidate Acad Statistics (SRPCCONP) process. Click Run, select the checkbox next to Consolidate Acad Statistics (SRPCCONP), then click OK. Click the Process Monitor button to return to the Process Monitor and use the Refresh button to refresh the Process Monitor and see the status of the Consolidate Acad Statistics process. Wait until the Consolidate Acad Statistics process runs to completion (Success, Posted) before moving to the next step.

Navigation: Records and Enrollment > Enrollment Reporting > Consolidated Statistics > Student Consolidated Stats

Navigation: Records and Enrollment > Enrollment Reporting > NSC Report

1. The NSC Report run control ID search page displays.
2. Select the Add a New Value tab.
3. Enter Run Control ID.
4. Select Add.
5. The NSC Report page displays.

6. Enter the following information:
   • Academic Institution
   • Academic Statistics Period
   • Brand Code: 00
   • Report Type: Use “Standard Report” for Fall, Winter, and Spring terms. Use “Non-Standard Report” for Summer terms. Use “Graduates Only” to generate a file containing only graduated students.
   • Address Usage: S_POSTAL
   • FICE Code: College FICE codes autopopulate from the FICE code listed on the Academic Institution page. This value can be overwritten if needed.
   • Output File: Output files begin with /CSTRANSFER/WAXXX/NSC/, with “XXX” replaced by an institution code (i.e., WA220, WA180). Use a descriptive file name ending in .csv (i.e.,/CSTRANSFER/WA130/NSC/2237_2.csv).
7. Click Run, make sure that the NSC (SRNSLCEX) checkbox is selected, then click OK. Return to the Process Monitor and refresh the page until the process runs to Success/ Posted.

Navigation: PeopleTools > CTC Custom > Extensions > Upload/Download Files

Generally, a blank NSC file is the result of selecting the wrong Statistics Period Type on the Define Statistics Period page. Review your Statistics Period set up and your process run control IDs and update any incorrect values, if needed. Re-run the Consolidate Academic Statistics processes and re-generate the NSC Report.

Make sure that the NSC Report process has run to completion. In addition, review the File Name. File names are case sensitive and must exactly match the file name entered on the NSC Report page. Make sure that there are no spaces entered before or after the file name in the File Name field.

NSC files are uploaded through a secure FTP portal. Visit the National Student Clearinghouse website and log in to your institution’s FTP portal page. If you need assistance, contact your institution’s NSC representative.

Level 99/ Non-Credential Programs require a special setup that differs from other programs. Review the Reporting Academic Plan as a COD Level 99 (Non-Credential) Program QRG for more information on how to correctly report these programs.

Review the Running the NSC Degree Verify File QRG for more information.

If a withdrawn student is missing from the NSC Report, it likely means that the Term Withdrawal process has not been run. The Term Withdrawal process should be run regularly throughout the term for both Financial Aid purposes and to ensure that withdrawn students are promptly reported to NSC. Consider running the Term Withdrawal process shortly before starting the process of creating each NSC report.

Assuming that no changes have been made to the student’s Student Consolidated Stats page, it’s likely that the Waitlist Purge process has not been run. The waitlist must be purged every term after the waitlist process finishes running and before the Census date. Failure to purge the waitlist will increase the reported enrollment load for waitlisted students.

SBCTC does not oversee the NSC reporting process, does not provide instruction or guidance on how to report to NSC, and does not assist in resolving NSC or NSLDS errors. Refer to the help documents listed on the National Student Clearinghouse website, visit NSC’s Compliance Central, or contact your institution’s NSC representative.

You may also review the NSLDS Reporting Guide for official reporting requirements or take a look at the NSC Enrollment Reporting Guide for more information about what kinds of data must be reported to the NSC. Finally, check out Oracle’s “Understanding Consolidate Academic Statistics Process Calculations” document for more in-depth information about where the NSC Report gets its data.

Back to Top