Public Works and Government Services CanadaCanada wordmark
Skip navigation links
 Français Contact Us Help Search Canada Site
PWGSC Home About PWGSC Services Canadians Businesses
Compensation Sector
 What's New  Site Map  Home
Compensation Sector Web Site
Who are you?
Public Service
Employee
Compensation
Advisor
Compensation
Manager
Public Service
Line Manager
Employment
Opportunities
Publications
Forms
Training
Tools
Pay
Pension
Insurance
Regional Corner
What we do
Links
Archives
Mailing List
FAQ
 

 

1997-007-e.html

COMPENSATION DIRECTIVE : 1997-007

Appendix A - Edit Messages


March 14, 1997

Ottawa, Canada
K1A 0S5

SUBJECT: Salary Service Enhancements - Data Integrity

1

PURPOSE

1.1 The purpose of this directive is to provide you with information concerning the movement of edits within Salary Service (S/S) to the front end of the Regional Pay System (RPS). This will reduce the possibility of future data corruption on the various Public Works and Government Services Canada (PWGSC) Compensation files.

2

BACKGROUND

2.1 The first phase of this project, implemented in June 1996, ensured that "new" transactions were input and processed correctly, for the Entitlement Adjustment Screen (EAJ), Leave Without Pay (LWOP), Ongoing LWOP, LWOP reporting on Temporarily Struck off Strength (T-SOS) and Struck Off Strength (SOS), reversal of LWOP, reversal of Ongoing LWOP, (SOS) effective date in the past and equalization payments.

The enhancements to the RPS are part of a larger undertaking known as the Compensation Productivity Initiative (CPI).

3

POLICY/PROCEDURES

3.1 Effective April 1, 1997, the S/S edits will be moved to the front end of the RPS for the following transactions:

PAC 01 - TOS
PAC 02 - SOS
PAC 03 - Transfer out
PAC 04 - Transfer in
PAC 09 - Salary Revision
PAC 12 - Status field change
PAC 13 - T-SOS
PAC 14 - RE-TOS
PAC 15S - On going leave stop
PAC 18 - Entitlements
See Appendix A for a description of the edit messages.

3.2 As a result of the relocation of the Salary Service edits, client departments will be responsible for correcting their input if discrepancies are identified between their input and the S/S Master file. If the S/S Master file is found to be in error, and the data cannot be corrected within the RPS, the client department must contact the Pay Office to correct S/S.

Client departments using the On-line input method will view their reject messages and S/S Master on-line.

Batch clients will receive their reject messages on hard copy with either a partial or complete S/S snapshot of the account.

3.3 New Edit messages have been created. If a discrepancy exists between the on-line transaction being input and S/S, the transaction will reject upon creation. If a discrepancy exists between a batch transaction and the S/S, a reject message and either a full or partial snapshot of the S/S master will be produced.

Refer to Personnel-Pay Input Manual (PPIM) 7-3-3-2 for a list and description of the edit messages.

4

INSTRUCTIONS

Effective April 1, 1997, the following new procedures are to be followed:

4.1 When a reject occurs that is caused by a discrepancy between existing information on the S/S master file and the transaction being input, an analysis and comparison by the client department is to be performed to ascertain the nature of the incorrect data. If the S/S master file is found to be in error the client department will advise the Pay Office who will create the necessary actions to correct the master on an urgent basis. Once the S/S master has been corrected the original transaction will require re-input by the client department.

If the transaction itself is found to be in error then the client department can correct the problem on-line immediately based on the error identified.

For more information regarding the correction process refer to the input instructions in the Personnel - Pay Input Manuals changes: PPIM AMENDMENT No. 41 (Volumes IV, V) and No. 48 (Volumes I, II, III) dated February 1997.

5

INQUIRIES

5.1 Any request for information regarding the foregoing should be addressed to your PWGSC Compensation Services Office.

Original Signed by
P. Charko

P. Charko
Director General
Compensation Sector
Government Operational Service

Reference: CJA 9020-40

APPENDIX A

EDIT MESSAGES

WS6 Fld. 34 Blank, 1 or 2 Imposed Based on Employee Code
R17 Invalid NSW Ind for EE Type
R78 Date in Field 63 Not = Date on Master
Q21 Account Already Exists on S/S
Q22 No Current Ident Record for Account
Q23 Partial Recovery Period not Found
Q24 Transfer Account Already Exists on S/S
Q25 PRI Change Rejected - Duplicate Account
Q26 No Salary Service Account Found
Q27 Trans. Rejected-Appropriate S/S Line Cannot be Found
Q28 Trans Eff to Date > Eff From Date on S/S
Q29 Transaction From Date Cannot be Matched
Q30 No Matching S/S Record - Contact Pay Office
Q31 Account not TSOS on S/S
Q32 Rate Base Or Amount Not = S/S Line
Q34 No Basic Pay Line Found
Q35 Current Line Not Found
Q36 Transaction Overlaps an Existing Line
Q38 TOS Date Prior to SOS Date on S/S
Q39 Transaction From Date < Record Type From Date
Q40 Transaction From Date < Oldest Record on SS
Q42 Trans Eff. To Date > Eff. From Date on S/S