1. EXTRACT DATA from Third Party Timekeeping System

MISD SubTracker Processing

Overview of SubTracker Steps

1.  EXTRACT DATA FROM Third Party Timekeeping System

2.  CREATE IMPORT RECORDS

a.  STUTLF Load Flat File into STUPIM

b.  STUTRS IMPORTUPDATE - Run SQL’s to update STUPIM records

3.  CREATE ATTENDANCE RECORDS

a.  STUTCE Clear Attend Error Table

b.  STUTMA Create Attendance records in STUPAT

c.  CDD ATTEND ERROR FILE – reads from Attend Error Table

d.  STUTRS ATTENDUPDATE - Run SQL’s to update STUPAT records

4.  CREATE TIMECARD ONLINE ENTRIES

a.  STUTCT Create batch(es) in Timecard Online table, IFPY_TC_IMP

b.  CDD TO1010, TO1020 - reads from IFPY_TC_IMP table

5.  CREATE TIMECARD BATCH(ES)

a.  PYTCIFPY Creates timecard batch(es) in classic timecard table

b.  CDD TO1030 - reads from classic timecard table

c.  PYTCDTBP Batch Proof Report reads from classic timecard table

STEP 1: EXTRACT DATA FROM Third Party Timekeeping System

STEP 2: CREATE IMPORT RECORDS

STUTLF

Go to STUTLF. Click the Blue Button and select the data file to upload.
Click Submit to process the file. Review the Tailsheet for errors.

STUTRS IMPORTUPDATE

Go to STUTRS. Choose G for Global Link and IMPORTUPDATE to update the STUPIM records.
Click Submit to process the file. Review the Tailsheet for errors.

STUPIM

Go to STUPIM to review the data. Do a Find/Search for your import file name (i.e. TESTFILE).
Review the selected records and verify data has loaded and been updated correctly.

STEP 3: CREATE ATTENDANCE RECORDS

STUTCE

Go to STUTCE.
Click Submit to process the file. Review the Tailsheet for errors.

STUTMA

Go to STUTMA. Fill out the Entity, Period, and name of the Flat File.
Click Submit to process the file. Review the Tailsheet for errors.

CDD

Go to the CDD Folder, find the ATTEND ERROR FILE. Enter the name of the Flat File.
Click Submit to process the file. Review the Report for errors.

Error Messages

Error Message / Potential Issues
001: Undefined Absentee ID / Record must exist in HREMEN for Absentee
Record must exist in STUPTR – Import ID for Absentee
002: Undefined Substitute ID / Record must exist in HREMEN for Substitute
Record must exist in STUPTR – Import ID for Substitute
013: No SUB_EPAY rule found for Substitute / No Business Rule exists in STUPBR à Pay Assignment Rule
-OR- No Pay Assignment Record exists in HRPYPA or HRPYQP
024: No SUB_ACCT rule found for Substitute, sub_import, account empty / Missing Location in Business Rules (STUPBR)
032: No EMPPAY Record found meeting SUB_EPAY rule / Check Pay Assignment – verify that employee has correct record type to match Subtracker rules.

STUTRS ATTENDUPDATE

Go to STUTRS. Choose G for Global Link and ATTENDUPDATE to update the STUPAT records.
Click Submit to process the file. Review the Tailsheet for errors.

STUPAT

Go to STUPAT to review the data. Do a Find/Search for your import file name (i.e. TESTFILE).
Review the selected records and verify data has loaded and been updated correctly.

STEP 4: CREATE TIMECARD ONLINE ENTRIES

STUTCT

Go to STUTCT.

Select S to only process the Substitute Records.
Enter in the Payroll Period and Flat File Name.
Key in the new Timecard Batch Name (start with a character, max 12 in length).
Click Submit to process the file. Review the Tailsheet and Interface Report for errors.

CDD (optional)

Go to the CDD, find the TO1010 & TO1020 reports. Enter the name of the Timecard Batch.
Click Submit to process the file. Review the Report for errors.

STEP 5: CREATE TIMECARD BATCH(ES)

PYTCIFPY

Go to PYTCIFPY.

Enter in the Payroll Period and Timecard Batch Name for the Substitute file.

Click Submit to process the file. Review the Tailsheet and Interface Report for errors.

CDD (optional)

Go to the CDD, find the TO1030 report. Enter the name of the Timecard Batch.
Click Submit to process the file. Review the Report for errors.

PYTCDTDS

Timecard records now exist in PYTCDTUB and can be edited as needed

Run PYTCDTDS to distribute the Timecard Batches – key in the batch name(s) from PYTCIFPY
Review the Tailsheet and Batch Proof Report for errors.

Deleting Subtracker Data

Depending on what step you are on in the import process, you may need to complete one or more of the steps below.

Delete Timecards from PYTCDTUB

Records populated in PYTCDTUB by running the PYTCIFPY utility are deleted as follows:

1.  Run PYTCDTUN to undistribute the Timecard Batch.

2.  Run PYTCDTCU to delete the Timecard Batch.

Delete Timecards from Timecard Online

Records populated in Timecard Online by running the PYUTCT utility are deleted as follows:

1.  Open the Admin Console.

2.  In the Administrative Menu, click on Database Admin à Utilities à SQL Query

Copy and Paste the following statement into the top box labeled ‘SQL Query’.

DELETE FROM IFPY_TC_IMP
WHERE IFPY_BATCH_ID = 'YOURBATCHNAME'
Change the red font items as necessary before copying and pasting.

Hit ‘Execute’ when ready to update

Delete Attendance Records from STUPAT

Records populated in STUPAT by running the STUTMA utility are deleted as follows:

1.  Run STUTDA to delete the Attendance Records.

2.  Run STUTCE to delete the Attendance Error Messages.

Delete the Imported File from STUPIM

Records populated in STUPIM by running the STUTLF utility are deleted as follows:

1.  Run STUTDF to delete the import file from STUPIM screen.

2/20/2013 / Page 7 of 7