PPMS Job Scheduling
PSxxxxJ PGxxxx Other

PS0386J
Match Vendors to Employees For Sao

This process extracts records meeting certain criteria from the GL. The transaction amounts of these records are summed by ID-NUM. Using the ID-NUM, the FED-TIN is retrieved from the vendor table. Then, the FED-TIN is checked against the employee ID in the EMP database. A match of FED-TIN and EMP-ID is reported on Report A along with the total transaction amount. Next, the vendor name is checked against employee names. If a specified percent of characters in the names match, the record is reported on Report B.
Special Instructions None
Frequency On-request
Scheduling Restrictions None
Execution Time Anytime (O, B, P or I)
Job Completion Status None
Job Groups
PG830A     Sao - Audit Reports
PG830R     Payroll Audit Reports
Job Dependency None
Operator Instructions None
Estimated Run Time None
Recovery/Restart This job is restartable.


Parameters

EXCL-OBJ Enter up to 10 objects to exclude from processing. Separate the objects with commas. The default for audit purposes is: A,B
FYR The fiscal year to be processed (YYYY). For example, 0203
INCL-BTCH-ID Enter up to 10 batch ID's to process. Separate batch ID's with commas. The default for audit purposes is: 46,47,49,50,52,53
PS0386-PCT The percent of an employee's name used to match with a vendor's name. Enter a compare percent as a 3 character field,
e.g. 090 for 90 percent.

Distribution: PPMS
Created: WED, JAN 04, 2012, 07:19 AM