Incumbent Data Element Dictionary

• 1= DI Plan Contributor
• 2= LTD Plan Contributorbr
• 3= Non-Participantbr
• 4= LTD Premium Holiday
• 5= DI Premium Holiday
• 6= LTD Executive
• 7= LTD Executive Holiday

• Set Employee Classification Effective Date (DTEMPCLS) = old DTEMPCLS

• If Acting Pay Code = 1 and old Acting Pay Code = 2 and M027 = Substantive Employee Classification
• Set DTEMPCLS = old Substantive DTEMPCLS

• Use the Effective From Date on the Suspense Record (Pay Transaction) with the earliest Effective From Date that contains the new Employee Classification.
• If no Suspense Record found
• If Acting Pay Code =1 and old Acting Pay Code =2
  Set DTEMPCLS = old Substantive DTEMPCLS

• Set DTEMPCLS = old DTEMPCLS

This code identifies each Geographic Location inside Canada and are assigned by Statistics Canada. The Geographic Location Code is composed of three components:

Component Example for Ottawa, Ontario
Province Code (first two digits) 35
Census Division (second two digits) 06
Census Sub-Division (last three digits) 014
The Geographic Location Code for Ottawa is therefore 3506014.

Locations outside Canada are assigned by PWGSC. The leftmost two digits of these outside-Canada GEOLOC codes usually indicate the continent, as:

Left 2 GEOLOC

Digits - Location

• 91 - Europe
• 93 - Africa
• 95 - Asia, Middle East, India, Pakistan
• 96 - Australia, New Zealand some of the south Pacific
• 97 - South America
• 98 - Central America, Mexico Caribbean
• 99 - United States, Greenland, Bermuda, St. Pierre & Miquelon

A list of these codes can be obtained from PAC.

• Set GEOLOC = GEOLOC on old Incumbent Master

• Set GEOLOC = M020

• Set End Date of Salary Reduction = M116

• Set Entitlement Effective Start Date (DTSTTAMT) = M110

• Set DTSTTAMT = old DTSTTAMT

• Set DTSTTAMT = the Effective Date (if non zero) from the last Suspense Record (Pay Transaction) with a Pay Action Code of 01C001(if one exists)

• Set Entitlement Effective Stop Date (DTSTPAMT) = M103

(Employees on leave due to Leave With Income Averaging (LIA) or Educational Leave with Allowance are not identified by the Pay Activity Status Code in the Pay System.) -

If there is an active LIA, pay action 15C/A306, attached to the MER (i.e. Effective From Date is < or = the current month)

• Reset DTSTPAMT = Effective From Date of the 15C/A306

If there is an Education Leave with Allowance

• (i.e. Basic Pay Entitlement (M108) = 077)
• Reset DTSTPAMT = Entitlement Effective Start Date from Pay (M110)

If Pay Activity Status Code = 1

• and Employee Type Code = E, F, G, or H
• If Employee Type Code = old Employee Type Code
  • Set DTSTPAMT = old DTSTPAMT

• Set DTSTPAMT = the Effective To Date on the Suspense Record (Pay Transaction) with the earliest Effective From Date that contains the new Employee Type Code

• Set DTSTPAMT = the Effective To Date (if non zero) on the last Suspense
  Record (Pay Transaction) with a Pay Action Code of 01C001(if one exists)
  which has an Employee Type Code = MER Employee Type Code and an
  Effective Date >= Effective Date on the transaction selected in the previous paragraph

If Pay Activity Status Code = 1 and Employee Type Code > D

• and DTSTPAMT < DTSTTAMT
  
• Set DTSTPAMT = ZERO

• Set PYRTAMT = M101

• Set PYRTAMT = old PYRTAMT

1. If Pay Rate Base (PYRTBASE) = 1
   Equivalent Annual Salary (EQUANSAL) = Entitlement/Deduction Pay Rate Amount (PYRTAMT) x Normal Work Week Hours(NORWKWK) x 52.176.
2. If PYRTBASE = 2
   EQUANSAL = PYRTAMT x 260.880.
3. If PYRTBASE = 3
   EQUANSAL = PYRTAMT x 52.176.
4. If PYRTBASE = 6
   EQUANSAL = (PYRTAMT + 0.02) x 12.000.
5. If PYRTBASE = 7
   EQUANSAL = PYRTAMT x 26.088.
6. If PYRTBASE = 9
   EQUANSAL = PYRTAMT.
7. Else set EQUANSAL = PYRTAMT.
   

NOTE: Round EQUANSAL to nearest dollar value, cents to zero.)

Note: The creation of Entitlement/Deduction Pay Rate Amount must be done first

1. aIf Pay Activity Status Code is 2 or 3
   or if PYRTBASE is not 1, 2, 3, 6, 7, 9 or if Entitlement/Deduction Pay Rate Amount (PYRTAMT) is less than $2.000
   Set Estimated Annual Salary (ESTANSAL) = zero.
2. Use a temporary field FTERATIO rounded to 7 decimals in the following calculation.
3. If Block Leave Indicator = 3 (employee on Pre-Retirement Leave)
   If Assigned Work Week (ASSWKWK) < Reduction in Hours Worked
   (REDHRS)
   Set FTERATIO = zero
   Else
   Set FTERATIO = (ASSWKWK - REDHRS) / Normal Work Week Hours
   Else
   Set FTERATIO = ASSWKWK / NORWKWK.
4. If FTERATIO > 1
   Set FTERATIO = 1.
5. If PYRTBASE = 1
   Set ESTANSAL = PYRTAMT x ASSWKWK x 52.176.
6. If PYRTBASE = 2
   Set ESTANSAL = PYRTAMT x FTERATIO x 260.880.
   
7. If PYRTBASE = 3
   Set ESTANSAL = PYRTAMT x FTERATIO x 52.176.
8. If PYRTBASE = 6
   Set ESTANSAL = PYRTAMT x FTERATIO x 12.000.
9. If PYRTBASE = 7
   Set ESTANSAL = PYRTAMT x FTERATIO x 26.088.
10. If PYRTBASE = 9
    Set ESTANSAL = PYRTAMT x FTERATIO.

(NOTE: Round ESTANSAL to nearest dollar value, cents to zero.)

Note: The creation of Entitlement/Deduction Pay Rate Amount must be done first.

A federal electoral district (FED) refers to any place or territorial area entitled to elect a representative member to serve in the House of Commons (source: Canada Elections Act, 1990).

Each FED is assigned a three-digit code that is not unique between provinces. In order to uniquely identify each FED in Canada, the code must be preceded by the two-digit province code. This concatenated code (PR + FED) is called the FED Unique ID.

Federal Electoral Districts do not cleanly map into Geographic Locations. For the 1996 data, the first FED found was assigned to a Geographic Location.

For the 2001 data a FED will be assigned to a Geographic Location based on population. The FED with the largest population in a Geographic Location will be assigned to that Geographic Location.

There is no guarantee that one way is more accurate than another.

The reasoning is as follows: An urban Geographic Location may have several FED's in it. If we assign the FED with the largest population to that GEOLOC, the situation could be inaccurate. The government buildings might be downtown (in a different riding, with lower population) than the residences, yet the FED with the largest population (with the majority of residences) was assigned to the GEOLOC.

Following are the conversion rules for FAA values from numeric to the alpha codes used in Department/Agency table:

• F= 0 - the organization is not subject to the FAA.
• A= 1 - the org. is subject to the FAA and is listed in Schedule 1.
• B = 2 - the org. is subject to the FAA and is listed in Schedule 2.
• C = 3 - the org. is subject to the FAA and is listed in Schedule 3, Part 1.
• D= 4 - the org. is subject to the FAA and is listed in Schedule 3, Part 2.
• E= 5 - the org. is subject to the FAA as a 'Branch Designated as Department' but is not listed in a Schedule.
• N or X= 6 - the org. is subject to the FAA but is not listed in a Schedule.
• "X" = Not under any of the FAA Schedules (PDED) but "N" is used in table 110
• No analogue- Crown Corporation = 7 - the organization is exempt from Part X of the FAA.

Two other values may appear in the Department/Agency table, as follows:

• G Under the FAA, by virtue of Section 7 (9) = no analogue in new FAA
• H Under the FAA, by virtue of Section 2 (c) = no analogue in new FAA