JOB NAME:   TEEW$

JOB TITLE:       ACH PRENOTIFICATION FILE CREATE

DESCRIPTION:
This job creates the prenotes for accounts that have been set up as automated clearinghouse (ACH) transactions. It creates the file that is transferred to the bank for electronic transmittal of  transactions.

INPUT:
SIS database

CONTROL PARAMETERS:

    Title:   ACH Prenotification control record

    Example:
 
SIPR538 B1 020612 024 017 *, , , , , , , , , ,UPDATE=Y
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 
POSITION FIELD VALUE
 01 07  PROGRAM ID  'SIPR538'  Required.
 08 08  DELIMITER  Space or comma (,)
 09 10  AU  Academic unit adding ACH prenotes.  Required.
Must be valid academic unit.
 11 11  DELIMITER  Space or comma (,)
 12 17  EFFECTIVE DATE Effective date for ACH prenotes.  Required.
Format: YYMMDD. 
Must be one (1) working day future of the run date for the job.
 18 18  DELIMITER  Space or comma (,)
 19 21  YEAR/TERM  Year and term of ACH prenotes.  Required.
Must be numeric.
Format YYT   e.g., 024
 22 22  DELIMITER  Space or comma (,)
 23 25  THRU TERM  This term is used to determine enrollment in prior terms.   Required.
This should be two (2) terms earlier than YEAR/TERM.
 26 26  DELIMITER  Space or comma (,)
 27 46  EXTERNAL INDICATORS  External indicators to have ACH prenotes added.  Up to ten (10) external indicators may be specified.  Separate externals with a comma (,).  e.g., *, W,X,Y,Z. 
Use an asterisk (*) to denote an external indicator of space. 
 47 53  FIELD LABEL UPDATE= 
 54 54  UPDATE SWITCH  Option specifying whether to update the SIS database.  Required.
Y=update the SIS database
N=No , do not update SIS database (SIRE083-ACH records). Output file still created.

    Title:   ACH Prenotification Bank record
                 Note: This record is specified by the receiving bank and is added as the first record on the file.  It will need to change if the University changes banking institutions.  All fields except ACH CAMPUS are literals provided by the receiving bank.  UMS will provide this control record with cooperation from the University Treasurer's office and the receiving bank.

    Example:
 
$$ADD ID=UOCUSER1 BID='NWFACH08460005          '
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 
POSITION FIELD VALUE
 01  05  RECORD TYPE  $$ADD
 06  06  DELIMITER  Space 
 07  17  TRANSACTION ID  ID=UOCUSER1
 18  18  DELIMITER  Space 
 19  23  FIELD LABEL  BID='NWFACH
 24  29  TRANSACTION LABEL NWFACH
 30  30  ACH CAMPUS Numeric identifier for the campus as provided by the receiving bank.  Values:
0=UCB, 2=UCHSC, 3=UCD, 4=UCCS
 31  47  ACCOUNT   Account number provided by the receiving bank.
Value=8460005
 48  48  QUOTE Closing single quotation mark (')

REPORT INFO:
None

OTHER OUTPUT:
Backup tape of Prenote transactions (SIS.ACH.TRANS.BKUP.&CAMPUS )
Prenote file to be appended to by job TEID$ and then transmitted to the bank by job TEAWF (SIS.ACH.TRANS1.&CAMPUS)

NOTES:
If the TRANS1 file is deleted, restore with the backup tape in job TEAV.