Welcome to JRI's Help page for Payroll

These notes are intended to describe how Payroll/GL data is loaded into Avante.

Unique Setup for USA

Payroll/GL data is built by ADP and saved to an ADP FTP site.
There are 2 types of files: ...PR... & ...ACC...

Unique Setup for Canada

Current version:
Canada uses an old version of ADP that gets downloaded to Neal, he scrubs it, & loads it to Oracle.
Oracle builds a flat file and puts in on the Avante box at /vol1/prod/work.
There is a VOC pointer to this location call: CYBORG (a global file).
Oracle always builds the same file name: cy031cy011.02DSCA.
Future version:
  1. SFCS9017.3 runs every night to load ADP data into PREMP (Avante) used by GLMS9037.1 - of most importance are:
    • Cost Center
    • Dept
    • Update date
    • Update time
    • Status (2=active)
    • Supervisor ID
    • ADP Status
    • ADP Location
    • Link(s) to DMSECURITY key(s)
  2. Sherri exports 2 files from old Canadian ADP and saves them to her O: drive (UNIX home dir)
    • Canada_current_pay_for_GL.CSV
    • Canada_current_pay_for_GL2.CSV
      To copy the files to your home dir, do the following:
      • !su -
      • cp /home/hartsl/Canada_current_pay_for_GL.CSV /home/israejr
      • cp /home/hartsl/Canada_current_pay_for_GL2.CSV /home/israejr
  3. Sherri runs process GLM90371 (or GLMS9037.11 from TCL) (replaces Tim's logic) to read the two files from the O: drive. This will:
    • Build a COMO file called O_GLMS9037.1 (to track all kinds of info - only needed if there is a problem) - Note that this causes a GUI screen to drop to text mode, but it will flip back to GUI when finished
    • Build a file (cy031cy011.02DSCA2) to be read by Rick's GLM9014 to populate GLJRNL in Avante
    • Build an Email copy of the export file (with colors & added spacing to make it easier to read), the total debits and credits (they should match) & a link to:
    • Build a web page that shows:
      1. The same data as the actual data file (cy031cy011.02DSCA2)
      2. To make it easier to read, I have added headers, colors & spacing
      3. Clicking on each line will give details as to exactly how that row of data was built
      4. When clicking on/expanding a row, it takes a moment to process
      5. The "Condition" column relates to the part of program GLMS9037.1 that were used to build the data
      6. The total debits and credits (they should match)
1 This builds a COMO called GLMS9037.1
2 In DEV, make a copy of the file and append ".DEV" - in PILOT, make a copy of the file and append ".TRN"

Program to Load to Avante

Run GLM9014 (GLMS9014.1)
  • Company 01 or 02?
  • Get data file from ADP or History (a prior download)?
    • Company 01 & source = ADP
      • Connect to ADP's FTP site
      • Query the files on the FTP site
      • Display a list of files for the user to download
      • Download the desired file to /vol1/prod/work
      • Copy the file from /vol1/prod/work to EDI.GL
      • Copy the file from /vol1/prod/work to EDI.GL appending "_ORIG" to the name
    • Company 02 & source = ADP
      • Copy the file from /vol1/prod/work to EDI.GL
      • Copy the file from /vol1/prod/work to EDI.GL appending "_ORIG" to the name
    • Source = History
      • Query the EDI.GL file
      • Display a list of files for the user to re-load
      • Copy the desired file from EDI.GL to /vol1/prod/work
  • Read the 1st row and verify that it matches the expected data in DSCTBL PAYWEEK
  • Loop through the file in /vol1/prod/work looking for invalid GLs
    • Fix invalid GLs ad needed
    • Append the original (bad) GL to the end of the offending row
  • Write the updated file back to EDI.GL (with the GL corrections)
  • Purge any prior un-posted payroll run
  • Loop through the corrected file in /vol1/prod/work
    • Extract the data
    • Build/update the GLJRNL record(s) based on the pay code (Weekly or Bi-weekly)
  • If an ACC file was built, build a reversal ACR file for the next period
  • If file was downloaded from ADP
    • Delete file from FTP site (optional, but recommended)
  • Send Email to Rick with the updated file for him to review as needed

Double Checking

Use the following command to see what is waiting to be posted:
SORT GLJRNL WITH NO POSTDATE BY COMPANY BY PER BY WK @ID2 PER WK COMPANY ID.SUPP ENTRY_DATE USER.ID AUDIT.DATE AUDIT.TIME