PG650R Automated Time and Attendance Upload

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 PS1645-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.

PG650R FTP's the Auto Time and Attendance Upload file from the remote processor to the HP3000. The file is then edited, the PPMS Payroll database is updated and detail and exception reports are produced.

_{Distribution:
PPMS

Created: WED, JAN 04, 2012, 07:19 AM}

Job parameters
Parameter	Values
FTPPASS	The password of the FTPUSER logging onto the server that will receive the ftp'd file. This field is case sensitive.
FTPUSER	The user id that will log onto the server for the ftp. 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.
PS1645-SORT-OPT	Reporting Sort: 1 = Employee ID 2 = Employee Name
PS1645-UPD-OPT	U = Update Time 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.

Parameters

Req/
Opt

Seq #

Prior
Seq #

Job
Number

Description/Reports

PS1644J

Auto Time and Att Upload Ftp

PS1645J

Auto Time and Attendance Upload
	Auto Time and Attendance Upload Detail Report (PS1645A)
	Auto Time and Attendance Upload Exception Report (PS1645B)

Job Group Definition

Special Instructions

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

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