PPMS Job Scheduling
PSxxxxJ PGxxxx Other

PG655R
Leave Reporting Upload

*** WARNING *** WARNING *** WARNING *** Use caution before scheduling this job group. This job group updates the PPMS Employee Database with Leave transactions from a file transferred from a remote server. Validate the file on the remote server before scheduling this job group.

This job group should be run with sufficient time to correct any issues prior to payroll processing.

This job group can be run in TRIAL mode. In TRIAL mode (job scheduling parm PS1648-UPD-OPT = "T") the file from the remote server is ftp'd to the HP3000 and all processing and reports are produced but no transactions are updated.

PG655R FTP's the Leave Reporting Upload file from the remote processor to the HP3000. The file is then edited, the PPMS Employee database is updated and detail and exception reports are produced.


Special Instructions PS1647J transfers the Upload file from the Remote Server to the HP3000 via FTP. The following parameters for PS1647J will require your IT department support: REMOTE-FILE-NAME REMOTE-EXT REMOTE-DIRECTORY REMOTE-SYSTEM FTPPASS-60 FTPUSER-60

Security Recommendations: 1. The two servers (web server, HP3000) should be on the same subnet. If the two servers are not on the same subnet, the traffic should not traverse an insecure network (i.e. Library, Student Lab).

2. The web server should not be exposed to the Internet.

3. The web server and database server should be "fully hardened". The college server administrator will understand this term as meaning the following: The servers have been secured and include all current service packs and patches.

4. Data handling on the web server should be carefully managed to prevent inappropriate information disclosure or incorrect usage of the data.

5. Review your Security Policies with your college Security Administrator.

Operator Instructions None


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
R 01 00 PS1647J
Leave Reporting File Upload
R 02 01 PS1648J
Leave Reporting File Posting
  Leave Upload Posting Report (PS1648A)
  Leave Upload Posting Exceptions (PS1648B)


Parameters

FTPPASS-60 The Password of the FTP Account that will be used to log onto the Remote Server. This field is case sensitive.
FTPUSER-60 The User Id of the FTP Account used to log onto the Remote Server. This field is case sensitive.
ID-PRINT-OPT Enter the option for printing the employees identification number to the report:
E = Print the Emp-Id (SSN)
L = Print last 4 characters of Emp-Id (SSN)
S = Print the System Id (SID)
B = Print spaces or blanks
* = Print all asterisks
PAYR-SCHD The payroll schedule being processed.
PS1648-UPD-OPT U = Update Leave Transactions.
T = Trial run, no update performed.
REMOTE-DIRECTORY The Remote Directory to which the file will be ftp'd. This field is case sensitive.
REMOTE-EXT The name of the file extension for the file after it has been ftp'd to a remove server. This field is case sensitive.
REMOTE-FILE-NAME The name of the file after it has been Ftp'd to the remote server. This field is case sensitive.
REMOTE-SYSTEM The Name or IP Address of the remote system to which the file will be ftp'd.



Distribution: PPMS
Created: TUE, JAN 16, 2018, 03:26 PM