Incumbent Data Element Dictionary
Overview
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 than 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.
Glossary/Definitions
- 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
- 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
File Names
- 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 (MER field) |
Derived from the Entitlement/Deduction Pay Codes on Pay
Input Form. (M108, right most character) |
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) INC.PROD.AAMS (Acting Segment) (136) & (250) & (364) |
Old File Name & Starting Position | INC.PROD.GKMST (81) INC.PROD.GKPRF (264) |
Element Name | Acting Start Date |
---|---|
Alias | N/A |
PDED No. | N/A |
Definition | The date an acting segment starts on the Acting Assignment Management System (AAMS). |
Data Source (MER field) |
Effective From Date of an start acting 18C002 on the Suspense file. |
Values | N/A |
Remarks | N/A |
Structure | YYYYMMDD |
1996 File Name & Starting Position | INC.PROD.AAMS (Acting Segment) (1) |
Element Name | Acting Close Date |
---|---|
Alias | N/A |
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) | N/A |
Values | N/A |
Remarks | N/A |
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 | N/A |
Old File Name & Starting Position | INC.PROD.GKPRF (243) INC.PROD.GKMOB (53) |
Element Name | Appointment Effective Date |
---|---|
PDED No. | 2-32 |
Alias | Position Appointed Effective Date (MST) Effective Date Position Change (PRF) Date Appointed to Position (MOB) |
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
|
Structure | X(8) |
1996 File Name & Starting Position | INC.PROD.MAST (90) INC.PROD.MOBILITY ( 138) & (239) INC.PROD.AAMS (Acting Segment) (85) & (199) & (313) |
Old File Name & Starting Position | INC.PROD.GKMST (208) INC.PROD.GKMOB (125) & (221) INC.PROD.GKPRF (121) |
Element Name | Appointment Effective Date (PCIS) |
---|---|
PDED No. | N/A |
Alias | N/A |
Definition | The date on which a particular appointment of an employee is effective. |
Data Source | PCIS Master (Col. 504) |
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)
|
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 (M055) |
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
|
Structure | X(2) |
1996 File Name & Starting Position | INC.PROD.MAST (255) |
Old File Name & Starting Position | INC.PROD.GKMST (330) INC.PROD.GK34101 (44) INC.PROD.GKPRF (359) |
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 (MER field) |
2517T, field 33 (M033) |
Values | N/A |
Remarks | N/A |
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) INC.PROD.GKPRF (64) |
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 (MER field) |
The Association Code is derived from the BUD Code. |
Values | N/A |
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) INC.PROD.AAMS (Acting Segment) (129) & (243) & (357) |
Old File Name & Starting Position | INC.PROD.GKMST (155) INC.PROD.GKPRF (178) INC.PROD.GKMOB (167) & (263) |
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 (M025) |
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) INC.PROD.AAMS (Acting Segment) (51 & 160 & (274) |
Old File Name & Starting Position | INC.PROD.GKMST (126) INC.PROD.GK34101 (90) INC.PROD.GKPRF (52) INC.PROD.GKMOB (88) & (184) |
Element Name | Bilingualism Bonus Code |
---|---|
Alias | Bilingual Bonus (MST) Bilingual Allowance Code (PRF) |
PDED No. | 202-0 |
Definition | A code which identifies the bilingualism bonus an employee is being paid. |
Data Source (MER field) |
Generated from field 62 on 2517T. (Based on entitlement portion of MER file. |
Values |
Blank = No Bilingual Bonus |
Remarks | If the employee has a pay action 18C/A007
|
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 | N/A |
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 (MER field) |
2517T, field 16 or from Contributor System Extract (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) CONT.PROD.SG2401 (29) |
Old File Name & Starting Position | INC.PROD.GKMST (68) INC.PROD.GKPRF (186) INC.PROD.GK34101 (73) INC.PROD.GKMOB (33) |
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 (M113) |
Values |
|
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 |
---|---|
Note | 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) |
---|---|
Note | Valid Starting with the Incumbent Master File of February 2005 |
Alias | N/A |
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.
|
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 |
---|---|
Note | 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 |
---|---|
Note | Valid starting with the Incumbent Master File of February, 2005 |
Alias | N/A |
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 |
|
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 (Col. 450) |
Values |
|
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)
|
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 | N/A |
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 | N/A |
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 (MER field) |
2517T, field 45 (M045) |
Values | YYYYMMDD |
Remarks | If M045 not = blank and not = zero.
|
Structure | 9(8) |
1996 File Name & Starting Position | INC.PROD.MAST (165) INC.PROD.MOBILITY (43) INC.PROD.AAMS (43) |
Old File Name & Starting Position | INC.PROD.GKMST (266) INC.PROD.GK34101 (128) INC.PROD.GKPRF (145) INC.PROD.GKMOB (41) |
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 (MER field) |
2517T, field 37 (M037) |
Values | 1 = Eligible to contribute to SDB 2 = Not eligible to contribute to SDB |
Remarks | N/A |
Structure | X |
1996 File Name & Starting Position | INC.PROD.MAST (266 |
Old File Name & Starting Position | INC.PROD.GKMST (158) INC.PROD.GK34101 (123) INC.PROD.GKPRF (284) |
Element Name | Department/Agency Code |
---|---|
Alias | Department /Agency (MST), Department or Agency Code (PRF) Department/Agency Code (MOB) & Department (MOB) |
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 (MER field) |
2517T, field 10 (M010) |
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, If Dept. Code = EXT &
If Dept. Code = SOL &
If Dept. Code = SOL &
If Dept. Code = SOL &
|
Structure | X(3) |
1996 File Name & Starting Position | INC.PROD.MAST (36) INC.PROD.MOBILITY (86) & (187) INC.PROD.AAMS (Acting Segment) (33) & (147) & (261) |
Old File Name & Starting Position | INC.PROD.GKMST (14) INC.PROD.GK34101 (23) INC.PROD.GKPRF (68) INC.PROD.GKMOB (76) & (172 |
Element Name | Department/Agency Employment Start Date |
---|---|
Alias | Date Incumbent Started at Ministry (MST) Date Started in Department (PRF) |
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
|
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 | N/A |
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 > Dep't/Agency Employment Start Date (DTDEPT)
|
Structure | 9(8) |
1996 File Name & Starting Position | INC.PROD.MAST (50) |
Old File Name & Starting Position | N/A |
- Date modified: