CIS Job Documentation: Connect Card Processing

Connect Card - ISO Number Create

SYSTEM:
CONNECT CARD

JOB NAME:
BSC_FEED

PROCEDURE NAME AND LOCATION:
On BSCBANNER, within /u05/sct/banprod/scripts:

BSC_FEED.shl – parameter: BANP which runs

@IsoFile.sql – parameter: none. This creates a file (isofile.txt) of all records with SSN’s to be fed into the ISO database in order to obtain an ISO number.

PURPOSE:
This job will create the files that will be used to assign the ISO number to a student or staff and FTP the output to an ISO Number Generator application.

FREQUENCY AND TIMING:
This process is submitted by CRON evenings at 9:00PM.

PREREQUISITES/DEPENDENCIES:
None

OTHER RESOURCES:
None

REQUIRED INPUT:
‘YYYYTC’ where YYYY = current term year (changed annually) and TC = current Term Code (i.e. 10 or 90 – NO 50!!! Use 90 for summer).

OUTPUT:
File: //CCURE/MACSYS_D/CONNCARD/ISOFILE.TXT

SPECIAL INSTRUCTIONS:
The parameter Term Code needs to be changed at the beginning of each semester!

Connect Card - MAKEISOS ISO Generator

SYSTEM:
CONNECT CARD

SUBSYSTEM:
Server Interface

JOB NAME:
MAKEISOS.BAT

PROCEDURE NAME AND LOCATION:
//CCURE/MACSYS_D/ISO/BATFILES/MAKEISOS.BAT

PURPOSE:
This job will create the actual ISO Numbers that are assigned to both students and faculty here at the college. The job executes a Visual Basic program (MAKEISOS.EXE) that reads in a text file (ISODB.INI) to determine the path of the database, the workgroup file that stores the passwords, and the import and export files. The output is to the ISO_TBL in the database as well as to a messages.log file and an error.log file.

FREQUENCY AND TIMING:
This process is submitted by the NT Scheduler evenings at 9:15PM.
It is run daily (with or without input) or on an ADHOC basis.

PREREQUISITES/DEPENDENCIES:
This process requires file input from BSC_FEED.shl otherwise an error message will be
generated in the error log: NO INPUT FILE.

OTHER RESOURCES:
//CCURE/MACSYS_D/ISO/MAKEISOS.EXE
//CCURE/MACSYS_D/ISO/ISODB.INI

REQUIRED INPUT:
//CCURE/MACSYS_D/CONNCARD/ISOFILE.TXT

INPUT FORMATS:
Not Applicable

OUTPUT:
File: //CCURE/MACSYS_D/CONNCARD/USERIDSO.TXT //CCURE/MACSYS_D/CONNCARD/ISOFILE.TXT.OLD

Report: None

Log Files: //CCURE/MACSYS_D/ISO/MESSAGES.LOG //CCURESVR/MACSYS_D/ISO/ERROR.LOG

RELOAD/NORELOAD:
Not Applicable.

SPECIAL INSTRUCTIONS:
None.

Connect Card - ISO Number Update

SYSTEM:
CONNECT CARD

JOB NAME:
BSC_FEED_ISO

PROCEDURE NAME AND LOCATION:
On BSCBANNER, within /u05/sct/banprod/scripts:

BSC_FEED_ISO.shl – parameter: BANP which runs

@BSC_FEED_5.sql – parameter: none.

PURPOSE:
This updates the BSC_FEED_TBL with the ISO numbers.

FREQUENCY AND TIMING:
This process is submitted by CRON evenings at 9:30PM.

PREREQUISITES/DEPENDENCIES:
This process requires BSC_FEED.shl and MAKEISOS.exe be run first.

OTHER RESOURCES:
None

REQUIRED INPUT:
None

OUTPUT:
None

SPECIAL INSTRUCTIONS:
None

Connect Card - Create Bio

SYSTEM:
Connect Card

SUBSYSTEM:
Mainframe Interface

JOB NAME:
BSC_CONCBIO_CREATE

PROCEDURE NAME AND LOCATION:
On BSCBANNER, within /u05/sct/banprod/scripts:

BSC_CONCBIO_CREATE.shl – parameter: BANP. Shell script to create the CONCBIO.txt file Monday night to be fed into the ISO database. Runs the following SQL scripts:

  • @IsoFile2.sql – parameter: none. This creates a file (concbio.txt) that is used to update records in CCURE.

PURPOSE:
This process will FTP the file created to be further processed. Data is extracted to create an input file CONCBIO.TXT that is accepted by CCure and Envision

FREQUENCY AND TIMING:
This process is submitted by CRON every Monday at 9:45 PM. It is run daily or on an ADHOC basis.

PREREQUISITES/DEPENDENCIES:
This process requires BSC_FEED.shl, MAKEISOS.exe, and BSC_FEED_ISO to be run first.

OTHER RESOURCES:
See above

REQUIRED INPUT:
None

OUTPUT:
//CCURE/MACSYS_D/CONNCARD/CONCBIO.TXT

SPECIAL INSTRUCTIONS:
None

Connect Card - CONNECTU Access Update

SYSTEM:
CONNECT CARD

SUBSYSTEM:
Server Interface

JOB NAME:
CONNECTU.BAT

PROCEDURE NAME AND LOCATION:
//CCURE/MACSYS_D/ISO/BATFILES/CONNECTU.BAT

PURPOSE:
This job will take input from the previous steps and update the information in a Microsoft Access database. The job executes a Visual Basic program (CONNECTU.EXE) that reads in a text file (ISODB.INI) to determine the path of the database, the workgroup file that stores the passwords, and the import and export files. The output is to the CONCBIO_TBL in the database as well as to a messages.log file and an error.log file.

FREQUENCY AND TIMING:
This process is submitted by the NT Scheduler nightly at 10:00PM.
It is run daily (with or without input) or on an ADHOC basis.

PREREQUISITES/DEPENDENCIES:
This process requires file input from BSC_FEED.shl, otherwise an error message will be generated in the error log: NO INPUT FILE. This process requires BSC_FEED.shl, MAKEISOS.exe, and BSC_FEED_ISO need to be run first.

OTHER RESOURCES:
//CCURE/MACSYS_D/ISO/CONNECTU.EXE
//CCURE/MACSYS_D/ISO/ISODB.INI

REQUIRED INPUT:
//CCURE/MACSYS_D/CONNCARD/CONCBIO.TXT

INPUT FORMATS:
Not Applicable

OUTPUT:

  • File:
  • //CCURE/MACSYS_D/CONNCARD/CONCBIO.TXT.OLD
  • Report:
  • None
  • Log Files:
  • //CCURE/MACSYS_D/ISO/MESSAGES.LOG
  • //CCURE/MACSYS_D/ISO/ERROR.LOG

SPECIAL INSTRUCTIONS:
None