Statuses Download (Bulk) (SREGL-9)

This file will download data according to the user input criteria and from data created on {SREGL-2}. On {BATCH-7} the user needs to create a directory whereto the file needs to be downloaded for 'System - FILED', 'Function - EXCD' and 'Suffix - .csv'.
Parameter 1 on {USERS-1b3} give an indication of what sub-systems data will be downloaded e.g. 'I' - Student, 'B' - Bursary {FBLMR1-14} and from {FSAO-38} the parameter will be 'F' - Finance.

Please take note: The process to upload / download files are the following:

Change the Parameter 1 indicator to 'I'.
Setup the directory on {BATCH-7}.
Run {SREGL-9} to download the .csv file. The file will be downloaded to the server to the specified directory as defined on {BATCH-7} for the subsystem specified on {USERS-1b3} in the Parameter 1 field.
Run {SREGL-12} to download the file from the server.
Open the .csv file and change the relevant 'Status Codes'. Save the document under a new name on the same directory as the downloaded file.
Run {SREGL-11} to upload the file back on the server
Run {SREGL-10} - This program will insert the new status records for the student(s).

Prompt Text ^{* an item between square brackets [ ] is the default answer}	Type & Length	Comments
Enter the Output File Name	A80	Create a user defined 'Output File' as in the example below. The users to take note that the 'Output File Name' must not contain .csv
Enter Start Student Number	N9	Enter the 'Start Student Number'.
Enter End Student Number	N9	Enter the 'End Student Number'.
Enter Start Date (DD-MON-YYYY)	DD-MON-YYYY	Enter the 'Start Date'.
Enter End Date (DD-MON-YYYY)	DD-MON-YYYY	Enter the 'End Date'.
Enter Include Null End Dates (Y / N)	A1	The user to indicate whether data for students with a 'Null End Date' must be included or excluded.
Enter select on (S)tatuses or (A)ctions Codes	A1	User to insert either (S) or (A).
When the selection is (A)ctions the following prompt will display: Enter Action Code or ALL	A3	Insert a specific 'Action Code' or select ALL 'Action Codes'. This will then be the end of the batch prompts.
When the selection is (S)tatuses the following prompts will display:
Enter Status Code Selection (A)ll / (R)ange / (S)elective	A1	User to enter either (A), (R) or (S).
When the selection is (R)ange the following prompts will display: Enter Start Financial Status	A4	Enter the 'Start Financial Status'
Enter End Financial Status	A4	Enter the 'End Financial Status'
When the selection is (S)elective the following prompts will display: Enter Financial Status or Press <ENTER> to Continue:	A4	The user will be allowed to enter up to 10 Financial Status Codes.
Enter Action Code or (ALL)	A3	Enter a spesific 'Action Code' or ALL.

Sort Order	Per	Comments
	User selection.

Example:

Output:

Example: .csv

Processing Rules
	No special processing rules.

History of Changes

Date	System Version	By Whom	Job	Description
18-Sep-2019	v04.1.0.0	Magda van der Westhuizen	T237748	New manual.
20-Nov-2019	v04.1.0.1	Magda van der Westhuizen	T240756	Insert additional information regarding the download / upload process.
27-Jan-2020	v04.1.0.2	Magda van der Westhuizen	T241379	Add more images.
29-Mar-2020	v04.1.0.4	Magda van der Westhuizen	T243634	Remove 'Financial' out of the heading of the manual.