...
As stated previously, Labor Ledger (L/L) tracking of permanent employee Payroll data occurs at the Position (employee) level. All KFS Labor Ledger financial transactions must contain a valid Position Number or they will be rejected by the batch jobs which process these transactions.
The transactions described below are generated bi-weekly, normally Tuesday night of a paycheck week during the GENESYS batch cycle.
Expenditure transactions:
Expenditures represent actual funds expended by the University for salaries, fringe benefits, Workers' Compensation, and other types of personal services expenses. Expenses are posted to the employee's source of funding by Account Number and Object Code.
Cash Offset transactions:
When expenditures are made, such as for Payroll activity, the University's Cash balances are reduced. Cash offset transactions are required to reduce Cash since the expenditure transaction does not due this automatically. Cash offsets are posted to the KFS account for Bank 20 (9000020) and the Cash Object Code (1110).
Encumbrance Liquidation transactions:
The University encumbers salaries, fringe benefits, and workers' compensation at the beginning of a fiscal year or when an employee is first hired throughout the year. In order to keep University accounts in balance, these Encumbrances must be partially liquidated during each bi-weekly when the expenditures are posted. Encumbrance liquidations are also posted to the employee's source of funding by Account Number and Object Code.
Since GENESYS is hosted on the z/OS server (mainframe), multiple steps are required prior to processing the above transactions by KFS. These steps are:
- Create the transactions via GENESYS batch jobs on the z/OS server,
- Jobs are maintained by UITS-EAS-Mainframe Application Support.
- Transfer the transactions to the KFS Batch Server. Note that all three files must be on the server, for a successful completion of this job.
- Run PRD-KFS-PayrollFromGenesysToKFS-AFT
- Run the KFS batch jobs to process the transactions.
- Jobs are maintained by UITS-Financial Systems (KFS) and Controller-Finance Systems.
The server hosts and file locations for the transactions described above are as follows:
Source | File | Destination | Path/File |
---|---|---|---|
Expenditures: uconnmvs.uconn.edu | DSN=UAPGENS.KFSFLAT.EXPENSE.J1918MK1
| prd.batch.uconn.edu | /srv/uconn_configs/kfs-config/work/prd/kfs/staging/adp/ ADP_PAYROLL_DATA.genesys_ccyymmdd_hhmmss.dat' |
Cash Offsets: uconnmvs.uconn.edu | DSN=UAPGENS.KFSFLAT.EXPCASH.J1918MK1 | prd.batch.uconn.edu | /srv/uconn_configs/kfsconfig/work/prd/kfs/staging/gl/collectorFlatFile/ PayrollCashOffset.genesys_ccyymmdd_hhmmss.data' and PayrollCashOffset.genesys_ccyymmdd_hhmmss.done (null file) |
Encumb. Liquidations: uconnmvs.uconn.edu | DSN=UAPGENS.KFSFLAT.LIQDENC.J1918MK1 | prd.batch.uconn.edu | /srv/uconn_configs/kfs-config/work/prd/kfs/staging/adp/ ADP_ENCUMBRANCE_DATA.genesys_ccyymmdd_hhmmss.dat' |
The file format for the Expenditure, Cash Offset, and Encumbrance Liquidation transactions can be found by selecting this link.