EDULOG Student Data Download and Update

1. In CICS go to the FACILITIES AND TRANSPORTATION MENU.
Press the F11 key to enter the Online Job Submit screen.

SCHOOL BOARD OF ALACHUA COUNTY 07/27/98 Batch Job Submit Selection 16:35:56

Edulog Student Download FEE001J Edulog Street/Address Reports FEE005J SELECTION===>
Please enter the number of the report needed
PF: 1=HELP 3=END 7=PREV 8=NEXT 12=FS01 FSL011

2.    Run FEE001J to extract records from the mainframe student database in EDULOG format.
        Select download type for complete or changes only.

3.    Wait until the download reports start on the transportation printer before continuing with the next step.
        (Approx. 15minutes).

4. If you have logged on to EDULOG go to step 7.

5. Click on the EDULOG icon.

6. Logon with your server userid and password.

7. At the /D/PRO/your userid prompt type RUN SETUP and logon with your EDULOG userid and password.

8. Select SYSTEMS MAINTENANCE from the menu options.

9. Prepare printer for Student Count report.

Press STOP on printer.
Press ORIENTATION to set printer to landscape.
Press START.
Press BUFFER.

10. Run CNTSTU.

Select 1 for regular students.
Answer y to sort by school code.
Select 1 for computed eligibility.
Enter 4 for number of eligibility codes.
Print to local printer.

11.   Copy the 3 current data files to allow for recovery.
            At the /PRO/your userid prompt use lower case and enter the word copyfiles.
            The display indicates when each file is completed.
            A message will display when copies are completed.

12. Type RUN SETUP

13. Run STUKRM in SYSTEMS MAINTENANCE.

14. Run UPSTU.

Do you wish to permanently modify the Student Data ……………………….. y.
Should Students with the UPSTU exclusion flag set appear in error listing ...…. n.
Process deletions for student records with UPSTU exclusion flag set …….….. n.
Enter Starting record number …………………………………………….…. 1.
Should Special Ed Student change records be ignored ……………………..... n.
Send listing to screen.

15. Run STUPRG in SYSTEMS MAINTENANCE.
Press F3 to purge records marked for deletion in UPSTU.

16. Run STUKRM.
Press ENTER to use the default file.

17. Run ADDUPD.

Do you want to read from a file …. y.
File is STA:ADDUPD.LST.
Data begins on line …….......…… 1.
Do you want audit list ….........….. n.
Do you want to modify …........…. y.

18. Run PSTSTU.
When prompted DAT must be keyed for file extension.

19. Prepare printer for error reports.

Press STOP on printer.
Make sure paper tray is loaded.
Press ORIENTATION to set printer to portrait.
Press START.
Press BUFFER.

20.   Run TYPUPD.
        ( If new schools have been entered or grade level changes have been made to the TYPE.NEW file,
            run TYPBLD at DOS prompt before this step).

File is TYPE.NEW.
Print to local line printer.

21. Run STUKRM.

22. Run ADSCAN.

Do you want to process …………………….………. 1 (All students).
Do you wish to process matches ……………..……… 2 (Exact matches only).
Do you wish to print an audit of changes ……....…….. n.
Do you wish to generate an error list …………..…….. y.
Do you want error list to go to ………………….…… Disk file no headings
Do you want to permanently modify student address .... y.
After the processed records stop displaying select DEFINE SORT.

1.	Pr	Street prefix (N S E W etc)
2.	Street	Street name
3.	Type	Street type (AVE BLVD etc)
4.	Sf	City code suffix (GV AL NB etc)

Select CONFIRM CHOICES.
Select FIND MATCHES.
After the sort is complete select DEFINE PRINT.

1.	Pr	Street prefix
2.	Street	Street name
3.	Type	Street type
4.	Sf	City code Suffix
5.	Res Address	PDB Residential Address field
6.	City
7.	First Name
8.	Last Name
9.	EDULOG Id	EDULOG student number
10.	Student Id	SBAC student number
11.	School

Select CONFIRM CHOICES.
When prompted for output filename enter TMP:ADSCAN.LST.
When report is complete and print definition screen is re-displayed press ESC.

23. In the GEOGRAPHIC MODULE select REPORTS.
Run STREET NAME LIST and create disk file TMP:STREET.LST.

24. In CICS press the F11 key to enter the Online Job Submit screen.
Run FEE005J to produce street name/address range error listings and new valid street name list.

SCHOOL BOARD OF ALACHUA COUNTY 07/27/98 Batch Job Submit Selection 16:35:56

Edulog Student Download FEE001J Edulog Street/Address Reports FEE005J SELECTION===>
Please enter the number of the report needed
PF: 1=HELP 3=END 7=PREV 8=NEXT 12=FS01 FSL011

25. Set printer back to landscape.

26. Run SHTSCH.

Do you wish to update ……. y.

25. Run BTHELG.