![]() |
|
|||
Date: November 7, 2002 |
Bulletin No. 349 |
|||
|
Subject | Elimination of Fiscal Year Earnings Balances |
Purpose | To inform Payroll Officers of the upcoming Fiscal Year Earnings Balances purge and provide instruction on obtaining this information using PS Query. |
Effective Date | November 12, 2002 |
OSC Actions | Due to the continued need to purge excess data from the payroll system, on the weekend of November 9, 2002, OSC will purge all Fiscal Year Earning Balances and will discontinue creation of these balances. |
Agency Actions |
There are several new queries that will
return earnings information for individual employees. These were created in
response to requests from Payroll and HR offices so that they could provide
earnings statements for employees who had applied for loans, mortgages, etc. There are two sets of queries. Each set includes a query for archived (ARC) and non-archived data. The first set returns gross pay received. The second set includes a prompt on an earnings code and returns earnings associated with that single code. The reason for the second set is that sometimes requests for earnings specify that only regular earnings should be included. Any earnings code can be entered in the prompt. Set 1 - Gross Earnings UG_IND_PAY_BETWEEN_DATES (gross pay) UG_IND_ARCHIVE_PAY_BETWN_DATES (archived data, gross pay) Set 2 - Prompt on Earnings Code UG_IND_EARN_PRMPT_BETWN_DATES (prompt on a single earnings code) UG_IND_ARC_ERN_PRM_BETWN_DATES (archived data) |
Questions | Questions regarding this bulletin may be directed to the Payroll Audit mailbox. |