Working Group(s) | PPO(s) University Registrar Advisory Member(s) Associate Registrar IT Documentation & Training Specialist |
Platform(s) Utilized | CAMS, Microsoft Excel |
Role of Intended Viewer | ☒ Administrator ☐ Student ☐ General Staff ☐ Public User ☐ Faculty |
Effective Date & Next Review Date | Effective 11-20-2023 (November 20, 2023) Next Review 04-22-2024 (April 22, 2024) |
End Result
The purpose of this process is to showcase how members of the Registrar’s office is to import the data from CAMS, the current Student Information System (SIS), then fix any mistakes and verify it in Excel before sending to the report to the National Student Loan Clearinghouse (NSLC). This report is essential to accurate recordkeeping of student and alumni credentials, as well as following federal regulations we are inclined to meet as an accredited public university. Security access to the report is managed by a user’s Active Directory membership in the group, CAMSReports-RegistrarFunctions. Other members in this group will have more knowledge on any issues faced during this process.
Process
Step 1. Using the Microsoft Edge browser, login to CAMS with your credentials. Next, select the Registrar option on the menu. The next menu after that, you will select Registrar Functions and click on the item, ‘NSLC Report’. This should be what you see on your screen now.
...
Step 2. Click the ‘Term’dropdown and select the appropriate semester you wish to report on (We’ll use the Fall 2023 term [FA 2023] as an example). Next, click the ‘<Select a Value>’ dropdown and select the appropriate option (We’ll use Subsequent-of-Term as an example).
...
Step 5. Open File Explorer on your PC and go to your Downloads folder. Look for your most recently downloaded Excel file (ending in .xlsx) and open the NSLC Report in Microsoft Excel. Once it’s open, click on the first column, ‘Student ID’. Hold down Ctrl on your keyboard and press the A key twice. Your entire sheet is highlighted now. Input Ctrl + C to copy the data.
...
Step 9. Use this linked Excel file, NSLC Report Test, and the latest linked Enrollment Reporting Programming & Testing Guide to refine the new sheet you made with all the data you copied over. The Color-Coding Key in the Excel file is how you should edit the report you are editing. The next steps will help you make the right adjustments. Here is further elaboration on the highlighted columns:
_GREEN_ – Create a column where you see this color and name it with what is already shown in the NSLC Report Test. Use this button at the top of the screen to create new columns:
...
Column | X | Z | AB | AV | AW | AX | BS | BV |
Column Name | Birth Date | Term Begin Date | Term End Date | Pri Prog | NSLCClass Credit | NSLCClass Level | blank | blank |
Step 11. Once finished with erasing the data on Step 10, click on Row 1 on the left part of the screen and press Ctrl + G on your keyboard.
...
Step 19. Return to CAMS and run the Student Term Status Report to retrieve certificate students. Filter the results by Student Level of Certificates and Cohort Group of Internal Transfer. Create a new sheet on your NSLC Report File (see Step 6). Copy the certificate student data and paste the values on the new sheet you just made.
...
Utilize the VLOOKUP Tool to determine who the Certificate Studentsare. Once designated, use CAMS to enter the appropriate data in the Program 2 columns, which are seen in Step 19.
...
Step 29. Click File in the top left of your screen. Then, click Save As… or Save a Copy. Name your NSLC Report appropriately and change the file type to Text (Tab delimited) (*.txt). Then, save your file. Login to the National Student Clearinghouse and upload the file you just saved correctly.
...
Related Processes
Revision History
Version # (v. 1.1) | Amendment Date | Author | Cause |
1.1 | 11-21-2023 | William Bowden (IT Documentation & Training Specialist) | Publication |
1
I