ZFRNOTE Creates an NACHA Pre-Note File

ZFRNOTE – Creates an NACHA Pre-Note File

ZFRNOTE is a job-submission process that generates a NACHA Pre-Note ACH check file. All dollar values for this ACH file are zero. It additionally provides the capability to flip all Pre-Noted students to an Active Status and also provides the capability to flip all Active Students to a Pre-Noted status. You may optionally work with a group of students, either by the term or by a selected population selection.

All students who are categorized as ‘Pre-Note’ recipients in GXADIRD will be reported in the NACHA Pre-Note file. It is important to understand that if Parameter 05 is set to Y, students who are in an Active Status will first be set to Pre-Note before any other processing is done.

ZFRNOTE Parameter Values

01 Check Date

Enter today’s date in a 01-JAN-2099 format.

02 Term

Enter the term code. All students in a given term (TSAAREV) will be considered.

03 – 06 Population Selection

Enter the Selection ID, Application, Creator and User. All students in the given population selection will be considered.

Note: If Term and Population Selection parameters are blank, all students with Banner will be considered.

07 Create Output File (Y/N)

When Y is entered, a /u02/jobsub/tmp/pachxxxxxxyyyyy file is created, and a report is generated. When N is entered, only the report is generated.

08 Bank Code

Enter the two-character Bank Code (usually 01 is Hope and 02 is PELL). See GXABANK for your Bank Code.

09 Flip Pre-notes to Active (Y/N)

Enter Y to flip all pre-noted students to Active. This will allow each student (either in the Banner system, the term or population selection) to be pre-noted. Once all students have been flipped to Y, all students must be flipped to Active before any ACH transactions will be generated.

10 Flip Actives to Pre-Notes (Y/N)

Enter Y to flip all Active Students to a Pre-Note Status. If this value is Y, all students (within Banner, the term or the population selection) will first be flipped to Pre-Note.

11 Enter Lines Per Page

Enter 55 as the default. Any value can be used in accordance with DATABASE.

ZFRNOTE Processing

If Parameter 5 is set to Y, all students in an Active Status will first be set to a Pre-Note status before any processing takes place. This parameter will allow for all students to be pre-noted.

ZFRNOTE Outputs

ZFRNOTE generates both a lis and log file. In the Update mode a /u02/jobsub/tmp/pachddddddtttt time is created (where dddddd is the date stamp and tttt is the time stamp). When generating the pach file, it is easier to use DATABASE so you can save the pach file to your desktop.

ACH PRE-NOTE CHECK REGISTER 21-JAN-2009

01/21/09 Victor Braddy 911135793 0.00

Grand Total ACH 0.00

The ACH FILE

101 06200569015899999990712211035A094101Regent Bank Tech School X

5220Tech School X DIRECT DEPOSIT 1589999999PPDREFUND CHK071221071221 1062005690000001

6231111111111212121212 0000000000911135793 Victor Braddy 0062005690120001

822000000100111111110000000000000000000000001589999999 062005690000001

9000001000001000000010011111111000000000000000000000000

999999999999999999999999999999999999999999999999999999999999999999999999999999999999

The Log file when no active Pre-note records are found

PARAMETER (1) = saisusr

PARAMETER (2) = XXXXXXXX

PARAMETER (3) = 76831

PARAMETER (4) = ZFRNOTE

Successfully Connected to Oracle in ZFRNOTE

NO ACTIVE PRE-NOTE RECORDS FOR THIS BANK CODE

CHECK PRE-NOTE INFO NOT PROCESSED

The Log file when a Pre-note file is created

PARAMETER (1) = saisusr

PARAMETER (2) = XXXXXXXX

PARAMETER (3) = 76832

PARAMETER (4) = ZFRNOTE

Successfully Connected to Oracle in ZFRNOTE

Successful run of ZFRNOTE

Version 3.1

21-AUG-2012

ACH File Name /u02/jobsub/tmp/pach20090821164044

Check Date 21-AUG-2012

Term Code

Selection Identifier

Application

Creator

User ID

Is this an Update(Y/N) Y

Bank Code (ACH) 01

Flip to Active Status N

Flip to Pre-Note Status Y

Lines Per Page 00055
For Technical Support Staff

Files for upload

/u02/app/Dtae/Menu/Mods/zfrnote_para4.sql

/u02/app/Dtae/Menu/Mods/cob/ZFRNOTE.pco

/u02/app/Dtae/Menu/Mods/shells/zfrnote.shl

/u02/app/sct/ban80/links/zfrnote.shl

/u02/app/sct/ban80/general/exe/ZFRNOTE

Upgrade instructions

Run script /u02/app/Dtae/Menu/Mods/zfrnote_para4.sql as sql user SATURN.

If Class Updating - Each user must have maintenance access to the object ZFRNOTE. Give

BAN_DEFAULT_M on ZFRNOTE to BAN_ARBASIC_C.

If USER ID Updating - Each user must have maintenance access to the object ZFRNOTE. Give

BAN_DEFAULT_M on ZFRNOTE to the Banner user needing access to this report.