The Incumbent Data Element Dictionary was originally prepared by the Treasury Board Secretariat and then turned over to Public Works and Government Services for updating and maintenance. It's purpose is to identify and define all the data elements in the Incumbent System and identify the source of the information stored in each data element and/or the rules by which the information is generated. Where the values of a specific data element are numerous a reference is made to other documents rather then repeating the information here. As an aid to analysts and programmers reference is also made to the location of the data element on the redesigned Incumbent Master and also on other files.
BUD |
- Bargaining Unit Designator Code |
E/D |
- Entitlement/Deduction Code |
FAA |
- Financial Administration Act |
INC |
- Incumbent |
MER |
- Pay Master Employee Record File |
PAC |
- Personnel Applications Centre (PWGSC) |
PCIS |
- Position and Classification Information System |
PDED |
- Personnel Data Element Dictionary |
PPIM |
- Personnel Pay Input Manual |
PSEA |
- Public Service Employment Act |
PSSRA |
- Public Service Staff Relations Act |
PWGSC |
- The Department of Public Works and Government Services |
RETOS |
- Re-taken on strength |
SOS |
- Struck off strength |
TBS |
- Treasury Board Secretariat |
TOS |
- Taken on strength |
TSOS |
- Temporarily struck off strength |
INC.PROD.MAST |
New Incumbent Master File April 1996 |
INC.PROD.MOBILITY |
New Incumbent Mobility File April 1996 |
INC.PROD.AAMS |
New Incumbent Acting Assignment Master File April 1999 |
INC.PROD.GEOLOC |
New Incumbent Geographic Master File |
CONT.PROD.SG2401 |
Contributor System Extract |
INC.PROD.GKMST |
Previous Incumbent Master File |
INC.PROD.GKPRF |
Previous Population Reporting File |
INC.PROD.GKMOB |
Previous Incumbent Mobility File |
INC.PROD.GK34101 |
Previous reformatted Pay Transaction File |
Element Name |
Acting Pay Code |
Alias |
Pay Rate Type Indicator (MST/PRF) |
PDED No. |
N/A |
Definition |
A code which identifies whether an employee is being paid acting pay or basic pay. |
Data Source |
Derived from the Entitlement/Deduction Pay Codes on Pay
Input Form. |
Values |
1=Basic Pay 2=Acting Pay/Acting Appointment |
Remarks |
If M108 =002 set Acting Pay Code to 2 else set to 1. |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (302) INC.PROD.MOBILITY (184) and (285) |
Old File Name & Starting Position |
INC.PROD.GKMST (81) INC.PROD.GKPRF (264) |
Element Name |
Acting Start Date |
Alias |
|
PDED No. |
N/A |
Definition |
The date an acting segment starts on the Acting Assignment Management System (AAMS). |
Data Source |
Effective From Date of an start acting 18C002 on the Suspense file. |
Values |
|
Remarks |
|
Structure |
YYYYMMDD |
1996 File Name & Starting Position |
INC.PROD.AAMS (Acting Segment) (1) |
Element Name |
Acting Close Date |
Alias |
|
PDED No. |
N/A |
Definition |
The date an acting segment ends on the Acting Assignment Management System (AAMS). |
Data Source |
Effective From Date of any of a number of transactions on the Suspense file that could stop an acting. Revert to basic pay (18C001). A new start acting (18C002). A Struck Off Strength (02). A Transfer Out (03). A Promotion (06). Or by a Miscellaneous Staffing Action (05). |
(MER field) |
|
Values |
|
Remarks |
|
Structure |
YYYYMMDD |
1996 File Name &Starting Position |
INC.PROD.AAMS (Acting Segment) (25) |
Element Name |
Age Years |
Alias |
Years of Age (MOB/PRF) |
PDED No. |
18-0 |
Definition |
The number of full years elapsed since the year a person was born. |
Data Source |
Derived from the Birth Date and Processing Date |
Values |
YY |
Remarks |
Subtract Birth Date (year) from Processing Date (year) giving Age years. If Birth Date (month) is greater then Processing Date (month) subtract one from Age years. If the calculation results in a negative or Birth Date is zeros, set Age Years to zero. |
Structure |
9(2) |
1996 File Name & |
INC.PROD.MAST (252) INC.PROD.MOBILITY (59) |
Starting Position |
|
Old File Name & |
INC.PROD.GKPRF (243) INC.PROD.GKMOB (53) |
Starting Position |
Element Name |
Appointment Effective Date |
PDED No. |
2-32 |
Alias |
Position Appointed Effective Date (MST) |
Definition |
The date on which a particular appointment of an employee is effective. |
Data Source |
2517T, field 63 |
Values |
YYYYMMDD |
Remarks |
If M052 = Position Number
Else
Else
If no Suspense Record found
Else
In cases of acting assignment, INC stores the acting appointment effective date in the Appointment Effective Date field, and the substantive appointment effective date, in the Substantive Appointment Effective Date field. |
Structure |
X(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (90) INC.PROD.MOBILITY ( 138) & (239) |
Old File Name & Starting Position |
INC.PROD.GKMST (208) INC.PROD.GKMOB (125) & (221) |
Element Name |
Appointment Effective Date (PCIS) |
PDED No. |
N/A |
Alias |
|
Definition |
The date on which a particular appointment of an employee is effective. |
Data Source |
PCIS Master |
Values |
YYYYMMDD |
Remarks |
The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, Employee Class (EMPCLS) andDepartment (DEPT)
Note: The creation of NOCID must be done first |
Structure |
X(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (458) |
Old File Name & Starting Position |
N/A |
Element Name |
Appointment Language Status Code |
Alias |
Appointment Status (MST/PRF) |
PDED No. |
200-0 |
Definition |
A code which identifies the language status of an employee's appointment under the Public Service Official Languages Appointment Regulations. |
Data Source (MER field) |
2517-T, field 55 |
Values |
Refer to the Personnel Pay Input Manual (PPIM), Section 3-5-3 for a list of code values. |
Remarks |
If M055 not = to blank and not = zero
else
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (255) |
Old File Name & Starting Position |
INC.PROD.GKMST (330) |
Element Name |
Assigned Work Week Hours |
Alias |
Assigned Work Week (MST/PRF) |
PDED No. |
8-2 |
Definition |
The hours per week an employee is assigned to work if less than a normal work week. |
Data Source |
2517T, field 33 |
Values |
|
Remarks |
|
Structure |
99v99 (v = implied decimal) |
1996 File Name & Starting Position |
INC.PROD.MAST (234) |
Old File Name & Starting Position |
INC.PROD.GKMST (106) INC.PROD.GK34101 (114) |
Element Name |
Association/Union Code |
Alias |
Association Code (MST/PRF/MOB) |
PDED No. |
54-0 |
Definition |
A code which identifies the union or association to which an employee pays membership dues. |
Data Source |
The Association Code is derived from the BUD Code. |
Values |
|
Remarks |
Incumbent BUD/Association Table associates the Bargaining Unit Code with Association/Union Codes. It is present for all PSSRA 1-1 employees. In most cases, the Association Code is the last 2 characters of the regular Deduction Code for union deductions. |
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (297) INC.PROD.MOBILITY (182) & (283) |
Old File Name & Starting Position |
INC.PROD.GKMST (155) INC.PROD.GKPRF (178) |
Element Name |
Bargaining Unit Designator Code |
Alias |
Bargaining Unit Designator (PRF/MOB) |
PDED No. |
29-0 |
Definition |
Identifies collective bargaining units by category, group and sub-group and supervisors of the same group that have formed a separate bargaining unit. Also used to identify occupations not subject to collective bargaining. |
Data Source (MER field) |
2517T, field 25 |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-3 for the list of codes. |
Remarks |
The known acronym is BUD. For PSSRA 1-1 BUD's, the first character identifies occupational category, the second two, the group and the last two, the sub-group. |
Structure |
X(5) |
1996 File Name & Starting Position |
INC.PROD.MAST (183) INC.PROD.MOBILITY (99) & (200) |
Old File Name & Starting Position |
INC.PROD.GKMST (126) INC.PROD.GK34101 (90) |
Element Name |
Bilingualism Bonus Code |
Alias |
Bilingual Bonus (MST) |
PDED No. |
202-0 |
Definition |
A code which identifies the bilingualism bonus an employee is being paid. |
Data Source |
Generated from field 62 on 2517T. (Based on entitlement portion of MER file. |
Values |
1= Bilingual Bonus (7%) 2= Bilingual Bonus ($800.00 per yr) Blank = No Bilingual Bonus |
Remarks |
If the employee has a pay action 18C/A007
Else
Else
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (257) |
Old File Name & Starting Position |
INC.PROD.GKMST (161) INC.PROD.GKPRF (192) |
Element Name |
Bindery Pay Zone Code |
Alias |
N/A |
PDED No. |
9-9 (New) |
Definition |
A code which identifies the geographic pay zones for the Bindery (PRBIN) occupational group and sub-group. |
Data Source |
Derived from the Pay Zone Code for BUD's 60901 and 65901 |
Values |
Refer to the Pay Input Manual (PPIM), Section 9.4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (107) |
Element Name |
Birth Date |
Alias |
Date of Birth (MST/PRF/MOB) |
PDED No. |
2-1 |
Definition |
The date a person was born. |
Data Source |
2517T, field 16 or from Contributor System Extract |
(MER field) |
(M016) |
Values |
YYYYMMDD |
Remarks |
Set from M016 and reset from Contributor System |
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (244) INC.PROD.MOBILITY (33) |
Old File Name & Starting Position |
INC.PROD.GKMST (68) INC.PROD.GKPRF (186) |
Element Name |
Block Leave Indicator |
Alias |
N/A |
PDED No. |
N/A |
Definition |
Indicates whether the employee is or was on Leave With Income Averaging (LIA) or Pre-retirement Transition Leave (PRL). |
Data Source (MER field) |
2517T, field 70 |
Values |
1 - currently on LIA and contributes to Superannuation (Sup) and Death Benefit (DB) based on full salary rate. 2 - currently on LIA and contributes to Sup and DB based on reduced salary. 3 - currently on PRL and contributes to Sup and DB based on full salary rate. 4 - previously on LIA contributed to Sup and DB based on full salary rate. 5 - previously on LIA contributed to Sup and DB based on reduced salary. 6 - previously on PRL contributed to Sup and DB based on full salary rate. |
Remarks |
Values 1-3 are input by departments; 4-6 are generated by the Regional Pay System when LIA/PRL entitlements are stopped. Data Element added April 1996. |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (418) |
Element Name |
Census Agglomeration Code |
Removed starting with Incumbent Master File of February, 2005 | |
Alias |
Current Census Agglom. & Prim CA (PRF) |
PDED No. |
N/A |
Definition |
A code used in the latest StatCan Census to identify an urban area with a population of between 10,000 and 100,000, together with adjacent urban and rural areas which are highly integrated economically and socially with that urban area. |
Data Source |
Stat Can GeoRef 1996 Census through the PWGSC Geographic Master File. |
Values |
See StatCan Publication "Census Metropolitan Areas and Census Agglomerations" |
Remarks |
The Incumbent table, Geographic Master File associates the Geographic Location Code with the Census Agglomeration Code. That data in this field may be inaccurate. |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (373) INC.PROD.GEOLOC (64) |
Old File Name & Starting Position |
INC.PROD.GKPRF (251) |
Element Name |
Census Agglomeration/Census Metropolitan Area (CA/CMA) |
Valid Starting with the Incumbent Master File of February 2005 | |
Alias |
|
PDED No. |
N/A |
Definition |
Census metropolitan areas (CMAs) and census agglomerations (CAs) are assigned three-digit codes that uniquely identify each metropolitan area in Canada. The first digit is the same as the second digit of the province code in which the CMA or CA is located. If a CMA or CA spans a provincial boundary, then the province code assigned represents the province with the greater proportion of urban core population. Codes for CMAs or CAs in the Yukon Territory and the Northwest Territories begin with the "9", the same digit as those located in British Columbia. Census Agglomeration (CA) A census agglomeration (CA) is a large urban area (known as the urban core) together with adjacent urban and rural areas (known as urban and rural fringes) that have a high degree of social and economic integration with the urban core. A CA has an urban core population of at least 10,000, based on the previous census. However, if the population of the urban core of a CA declines below 10,000, the CA is retired. Once a CA attains an urban core population of at least 100,000, based on the previous census, it is eligible to become a CMA. CAs that have urban cores of at least 50,000, based on the previous census, are subdivided into census tracts. Census tracts are maintained for CAs even if the population of the urban cores subsequently fall below 50,000. A CA may be consolidated with adjacent CAs if they are socially and economically integrated. This new grouping is called a consolidated CA and the component CAs are called primary census agglomerations (PCAs). The CMAtype field identifies whether the CA is consolidated or regular. Census Metropolitan Area (CMA) A census metropolitan area (CMA) is a very large urban area (known as the urban core) together with adjacent urban and rural areas (known as urban and rural fringes) that have a high degree of social and economic integration with the urban core. A CMA has an urban core population of at least 100,000, based on the previous census. Once an area becomes a CMA, it is retained as a CMA even if the population of its urban core declines below 100,000. All CMAs are subdivided into census tracts. A CMA may be consolidated with adjacent census agglomerations (CAs) if they are socially and economically integrated. This new grouping is known as a consolidated CMA and the component CMA and CA(s) are known as the primary census metropolitan area (PCMA) and primary census agglomeration(s) [PCA(s)]. A CMA may not be consolidated with another CMA. The CMAtype field identifies whether the CMA is consolidated or regular. |
Data Source |
Stat Can GeoRef 1996 Census CD through the PWGSC Geographic Master File. |
Values |
See StatCan Publication "Census Metropolitan Areas and Census Agglomerations" |
Remarks |
The Incumbent table, Geographic Master File associates the Geographic Location Code with the CA/CMA Code. |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (373) INC.PROD.GEOLOC (64) |
Old File Name & Starting Position |
INC.PROD.GKPRF (251) |
Element Name |
Census Area Code |
Remove starting with Incumbent Master File of February, 2005 | |
Alias |
Census Agglomeration Code (PRF) |
PDED No. |
126-0 |
Definition |
A code which identifies the previous census agglomeration area as defined by Statistics Canada, Census Division. |
Data Source |
StatCan GeoRef 1996 Census CD through the PWGSC Geographic Master File. |
Values |
This is the previous version of the StatCan Census Agglomeration Code. Values between 001-030 denote Metropolitan areas; values greater than 030, other than urban areas. Metropolitan Area is the last two characters of Census Area Code. |
Remarks |
The Incumbent table, Geographic Master File, associates the Geographic Location Code with the Census Area Code. This data field is inaccurate, hence was removed in February, 2005. |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (358) INC.PROD.GEOLOC (76) |
Old File Name & Starting Position |
INC.PROD.GKPRF (222) |
Element Name |
CMA Type |
Valid starting with the Incumbent Master File of February, 2005 | |
Alias |
|
PDED No. |
N/A |
Definition |
The CMAtype field identifies whether the Geographic unit is a CMA (Census Metropolitan Area) or a CA (Census Agglomeration). |
Data Source |
Stat Can GeoRef 1996 CD through the PWGSC Geographic Master File.. |
Values |
CMA Location Type Type A Consolidated CMA |
Remarks |
The Incumbent table, Geographic Master File associates the Geographic Location Code with the CMAType Code. |
Structure |
X(1) |
1996 File Name & Starting Position |
INC.PROD.MAST (370) INC.PROD.GEOLOC (64) |
Old File Name &Starting Position |
INC.PROD.GKPRF (251) |
Element Name |
Communication Requirements Code of the Position (PCIS) |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A code which identifies certain functions of the position and the official language or languages required to carry out these functions. |
Data Source (PCIS field) |
PCIS Master |
Values |
0 = Not required 1 = Both English and French 2 = English only 3 = French only 4 = Either French or English |
Remarks |
The 1st character refers to service to the public The 2nd character refers to the provision of personal services to federal employees The 3rd character refers to the provision of central services to federal employees The 4th character refers to supervisory functions The 5th character refers to a formal level in the grievance process The 6th character refers to other functions The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, Employee Class (EMPCLS) and Department (DEPT)
Note: The creation of NOCID must be done first |
Structure |
X(6) |
1996 File Name & Starting Position |
INC.PROD.MAST (474) |
Old File Name &Starting Position |
N/A |
Element Name |
Cold Type Composition Pay Zone Code |
Alias |
N/A |
PDED No. |
9-6 (New) |
Definition |
A code which identifies the geographic pay zones for the Cold Type Composition (PRCTC) occupational group and sub-group. |
Data Source |
Derived from the Pay Zone Codes for BUD's 60902 and 65902 |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (99) |
Element Name |
Composition Pay Zone Code |
Alias |
N/A |
PDED No. |
9-5 (New) |
Definition |
A code which identifies the geographic pay zones for the Composition (PRCOM) occupational group and sub-group. |
Data Source |
Derived from the Pay Zone Codes for BUD's 60903 and 65903 |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (101) |
Element Name |
Continuous Employment Start Date |
Alias |
Continuous Service Start Date (MST) Date Start Continuous Service (PRF) Date Started Continuous Service (MOB) |
PDED No. |
2-53 |
Definition |
The start date of an employee's continuous employment in the Public Service as defined in the Public Service Terms and Conditions of Employment Regulations. |
Data Source |
2517T, field 45 |
Values |
YYYYMMDD |
Remarks |
If M045 not = blank and not = zero.
Else
|
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (165) INC.PROD.MOBILITY (43) |
Old File Name & Starting Position |
INC.PROD.GKMST (266) INC.PROD.GK34101 (128) |
Element Name |
Continuous Employment Years |
Alias |
Years of Continuous Service (PRF/MOB) |
PDED No. |
24-0 |
Definition |
The number of years of continuous employment in the Public Service as defined in the Public Service Terms and Conditions of Employment Regulations. |
Data Source |
Calculated from the Continuous Employment Start Date and Processing Date |
Values |
YY |
Remarks |
Subtract Continuous Employment Start Date (years) from the Processing Date (years) giving Continuous Employment Years. If Continuous Employment Start Date (months) is greater than Processing Date (months) subtract one from Continuous Employment Years. If the calculation results in a negative or Continuous Employment Start Date is zero, set Continuous Employment Years to zero. |
Structure |
9(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (173) INC.PROD.MOBILITY (61) |
Old File Name & Starting Position |
INC.PROD.GKPRF (198) INC.PROD.GKMOB (55) |
Element Name |
Death Benefit Eligibility Indicator |
Alias |
Death Benefit Eligibility (MST/PRF) |
PDED No. |
11-0 |
Definition |
Identifies whether an employee is eligible to contribute to the Supplementary Death Benefit (SDB) Plan. |
Data Source |
2517T, field 37 |
Values |
1 = Eligible to contribute to SDB, 2 = Not eligible to contribute to SDB |
Remarks |
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (266 |
Old File Name & Starting Position |
INC.PROD.GKMST (158) INC.PROD.GK34101 (123) |
Element Name |
Department/Agency Code |
Alias |
Department /Agency (MST), Department or Agency Code (PRF) |
PDED No. |
1-0 |
Definition |
A system processing code which identifies a federal organization structured to carry out programs or activities specified by Parliament. |
Data Source |
2517T, field 10 |
Values |
The list of valid Department Codes is maintained on Incumbent Department/Agency Table. TBS supplies new Department Codes via the Population Affiliation System. |
Remarks |
Ignore MER records with Dept Code = CAE, CCA, CPC, DNT,
DPW, DSS, EIC, |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (36) INC.PROD.MOBILITY (86) & (187) |
Old File Name & Starting Position |
INC.PROD.GKMST (14) INC.PROD.GK34101 (23) |
Element Name |
Department/Agency Employment Start Date |
Alias |
Date Incumbent Started at Ministry (MST) |
PDED No. |
2-34 |
Definition |
The date employee starts employment with a department or agency, or the effective date of a movement to a new department or agency due to a restructure |
Data Source |
2517T, field 63, or Bulk Change Table |
Values |
YYYYMMDD |
Remarks |
If bulk change to department code
If M010 = Dep't
Else
|
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (39) |
Old File Name & Starting Position |
INC.PROD.GKMST (10) INC.PROD.GKPRF (258) |
Element Name |
Department Start Date Prior to Restructure |
Alias |
|
PDED No. |
N/A (field created in may 2004) |
Definition |
The date employee starts employment with a department or agency prior to being moved to a new department as part of government restructure. |
Data Source |
Previous Incumbent Master |
Values |
YYYYMMDD |
Remarks |
If bulk change to department code and the Bulk Change
argument Effective Date >
If M010 = Dep't
Else
|
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (50) |
Old File Name & Starting Position |
Element Name |
Disability Insurance Eligibility Code |
Alias |
Disability Insurance Eligibility (MST/PRF) |
PDED No. |
13-0 |
Definition |
A code which identifies the eligibility of an employee to contribute to the Disability Insurance Plan (DI) Plan or the Long Term Disability Insurance (LTD) Plan of the Public Service Management Insurance Plan (PSMIP) or to neither. |
Data Source |
2517T, field 47 |
Values |
1= DI Plan Contributor 2= LTD Plan Contributor |
Remarks |
Reference: Pay Input Manual (PPIM), Section 3-5-3 |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (265) |
Old File Name & Starting Position |
INC.PROD.GKMST (157) INC.PROD.GK34101 (136) |
Element Name |
Dual Remuneration Code |
Alias |
Dual Remuneration Indicator (MST) |
PDED No. |
15-0 |
Definition |
Identifies whether the employee is receiving or ceases to receive dual remuneration on two pay lists within a department or from another department within the PWGSC Pay System. |
Data Source |
2517T, field 19 |
Values |
Blank=Employee does not receive dual remuneration 1=Employee receives dual remuneration 2=Employee ceases receiving dual remuneration |
Remarks |
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (417) |
Old File Name & Starting Position |
INC.PROD.GKMST (283) INC.PROD.GK34101 (79) |
Element Name |
Economic Region Code |
Alias |
N/A |
PDED No. |
127-0 |
Definition |
A code which identifies the economic region selected for employment studies. |
Data Source |
StatCan GeoRef 1996 Census CD through the PWGSC Geographic Master File. |
Values |
|
Remarks |
An economic region (ER) is a grouping of complete census divisions (with one exception in Ontario). Economic regions are used to analyse regional economic activity. Each economic region (ER) is assigned a two-digit code that is not unique between provinces. In order to uniquely identify each ER in Canada, the code must be preceded by the two-digit province code. This concatenated code (PR + ER) is called the Economic Region Unique ID. |
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (356) |
Old File Name & Starting Position |
INC.PROD.GKPRF (220) GEOGMAST (71) |
Element Name |
Effective Date of Change |
Alias |
N/A |
PDED No. |
|
Definition |
The effective date of a mobility change. |
Data Source |
Field 63 on the Suspense transaction. |
Values |
YYYYMMDD |
Remarks |
The significance of the date is related to the type of Mobility event (record). For example: the Effective Date of Change of a separation event (Mobility Code values 3100 or 3150) is the employee's Struck Off Strength (SOS) Date. |
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MOBILITY (74) |
Old File Name & Starting Position |
INC.PROD.GKMOB (66) |
Element Name |
Elective Pensionable Service Amount |
Alias |
Previous Elective Pensionable Service (MST) |
PDED No. |
62-1 (New) |
Definition |
The amount of service, for which an employee has made a valid election to count as pensionable service under the Public Service Superannuation Act. |
Data Source |
Contributor System. |
Values |
YYMM |
Remarks |
The Incumbent System receives this information in "YYDDD.D'' format from the Contributor System and converts it into "YYMM'' format. The days (DDD.D) of service are divided by 30.5 and the result stored as months (MM). |
Structure |
X(4) |
1996 File Name & Starting Position |
INC.PROD.MAST (405) CONT.PROD.SG2401 (45) |
Old File Name & Starting Position |
INC.PROD.GKMST (173) INC.PROD.GKPRF (298) |
Element Name |
Employee Classification Code |
Alias |
Abbrev Classification Title (MST) |
PDED No. |
94-1 |
Definition |
A code which identifies an employee's occupational group, sub-group and level. |
(MER field) |
2517T, field 27 |
Values |
Refer to the Personnel Pay Input Manual (PPIM), Section 9-3 for the list of the codes. |
Remarks |
The first two characters identify the occupational group; the next three, the sub-group; and the last two characters, the level. In cases of acting assignment, INC stores the acting employee classification in the Employee Classification Code field, and the substantive employee classification, in the Substantive Employee Classification Code field. |
Structure |
X(7) |
1996 File Name & Starting Position |
INC.PROD.MAST (196) INC.PROD.MOBILITY (106) & (207) |
Old File Name & Starting Position |
INC.PROD.GKMST (115) INC.GKMOB22 (95) & (191) |
Element Name |
Employee Classification Code Effective Date |
Alias |
Effective Date Emp. Class Chg (PRF) Employee Classification Effective Date (MST) Employee Class. Effective Date (MOB) |
PDED No. |
2-114 (New) |
Definition |
The effective date an employee Classification code is changed. |
Data Source |
2517T, field 63 |
Values |
YYYYMMDD |
Remarks |
If M027 = Employee Classification
Else
Else
Else
In cases of acting assignment, INC stores the acting employee classification effective date in the Employee Classification Effective Date field, and the substantive employee classification effective date, in the Substantive Employee Classification Effective Date field. |
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (203) INC.PROD.MOBILITY (113) & (214) |
Old File Name & Starting Position |
INC.PROD.GKPRF (127) INC.PROD.GKMST (122) |
Element Name |
Employee Collective Bargaining Status Code |
Alias |
Exclusion Status (MST/MOB) |
PDED No. |
30-0 |
Definition |
A code which identifies the collective bargaining status of an employee, as defined by the Public Service Staff Relations Act (PSSRA). |
Data Source |
2517T, field 26 |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-2 for the list of codes. |
Remarks |
Employees who are not excluded from collective bargaining have a Bargaining Status Code which starts with "1" or "3". |
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (221) INC.PROD.MOBILITY (104) & (205) |
Old File Name & Starting Position |
INC.PROD.GKMST (149) INC.PROD.GK34101 (95) |
Element Name |
Employee Family Name |
Alias |
Family Name (MST) |
PDED No. |
4-1 |
Definition |
The family name of an employee. |
Data Source |
2517T, field 14 |
Values |
|
Remarks |
The first four characters are commonly referred to as the employee's "Name Tag". |
Structure |
X(20) |
1996 File Name & Starting Position |
INC.PROD.MAST (10) INC.PROD.MOBILITY (10) |
Old File Name & Starting Position |
INC.PROD.GKMST (25) INC.PROD.GKMOB (10) |
Element Name |
Employee Geographic Location Code |
Alias |
Geographic Location Code (MST/PRF/MOB) |
PDED No. |
10-3 |
Definition |
A code which identifies the geographic location of an employee's place of work. |
Data Source |
2517T, field 20 |
Values |
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 91
Europe A list of these codes can be obtained from PAC. |
Remarks |
Beginning in March 2004 the Employee Geographic Location Code (GEOLOC) will contain the 7 character Geographic Location from Statistics Canada Code If M020 = spaces or zeros
Else
|
Structure |
X(7) |
1996 File Name & Starting Position |
INC.PROD.MAST (69) INC.PROD.MOBILITY (92) & (193) |
Old File Name & Starting Position |
INC.PROD.GKMST (216) INC.PROD.GKPRF (115) |
Element Name |
Employee Type Code |
Alias |
Employee Type (MST/PRF/MOB) |
PDED No. |
44-0 |
Definition |
A code which identifies the employment status of an employee. |
Data Source |
2517T, field 31 |
Values |
See Pay Input Manual, PPIM Section 3-5-3 for codes. |
Remarks |
This code indicates whether an employee is employed on a full-time/part-time; indeterminate, term (under/over 3 mos.), casual, or seasonal basis. The INC System ignores casual (type `M') and employees TOS for retroactive payments (type `X'). |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (211) INC.PROD.MOBILITY (91) & (192) |
Old File Name & Starting Position |
INC.PROD.GKMST (110) INC.PROD.GK34101 (109) |
Element Name |
End Date of Salary Reduction |
Alias |
End of Block Leave |
PDED No. |
New |
Definition |
This element will identify the last day of the period of salary reduction due to Leave With Income Averaging (LIA) or Pre-retirement Transition Leave. |
Data Source |
2517T, field 64 |
Values |
YYYYMMDD |
Remarks |
If Block Leave Indicator is 1, 2 or 3
Data element added April 1996. |
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (432) |
Element Name |
Entitlement Effective Start Date |
Alias |
Start Date of Pay Rate Amount (MST/PRF) |
PDED No. |
2-18 |
Definition |
The effective date an entitlement starts. |
Data Source |
2517T, field 63 |
Values |
YYYYMMDD |
Remarks |
If M101 not = old Entitlement/Deduction Pay Rate Amount
Else
If M110 not = old DTSTTAMT
Note: The creation of Reduced Salary Amount must be done first. |
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (123) |
Old File Name & Starting Position |
INC.PROD.GKMST (95) INC.PROD.GK34101 (36) |
Element Name |
Entitlement Effective Stop Date |
Alias |
Final Date Of Pay Rate Amount (MST/PRF) |
PDED No. |
2-19 |
Definition |
The effective date an entitlement stops. On the SOS file this field contains the date the employee was struck off strength. On the master file this field contains the start date of LWOP if the employee is on leave with out pay or the end date of the term of employment if the person is a term employee. |
Data Source |
2517T, field 63 |
Values |
YYYYMMDD |
Remarks |
If Pay Activity Status Code is not = 1
(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
Reset DTSTPAMT = Entitlement Effective Start Date from Pay (M110)
If Employee Type Code = old Employee Type Code
Else
If Pay Activity Status Code = 1
If Pay Activity Status Code = 1 and Employee Type Code
> D |
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (157) |
Old File Name & Starting Position |
INC.PROD.GKMST (99) INC.PROD.GKPRF (275) INC.PROD.GK34101 (168) |
Element Name |
Entitlement/Deduction Pay Rate/Amount |
Alias |
Pay Rate Amount (MST) |
PDED No. |
36-0 |
Definition |
The pay rate or amount of an entitlement or deduction expressed in dollars, cents or a percentage, to three decimal points. |
Data Source |
2517T, field 66 |
(M101) |
|
Values |
|
Remarks |
The only entitlement amounts copied to the system are Basic Pay (E/D Code 001) or Acting Pay (E/D Code 002). Employees on Educational Leave with Allowance are not identified by the Pay Activity Status in the Pay System. Instead they are considered to be on "Basic Pay" and the amount is replaced with the Educational Allowance (E/D code 077). Therefore If M101 not = old Entitlement/Deduction Pay Rate Amount
(PYRTAMT)
Else
Note: The creation of Reduced Salary Amount must be done first. |
Structure |
9(6)v999 (v = implied decimal) |
1996 File Name & Starting Position |
INC.PROD.MAST (114) |
Old File Name & Starting Position |
INC.PROD.GKMST (90) INC.PROD.GK34101 (176) |
Element Name |
Equivalent Annual Salary Amount |
Alias |
Equivalent Annual Salary (Estimated ) (MST) |
PDED No. |
56-2 |
Definition |
The conversion of hourly, weekly, monthly rated salary to an annual salary. |
Data Source |
Generated from Pay Rate Base Code, Salary Amount, & Normal Work Week Hours (for hourly rates). |
Values |
|
Remarks |
a. If Pay Rate Base (PYRTBASE) = 1 b. If PYRTBASE = 2
c. If PYRTBASE = 3
d. If PYRTBASE = 6
e. If PYRTBASE = 7
f. If PYRTBASE = 9 g.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 |
Structure |
9(6)v999 (v = implied decimal) |
1996 File Name & Starting Position |
INC.PROD.MAST (131) INC.PROD.MOBILITY (146) & (247) |
Old File Name & Starting Position |
INC.PROD.GKMST (76) INC.PROD.GKPRF (229) |
Element Name |
Estimated Annual Salary Amount |
Alias |
Estimated Annual Salary (MST/PRF) |
PDED No. |
56-4 (New) |
Definition |
The amount of salary an employee is estimated to earn during the year. |
Data Source |
Calculated from Equivalent Annual Salary Amount, Normal Work Week Hours and Assigned Work Week Hours. |
Values |
Part-time employees salaries, Estimated Annual and Equivalent Annual are different. |
Remarks |
a. If Pay Activity Status Code is 2 or 3
b. Use a temporary field FTERATIO rounded to 7 decimals in the following calculation. c. If Block Leave Indicator = 3 (employee on Pre-Retirement Leave)
Else
Else
d. If FTERATIO > 1
e. If PYRTBASE = 1
f. If PYRTBASE = 2
g. If PYRTBASE = 3
h. If PYRTBASE = 6
i. If PYRTBASE = 7
j. If PYRTBASE = 9
(NOTE: Round ESTANSAL to nearest dollar value, cents to zero.) *Note: The creation of Entitlement/Deduction Pay Rate Amount must be done first. |
Structure |
9(6)v999 (v = implied decimal) |
1996 File Name & Starting Position |
INC.PROD.MAST (140) |
Old File Name & Starting Position |
INC.PROD.GKMST (325) INC.PROD.GKPRF (343) |
Element Name |
Federal Electoral District Code |
Alias |
Federal Electoral District (PRF) |
PDED No. |
166-0 |
Definition |
A code that identifies the specific areas designated by Parliament as Federal Electoral Districts. |
Data Source |
StatCan GeoRef 1996 Census CD through the PWGSC Geographic Master File. |
Values |
|
Remarks |
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. |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (362) INC.PROD.GEOLOC (85) |
Old File Name & Starting Position |
INC.PROD.GKPRF (226) |
Element Name |
File Date |
Alias |
Date of File Year/Month |
PDED No. |
N/A |
Definition |
The processing year and month that a file is created. It resides on every record in the file and is the same date for every record. |
Data Source |
Generated from the processing date |
Values |
YYYYMM |
Remarks |
|
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (495) INC.PROD.MOBILITY (68) |
Element Name |
Financial Administration Act Code |
Alias |
N/A |
PDED No. |
58-0 |
Definition |
A code which identifies the legal status of a department or agency under the Financial Administration Act (FAA). |
Data Source |
TBS Population Affiliation System. Derived from Dep't code. |
Values |
Following are the conversion rules for FAA values from
numeric to the alpha codes F = 0 - the organization is not subject to 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 |
Remarks |
Incumbent Department/Agency table associates Dep't/Agency code with the FAA code. |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (296) INC.PROD.MOBILITY (89) & (190) |
Old File Name & Starting Position |
INC.PROD.GKMST (17) INC.PROD.GKPRF (177) |
Element Name |
Financial Code |
Alias |
Financial Coding (MST) |
PDED No. |
59-0 |
Definition |
A code of varying length and structure (unique to department or agency) which identifies items of expenditure. |
Data Source |
2517T, field 71 |
(MER field) |
(M105) |
Values |
|
Remarks |
The structure of this code varies from Department to Department. |
Structure |
X(25) |
1996 File Name & Starting Position |
INC.PROD.MAST (270) INC.PROD.MOBILITY (157) & (258) |
Old File Name & Starting Position |
INC.PROD.GKMST (230) INC.PROD.GK34101 (201) |
Element Name |
Financial Program Activity Code |
Alias |
Central Accounts Program/Activity code (PRF) |
PDED No. |
N/A |
Definition |
The code used in the TBS Financial Management Chart of Accounts to denote the programs and activities of the Government of Canada for a fiscal year. |
Data Source |
No longer available. Was originally obtained from the Central Accounting System output file CA920 (for Auditor General). |
Values |
See TBS Financial Management Manual. |
Remarks |
|
Structure |
|
1996 File Name & Starting Position |
Was removed from INC.PROD.MAST (64) |
Old File Name & Starting Position |
INC.PROD.GKPRF (6) |
Element Name |
First Official Language Code |
Alias |
First Official Language (MST/PRF) |
PDED No. |
8-0 |
Definition |
A code which identifies the official language with which an employee feels a primary personal identification. |
Data Source |
2517-T, field 54 |
Values |
1 = English; |
Remarks |
The known acronym is FOL. If M054 is not = blank and not = zero
Else
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (254) |
Old File Name & Starting Position |
INC.PROD.GKMST (324) INC. PROD.GK34101 (43) |
Element Name |
First Official Language Code (PCIS) |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A code which identifies the official language with which an employee feels a primary personal identification. |
Data Source |
PCIS Master |
Values |
1 = English; |
Remarks |
The Incumbent table, National Occupation Classification
(NOC) Code Table (which also contains additional PCIS fields) is created
from the PCIS Master. The Incumbent Master file is then matched with this
table using the key : PRI, Employee Class (EMPCLS) and Department (DEPT)
Note: The creation of NOCID must be done first |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (480) |
Old File Name & Starting Position |
N/A |
Element Name |
Forces Pensionable Service Amount |
Alias |
Previous Forces Pensionable Service (MST) |
PDED No. |
62-3 (New) |
Definition |
The amount of Armed Forces service for which an employee has made a valid election to count as pensionable service under the Public Service Superannuation Act. |
Data Source |
Contributor System. |
Values |
YYMM |
Remarks |
The Incumbent receives this information in "YYDDD.DD''format from the Contributor System and converts it to "YYMM'' format. The number of days (DDD.D) is divided by 30.5 and the result stored as months (MM). Includes annuity service credit under RCMPSA or CFSA. |
Structure |
X(4) |
1996 File Name & Starting Position |
INC.PROD.MAST (413) CONT.PROD.SG2401 (57) |
Old File Name & Starting Position |
INC.PROD.GKMST (361) INC.PROD.GKPRF (394) |
Element Name |
Full-time Equivalent Ratio |
Alias |
Full Time Equivalent (PRF) |
PDED No. |
N/A |
Definition |
A measure of the extent to which an employee represents a full person-year charge against departmental budgets. |
Data Source |
Calculated from the employee's Activity Status, Assigned Work Week and Normal Work Week Hours. |
Values |
|
Remarks |
The known acronym is FTE. Falls within the range zero to 1.00. |
If Pay Activity Status not = 1 or Assigned Work Week (ASSWKWK) = zero or Reduction in Hours Worked (REDHRS) > ASSWKWK
Else
Else
If FTE > 1
|
|
Structure |
9v99 (v = implied decimal) |
1996 File Name & Starting Position |
INC.PROD.MAST (239) |
Old File Name & Starting Position |
INC.PROD.GKPRF (71) |
Element Name |
General Labour & Trade Pay Zone Code |
Alias |
N/A |
PDED No. |
9-1 (New) |
Definition |
A code which identifies the geographic pay zones for the General Labor and Trades (GL) occupational group. |
Data Source |
Derived from the Pay Zone Codes for BUD's 603 and 653. |
Values |
Refer to the Pay Input Manual (PPIM) Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (91) |
Element Name |
General Services Pay Zone Code |
Alias |
N/A |
PDED No. |
9-2 (New) |
Definition |
A code which identifies the geographic pay zones for the General Service(GS) occupational group. |
Data Source |
Derived from the Pay Zone Code for BUD's 604 and 654. |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (93) |
Element Name |
Geographic Location Name |
Alias |
Location Name (PRF) |
PDED No. |
170-1 (New) |
Definition |
The name of the location associated with a Geographic Location Code. |
Data Source |
StatCan GeoRef 1996 Census CD through the PWGSC Geographic Master File. |
Values |
Most Geographic Location Names are official names passed by provincial or territorial legislation for municipalities. These names can only be changed through the provincial legislative process. |
Remarks |
The Incumbent table, Geographic Master, associates the Geographic Location Code with the Geographic Location Name. The name is 40 characters on the table but only the first 20 are move to the Incumbent master. Names are stored on the PWGSC Geographic Master File and Incumbent Master File in upper case with no accented characters. |
Structure |
X(20) |
1996 File Name & Starting Position |
INC.PROD.MAST (336) INC.PROD.GEOLOC (11) |
Old File Name & Starting Position |
INC.PROD.GKPRF (200) |
Element Name |
Hospital Services Pay Zone Code |
Alias |
N/A |
PDED No. |
9-3 (New) |
Definition |
A code which identifies the geographic pay zones for the Hospital Services(HS) occupational group. |
Data Source |
Derived from the Pay Zone Code for BUD's 606 and 656. |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (95) |
Element Name |
Imperative Staffing Indicator (PCIS) |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A code which identifies that the language requirements of a bilingual position must be completely satisfied at the time of appointment or deployment and the reason for these requirements |
Data Source |
PCIS Master |
Values |
1 = Special skills - Imperative staffing action for a bilingual position involving specialized or expert language usage in all the linguistic skills required by the position in both official languages 2 = Special relationship - Imperative staffing action for a bilingual position which involves special relationships to a particular community or group, or having significant operational impact 3 = Indispensable bilingual position - Imperative staffing action for an indispensable bilingual position 4 = Specified period appointment or deployment - Imperative staffing action for a bilingual position requiring an appointment or a deployment for a PER specified period |
Remarks |
The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, Employee Class (EMPCLS) and Department (DEPT) If NOC Code Indicator (NOCID) = '3' and IMP (PCIS) not = blank
Note: The creation of NOCID must be done first |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (467) |
Old File Name & Starting Position |
N/A |
Element Name |
Initials |
Alias |
Initials of Given Names (MST) |
PDED No. |
5-0 |
Definition |
The first letter of each name given to a person to identify this person in a somewhat precise way. |
Data Source |
2517T, field 15 |
Values |
|
Remarks |
|
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (30) INC.PROD.MOBILITY (30) |
Old File Name & Starting Position |
INC.PROD.GKMST (45) INC.PROD.GK34101 (70) |
Element Name |
Inmate Training Differential Code |
Alias |
Inmate Training Differential Grid (MST/PRF) |
PDED No. |
102-0 |
Definition |
A code which identifies the rate of differential payable to qualified employees responsible for inmate training. |
Data Source |
2517T, field 29. |
Values |
See the Personnel Pay Input Manual (PPIM), Section 3-5-3 for acceptable values. |
Remarks |
Applies to Penitentiary Service employees only. The first character represents the degree of training responsibility; the second, a coded representation of number of inmates trained. |
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (263) |
Old File Name & Starting Position |
INC.PROD.GKMST (143) INC.PROD.GK34101 (106) |
Element Name |
Language Requirements of Position (PCIS) |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A code which identifies the official language or languages required to perform the duties of the position. |
Data Source |
PCIS Master |
Values |
1 = Bilingual |
Remarks |
The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, Employee Class (EMPCLS) and Department (DEPT)
Note: The creation of NOCID must be done first |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (466) |
Old File Name & Starting Position |
N/A |
Element Name |
Last Update Date |
Alias |
|
PDED No. |
|
Definition |
The last date that a portion of the acting segment of the AAMS file has been updated.. |
Data Source |
|
Values |
|
Remarks |
Set to the processing date when the During or Following portion of the acting segment has been modified. |
Structure |
YYYYMM |
1996 File Name & Starting Position |
INC.PROD.AAMS (251) & (365) |
Element Name |
Leave Without Pay Reason Code |
Alias |
Reason for Leave Without Pay (MST) |
PDED No. |
106-0 |
Definition |
A code which identifies the reason why an employee is on leave without pay (LWOP). |
Data Source |
2517T, field 71 |
Values |
Refer to the Personnel Pay Input Manual (PPIM), Section 4-4-13 (PAC13) for the list of code values. |
Remarks |
Only LWOP absences of 6 or more continuous compensation
days are recorded in the PWGSC Pay System.
Employees on leave due to Leave with Income Averaging (LIA) or on Educational Leave are not identified on Pay in this field. If there is an active pay action 15C/A306 (ie. Effective From Date is < or = the current month
If Basic Pay Entitlement (M108) = 077
|
Structure |
XX |
1996 File Name & Starting Position |
INC.PROD.MAST (214) Prior to March 2004 one digit in location 267 |
Old File Name & Starting Position |
INC.PROD.GKMST (259) INC.PROD.GKPRF (317) |
Element Name |
Leaving Public Service Reason Code |
Alias |
Reason for Leaving DSS Pay System (MST) |
PDED No. |
139-0 |
Definition |
A code which identifies the reason an employee is leaving the Public Service or is transferring out of the Public Service Employee Pay System. |
Data Source |
2517T, field 48 |
Values |
Refer to the Personnel Pay Input Manual (PPIM), Section 3-5-3 for a list of code values. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (268) INC.PROD.MOBILITY (66) |
Old File Name & Starting Position |
INC.PROD.GKMST (260) INC.GKMOB22 (60) |
Element Name |
Linguistic Profile of Position (PCIS) |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A compound code which identifies for a bilingual position, the required level of proficiency in reading, writing and oral interaction for each of the official languages used. The first three values refer to ENGLISH skills and the last three values refer to FRENCH skills |
Data Source |
PCIS Master |
Values |
- = Not required |
Remarks |
The code is composed of three characters for each skill in
each official language: The 1st and 4th characters refer to the reading
ability The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, Employee Class (EMPCLS) and Department (DEPT) If NOC Code Indicator (NOCID) = '3' and LNGPRF (PCIS) not = blank
Note: The creation of NOCID must be done first |
Structure |
X(6) |
1996 File Name & Starting Position |
INC.PROD.MAST (468) |
Old File Name & Starting Position |
N/A |
Element Name |
Linguistic Status of Incumbent - GEN (PCIS) |
Alias |
N/A |
PDED No. |
N/A |
Definition |
This element indicates the linguistic situation of incumbents of bilingual positions |
Data Source |
PCIS Master |
(PCIS field) |
(Col. 560) |
Values |
Refer to PCIS documentation |
Remarks |
The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, Employee Class (EMPCLS) and Department (DEPT) If NOC Code Indicator (NOCID) = '3' and LSI-G (PCIS) not = blank
Note: The creation of NOCID must be done first |
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (481) |
Old File Name & Starting Position |
N/A |
Element Name |
Marital Status Code |
Alias |
Marital Status (MST/PRF/MOB) |
PDED No. |
6-0 |
Definition |
A code which identifies the marital status of a person. |
Data Source |
2517T, field 22 |
(MER field) |
(M022) |
Values |
1=Single |
Remarks |
This field is unreliable on both the Pay MER and INC system. Its value is regularly blanked out on the MER. If M022 is not = blank and not = zero
Else
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (243) INC.PROD.MOBILITY (42) |
File Name & Starting Position |
INC.PROD.GKMST (73) INC.PROD.GK34101 (88) |
Element Name |
Metropolitan Area Code |
Removed starting with Incumbent Master File of February, 2005 | |
Alias |
1991 Metropolitan Area Code (PRF) |
PDED No. |
N/A |
Definition |
A code used in the current StatCan Census to identify a very large urban area with a population of at least 100,000, together with adjacent urban and rural areas which are highly integrated economically and socially with that urban area. |
Data Source |
StatCan Geography File through the PWGSC Geographic Master File. |
Values |
See StatCan Publication "Census Metropolitan Areas and Census Agglomerations" |
Remarks |
The Incumbent table, Geographic Master File, associates the Geographic Location Code with the Metropolitan Area Code. Kelowna (915) and Sydney, N.S. (225) are not Census Metropolitan Areas but they are included because they have smaller components which are classed as "Census Agglomerations". This field has uncertain data hence is removed starting the February, 2005 Incumbent Master. |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (370) INC.PROD.GEOLOC (61) |
Old File Name & Starting Position |
INC.PROD.GKPRF (245) |
Element Name |
Metropolitan/Major Urban Area Code |
|
Removed starting with Incumbent Master File of February, 2005 | ||
Alias |
MA/MU Code (PRF) |
|
PDED No. |
35-0 |
|
Definition |
A code which identifies the metropolitan or major urban work area as defined by Statistics Canada, Census Division, for the previous Census. |
|
Data Source |
StatCan Geography Tape File through the PWGSC Geographic Master File. |
|
Values |
01 St. John's |
16 London |
Remarks |
The Incumbent table, Geographic Master File, associates the Geographic Location Code with the M/M Urban Area Code. Major Metropolitan/Major Urban Area Code is the last 2 characters of the 1971 Census Area Code (code values 001-030). These data are inaccurate, hence the field was removed starting February, 2005. |
|
Structure |
X(2) |
|
1996 File Name & Starting Position |
INC.PROD.MAST (365) INC.PROD.GEOLOC (74) |
|
Old File Name & Starting Position |
INC.PROD.GKPRF (238) |
Element Name |
Mobility Code |
Alias |
Turnover Code (MOB) |
PDED No. |
N/A |
Definition |
A code which identifies the movements of an employee into, within or out of the Public Service. |
Data Source |
Derived from Pay Action Code and changes to the Employee Classification Code. |
Values |
1100 Hiring of employee (not term/casual reappointment |
Remarks |
|
Structure |
X(4) |
1996 File Name & Starting Position |
INC.PROD.MOBILITY (82) INC.PROD.AAMS (Acting Segment) (9) & (21) |
Old File Name & Starting Position |
INC.PROD.GKMOB (72) |
Element Name |
National Occupation Classification Code |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A code created by the department to identify the occupation assigned to a position. |
Data Source |
PCIS Master |
Values |
|
Remarks |
The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, Employee Class (EMPCLS) and Department (DEPT) If NOC Code Indicator (NOCID) = '2' or '3' and NOC Code (NOC) not = blank
Note: The creation of NOCID must be done first |
Structure |
X(4) |
1996 File Name & Starting Position |
INC.PROD.MAST (191) |
Old File Name & Starting Position |
N/A |
Element Name |
National Occupation Classification Code Indicator |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A code indicating how the National Occupation Code (NOC) has been assigned |
Data Source |
Generated as per remarks |
Values |
0,1,2,3,4 |
Remarks |
If the NOC Code (NOC) is not blank and the Employee Classification (EMPCLS) = old EMPCLS
The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, EMPCLS and Department (DEPT). The following codes are generated (and subsequently moved into NOCID) : 0 = no match |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (195) |
Old File Name & Starting Position |
N/A |
Element Name |
Next Statutory Increment Date |
Alias |
N/A |
PDED No. |
2-13 |
Definition |
The date an employee will be paid his/her next statutory increment. |
Data Source |
2517T, field 50 |
Values |
YYYYMMDD |
Remarks |
If M050 not = blank and not = zero
Else
|
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (175) |
Old File Name & Starting Position |
INC.PROD.GKMST (262) INC.PROD.GK34101 (139) |
Element Name |
Non Elective Pensionable Service Amount |
Alias |
Previous Non-Elective Pensionable Service (MST) |
PDED No. |
62-2 (New) |
Definition |
The amount of non-elective service an employee has to his/her credit as pensionable service under the Public Service Superannuation Act. |
Data Source |
Contributor System |
Values |
YYMM |
Remarks |
The Incumbent System receives this information in "YYDDD.D'' format from the Contributor System and converts it into "YYMM'' format. The number of days (DDD.D) is divided by 30.5 to yield number of months (MM). This includes service transferred under Reciprocal Transfer agreements, and service with Crown Corporations prior to their being covered by the PSSA. |
Structure |
X(4) |
1996 File Name & Starting Position |
INC.PROD.MAST (409) CONT.PROD.SG2401 (51) |
Old File Name & Starting Position |
INC.PROD.GKMST (357) INC.PROD.GKPRF (390) |
Element Name |
Non Standard Work Week Indicator |
Alias |
Non-Standard Work Week (MST) |
PDED No. |
91-0 |
Definition |
An indicator which identifies whether an employee works a non-standard work week. A standard work week is a five day week, Monday to Friday. |
Data Source |
The Pay System imposes these code values from the Employee
Type Code. |
Values |
1= Yes, works non-standard week 2= No, works standard week Refer to the Pay Input Manual (PPIM), Section 3-5-3 for specifications. |
Remarks |
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (238) |
Old File Name & Starting Position |
INC.PROD.GKMST (109) INC.PROD.GK34101 (118) |
Element Name |
Normal Work Week Hours |
Alias |
Scheduled Work Hours (MST) |
PDED No. |
8-1 |
Definition |
The normal hours of work per week as defined in collective agreements for pertinent groups or sub-groups. |
Data Source |
2517T, field 32 |
Values |
|
Remarks |
If M032 is not = zero and not = blank
Else
|
Structure |
99v99 (v = implied decimal) |
1996 File Name & Starting Position |
INC.PROD.MAST (230) |
Old File Name & Starting Position |
INC.PROD.GKMST (103) INC.PROD.GK34101 (110) |
Element Name |
Nursing Pay Zone Code |
Alias |
N/A |
PDED No. |
9-10 (New) |
Definition |
A code which identifies the geographic pay zones for the Community Health Nursing and Hospital Nursing (NO) occupational group and sub-group derived from the Pay Zone Code for BUD`s 21901 and 21902. |
Data Source |
Derived from the Pay Zone Code for BUD's 21901 and 21902. |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (109) |
Element Name |
Offset Preparation Pay Zone Code |
Alias |
N/A |
PDED No. |
9-7 (New) |
Definition |
A code which identifies the geographic pay zone for the Offset Preparation (PROFE) occupational group and sub-group. |
Data Source |
Derived from the Pay Zone Code for BUD's 60905 and 65905. |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (103) |
Element Name |
Offset Production Pay Zone Code |
Alias |
N/A |
PDED No. |
9-8 (New) |
Definition |
A code which identifies the geographic pay zone for the Offset Production (PROFO) occupational group and sub-group. |
Data Source |
Derived from the Pay Zone Code for BUD's 60906 and 65906. |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (105) |
Element Name |
Owner Department/Agency Code |
Alias |
Ministry (Owner-Dept/Ministerial Affiliation) (MST) |
PDED No. |
1-2 |
Definition |
A code which identifies the ministry through which a department or agency reports to Parliament. |
Data Source |
Derived from the Department/Agency Code. |
Values |
|
Remarks |
Incumbent Department/Agency Table associates the Dep't/Agency Code with the Owner Department Code. |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (33) |
Old File Name & Starting Position |
INC.PROD.GKMST (3) INC.PROD.GKPRF (3) |
Element Name |
Pay Activity Status Code |
Alias |
Activity Status (MST/PRF) |
PDED No. |
48-0 |
Definition |
A code which identifies the employee's Pay Activity Status. |
Data Source |
Generated from the Pay Action Code on PAC01 (TOS), 02
(SOS), 13 |
Values |
1=Active |
Remarks |
If M107 = X and LWOP Reason Code not = B and not = I
If M107 = X and LWOP Reason Code = B or I
If M107 = T set Pay Activity Status Code to 2 If M107 = S set Pay Activity Status Code to 3 Note: The generation of LWOP Reason Code must be done first |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (258) |
Old File Name & Starting Position |
INC.PROD.GKMST (282) INC.PROD.GKPRF (58) |
Element Name |
Pay Office Code |
Alias |
Pay Office (PRF) |
PDED No. |
117-0 |
Definition |
A code which identifies pay offices and other service offices within the Public Service Pay System. |
Data Source |
2517T, field 09 |
Values |
Refer to Pay Input Manual (PPIM), Section 3-5-3 for list of codes. |
Remarks |
The Incumbent does not use records from Pay Offices 22, 23, 31, 90 and 93. |
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (58) |
Old File Name & Starting Position |
INC.PROD.GKMST (1) INC.PROD.GK34101 (21) |
Element Name |
Pay Rate Base Code |
Alias |
Pay Rate Base (MST/PRF) |
PDED No. |
25-0 |
Definition |
A code which identifies the rate base used to calculate an employee`s pay, to recover an overpayment or the frequency with which a deduction is made. |
Data Source |
2517T, field 65 |
Values |
Refer to Pay Input Manual (PPIM), Section 3-5-5 for list of codes. |
Remarks |
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (107) |
Old File Name & Starting Position |
INC.PROD.GKMST (89) INC.PROD.GK34101 (175) |
Element Name |
Pay Rate Code |
Alias |
N/A |
PDED No. |
23-0 |
Definition |
A code which identifies the basis upon which the pay rate of an employee has been established on appointment and subsequent to appointment, when applicable. |
Data Source |
2517T, field 21 |
Values |
Refer to Personnel Pay Input Manual (PPIM), Section 3-5-3 for list of codes. |
Remarks |
|
Structure |
X |
1996 File Name & |
INC.PROD.MAST (98) |
Old File Name & Starting Position |
INC.PROD.GKMST (82) INC.PROD.GK34101 (87) |
Element Name |
Pay Rate Code Effective Date |
Alias |
N/A |
PDED No. |
2-4 |
Definition |
The date a Pay Rate Code is effective. |
Data Source |
2517T, field 63 |
Values |
YYYYMMDD |
Remarks |
If M021 = old Pay Rate Code
Else
|
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (99) |
Old File Name & Starting Position |
INC.PROD.GKMST (83) |
Element Name |
Pay Zone Code |
Alias |
Pay Zone (MST/PRF) |
PDED No. |
9-0 |
Definition |
A code which identifies the geographical zone where rates of pay are established for employees in certain occupational groups and sub-groups according to specific collective agreements. |
Data Source |
2517T, field 36 |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
The first character represents the Pay Zone System particular to an occupational group; the last two, the geographic zone. |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (108) |
Old File Name & Starting Position |
INC.PROD.GKMST (223) INC.PROD.GK34101 (120) |
Element Name |
Paylist Number |
Alias |
Pay List Number (PRF) |
PDED No. |
17-0 |
Definition |
A unique number assigned by the employing department or agency to identify the paylist to which an employee has been designated. |
Data Source |
2517T, field 11 |
Values |
|
Remarks |
|
Structure |
X(4) |
1996 File Name & Starting Position |
INC.PROD.MAST (60) |
Old File Name & Starting Position |
INC.PROD.GKMST (6) INC.PROD.GK34101 (26) |
Element Name |
Payment Cycle Code |
Alias |
N/A |
PDED No. |
85-0 |
Definition |
A code which identifies the frequency of issuance of a pay or pension cheque. |
Data Source |
2517T, field 35 |
Values |
3= Weekly 6= Monthly 7= Bi-weekly |
Remarks |
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (111) |
Old File Name & Starting Position |
INC.PROD.GKMST (87) INC.PROD.GK34101 (119) |
Element Name |
Pension/Insurance Contribution Start Date |
Alias |
Pension Contribution Start Date (MST/PRF) |
PDED No. |
2-5 |
Definition |
The date an employee starts contributions to a pension or insurance plan. |
Data Source |
Contributor System. INC receives the start date of the most recent (current) period of pensionable service from the Contributor System. |
Values |
YYYYMMDD |
Remarks |
|
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (397) CONT.PROD.SG2401 (37) |
Old File Name & Starting Position |
INC.PROD.GKMST (177) INC.GKPRF (302) |
Element Name |
Pension Plan Code |
Alias |
Pension Type (MST/PRF) |
PDED No. |
14-0 |
Definition |
A code which identifies the pension plan to which an employee must contribute and the employee's contributory status under the plan or the reason an employee is a non- contributor. |
Data Source |
2517T, field 39 |
Values |
Refer to the Pay Input Manual (PPIM), Section 3-5-3 for the list of code values. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (376) |
Old File Name & Starting Position |
INC.PROD.GKMST (162) INC.PROD.GK34101 (125) |
Element Name |
Pensionable Service Base Date |
Alias |
Base Date of Pensionable Service (MST) |
PDED No. |
2-31 |
Definition |
The base date used to determine the amount of pensionable service an employee has accrued under the Public Service Superannuation Act. |
Data Source |
Generated from the Pension/Insurance Contribution Start Date (current service); Elective, Forces and Non Elective Pensionable Service. |
Values |
YYYYMMDD |
Remarks |
The years and months of Elective, Forces and Non-Elective Pensionable Service are subtracted from the Pension/Insurance Contribution Start Date. |
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (387) INC.PROD.MOBILITY (51) |
Old File Name & Starting Position |
INC.PROD.GKMST (181) INC.PROD.GKPRF (77) |
Element Name |
Pensionable Service Years |
Alias |
Years of Pensionable Service (PRF/MOB) |
PDED No. |
62-0 |
Definition |
The numbers of years and days of pensionable service an employee has accrued under the Public Service Superannuation Act. |
Data Source |
Generated from the Pensionable Service Base Date and Processing Date. |
Values |
YY |
Remarks |
The Pensionable Service Base Date (YYMM) is subtracted from the Processing Date giving Pensionable Service Years. If Pensionable Service Base Date (month) is greater then Processing Date (month) subtract one from Pensionable Service Years. If the calculation results in a negative or Pensionable Service Base Date is zeros, set Pensionable Service Years to zero. Only the resultant "years'' are written to the Incumbent system.If the number of years are greater than 35 then 35 is stored in this element. |
Structure |
99 |
1996 File Name & Starting Position |
INC.PROD.MAST (395) INC.PROD.MOBILITY (63) |
Old File Name & Starting Position |
INC.PROD.GKPRF (196) INC.PROD.GKMOB (57) |
Element Name |
Personal Record Identifier |
Alias |
PRI (PRF) |
PDED No. |
333-0 |
Definition |
A number assigned to uniquely associate a person with their personal records in the federal Public Service. |
Data Source |
Central Index |
Values |
|
Remarks |
The acronym is PRI. The last digit is a modulus-11 check digit. The PRI is 8 digits long, but is stored in the field previously occupied by the (9 digit) Social Insurance Number. The first digit in the stored PRI in the INC System is always a zero. |
Structure |
X(9) |
1996 File Name & Starting Position |
INC.PROD.MAST (1) INC.PROD.MOBILITY (1) |
Old File Name & Starting Position |
INC.PROD.GKMST (19) INC.PROD.GK34101 (12) |
Element Name |
Population Density Code |
Alias |
Size of Locality Code (PRF) |
PDED No. |
125-0 |
Definition |
A code which identifies the population density of municipalities according to the most recently published census data. |
Data Source |
StatCan GeoRef 1996 Census CD through the PWGSC Geographic Master File. |
Values |
9 = no population provided* * added with the Incumbent Master File of February 2005. |
Remarks |
Populations of Geographic Locations are provided by StatCan; the populations are broken into ranges, (see above) which appear on the Geographic Master File and the Incumbent Master File. |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (361) INC.PROD.GEOLOC (83) |
Old File Name & Starting Position |
INC.PROD.GKPRF (225) |
Element Name |
Position Classification Code |
Alias |
Position Class Title (MST/PRF) |
PDED No. |
94-5 |
Definition |
A code which identifies the occupational group, sub-group and level for a position. |
Data Source |
2517T, field 53 |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-3 for the list of codes. |
Remarks |
The first two characters identify the occupational group; the next three, the sub-group; and the last two, the level. |
Structure |
X(7) |
1996 File Name & Starting Position |
INC.PROD.MAST (223) INC.PROD. MOBILITY (131) & (232) |
Old File Name & Starting Position |
INC.PROD.GKMST (201) INC.PROD.GK34101 (155) |
Element Name |
Position Number |
Alias |
Position Number Hiring (MOB) |
PDED No. |
12-0 |
Definition |
A unique number assigned to each organizational position in a department or agency. |
Data Source |
2517T, field 52 |
Values |
a. The position number will be assigned and controlled by departments or agencies. b. Positions 1-5 (inclusive) represent the Branch portion of the position number. This portion may be alpha/numeric and be left justified. If any leading zeroes are used, it is important to type them in. c. Positions 6-10 (inclusive) represent the number portion of the position number. The validation for these characters is as follows:
d. Position numbers must be unique within departments or agencies. e. When a printout of the position number is printed for central agencies, its department or agency code is also listed. f. Dashes will not be accepted in either segment. g. Spaces will not be accepted between characters within a segment. h. The first three (3) characters of the first segment must not match the three (3) alpha characters representing the department or agency code. |
Remarks |
In cases of acting assignment, INC stores the acting position identifier in the Position Number field, and the substantive position identifier, in the Substantive Position Number field. |
Structure |
X10) |
1996 File Name & Starting Position |
INC.PROD.MAST (80) INC.PROD.MOBILITY (121) & (222) |
Old File Name & Starting Position |
INC.PROD.GKMST (191) INC.PROD.GK34101 (145) |
Element Name |
Position Number (PCIS) |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A unique number assigned to each organizational position in a department or agency. |
Data Source |
PCIS Master |
Values |
a. The position number will be assigned and controlled by departments or agencies. b. Positions 1-5 (inclusive) represent the Branch portion of the position number. This portion may be alpha/numeric and be left justified. If any leading zeroes are used, it is important to type them in. c. Positions 6-10 (inclusive) represent the number portion of the position number. The validation for these characters is as follows:
d. Position numbers must be unique within departments or agencies. e. When a printout of the position number is printed for central agencies, its department or agency code is also listed. f. Dashes will not be accepted in either segment. g. Spaces will not be accepted between characters within a segment. h. The first three (3) characters of the first segment must not match the three (3) alpha characters representing the department or agency code. |
Remarks |
The Incumbent table, NOC Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, EMPCLS and DEPT If NOCID = '3' and Position Number (PCIS) not = blank
Note: The creation of NOCID must be done first |
Structure |
X(10) |
1996 File Name & Starting Position |
INC.PROD.MAST (448) |
Old File Name & Starting Position |
N/A |
Element Name |
Positive Reporting Indicator |
Alias |
Time Summary Indicator (MST/PRF) |
PDED No. |
N/A |
Definition |
A indicator which identifies whether an employee is paid under the positive reporting whereby pay cheques are issued in arrears and based on actual hours worked. |
Data Source |
Pay MER |
Values |
C = Current reporting |
Remarks |
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (112) |
Old File Name & Starting Position |
INC.PROD.GKMST (313) INC.PROD.GKPRF (358) |
Element Name |
Previous Department / Agency Code |
Alias |
Previous Ministry (Owner-Dept) (MST) |
PDED No. |
1-1 |
Definition |
A code which identifies the previous department or agency where a person was employed. |
Data Source |
Generated from Department/Agency Code on INC Master when it changes. |
Values |
Incumbent Department/Agency Table contains valid Department Codes. |
Remarks |
|
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (47) |
Old File Name & Starting Position |
INC.PROD.GKMST (287) |
Element Name |
Public Service Employment Code |
Alias |
Public Service Population Flag (PRF) |
PDED No. |
N/A |
Definition |
A code which identifies the status of an employee under the Public Service Employment Act (PSEA). It also indicates whether the employee is employed as a "casual''. |
Data Source |
Generated from the PSEA Code of the employing department and the Employee Type Code. |
Values |
1= Subject to PSEA, not casual employee |
Remarks |
If Pay Activity Status Code (ACTVSTAT) is 2 or 3
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (299) |
Old File Name & Starting Position |
INC.PROD.GKPRF (353) |
Element Name |
Public Service Staff Relations Act Code |
Alias |
N/A |
PDED No. |
80-0 |
Definition |
A code which identifies the status of department or agency under the Public Service Staff Relations Act (PSSRA). |
Data Source |
TBS Population Affiliation System. |
Values |
1= Under PSSRA Schedule I, Part I |
Remarks |
The Incumbent department/Agency table, associates the Department/Agency Code with the PSSRA code. TB represents the Employer for departments under PSSRA I-I. Organizations listed in PSSRA I-II are called "separate employers" and bargain for themselves. |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (295) INC.PROD.MOBILITY (90) & (191) |
Old File Name & Starting Position |
INC.PROD.GKMST (18) INC.PROD.GKPRF (176) |
Element Name |
Reduced Salary Amount |
Alias |
N/A |
PDED No. |
New |
Definition |
This element is used to calculate the salary to be paid an employee who is on Leave With Income Averaging (LIA) (i.e. when Block Leave Indicator is 1 or 2), on Pre-retirement Transition Leave (PRL) (i.e. when Block Leave Indicator is 3) or on Educational Leave with Allowance. |
Data Source |
2517T, field 69 |
Values |
|
Remarks |
The Reduced Salary Amount has the same Pay Rate Base
associated with it as the employee's basic pay rate. Data Element added
April 1996.
Else
|
Structure |
9(6)v999 (v = implied decimal) |
1996 File Name & Starting Position |
INC.PROD.MAST (419) |
Element Name |
Reduction in Hours Worked (PRL) |
Alias |
PRL Hours |
PDED No. |
New |
Definition |
This element will contain the number of fewer hours worked per week. (i.e. if the employee normally works 37.5/week and now works 22.5/week this element contains 15). |
Data Source |
2517T, field 68 |
Values |
|
Remarks |
Data Element added April 1996 |
Structure |
99v99 (v = implied decimal) |
1996 File Name & Starting Position |
INC.PROD.MAST (428) |
Element Name |
Residence Province / Region Code |
Alias |
Province of Residence (MST/PRF) |
PDED No. |
230-1 |
Definition |
A code which identifies the province or region where a person's residence is located. |
Data Source |
2517T, field 46 |
Values |
See Pay Input Manual (PPIM), Section 3-5-3 for a list of code values in Pay. 10=NFLD 11=PEI 12=NS 13=NB 24=QUE 35=ONT 46=MAN 47=SASK 48=ALTA 59=BC 60=YT 61=NWT 62=Nunavut 91=Europe 93=Africa 95=Asia 96=Oceania & Antarctica 97=South America 98=North America (Central America & Antilles) 99= North America (Northern Sub-Groups incl. USA) |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (78) |
Old File Name & Starting Position |
INC.PROD.GKMST (74) INC.PROD.GK34101 |
Element Name |
Second Language Evaluation Results ENGLISH (PCIS) |
Alias |
N/A |
PDED No. |
N/A |
Definition |
The results of SLE ENGLISH tests |
Data Source |
PCIS Master |
Values |
|
Remarks |
The field consists of 3 one character designations of the employee's latest (1st occurrence) English second language test results (Level achieved) in Reading, Writing and Oral Interaction respectively The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, Employee Class (EMPCLS) and Department (DEPT)
Note: The creation of NOCID must be done first |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (483) |
Old File Name & Starting Position |
N/A |
Element Name |
Second Language Evaluation Results FRENCH (PCIS) |
Alias |
N/A |
PDED No. |
N/A |
Definition |
The results of SLE FRENCH tests |
Data Source |
PCIS Master |
Values |
|
Remarks |
The field consists of 3 one character designations of the employee's latest (1st occurrence) French second language test results (Level achieved) in Reading, Writing and Oral Interaction respectively The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, Employee Class (EMPCLS) and Department (DEPT)
Note: The creation of NOCID must be done first |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (486) |
Old File Name & Starting Position |
N/A |
Element Name |
Sex Code |
Alias |
Sex (MOB) |
PDED No. |
3-0 |
Definition |
A code which identifies the sex of a person. |
Data Source |
2517T, field 24 or the Contributor System Extract if data is missing in Pay or different than Pay. |
(MER field) |
(M024) |
Values |
1=Male 2=Female |
Remarks |
If M024 not = space and not = zero
Else
Change Contributor Sex Code 'M' to '1' and 'F'
to '2'
Else
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (242) INC.PROD.MOBILTIY (41) |
Old File Name & Starting Position |
INC.PROD.GKMST (72) INC.PROD.GKMOB (39) |
Element Name |
Ships Crews Pay Zone Code |
Alias |
N/A |
PDED No. |
9-11 (New) |
Definition |
A code which identifies the geographic pay zones for the Ships Crew (SC) occupational group. |
Data Source |
Derived from the Pay Zone Code for BUD's 612 and 662. |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (117) |
Element Name |
Statistics Canada Reporting Indicator |
Alias |
Stat Can Population Flag (PRF) |
PDED No. |
N/A |
Definition |
A code which identifies whether an employee is to be reported in the Federal Government Employment Statistics published by Statistics Canada. |
Data Source |
Generated |
Values |
1 = YES 3 = NO |
Remarks |
If Pay Activity Status Code (ACTVSTAT) is 2
else (i.e. ACTVSTAT = 1 or 3)
else
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (301) |
Old File Name & Starting Position |
INC.PROD.GKPRF (355) |
Element Name |
Statistics Canada Geographic Code |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A code which identifies geographic locations assigned by Statistics Canada. |
Data Source |
StatCan Standard Geographic Manual |
Values |
|
Remarks |
|
Structure |
X(7) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (54) |
Element Name |
Substantive Appointment Effective Date |
Alias |
Substantive Appointment Effective Date to Position (MST) |
PDED No. |
2-112 (New) |
Definition |
The effective date an employee is appointed to his/her substantive position. |
Data Source |
Copied from Appointment Effective Date on INC Master. |
Values |
YYYYMMDD |
Remarks |
If Acting Pay Code = 2
Effective Date. If the Acting Pay Code = 2 and the old Acting Pay Code = 1
|
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (313) |
Old File Name & Starting Position |
INC.PROD.GKMST (342) INC.PROD.GKPRF (371) |
Element Name |
Substantive Employee Classification Code |
Alias |
Substantive Employee Classification (MST/PRF) |
PDED No. |
94-8 (New) |
Definition |
A code which identifies the employee classification in the substantive appointment. |
Data Source |
Copied from Employee Classification Code on INC Master. |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-3 for the list of codes. |
Remarks |
The first two characters identify the occupational group; the next three, the sub-group; and the last two, the level. If the Acting Pay Code =2
Classification Code. If the Acting Pay Code = 2 and the old Acting Pay Code = 1
|
Structure |
X(7) |
1996 File Name & Starting Position |
INC.PROD.MAST (321) |
Old File Name & Starting Position |
INC.PROD.GKMST (346) INC.PROD.GKPRF (377) |
Element Name |
Substantive Employee Classification Code Effective Date |
Alias |
Substantive Employee Classification Effective Date (MST) |
PDED No. |
2-113 (New) |
Definition |
The date an employee's Classification Code in the substantive position is effective. |
Data Source |
Copied from Employee Classification Code Effective Date on INC Master. |
Values |
YYYYMMDD |
Remarks |
If Acting Pay Code = 2
If the Acting Pay Code = 2 and the old Acting Pay Code = 1
|
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (328) |
Old File Name & Starting Position |
INC.PROD.GKMST (353) INC.PROD.GKPRF (384) |
Element Name |
Substantive National Occupation Classification Code |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A code created by the department to identify the occupation assigned to the substantive position to which an employee is appointed. |
Data Source |
PCIS Master |
Values |
|
Remarks |
The Incumbent table, National Occupation Classification (NOC) Code Table (which also additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, Substantive Employee Class(SEMPCLS) and Department (DEPT)
Note: The creation of SNOCID must be done first |
Structure |
X(4) |
1996 File Name & Starting Position |
INC.PROD.MAST (216) |
Old File Name & Starting Position |
N/A |
Element Name |
Substantive National Occupation Classification Code Indicator |
Alias |
N/A |
PDED No. |
N/A |
Definition |
A code indicating how the Substantive National Occupation Code (SNOC) has been assigned |
Data Source |
Generated as per remarks |
Values |
0,1,2,3,4 |
Remarks |
If the Substantive NOC Code (SNOC) is not blank and the Substantive Employee Classification (SEMPCLS) = old SEMPCLS
The Incumbent table, National Occupation Classification (NOC) Code Table (which also contains additional PCIS fields) is created from the PCIS Master. The Incumbent Master file is then matched with this table using the key : PRI, SEMPCLS and Department (DEPT). The following codes are generated (and subsequently moved into SNOCID) : 0 = no match |
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (220) |
Old File Name & Starting Position |
N/A |
Element Name |
Substantive Position Number |
Alias |
N/A |
PDED No. |
12-5 (New) |
Definition |
The position number of the substantive position to which an employee is appointed. |
Data Source |
Copied from Position Number on INC Master. |
Values |
Refer to Position Number for description of structure. |
Remarks |
If the Acting Pay Code = 2
If the Acting Pay Code = 2 and the old Acting Pay Code = 1
|
Structure |
X(10) |
1996 File Name & Starting Position |
INC.PROD.MAST (303) |
Old File Name & Starting Position |
INC.PROD.GKMST (332) INC.PROD.GKPRF (361) |
Element Name |
Superannuation Number |
Alias |
N/A |
PDED No. |
144-0 |
Definition |
A number which uniquely identifies an employee's Superannuation account. |
Data Source |
Contributor System |
Values |
|
Remarks |
|
Structure |
X(9) |
1996 File Name & |
INC.PROD.MAST (378) CONT.PROD.SG2401 (63) |
Old File Name & Starting Position |
INC.PROD.GKMST (168) INC.PROD.GKPRF (289) |
Element Name |
Supervisory Factor Coordinates Code |
Alias |
Supervisory Grid (MST/PRF) |
PDED No. |
140-0 |
Definition |
A code which identifies the evaluation coordinates in a point rating plan for the supervisory classification factors in either a collective agreement or classification rating document. |
Data Source |
2517T, field 28 |
Values |
Refer to the Pay Input Manual (PPIM), Section 3-5-3 for the inter-element relationship with the BUD Group. |
Remarks |
The first character represents the degree of supervisory responsibility; the second, a coded representation of the number of employees supervised. |
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (261) |
Old File Name & Starting Position |
INC.PROD.GKMST (135) INC.PROD.GK34101 (104) |
Element Name |
Supervisory Level Code |
Alias |
Supervisory Level (MST/PRF/MOB) |
PDED No. |
82-0 |
Definition |
A code which identifies the classification level of supervisory duties being performed by an employee. |
Data Source |
Derived from Supervisory Factor Coordinates Code. |
Values |
01= Grid coordinate A1 for General Labour & Trades, General Services, Hospital Services, Operations (supervisory) and Royal Canadian Mint; grid coordinate S1 for printing 02= Grid coordinate B2 for General Labour & Trades, General Services, Hospital Services, Operations (supervisory) and Royal Canadian Mint; Grid coordinate S2 for printing 03= Grid coordinates B3, C2 for General Labour & Trades, General Services, Hospital Services, Operations (supervisory) and Royal Canadian Mint 04= Grid coordinates B4, C3, D2 for General Labour & Trades, General Services and Hospital Services; grid coordinates B4, C3 for Operations (supervisory) and Royal Canadian Mint 05= Grid coordinates B5, C4, D3, E2 for General Labour & Trades; grid coordinates B5, C4, D3 for General Services, Hospital Services and Operations (supervisory); grid coordinate C4 for Royal Canadian Mint 06= Grid coordinate B6, C5, D4, E3 for General Labour & Trades; grid coordinates B6, C5, D4 for General Services, Hospital Services and Operations (supervisory) 07= Grid coordinates B7, C6, D5, E4 for General Labour & Trades; grid coordinates C6, D5 for General Services and Operations (supervisory); grid coordinates B7, C6, D5 for Hospital Services 08= Grid coordinates C7, D6, E5 for General Labour & Trades; grid coordinate D6 for General Labour & Trades; grid coordinate D6 for General Services and Operations (supervisory); grid coordinates C7, D6 for Hospital Services 09= Grid coordinates D7, E6 for General Labour & Trades; grid coordinate C7 for Hospital Services 10= Grid coordinate E7 for General Labour & Trades BLANK= Not applicable |
Remarks |
The Incumbent Supervisory Grid Table associates the BUD and Supervisory Factor Coordinates Code with the Supervisory Level Code. |
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.MAST (259) INC.PROD.MOBILITY (155) & (256) |
Old File Name & Starting Position |
INC.PROD.GKMST (137) INC.PROD.GKPRF 140) |
Element Name |
Taken on Strength Date |
Alias |
N/A |
PDED No. |
2-40 |
Definition |
The date an employee is rendered active on the Pay System. |
Data Source |
2517T, field 63 |
Values |
YYYYMMDD |
Remarks |
|
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (149) |
Old File Name & Starting Position |
INC.PROD.GKMST (270) INC.PROD.GKPRF (324) |
Element Name |
Teachers Aide Pay Zone Code |
Alias |
N/A |
PDED No. |
9-12 (New) |
Definition |
A code which identifies the geographic pay zones for the Teachers' Aide (EUTEA) occupational group and sub-group. Derived from the Pay Zone Code for BUD's 41401 and 41421. |
Data Source |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Values |
|
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (119) |
Element Name |
Teaching Pay Zone Code |
Alias |
N/A |
PDED No. |
9-4 (New) |
Definition |
A code which identifies the geographic pay zones for the Elementary and Secondary Teaching (EDEST) occupational group and sub-group. |
Data Source |
Derived from the Pay Zone Code for BUD's 20902 and 20922. |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (97) |
Element Name |
Therapy Pay Zone Code |
Alias |
N/A |
PDED No. |
9-13 (New) |
Definition |
A code which identifies the geographic pay zone for the Occupational and Physical Therapy (OP) occupational group. |
Data Source |
Derived from the Pay Zone Code for BUD 220. |
Values |
Refer to the Pay Input Manual (PPIM), Section 9-4 for the list of codes. |
Remarks |
|
Structure |
X(2) |
1996 File Name & Starting Position |
INC.PROD.GEOLOC (115) |
Element Name |
Treasury Board Population Indicator |
Alias |
TBS Population Flag (PRF) |
PDED No. |
N/A |
Definition |
Indicates whether Treasury Board represents the Employer for an employee on PWGSC Pay System. |
Data Source |
Generated from Activity Status Code (active), BUD (in range 101-699), and PSSRA Code (PSSRA 1-1). |
Values |
1=TB is Employer 3= TB is not Employer |
Remarks |
If Activity Status Code(ACTVSTAT) = 2 or 3 else (ie. ACTVSTAT = 1)
else
|
Structure |
X |
1996 File Name & Starting Position |
INC.PROD.MAST (300) |
Old File Name & Starting Position |
INC.PROD.GKPRF (354) INC.GKMOB22 (169)&(265) |
Element Name |
Urban Employment Code |
Alias |
N/A |
PDED No. |
124-0 |
Definition |
A code that identifies urban work areas selected for employment studies by Statistics Canada. |
Data Source |
Direct from StatCan through the PWGSC Geographic Master File. |
Values |
|
Remarks |
The Incumbent table, Geographic Master File, associates the Geographic Location Code with the Urban Employment Code. |
Structure |
X(3) |
1996 File Name & Starting Position |
INC.PROD.MAST (367) INC.PROD.GEOLOC (79) |
Old File Name & Starting Position |
INC.PROD.GKPRF (240) |
Element Name |
Withered Date |
Alias |
N/A |
PDED No. |
N/A |
Definition |
The processing year and month when a record (PRI, Dept. Pay Office) appears on the previous months Incumbent Master but is not on the current months MER file. |
Data Source |
Generated from the processing date |
Values |
YYYYMM |
Remarks |
This date indicates that there is a discrepancy with the MER and if there is more than a 100 in the month the Incumbent Application Manager is notified. The records are checked for a pattern that would indicate a bulk change being processed by Pay and not by Incumbent or vice versa. If a record that was withered last month does not appear in the current month MER it is dropped from the Incumbent. |
Structure |
9(8) |
1996 File Name & Starting Position |
INC.PROD.MAST (489) |
Element Name |
Bargaining Unit Designator Code Effective Date REMOVED AS PER THE DECISION OF THE INCUMBENT REDESIGN PROJECT USER GROUP MEETING OF NOVEMBER 9, 1995 |
Element Name |
Employee Type Code Effective Date REMOVED AS PER THE DECISION OF THE INCUMBENT REDESIGN PROJECT USER GROUP MEETING OF NOVEMBER 27, 1995 |
Element Name |
Occupational Category Code REMOVED AS PER THE DECISION OF THE INCUMBENT REDESIGN PROJECT USER GROUP MEETING OF NOVEMBER 9, 1995 |
Element Name |
Pay Change Reason Code REMOVED AS PER DECISION OF THE INCUMBENT REDESIGN PROJECT USER GROUP MEETING OF OCTOBER 19, 1995 |
Element Name |
Previous Department / Agency Start Date REMOVED AS PER THE DECISION OF THE INCUMBENT REDESIGN PROJECT USER GROUP AS OF FEBRUARY 13, 1996 |
Element Name |
Select Area Code REMOVE AS PER DECISION OF THE INCUMBENT REDESIGN PROJECT USER GROUP MEETING OF OCTOBER 19, 1995 |
Element Name |
Work Province / Region Code REMOVED AS PER THE DECISION OF THE INCUMBENT REDESIGN PROJECT USER GROUP MEETING OF NOVEMBER 9, 1995 |