georgefoxuniversity/payroll-loading-for-peoplesoft

Payroll Loading For Peoplesoft

Payload Loading For Peoplesoft

Load job payment items into the PS Staging table.

Setup using a virtual enviroment

• Make the dependencies for the pip package cx_Oracle are already installed
• Create the virtual enviroment python -m venv venv
• Activate the virtual enviroment source venv/bin/activate
• Install the pip packages: pip install -r requirements.txt

If using a config file

• Create a config file: cp config.ini.dist config.ini
• Add your database settings to config.ini

Running

Command Line Arguments

• csv: Path to the CSV file to load
• pay_start: Earns begin date, this needs to match the current PS Paysheets entry for the target pay group.
• pay_end: Earns end date, this needs to match the current PS Paysheets entry for the target pay group.
• pay_group: The PeopleSoft pay group these records are for.
• company: The PeopleSoft company code these records are for.
• --config: Path of a config containing db connection details. If this isn't given it will check your environmental variables for connection details.
• --as-sysdba: Connect to the database as sysdba. Probably not something you want to do in production.

Environmental Variables

If a config file isn't passed in, the script will look at the following environmental variables for the database connection details.

• PS_DATABASE_HOST
• PS_DATABASE_USER
• PS_DATABASE_PASSWORD
• PS_DATABASE_SID
• PS_DATABASE_PORT

Valid Column Headers

• disable_direct_deposit - Disable Direct Deposit for this entry.
• emplid- PS Emplid of job for this entry.
• empl_rcd - PS Job empl_rcd for this entry, defaults to 0
• seq_no - Sequence number for the staging table, defaults to 0. You are response for making sure the order in the csv file is correct
• earning_code- Earning code for this entry.
• hours- Hours to be loaded for this entry. Mutually exclusive with amount.
• amount - Amount (money) to be loaded for this entry. Mutually exclusive with hours.
• combo_code- Match the payment to an account string.

Example

python import-csv.py example.csv 2019-01-01 2019-01-31 PAYGROUP_CODE COMPANY_CODE --config config.ini

Useful stuff to read before you try to make this script work

The PeopleSoft Documentation related to the staging table this script loads into

• http://docs.oracle.com/cd/E79521_01/hcm92pbr11/eng/hcm/hpay/task_DataInputRequirementsforThird-PartyPaysheetData-3e3d81.html#ua57c9be8-6326-4b37-8dac-355df2d501fb
• http://docs.oracle.com/cd/E79521_01/hcm92pbr11/eng/hcm/hpay/task_LoadingPaysheetTransactions-3e3aab.html?pli=ul_d209e281_hpay

Copyright Stuff

• Written by: Joel Kelley [email protected]
• Copyright: 2019, George Fox University