Yearly Events - June & beginning of July

• Receive PLFBM952 & PLFBM953 from OSP - sent to Conadm03 and moved to Conadm02. Complete a table option 1 and send to Scheduling.
• Month end schedule begins at 7:30 pm

Finance Systems - Michael Virone
OSP- Beverly Rutlege or Tina Blatchley

UITS - Marie Dexter

• Schedule J9645M01, J9645M02 & J9645M03 - Fixed Assets for programs TBM200 & TBM210.
• Schedule J9619M05 job - Dottie Koss
• Bank Reconcilliation control cards:
  • C9615M04
    C9615M06
    C9615M1B
    C9615M2B
    C9615M4B
    C9615M6B

• Bank reconcilliation jobs received from Bank of America. Transfer bank files to SP server.
• Schedule J9615S80 & J9615S95 job reformatters. Day jobs.
• Schedule reconcilliation jobs from FRSSCHED menu. Evening jobs.

Finance Systems - Carolyn McEvitt

Payroll activity is done in the following order and includes:
1. Posting payroll (UITS checks)
2. Posting worker's comp (Acctng)
3. Sending encumbrance flat file for personal services, fiscal & project accounts (Budget). See specifics below.

• Verify last check cycle of Fiscal Year has been processed prior to excluding Payroll Files. Pay period 26's check date is 6/17/11. Last feed of charges for pay period 26 should be 6/14.
• Turn off the FRS acceptance of payroll feeds to eliminate the possibility of loading a feed for the new year into the old year.
• Edit and migrate DEV.CTLLIB(F9650M01), J9650M01 (Data Collect) will now exclude the following files: Personal Services (payroll) encumbrances for FY12 for non-project accounts to FRS from GENESYS:

GENESYS-Payroll Budget Transaction File: FILE27 INCLUDE=NO

GENESYS-Payroll Encumbrance Transaction File: FILE28 INCLUDE=NO

GENESYS-Payroll Distribution Interface File: FILE16 INCLUDE=NO

• Accounting posts Worker's Comp to FRS via flatfile (depends on when Personal Services are posted).
• Personal Services Encumbrances, Fringe, Worker's Comp are netted to 0 by a flat file (Encumb Foctemp). Flat file sent to Scheduling via FRSSEND FRSBATCH up until 1:00 p.m. This is done the day after Accounting posts Worker's comp to FRS. File will have old FY in columns 91 & 92 of header record.

UITS/FRS - Marie Dexter/Kathy Avery

Accounting -Kara Dudas

Budget - Mike Golden
Finance Sys. -Carolyn McEvitt

• Update normal CY month end parameter files (EOM report dates) and submit an FRSOPT request to Scheduling for migration. These control cards are found under FRSMNTH2 of which FRSMNTH6 is a subset. NOTE: C9666M02 FY parameter does not change until July of the new FY.

Finance Sys. -Carolyn McEvitt/M.Virone

• Last day for GSE changes until new fiscal year opens.
• Remind Nancy Patrylak about undeletes that are needed for last future order jobs.
• Verify if PROCARD still gets turned off after the 6/23 posting date has been fed to FRS. If so, Nancy Patrylak will determine when.
• Remind users that once the new year opens the LY focus files now contain data for FY 12 and that they need to use 11 focus files for retrieving FY 11 data.

Finance Sys. -Carolyn McEvitt

• Send a reminder note to FRS3-L concerning June deadlines, batch file submissions and other important June activity dates. Batch file deadline = 11:00 a.m. on 6/30. NOTE: PO invoices posted and Reviewable Batches may post right up to 6:00 deadline.
• Review open departmental created encumbrances for FY accounts (2-ledgers). Use OCFDOLE FOCEXEC for the report. Drop them using screen 11.

Finance Sys. -Carolyn McEvitt

• PO Undeletes need to be done before Future Order jobs run.
• Send an email to Mitch Saba asking him to extend the FAMIS FRS kron to 1:00 pm on July 1st only. It normally runs at 9:30 pm, M-F, but Famis interfaces will probably run later after the 9:30 scripts:
  mod_data.sh & pushData_ctrl.sh

Purchasing - Nancy Patrylak

UITS/FRS - Marie Dexter/Kathy Avery

• Purchasing notifies Finance Systems when PROCARD transactions should to be excluded from Data Collect. Nancy will base this on an FBD010 report from Control-D showing June's ProCard transactions.
  After the ProCard file with the posting date of 6/23 is processed, the ProCard file can be turned off in Data Collect (J9650M01). Edit and migrate DEV.CTLLIB(F9650M01) to exclude the following file:
  File 29 INCLUDE=NO DSN=UAPFRSP.PROCARD.D9556M05
  Contact Scheduling to ask them to start running P9551E12 in place of J9551S12. This is done so that records from MasterCard after the statement date will not be sent to the ProCard FOCUS database for reallocation in the old Fiscal Year. P9551E12 will run until after the new Fiscal Year opens. The records will be saved for input after FRSYRPT1 completes.
• Send a note to Scheduling for 7/1 asking them to add a dependency to J9570S51, J9570S52, J9570S53, J9570S54, J9570 S55 (FAMIS) so they run after the end of FRSYRPT2. The FAMIS interfaces cannot be run until after we create the current year FOCUS shadow files.
• Disallow use of 0E1 screen. Replace with the message screen 0EM.
• Last morning to post automatic TV's (transfer vouchers) for FY 11. Any fixes to FY11 after 6/24 will need to be done online on 6/27or 6/29 as the automatic process will be shutoff on 6/26. The automatic process will be turned back on between parts I and II and those TVs held will appear in FY12. NOT DONE FOR '08.
• Remove J9576M02 from Sunday nite schedule (select, purge, archive documents). This job usually runs the Sunday before new year opens, but needs to be removed for FY11 and placed on 6/28 so that Nancy's undeletes are not deleted.

Purchasing - Nancy Patrylak

UITS/FRS - Marie Dexter/Kathy Avery

Finance Systems - Bruce Gerber

UITS/FRS - Marie Dexter/Kathy Avery

• Send SCHEDULING a note about FRS Fiscal Year processing. FBD010 verifies that last batch has been fed.

• Check control cards for Future Order jobs and put on the nightly schedule::

  Job #	Control Card	PO-Type
  J9580M01	C9580M01	DM
  J9580M11	C9580M11	SO
  J9580M21	C9580M21	BO
  J9580M31	C9580M31	SM
  J9580M41	C9580M41	FR
  J9580M51	C9580M51	CR
  J9580M61	C9580M61	LO
  J9580M71	C9580M71	PR
  J9580M81	C9580M81	SL
  J9580M02	C9580M02	Pointer=POB38
  J9580R03	None	Print Job

UITS/FRS - Marie Dexter/Kathy Avery

Finance Sys. -Carolyn McEvitt

Finance Systems - Carolyn McEvitt

• First payroll files for new fiscal year are processed in Genysys, but not fed into FRS.
• Determine control card parameters for pre-month end check cycle (C9605M05, C9605M45, C9605M55, C9605M6A, C9605M6K, C9605M6P). This will be the last daily cycle for the checks.
  PYTHRU =6/30 DSCNT = 6/19
  

• Send data collect Payroll files to Budget7, Person12 and Jim Hall. Files are to be reviewed by BUDGET (Kelly).
• Last day to physically print checks in Accounts Payable.
• No control cards for checks.
• Reminder to verify that PLFBY005 has been PROCOPIED and Encumb Foctemp has been processed before FRSYRPT1 is started (Encumb was done on 6/16) .

• FBY005 posts carryover encumbrances and associated budgets from old FY to new FY. Carolyn sends the file to UITS. UITS places the file in TEST (UATFRSP.FRSTEST.TABLES(PLFBY005)) and runs T9512M01 to verify syntax. After Finance System validates the results, UITS copies the file to DEV.TABLES and requests that Scheduling PROCOPY it to PRO.TABLES where it will be used as input for J9670S50, J9670S52 & J9670S54 in FRSYRPT1. These jobs create Payroll carryover encumbrances and associated budget transactions for the new fiscal year, which will go into FRS when the FA Data Collect is run in the first part of FRSYRPT2. Note: A preliminary file was tested when FRSYRPT1 was run in TEST earlier.
• Send Final reminder note to FRS3-L concerning June deadlines, batch file submissions and other important June activity dates. Use FRS3-L & Budds-L listservs.
• Remind Carolyn/Mike to update PO number counter after Part II.
• Receive PLFBM952 & PLFBM953 from OSP - sent to Conadm02. Complete a table option 1 and send to Scheduling.

Budget - Mike Golden
Finance Systems- Carolyn McEvitt

UITS/FRS - Marie Dexter/Kathy Avery

Scheduling - Jill Stedman

Finance Systems- Carolyn McEvitt

Office of Sponsored Prgms - Tina Blatchley
Finance Sys. -Carolyn McEvitt

• FRS unavailable at 6:00pm to begin batch processing for June month end and new fiscal year open. The year end process runs from 6:05 pm on 6/30 through NOON on 7/31.

• Begin PART I of Year End Schedule, FRSYRPT1. This year end schedule begins at 6:05, after CICS comes down. FBY001 (J9670M01) and FBY002 (J9670M02) rolls the current FY to 12, FY11 becomes the last FY, project accounts are carried forward to FY12 from FY11. FOCUS shadow files are changed to reflect the New Year, FY11 data is moved to the D95LYFxx files, FY12 data is moved to the D9530Fxx files. Note: when prior year projects are opened and adjusted, the amounts will not be carried forward.

• Remind SCHEDULING that reports need to be decollated to Control-D when FRS PART I is completed (only if NOT run during last 3 days of June (If YE is before 6/28).

- FRS will be unavailable until noon to complete the year end batch processing. FRS will operate in LY and CY from now until LY closes in August.

- Migrate several PROCOPYs after FRSYRPT1 completes.

NOTE: SCHEDULING must place jobs listed on the NIGHTLY schedule on hold to eliminate the possibilty of wrong jobs being released during the year end cycle.

• If this is a Wednesday of payweek, hold P1918R01, P1991M20, and J1100M10 jobs (1st Genesys cycle of the Fiscal Year) until after FRSYRPT2 finishes. Verify that encumbrances were processed by FRS prior to releasing these jobs.

• Edit F9650M01to turn off all interface files except CMSTRX. When J9650M01 runs at the beginning of FRSYRPT2 only selected files (ABR budget changes (if any)) be processed
• Copy the ABR interface to a CMSTRX file for input into Data Collect:
  UAPFRSP.CMSTRX.D9552S01(+1).
  Note: there were no ABR transactions for FY12 processing.
  
• Have Scheduling run FRSYRPT2 verifying that it will stop after the first set of Data Collect jobs (ending with J9650M03) completes. Only the first 5 jobs will be run.

  Load new budgets for accounts with ABR changes into Data Collect in the beginning of FRSYRPT2. Note: If needed this year.

• Verify that the ABR budgets were updated correctly (if any).
• Update CY parameter files: FRSFOCCY and submit PROCOPY request to scheduling for migration. FRSFOCCY (C9530S02, S14, S15, S16) should be set to the new FY....Update to new fiscal year.
• Update other control cards (C9655S9A, C9655S15 and C9662R17).
  
• FRSYRPT2 will stop after the first data collect jobs (J9650M03).

UITS/FRS - Marie Dexter/Kathy Avery

UITS/FRS - Marie Dexter/Kathy Avery

Finance Sys. -Carolyn McEvitt

- Edit DEV.JOBLIB(P9551S12) to add the PROCARD interfaces that were stopped by P9551E12.

- Ask Scheduling to run P9551S12. Procard reallocation will be loaded with this data. Run J9551S12 instead of P9551E12, this afternoon, when the Mastercard data arrives.

UITS/FRS - Marie Dexter/Kathy Avery

• Update LY parameter file: FRSY15LY and submit a PROCOPY request to Scheduling for migration. FRSY15LY (C9655S9A & C9655S15) should be set to fiscal year ended. Do with the IA budgets. Note: This migration should happen after FRSYRPT1 and before FRSYRPT2. PROCOPY F9650M01 after FRSYRPT1 and before FRSYRPT2.
• Check Part I output on Control-D: FBM010 batch files, PLFBM952 & PLFBM953 output, FBM092 & FBM061 data.

• Request that Scheduling PROCOPY F9650M01 to Production and that the job, J9650M01 (in FRSYRPT2), be rescheduled to pick up the changes made above. If the job was already placed in the schedule queue, it will contain prior values from F9650M01 and the above files will not be included in this run. Note: This migration should happen after FRSYRPT1 and before FRSYRPT2.

• Update the current year and prior year parameters in J9556F08 EXEC on the E-disk for the ProCard Reallocation extracts (&CY/&PY).

- Begin PART II of Year End Schedule, FRSYRPT2 :

When the 6/30 schedule has been built, after J9520S01 (deallocation of CICS files) has been completed, after J9509Q02 at end of FRSYRPT1 completes, and after F9650M01, IA*** Data, and required control cards are copied to Production.

- FBY110 (J9513M32) sets LY security access to CY; change users as requested.

-After the completion of J9650M03 and before J9650M11 in FRSYRPT2 migrate the following:

• F9650M01
• All university and non-project self-supporting budgets are loaded by a flat file copied from VM (IA*** DATA) to MVS (UAPFRSP.CMSTRX.D955201)via the FRSSEND Utility. Call Scheduling to pick them up before starting Part II. Note: This migration should happen after FRSYRPT1 and before FRSYRPT2.PROCOPY F9650M01 after FRSYRPT1 and before FRSYRPT2.

- Edit and use DEV.CTLLIB(F9650M01), J9650M11 (Data Collect) to Include non-payroll files that were turned off, including:

-PRFEED2-Encumb feed from Purchasing File ('YYY' batches): File10 INCLUDE=YES

-PROCARD-Procard transaction file: FILE29 INCLUDE=YES

-* LOTUSTV - Online Transfer Voucher file: FILE47 INCLUDE=YES DSN=UAPFRSP.LOTUSTV.D9556S21 NOT DONE IN '08.

-Migrate F9650M01

-After the migration is verified J9650M11 has to be reloaded and started.

- When FRSYRPT2 completes, allocate S410 region to bring FRSPLUS online with DADS.

- Send a note to Scheduling to remind them that some FRS jobs are going to run twice in the same day (in FRSYRPT2 and in the nightly batch schedule). They will have to go into Control-D to manually decollate the second set of reports.

- Once the July 1st Part 2 reports have been decollated, please contact Nancy Patrylak for her to review them on Control-D. Nancy should be looking for the following:

FBD010 FA FL MNT R2 07/01/09 2765 143311 V, 001, Decollated

**Next PO No 210000 (1st digit=last digit of FY followed by 10000)

**FA Batch reference: XXX 001 used by PBD050 in J9560M01

**FA Batch Reference: YYY 001 used by PBD050 in J9560M01

**FA Batch Reference: ZZZ 001 used by PBD080 in J9560M10

**Next Commit: 0001

**Next Expend: 0001

**Next Transfer: 7800

FRSLYMON should be scheduled with PLUSMON
FRSLYSUN should be scheduled with PLUSSUN
FRSLYMNT should be scheduled with PLUSMNTH for July month-end only
FRSMNAUG should be scheduled with PLUSMNTH for August month-end only

The jobs in the LY schedules update FOCUS shadow files that contain data from the old fiscal year.
The August schedule creates reports and creates year-end archive tapes.

JULY MONTH END - J9655M91, J9671R20, J9672R30, J9531S14, J9531S15, J9531S16, J9531S03

Bursar

Lan Guglietta

Lan Guglietta

Lockbox transmission received on 6/30 & control card change (C9550M01) - contains Work of 6/30 that will go to the old year. J9550M01 is the batch interface job for SARS.

Student Financial batches posted thru 6/30

-Check cycle control cards through "7/4" and run on 7/3, Sunday, distribute checks on 7/5, Tuesday.

-Reminder to Accounting & Sponsored Prgrms of the moritorium on setting GL delete flags in CY until 8/28. Note: If GL is undeleted in PY then must be re-deleted.

-Start running the focexec FLY_F30 weekly or more frequently to update the project account balances in the current year and send the batch through overnite. The final batch is submitted one week after the old year closes.