{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["General Information Générale","Codes SLT","Language terms","AOLS Codes","LSI Codes","REH _ Bilingual Posn ","Sheet1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"General Information Générale","index":0,"n_rows":31,"n_cols":30,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,8,4,10],[4,18,4,19],[30,2,36,19],[28,10,28,19],[14,2,14,9],[14,10,14,19],[6,2,6,10],[10,2,10,19],[12,2,12,8],[6,14,6,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f","e","e",null,"f","f"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Series","AOLS -10","AOLS - 20","AOLS - 30","LSI - 10","LSI - 20"]
[]
[null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A3,'Language terms'!B3)","v":"AOLS Code"},null,{"$f":"IF(Z1=\"e\",'Language terms'!A6,'Language terms'!B6)","v":"Status"},null,null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A5,'Language terms'!B5)","v":"English Description "},null,null,null,null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A7,'Language terms'!B7)","v":"LSI Code "},null,{"$f":"IF(Z1=\"e\",'Language terms'!A6,'Language terms'!B6)","v":"Status"},null,{"$f":"IF(Y1=\"e\",'Language terms'!#REF!,'Language terms'!A5)","v":"English Description "}]
[null,null,13,null,{"$f":"IF(ISNA(VLOOKUP(C5,'AOLS Codes'!A1:J36,7,FALSE)),\"N/A\",(VLOOKUP(C5,'AOLS Codes'!A1:J36,7,FALSE)))","v":"Active"},null,null,null,{"$f":"IF(ISNA(VLOOKUP(C5,'AOLS Codes'!A1:J36,4,FALSE)),\"N/A\",(VLOOKUP(C5,'AOLS Codes'!A1:J36,4,FALSE)))","v":"Appt-Bil imperative pos"},null,null,null,null,null,17,null,{"$f":"IF(ISNA(VLOOKUP(O5,'Codes SLT'!A2:I21,7,FALSE)),\"N/A\",(VLOOKUP(O5,'Codes SLT'!A2:I21,7,FALSE)))","v":"Inactive"},null,{"$f":"IF(ISNA(VLOOKUP(O5,'Codes SLT'!A2:I21,4,FALSE)),\"N/A\",(VLOOKUP(O5,'Codes SLT'!A2:I21,4,FALSE)))","v":"17 - Meets OL-Not PSC-No Entd BB"}]
[null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A4,'Language terms'!B4)","v":"Definition"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A4,'Language terms'!B4)","v":"Definition"}]
[null,null,{"$f":"IF(ISNA(VLOOKUP(C5,'AOLS Codes'!A1:J36,10,FALSE)),\"N/A\",(VLOOKUP(C5,'AOLS Codes'!A1:J36,10,FALSE)))","v":"Imperative Appointment to a Bilingual position"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(O5,'Codes SLT'!A2:J21,10,FALSE)),\"N/A\",(VLOOKUP(O5,'Codes SLT'!A2:J21,10,FALSE)))","v":"Inactive"}]
[]
[]
[]
[null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A8,'Language terms'!B8)","v":"Scenario"}]
[null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A9,'Language terms'!B9)","v":"Action  "}]
[null,null,5]
[]
[null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A10,'Language terms'!B10)","v":"Business description of the Appointment Official Languages Status codes (AOLS)"},null,null,null,null,null,null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A11,'Language terms'!B11)","v":"Linguistic Status of Incumbent codes (LSI)"}]
[null,null,{"$f":"IF(C13=1,'Language terms'!C27:C35,IF(C13=2,'Language terms'!C66,IF(C13=3,'Language terms'!C36:C44,IF(C13=4,'Language terms'!C75,IF(C13=5,'Language terms'!C45:C53,IF(C13=6,'Language terms'!C54:C62,IF(C13=7,'Language terms'!C86:C91,IF(C13=8,'Language terms'!C93:C99,IF(C13=10,'Language terms'!C100,IF(C13=9,'Language terms'!C100))))))))))","v":"13 - Acting Appointment (Bilingual position imperative)"},null,null,null,null,null,null,null,{"$f":"IF(C16='Language terms'!C27,'Language terms'!C109:C111,IF(C16='Language terms'!C66,'Language terms'!C116:C118,IF(C16='Language terms'!C75,'Language terms'!C116:C118,IF(C16='Language terms'!C45,'Language terms'!C122:C127,IF(C16='Language terms'!C93,'Language terms'!C131:C132,IF(C16='Language terms'!C86,'Language terms'!C122:C124,IF(C16='Language terms'!C100,'Language terms'!C134:C135,IF(C16='Language terms'!C36,'Language terms'!C109:C110,IF(C16='Language terms'!C54,'Language terms'!C131:C132)))))))))","v":"10 - Meets OL Req - Entitled to BB "}]
[null,null,"\"",null,null,null,null,null,null,null,"15 - NOT Required to meet OL Req (does not receive BB in substantive position)"]
[null,null,"\"",null,null,null,null,null,null,null,"16 - Does not meet - gets BB  (Receives BB in substantive position)"]
[null,null,"\"",null,null,null,null,null,null,null,"40 - Acting appointment encumbered bilingual position - exclusion under PSER 4 - 12 months (substantive position = 14,15,30,31,32,blank)"]
[null,null,"\"",null,null,null,null,null,null,null,"41 - Acting appointment in bilingual position while incumbent on Language Training - exclusion under PSER < 18 months (substantive position = 14,15,30,31,32,blank)"]
[null,null,"\"",null,null,null,null,null,null,null,"50 - Acting appointment to position in rotational system – exclusion under PSER (Only used by CBSA,IRCC,DFAIT)"]
[null,null,"15 - Acting Appointment (English essential position)",null,null,null,null,null,null,null,{"$f":"IF(C22='Language terms'!C51,'Language terms'!C108,IF(C22='Language terms'!C42,'Language terms'!C108,IF(C22='Language terms'!C99,'Language terms'!C108,IF(C22='Language terms'!C60,'Language terms'!C108,IF(C22=\"\",\"\")))))","v":"Leave Blank "}]
[null,null,"16 - Actng Appointment (French essential position)",null,null,null,null,null,null,null,{"$f":"IF(C23='Language terms'!C52,'Language terms'!C108,IF(C23='Language terms'!C43,'Language terms'!C108,IF(C23='Language terms'!C61,'Language terms'!C108,IF(C23=\"\",\"\"))))","v":"Leave Blank "}]
[null,null,"17 - Acting Appointment  (English or French essential position)",null,null,null,null,null,null,null,{"$f":"IF(C24='Language terms'!C53,'Language terms'!C108,IF(C24='Language terms'!C44,'Language terms'!C108,IF(C24='Language terms'!C62,'Language terms'!C108,IF(C24=\"\",\"\"))))","v":"Leave Blank "}]
[null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A12,'Language terms'!B12)","v":"Executive (EX)"}]
[null,null,{"$f":"IF(C13=1,'Language terms'!C27,IF(C13=2,'Language terms'!C66,IF(C13=3,'Language terms'!C36,IF(C13=4,'Language terms'!C75,IF(C13=5,'Language terms'!C84,IF(C13=6,'Language terms'!C54,IF(C13=7,'Language terms'!C86,IF(C13=8,'Language terms'!C93,IF(C13=9,'Language terms'!C100,IF(C13=10,'Language terms'!C100))))))))))","v":"13 - Acting Appointment (Bilingual position imperative) - EX"},null,null,null,null,null,null,null,{"$f":"IF(C26='Language terms'!C27,'Language terms'!C110,IF(C26='Language terms'!C36,'Language terms'!C110,IF(C26='Language terms'!C85,'Language terms'!C128:C130,IF(C26='Language terms'!C54,'Language terms'!C128:C129,IF(C26='Language terms'!C86,'Language terms'!C128:C129,IF(C26='Language terms'!C93,'Language terms'!C128,IF(C26='Language terms'!C100,'Language terms'!C136:C137,IF(C26='Language terms'!C66,'Language terms'!C116:C118,IF(C26='Language terms'!C75,'Language terms'!C116:C118,IF(C26='Language terms'!C84,'Language terms'!C128:C130))))))))))","v":"14 - Meet OL Req - NOT entitled to BB (Executive)"}]
[null,null,null,null,null,null,null,null,null,null,"15 - NOT Required to meet OL Req (Executive)"]
[null,null,null,null,null,null,null,null,null,null,"50 - Acting appointment to position in rotational system – exclusion under PSER (Executive)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A14,'Language terms'!B14)","v":"***Note: Only LSI codes 10 and 16 start Bilingual Bonus in Phoenix***"}]
[null,null,{"$f":"IF(Z1=\"e\",'Language terms'!A13,'Language terms'!B13)","v":"Information"}]
[null,null,{"$f":"IF(C13=1,'Language terms'!C143,IF(C13=2,'Language terms'!C142,IF(C13=3,'Language terms'!C143,IF(C13=4,'Language terms'!C142,IF(C13=5,'Language terms'!C144,IF(C13=6,'Language terms'!C144,IF(C13=7,'Language terms'!C145,IF(C13=8,'Language terms'!C145,IF(C13=9,'Language terms'!C146,IF(C13=10,'Language terms'!C146))))))))))","v":"If the employee receives the bonus for his substantive position and is temporarily assigned to a unilingual position (NNLO codes 15, 16 or 17), he will continue to receive the bonus only if the basic monthly salary of the acting position is less than or equal to the base salary of the substantive position plus the bonus, enter (10 - Satisfied - receives PB)"}]

{"sheet":"Codes SLT","index":1,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Codes SLT","Eng Description","FR description","Language Toggle","Status","État","Language Toggle","Definition","Définition","Language Toggle"]
[10,"10-Meets OL req - Entlitled to BB","10-Satisfait - reçoit PB",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B2,'Codes SLT'!C2)","v":"10-Meets OL req - Entlitled to BB"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E2,'Codes SLT'!F2)","v":"Active"},"Use this value when the employee MEETS the OL requirement of the Position, and IS ENTITLED to the Bilingual Bonus","Utilisez cette valeur lorsque l'employé satisfait à l'exigence de LO du poste et EST Admissible à la prime au bilinguisme",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H2,'Codes SLT'!I2)","v":"Use this value when the employee MEETS the OL requirement of the Position, and IS ENTITLED to the Bilingual Bonus"}]
[11,"Awaiting SLE results","En attente résults ELS",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B3,'Codes SLT'!C3)","v":"Awaiting SLE results"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E3,'Codes SLT'!F3)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H3,'Codes SLT'!I3)","v":"Inactive"}]
[12,"Pos ling data missing-Bil",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B4,'Codes SLT'!C4)","v":"Pos ling data missing-Bil"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E4,'Codes SLT'!F4)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H4,'Codes SLT'!I4)","v":"Inactive"}]
[13,"Bil-Appt status missing/uni",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B5,'Codes SLT'!C5)","v":"Bil-Appt status missing/uni"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E5,'Codes SLT'!F5)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H5,'Codes SLT'!I5)","v":"Inactive"}]
[14,"14-Meets OL req-Not Entd to BB","14-Satisf LO-ne reçoit pas PB",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B6,'Codes SLT'!C6)","v":"14-Meets OL req-Not Entd to BB"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E6,'Codes SLT'!F6)","v":"Active"},"Use this value when the employee MEETS the OL requirement of the Position, but IS NOT ENTITLED to the Bilingual Bonus (ie – Executives, Translators, NFB)","Utilisez cette valeur lorsque l'employé satisfait à l'exigence de LO du poste, mais N'EST PAS admissible à la prime bilingue (c.-à-d. Cadres, traducteurs, ONF) ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H6,'Codes SLT'!I6)","v":"Use this value when the employee MEETS the OL requirement of the Position, but IS NOT ENTITLED to the Bilingual Bonus (ie – Executives, Translators, NFB)"}]
[15,"15-Not required to meet OL req","15-Pas obligé-Satisf exig. LO",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B7,'Codes SLT'!C7)","v":"15-Not required to meet OL req"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E7,'Codes SLT'!F7)","v":"Active"},"Use this value when the employee is NOT REQUIRED TO MEET any OL requirement (ie – Casuals, Acting less than 4 months, etc..)","Utilisez cette valeur lorsque l'employé N'EST PAS REQUIS DE RÉPONDRE à une exigence de LO (c.-à-d. occasionnels, agissant moins de 4 mois, etc.) ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H7,'Codes SLT'!I7)","v":"Use this value when the employee is NOT REQUIRED TO MEET any OL requirement (ie – Casuals, Acting less than 4 months, etc..)"}]
[16,"16-Does not meet - gets BB","16-Ne rencontre pas-reçoit PB",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B8,'Codes SLT'!C8)","v":"16-Does not meet - gets BB"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E8,'Codes SLT'!F8)","v":"Active"},"Use this value when the employee DOES NOT MEET the OL requirement, but IS STILL ENTITLED to the Bilingual Bonus","Utilisez cette valeur lorsque l'employé NE RÉPOND PAS à l'exigence de LO, mais EST TOUJOURS Admissible à la prime au bilinguisme ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H8,'Codes SLT'!I8)","v":"Use this value when the employee DOES NOT MEET the OL requirement, but IS STILL ENTITLED to the Bilingual Bonus"}]
[17,"17 - Meets OL-Not PSC-No Entd BB","Sat LO-Pas CFP-reçoit pas PB",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B9,'Codes SLT'!C9)","v":"17 - Meets OL-Not PSC-No Entd BB"},"Inactive","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E9,'Codes SLT'!F9)","v":"Inactive"},"Inactive","Inatif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H9,'Codes SLT'!I9)","v":"Inactive"}]
[20,"20 - Employee does not meet","20 - L'employé rencontre pas",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B10,'Codes SLT'!C10)","v":"20 - Employee does not meet"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E10,'Codes SLT'!F10)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H10,'Codes SLT'!I10)","v":"Inactive"}]
[21,"Exmp appt/depl/renum/restr","Exemption nom/mut/",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B11,'Codes SLT'!C11)","v":"Exmp appt/depl/renum/restr"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E11,'Codes SLT'!F11)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H11,'Codes SLT'!I11)","v":"Inactive"}]
[22,"Unilingual to bilingual","Unilingue à bilingue ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B12,'Codes SLT'!C12)","v":"Unilingual to bilingual"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E12,'Codes SLT'!F12)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H12,'Codes SLT'!I12)","v":"Inactive"}]
[23,"Raised ling prof-doesnt mt",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B13,'Codes SLT'!C13)","v":"Raised ling prof-doesnt mt"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E13,'Codes SLT'!F13)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H13,'Codes SLT'!I13)","v":"Inactive"}]
[24,"New SLE results lower prf",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B14,'Codes SLT'!C14)","v":"New SLE results lower prf"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E14,'Codes SLT'!F14)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H14,'Codes SLT'!I14)","v":"Inactive"}]
[26,"Refusal to take a new test",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B15,'Codes SLT'!C15)","v":"Refusal to take a new test"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E15,'Codes SLT'!F15)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H15,'Codes SLT'!I15)","v":"Inactive"}]
[30,"30-PSOLEO Must meet OL reqm'","30-DELOFP doit satisfaire LO",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B16,'Codes SLT'!C16)","v":"30-PSOLEO Must meet OL reqm'"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E16,'Codes SLT'!F16)","v":"Active"},"Use this value per the Public Service Official Languages Exclusion Approval Order - When the Aptmt Official Language Status = Bilingual Non-Imperative (14 or 24) and the employee DOES NOT MEET the language requirement, and they submit an agreement to become bilingual.","Utilisez cette valeur conformément au décret d'exclusion des langues officielles dans la fonction publique - Lorsque le statut de langue officielle d'Aptmt = bilingue non impératif (14 ou 24) et que l'employé NE RENCONTRE PAS les exigences linguistiques et soumet un accord de devenir bilingue. ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H16,'Codes SLT'!I16)","v":"Use this value per the Public Service Official Languages Exclusion Approval Order - When the Aptmt Official Language Status = Bilingual Non-Imperative (14 or 24) and the employee DOES NOT MEET the language requirement, and they submit an agreement to become bilingual."}]
[31,"31-PSOLEO Medical grounds","31-DELOFP raison médicale",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B17,'Codes SLT'!C17)","v":"31-PSOLEO Medical grounds"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E17,'Codes SLT'!F17)","v":"Active"},"Use this value per the Public Service Official Languages Exclusion Approval Order - When the Aptmt Official Language Status = Bilingual Non-Imperative (14 or 24) and the employee DOES NOT MEET, and is excluded for medical reasons","Utilisez cette valeur conformément au décret d'exclusion des langues officielles dans la fonction publique - Lorsque le statut de langue officielle d'Aptmt = bilingue non impératif (14 ou 24) et le l'employé NE RENCONTRE PAS et est exclu pour des raisons médicales ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H17,'Codes SLT'!I17)","v":"Use this value per the Public Service Official Languages Exclusion Approval Order - When the Aptmt Official Language Status = Bilingual Non-Imperative (14 or 24) and the employee DOES NOT MEET, and is excluded for medical reasons"}]
[32,"32-PSOLEO Elig. immed. annuity","32-DELOFP adm pension imméd",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B18,'Codes SLT'!C18)","v":"32-PSOLEO Elig. immed. annuity"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E18,'Codes SLT'!F18)","v":"Active"},"Use this value per the Public Service Official Languages Exclusion Approval Order - When the Aptmt Official Language Status = Bilingual Non-Imperative (14 or 24) and the employee DOES NOT MEET and is eligible for an immediate annuity - irrevocable resignation to leave / retire within 2 years","Utilisez cette valeur conformément au décret d'exclusion des langues officielles dans la fonction publique - Lorsque le statut de langue officielle d'Aptmt = bilingue non impératif (14 ou 24) et le l'employé NE RENCONTRE PAS et est admissible à une rente immédiate - irrévocable démission pour quitter / prendre sa retraite dans les 2 ans ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H18,'Codes SLT'!I18)","v":"Use this value per the Public Service Official Languages Exclusion Approval Order - When the Aptmt Official Language Status = Bilingual Non-Imperative (14 or 24) and the employee DOES NOT MEET and is eligible for an immediate annuity - irrevocable resignation to leave / retire within 2 years"}]
[40,"40-Act Apt encum. bil position","40-Nom inter poste bil non vac",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B19,'Codes SLT'!C19)","v":"40-Act Apt encum. bil position"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E19,'Codes SLT'!F19)","v":"Active"},"Use this value when the employee DOES NOT MEET and falls under the following exclusion under the Public Service Employment Regulations (PSER) - An acting appointment of 4 months or more, but not more than 12 months, to an encumbered bilingual position that the Commission cannot fill with an acting appointment of a person who meets the language proficiency qualification under paragraph 30(2)(a) of the Act is excluded from the application of that paragraph respecting official language proficiency","Utilisez cette valeur lorsque l'employé NE SE RENCONTRE PAS et relève de ce qui suit exclusion en vertu du Règlement sur l'emploi dans la fonction publique (REFP) - Une nomination de 4 mois ou plus, mais pas plus de 12 mois, à un poste bilingue que la Commission ne peut combler par la nomination intérimaire d'une personne qui satisfait à la qualification de compétence linguistique en vertu de l'alinéa 30 (2) a) de la Loi est exclus de l'application de cet alinéa concernant la maîtrise des langues officielles ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H19,'Codes SLT'!I19)","v":"Use this value when the employee DOES NOT MEET and falls under the following exclusion under the Public Service Employment Regulations (PSER) - An acting appointment of 4 months or more, but not more than 12 months, to an encumbered bilingual position that the Commission cannot fill with an acting appointment of a person who meets the language proficiency qualification under paragraph 30(2)(a) of the Act is excluded from the application of that paragraph respecting official language proficiency"}]
[41,"41-Act Apt bil pos/lng trainin","41-Nom inter pst bil/form lang",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B20,'Codes SLT'!C20)","v":"41-Act Apt bil pos/lng trainin"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E20,'Codes SLT'!F20)","v":"Active"},"Use this value when the employee DOES NOT MEET and falls under the following exclusion under the Public Service Employment Regulations (PSER) - An acting appointment of 4 months or more, but not more than 18 months, to a bilingual position, while the incumbent is on language training, that the Commission cannot fill with an acting appointment of a person who meets the language proficiency qualification under paragraph 30(2)(a) of the Act is excluded from the application of that paragraph respecting official language proficiency","Utilisez cette valeur lorsque l'employé NE RENCONTRE PAS et relève de l'exclusion suivante du Règlement sur l'emploi dans la fonction publique (REFP) - Une nomination intérimaire de 4 mois ou plus, mais pas plus de 18 mois, à un poste bilingue, alors que le titulaire est sur la formation linguistique, que la Commission ne peut combler par la nomination intérimaire d'une personne qui satisfait à la qualification de compétence linguistique prévue à l'alinéa 30 (2) a) de la Loi est exclue de l'application de cet alinéa concernant la maîtrise des langues officielles",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H20,'Codes SLT'!I20)","v":"Use this value when the employee DOES NOT MEET and falls under the following exclusion under the Public Service Employment Regulations (PSER) - An acting appointment of 4 months or more, but not more than 18 months, to a bilingual position, while the incumbent is on language training, that the Commission cannot fill with an acting appointment of a person who meets the language proficiency qualification under paragraph 30(2)(a) of the Act is excluded from the application of that paragraph respecting official language proficiency"}]
[50,"50-Pos Rotatnl system","50 Poste permutant",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!B21,'Codes SLT'!C21)","v":"50-Pos Rotatnl system"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!E21,'Codes SLT'!F21)","v":"Active"},"Use this value when the employee DOES NOT MEET and falls under the following exclusion under the Public Service Employment Regulations (PSER) - an acting appointment to a position in a rotational system established by the deputy head, in order to provide for the movement of employees within and outside Canada in the following organization is excluded from the application of sections 30 and 77 of the Act: Department of Citizenship and Immigration Department of Foreign Affairs and International Trade Canada Border Services Agency","Utilisez cette valeur lorsque l'employé NE SE RENCONTRE PAS et relève de l'exclusion suivante du Règlement sur l'emploi dans la fonction publique (REFP) - une nomination intérimaire à un poste dans un système de rotation établi par l'administrateur général, afin de permettre le mouvement des employés au Canada et à l'étranger dans l'organisation suivante est exclue de l'application des articles 30 et 77 de la Loi: Ministère de la Citoyenneté et de l'Immigration Ministère des Affaires étrangères et du Commerce international Agence des services frontaliers du Canada",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Codes SLT'!H21,'Codes SLT'!I21)","v":"Use this value when the employee DOES NOT MEET and falls under the following exclusion under the Public Service Employment Regulations (PSER) - an acting appointment to a position in a rotational system established by the deputy head, in order to provide for the movement of employees within and outside Canada in the following organization is excluded from the application of sections 30 and 77 of the Act: Department of Citizenship and Immigration Department of Foreign Affairs and International Trade Canada Border Services Agency"}]

{"sheet":"Language terms","index":2,"n_rows":146,"n_cols":3,"rows_kept":146,"cut":false,"hidden":false,"merged":[[0,0,0,2],[14,0,14,2],[25,0,25,2],[106,0,106,2],[137,0,137,2]]}
["Interface"]
["English","Français"]
["AOLS Code","Code NNCLO",{"$f":"IF('General Information Générale'!Z1=\"e\",'Language terms'!A3,'Language terms'!B3)","v":"AOLS Code"}]
["Definition","Définition",{"$f":"IF('General Information Générale'!Z1=\"e\",'Language terms'!A4,'Language terms'!B4)","v":"Definition"}]
["English Description ","Description Française",{"$f":"IF('General Information Générale'!Z1=\"e\",'Language terms'!A5,'Language terms'!B5)","v":"English Description "}]
["Status","État",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A6,'Language terms'!B6)","v":"Status"}]
["LSI Code ","Code SLT",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A7,'Language terms'!B7)","v":"LSI Code "}]
["Scenario","Scénario",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A8,'Language terms'!B8)","v":"Scenario"}]
["Action  ","Action",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A9,'Language terms'!B9)","v":"Action  "}]
["Business description of the Appointment Official Languages Status codes (AOLS)","Code sur la nature de la nomination concernant les langues officielles (NNCLO)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A10,'Language terms'!B10)","v":"Business description of the Appointment Official Languages Status codes (AOLS)"}]
["Linguistic Status of Incumbent codes (LSI)","Codes sur la situation linguistique du titulaire (SLT)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A11,'Language terms'!B11)","v":"Linguistic Status of Incumbent codes (LSI)"}]
["Executive (EX)","Executif (EX)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A12,'Language terms'!B12)","v":"Executive (EX)"}]
["Information","Information",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A13,'Language terms'!B13)","v":"Information"}]
["***Note: Only LSI codes 10 and 16 start Bilingual Bonus in Phoenix***","***Remarque: Seulement les codes SLT 10 et 16 commence la prime au bilinguisme dans Phénix***",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A14,'Language terms'!B14)","v":"***Note: Only LSI codes 10 and 16 start Bilingual Bonus in Phoenix***"}]
["Scenarios"]
["Appointment (imperative)","Nomination (impérative)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A16,'Language terms'!B16)","v":"Appointment (imperative)"}]
["Appointment (non-imperative)","Nomination (non-impérative)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A17,'Language terms'!B17)","v":"Appointment (non-imperative)"}]
["Deployment/Transfer (imperative)","Mutation (impérative)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A18,'Language terms'!B18)","v":"Deployment/Transfer (imperative)"}]
["Deployment/Transfer (non-imperative)","Mutation (non-impérative)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A19,'Language terms'!B19)","v":"Deployment/Transfer (non-imperative)"}]
["Acting ","Intérimaire ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A20,'Language terms'!B20)","v":"Acting "}]
["Acting Extension","Prolongation Intérimaire ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A21,'Language terms'!B21)","v":"Acting Extension"}]
["Assignment / Secondment In to a bilingual position","Affectation / Détachement d'entrée à un poste bilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A22,'Language terms'!B22)","v":"Assignment / Secondment In to a bilingual position"}]
["Assignment / Secondment In to a unilingual position","Affectation / Détachement d'entrée à un poste unilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A23,'Language terms'!B23)","v":"Assignment / Secondment In to a unilingual position"}]
["New SLE Results","Nouveaux résultats ELS ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A24,'Language terms'!B24)","v":"New SLE Results"}]
["Re-Identification of OL requirement","Ré-identification des exigences linguistiques",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A25,'Language terms'!B25)","v":"Re-Identification of OL requirement"}]
["AOLS Code"]
["13 - Appointment / Promotion (Bilingual position imperative)","13 - Nomination impérative (Poste bilingue)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A27,'Language terms'!B27)","v":"13 - Appointment / Promotion (Bilingual position imperative)"}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A28,'Language terms'!B28)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A29,'Language terms'!B29)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A30,'Language terms'!B30)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A31,'Language terms'!B31)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A32,'Language terms'!B32)","v":"\""}]
["15 - Appointment / Promotion (English essential position)","15 - Nomination impérative (Poste anglais essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A33,'Language terms'!B33)","v":"15 - Appointment / Promotion (English essential position)"}]
["16 - Appointment / Promotion (French essential position)","16 - Nomination impérative (Poste français essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A34,'Language terms'!B34)","v":"16 - Appointment / Promotion (French essential position)"}]
["17 - Appointment / Promotion (English or French essential position)","17   Nomination impérative (Poste anglais ou français essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A35,'Language terms'!B35)","v":"17 - Appointment / Promotion (English or French essential position)"}]
["23 - Deployment / Transfer (Bilingual position imperative) ","23 - Mutation impérative - Poste \nbilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A36,'Language terms'!B36)","v":"23 - Deployment / Transfer (Bilingual position imperative) "}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A37,'Language terms'!B37)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A38,'Language terms'!B38)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A39,'Language terms'!B39)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A40,'Language terms'!B40)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A41,'Language terms'!B41)","v":"\""}]
["25 - Deployment / Transfer (English essential position)","25 -  Mutation - Poste anglais essentiel\nbilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A42,'Language terms'!B42)","v":"25 - Deployment / Transfer (English essential position)"}]
["26 - Deployment / Transfer (French essential position)","26 - Mutation - Poste français essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A43,'Language terms'!B43)","v":"26 - Deployment / Transfer (French essential position)"}]
["27 - Deployment / Transfer (English or French essential position)","27 - Mutation - Poste réversible \n(anglais ou français essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A44,'Language terms'!B44)","v":"27 - Deployment / Transfer (English or French essential position)"}]
["13 - Acting Appointment (Bilingual position imperative)","13 - Nomination intérimaire (Poste bilingue)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A45,'Language terms'!B45)","v":"13 - Acting Appointment (Bilingual position imperative)"}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A46,'Language terms'!B46)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A47,'Language terms'!B47)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A48,'Language terms'!B48)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A49,'Language terms'!B49)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A50,'Language terms'!B50)","v":"\""}]
["15 - Acting Appointment (English essential position)","15 - Nomination intérimaire (Poste anglais essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A51,'Language terms'!B51)","v":"15 - Acting Appointment (English essential position)"}]
["16 - Actng Appointment (French essential position)","16 - Nomination intérimaire (Poste français essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A52,'Language terms'!B52)","v":"16 - Actng Appointment (French essential position)"}]
["17 - Acting Appointment  (English or French essential position)","17   Nomination intérimaire (Poste anglais ou français essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A53,'Language terms'!B53)","v":"17 - Acting Appointment  (English or French essential position)"}]
["30 - Data Change (Acting Extension)","30 - Modification des données (Prolongation d'intérimaire)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A54,'Language terms'!B54)","v":"30 - Data Change (Acting Extension)"}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A55,'Language terms'!B55)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A56,'Language terms'!B56)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A57,'Language terms'!B57)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A58,'Language terms'!B58)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A59,'Language terms'!B59)","v":"\""}]
["15 - Appointment / Promotion (English essential position)","15 - Nomination impérative (Poste anglais essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A60,'Language terms'!B60)","v":"15 - Appointment / Promotion (English essential position)"}]
["16 - Appointment / Promotion (French essential position)","16 - Nomination impérative (Poste français essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A61,'Language terms'!B61)","v":"16 - Appointment / Promotion (French essential position)"}]
["17 - Appointment / Promotion (English or French essential position)","17   Nomination impérative (Poste anglais ou français essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A62,'Language terms'!B62)","v":"17 - Appointment / Promotion (English or French essential position)"}]
["Deployment - Detachement - Interchange program - EX","Affectation - Détachement - Programme interchange - CS",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A63,'Language terms'!B63)","v":"Deployment - Detachement - Interchange program - EX"}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A64,'Language terms'!B64)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A65,'Language terms'!B65)","v":"\""}]
["14 - Appointment / Promotion (Bilingual position non-imperative) ","14 - Nomination non impérative (Poste bilingue)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A66,'Language terms'!B66)","v":"14 - Appointment / Promotion (Bilingual position non-imperative) "}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A67,'Language terms'!B67)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A68,'Language terms'!B68)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A69,'Language terms'!B69)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A70,'Language terms'!B70)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A71,'Language terms'!B71)","v":"\""}]
["15 - Appointment / Promotion (English essential position)","15 - Nomination impérative (Poste anglais essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A72,'Language terms'!B72)","v":"15 - Appointment / Promotion (English essential position)"}]
["16 - Appointment / Promotion (French essential position)","16 - Nomination impérative (Poste français essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A73,'Language terms'!B73)","v":"16 - Appointment / Promotion (French essential position)"}]
["17 - Appointment / Promotion (English or French essential position)","17   Nomination impérative (Poste anglais ou français essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A74,'Language terms'!B74)","v":"17 - Appointment / Promotion (English or French essential position)"}]
["24 - Deployment / Transfer (Bilingual position non-imperative)","24 - Mutation non impérative",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A75,'Language terms'!B75)","v":"24 - Deployment / Transfer (Bilingual position non-imperative)"}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A76,'Language terms'!B76)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A77,'Language terms'!B77)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A78,'Language terms'!B78)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A79,'Language terms'!B79)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A80,'Language terms'!B80)","v":"\""}]
["25 - Deployment / Transfer (English essential position)","25 -  Mutation - Poste anglais essentiel\nbilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A81,'Language terms'!B81)","v":"25 - Deployment / Transfer (English essential position)"}]
["26 - Deployment / Transfer (French essential position)","26 - Mutation - Poste français essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A82,'Language terms'!B82)","v":"26 - Deployment / Transfer (French essential position)"}]
["27 - Deployment / Transfer (English or French essential position)","27 - Mutation - Poste réversible \n(anglais ou français essentiel)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A83,'Language terms'!B83)","v":"27 - Deployment / Transfer (English or French essential position)"}]
["13 - Acting Appointment (Bilingual position imperative) - EX","13 - Nomination intérimaire (Poste bilingue) - EX",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A84,'Language terms'!B84)","v":"13 - Acting Appointment (Bilingual position imperative) - EX"}]
["13 - Appointment / Promotion (Bilingual position imperative) - EX ","13 - Nomination impérative (Poste bilingue) - CS ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A85,'Language terms'!B85)","v":"13 - Appointment / Promotion (Bilingual position imperative) - EX "}]
["30 - Data Change (bilingual position)","30 - Modification des données (poste bilingue)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A86,'Language terms'!B86)","v":"30 - Data Change (bilingual position)"}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A87,'Language terms'!B87)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A88,'Language terms'!B88)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A89,'Language terms'!B89)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A90,'Language terms'!B90)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A91,'Language terms'!B91)","v":"\""}]
["Unilingual Substantive Position","Poste d'attache Unilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A92,'Language terms'!B92)","v":"Unilingual Substantive Position"}]
["30 - Data Change (unilingual position)","30 - Modification des données (poste unilingue)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A93,'Language terms'!B93)","v":"30 - Data Change (unilingual position)"}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A94,'Language terms'!B94)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A95,'Language terms'!B95)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A96,'Language terms'!B96)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A97,'Language terms'!B97)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A98,'Language terms'!B98)","v":"\""}]
["Unilingual Substantive Position","Poste d'attache Unilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A99,'Language terms'!B99)","v":"Unilingual Substantive Position"}]
["30 - Data Change (new SLE, add a row and update codes)","30 - Modification des données (nouveaux ELS, ajouter un rang et mettre à jour les codes)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A100,'Language terms'!B100)","v":"30 - Data Change (new SLE, add a row and update codes)"}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A101,'Language terms'!B101)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A102,'Language terms'!B102)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A103,'Language terms'!B103)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A104,'Language terms'!B104)","v":"\""}]
["\"","\"",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A105,'Language terms'!B105)","v":"\""}]
["Unilingual Substantive Position","Poste d'attache Unilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A106,'Language terms'!B106)","v":"Unilingual Substantive Position"}]
["LSI Code "]
["Leave Blank ","Laisser vide",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A108,'Language terms'!B108)","v":"Leave Blank "}]
["10 - Meets OL Req - Entitled to BB (indeterminate or term > 3 months with more than 12.5 hrs AWW)","10 - Rencontre LO, admissible à la prime au bilinguisme (indéterminé ou terme > 3 mois avec plus de 12,5 heures SDT)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A109,'Language terms'!B109)","v":"10 - Meets OL Req - Entitled to BB (indeterminate or term > 3 months with more than 12.5 hrs AWW)"}]
["14 - Meet OL Req - NOT entitled to BB (Term > 3 months with less than 12.5 hrs AWW or Term < 3 months who meets the language requirement)","14 - Rencontre LO, non admissible à la prime au bilinguisme (terme > 3 mois avec moins de 12,5 heures SDT ou term < 3 mois qui recontre les exigeances des langues)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A110,'Language terms'!B110)","v":"14 - Meet OL Req - NOT entitled to BB (Term > 3 months with less than 12.5 hrs AWW or Term < 3 months who meets the language requirement)"}]
["15 - NOT Required to meet OL Req (Part-time worker excluded from LEFP)","15 -  Non requis de satisfaire aux LO, non admissible à la prime au bilinguisme (travaileur à temps partiel exclus de la LEFP)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A111,'Language terms'!B111)","v":"15 - NOT Required to meet OL Req (Part-time worker excluded from LEFP)"}]
["16 - Does not meet - gets BB  ","16 -  Ne rencontre pas, admissible à la prime au bilinguisme",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A112,'Language terms'!B112)","v":"16 - Does not meet - gets BB  "}]
["40 - Acting appointment encumbered bilingual position - exclusion under PSER ","40 - Nomination intérimaire (entre 4 et 12 mois - poste non vacant)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A113,'Language terms'!B113)","v":"40 - Acting appointment encumbered bilingual position - exclusion under PSER "}]
["41 - Acting appointment in bilingual position while incumbent on Language Training - exclusion under PSER","41 -  Nomination intérimaire (moins de 18 mois - titulaire en formation linguistique)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A114,'Language terms'!B114)","v":"41 - Acting appointment in bilingual position while incumbent on Language Training - exclusion under PSER"}]
["50 - Acting appointment to position in rotational system – exclusion under PSER (Only used by CBSA,IRCC,DFAIT)","50 - Nomination intérimaire à un poste faisant partie d'un système de permutabilité  - exclusion en vertu du REFP(Seulement utilisé par IRCC, ASFC, MAECI)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A115,'Language terms'!B115)","v":"50 - Acting appointment to position in rotational system – exclusion under PSER (Only used by CBSA,IRCC,DFAIT)"}]
["30 - PSOLEO Employee must meet OL requirements \n(insert a Target Date for employee to Meet) ","30 - DELOFP - Doit satisfaire aux exigences linguistiques (ajouter la date cible pour que l'employé rencontre)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A116,'Language terms'!B116)","v":"30 - PSOLEO Employee must meet OL requirements \n(insert a Target Date for employee to Meet) "}]
["31 - PSOLEO Medical Grounds exclusion ","31 - DELOFP - Exclusion raisons médicales (approbation requise de la CFP)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A117,'Language terms'!B117)","v":"31 - PSOLEO Medical Grounds exclusion "}]
["32 - PSOLEO Eligible Immediate Annuity exclusion  ","32 –  DELOFP - Exclusion pension immédiate",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A118,'Language terms'!B118)","v":"32 - PSOLEO Eligible Immediate Annuity exclusion  "}]
["10 - Meets OL Req - Entitled to BB ","10 - Rencontre LO, admissible à la prime au bilinguisme",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A119,'Language terms'!B119)","v":"10 - Meets OL Req - Entitled to BB "}]
["15 - NOT Required to meet OL Req < 4 months (substantive position = 14,15,30,31,32,blank)","15 -  Non requis de satisfaire aux LO, non admissible à la prime au bilinguisme < 4 mois (poste d'attache = 14,15,30,31,32,vide)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A120,'Language terms'!B120)","v":"15 - NOT Required to meet OL Req < 4 months (substantive position = 14,15,30,31,32,blank)"}]
["16 - Does not meet - gets BB  < 4 months (substantive position = 10,16)","16 -  Ne rencontre pas, admissible à la prime au bilinguisme < 4 mois (poste d'attache = 10,16)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A121,'Language terms'!B121)","v":"16 - Does not meet - gets BB  < 4 months (substantive position = 10,16)"}]
["10 - Meets OL Req - Entitled to BB ","10 - Rencontre LO, admissible à la prime au bilinguisme",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A122,'Language terms'!B122)","v":"10 - Meets OL Req - Entitled to BB "}]
["15 - NOT Required to meet OL Req (does not receive BB in substantive position)","15 -  Non requis de satisfaire aux LO, non admissible à la prime au bilinguisme (Ne reçoit pas la PB dans son poste d'attache)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A123,'Language terms'!B123)","v":"15 - NOT Required to meet OL Req (does not receive BB in substantive position)"}]
["16 - Does not meet - gets BB  (Receives BB in substantive position)","16 -  Ne rencontre pas, admissible à la prime au bilinguisme (Reçoit la PB dans le poste d'attache)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A124,'Language terms'!B124)","v":"16 - Does not meet - gets BB  (Receives BB in substantive position)"}]
["40 - Acting appointment encumbered bilingual position - exclusion under PSER 4 - 12 months (substantive position = 14,15,30,31,32,blank)","40 - Nomination intérimaire (entre 4 et 12 mois - poste non vacant) 4 à 12 mois (poste d'attache = 14,15,30,31,32,vide)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A125,'Language terms'!B125)","v":"40 - Acting appointment encumbered bilingual position - exclusion under PSER 4 - 12 months (substantive position = 14,15,30,31,32,blank)"}]
["41 - Acting appointment in bilingual position while incumbent on Language Training - exclusion under PSER < 18 months (substantive position = 14,15,30,31,32,blank)","41 -  Nomination intérimaire (moins de 18 mois - titulaire en formation linguistique) < 18 mois (poste d'attache = 14,15,30,31,32,vide)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A126,'Language terms'!B126)","v":"41 - Acting appointment in bilingual position while incumbent on Language Training - exclusion under PSER < 18 months (substantive position = 14,15,30,31,32,blank)"}]
["50 - Acting appointment to position in rotational system – exclusion under PSER (Only used by CBSA,IRCC,DFAIT)","50 - Nomination intérimaire à un poste faisant partie d'un système de permutabilité - exclusion en vertu du REFP (Seulement utilisé par IRCC, ASFC, MAECI)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A127,'Language terms'!B127)","v":"50 - Acting appointment to position in rotational system – exclusion under PSER (Only used by CBSA,IRCC,DFAIT)"}]
["14 - Meet OL Req - NOT entitled to BB (Executive)","14 - Rencontre LO, non admissible à la prime au bilinguisme (Cadre Supérieur)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A128,'Language terms'!B128)","v":"14 - Meet OL Req - NOT entitled to BB (Executive)"}]
["15 - NOT Required to meet OL Req (Executive)","15 -  Non requis de satisfaire aux LO, non admissible à la prime au bilinguisme (Cadre Supérieur)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A129,'Language terms'!B129)","v":"15 - NOT Required to meet OL Req (Executive)"}]
["50 - Acting appointment to position in rotational system – exclusion under PSER (Executive)","50 - Nomination intérimaire à un poste faisant partie d'un système de permutabilité (Cadre Supérieur postes permutant ou mobile)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A130,'Language terms'!B130)","v":"50 - Acting appointment to position in rotational system – exclusion under PSER (Executive)"}]
["10 - Meets OL Req - Entitled to BB (Receives BB in substantive position)","10 - Rencontre LO, admissible à la prime au bilinguisme (reçoit la PB dans son poste d'attache)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A131,'Language terms'!B131)","v":"10 - Meets OL Req - Entitled to BB (Receives BB in substantive position)"}]
["15 - Not eligible for the bilingual bonus in the substantive position","15 -  N'est pas admissible à la prime au bilinguisme pour son poste  d'attache ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A132,'Language terms'!B132)","v":"15 - Not eligible for the bilingual bonus in the substantive position"}]
["16 - Is eligible for the bilingual bonus in the substantive position","16 -  Est admissible à la prime au  bilinguisme pour son poste d'attache",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A133,'Language terms'!B133)","v":"16 - Is eligible for the bilingual bonus in the substantive position"}]
["10 - Meets the linguistic profile of the position, following new SLE results ","10 - Rencontre le profile linguistique du poste, suite à de nouveaux resultats ELS",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A134,'Language terms'!B134)","v":"10 - Meets the linguistic profile of the position, following new SLE results "}]
["15 - Does not meet the linguistic profile of the position, following new SLE results ","15 - Rencontre pas le profile linguistique du poste, suite à de nouveaux resultats ELS",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A135,'Language terms'!B135)","v":"15 - Does not meet the linguistic profile of the position, following new SLE results "}]
["14 - Meets the linguistic profile of the position, following new SLE results ","14 - Rencontre le profile linguistique du poste, suite à de nouveaux resultats ELS",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A136,'Language terms'!B136)","v":"14 - Meets the linguistic profile of the position, following new SLE results "}]
["15 - Does not meet the linguistic profile of the position, following new SLE results ","15 - Rencontre pas le profile linguistique du poste, suite à de nouveaux resultats ELS",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A137,'Language terms'!B137)","v":"15 - Does not meet the linguistic profile of the position, following new SLE results "}]
["Information"]
["No target date for acting appointments","Aucune date cible pour les nominations intérimaires",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A139,'Language terms'!B139)","v":"No target date for acting appointments"}]
["No target date for Deployment - Detachement - Interchange program ","Aucune date cible pour les affectations, les détachements ou les programmes interchange",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A140,'Language terms'!B140)","v":"No target date for Deployment - Detachement - Interchange program "}]
["If the holder does not meet the language requirements of his substantive position following an appointment or a transfer non-imperative unresolved, leave target date as is. For all other situations, leave the field empty.","Si le titulaire ne rencontre pas les exigences linguistiques de son poste d'attache suite à une nomination ou à une mutation non impérative non résolue, laisser la date cible telle quelle. Pour toutes autres situations, laisser le champ vide.",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A141,'Language terms'!B141)","v":"If the holder does not meet the language requirements of his substantive position following an appointment or a transfer non-imperative unresolved, leave target date as is. For all other situations, leave the field empty."}]
["Applies only to non-imperative staffing with commitment to become bilingual (AOLS codes (14) and (24) AND LSI code (30) Applies only to non-imperative staffing with commitment to become bilingual (codes AOLS (14) and (24) AND LSI code (30)) Enter the target date by which the incumbent must meet the OL requirements of the position (latest date - two years from the date of offer letter OR two years from the effective date of the appointment or non-imperative transfer with a commitment to become bilingual).\nExtension granted following a non-imperative staffing with a commitment to become bilingual\n- Add a new line DATA / OL\n- Change the code on the AOLS to (30)\n- Keep the LSI code (30) as is\n- Modify the target date to reflect the expiration date of the extension granted","S'applique seulement à la dotation non impérative avec engagement de devenir bilingue (codes NNCLO (14) et (24) ET code SLT (30)) Entrer la date cible à laquelle le titulaire doit rencontrer les exigences LO du poste (date la plus éloignée - deux ans à compter de la date de la lettre d'offre OU deux ans à compter de la date de la prise d'effet de la nomination ou mutation non impérative avec engagement de devenir bilingue).                                                                                                                                                                                                  Prolongation accordée suite à une dotation non impérative avec engagement de devenir bilingue\n- Ajouter une nouvelle ligne DONNÉES/LO\n- Changer le code sur la NNCLO à (30)\n- Garder le code SLT (30) tel quel\n- Modifier la date cible afin de refléter la date d'expiration de la prolongation accordée",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A142,'Language terms'!B142)","v":"Applies only to non-imperative staffing with commitment to become bilingual (AOLS codes (14) and (24) AND LSI code (30) Applies only to non-imperative staffing with commitment to become bilingual (codes AOLS (14) and (24) AND LSI code (30)) Enter the target date by which the incumbent must meet the OL requirements of the position (latest date - two years from the date of offer letter OR two years from the effective date of the appointment or non-imperative transfer with a commitment to become bilingual).\nExtension granted following a non-imperative staffing with a commitment to become bilingual\n- Add a new line DATA / OL\n- Change the code on the AOLS to (30)\n- Keep the LSI code (30) as is\n- Modify the target date to reflect the expiration date of the extension granted"}]
["The bilingual bonus is not paid to the following categories of employees: as and when required, students and casual employees. No OL code should be entered in My GCHR for this type of staffing action.","La prime au bilinguisme n’est pas versée aux catégories d’employés suivantes : selon les besoins, étudiants et employés occasionnels. Aucun code de LO ne doit être entré dans Mes RHGC pour ce type de mesures de dotation.",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A143,'Language terms'!B143)","v":"The bilingual bonus is not paid to the following categories of employees: as and when required, students and casual employees. No OL code should be entered in My GCHR for this type of staffing action."}]
["If the employee receives the bonus for his substantive position and is temporarily assigned to a unilingual position (NNLO codes 15, 16 or 17), he will continue to receive the bonus only if the basic monthly salary of the acting position is less than or equal to the base salary of the substantive position plus the bonus, enter (10 - Satisfied - receives PB)","Si l’employé reçoit la prime pour son poste d’attache et qu’il est temporairement affecté à un poste unilingue (codes NNLO 15, 16 ou 17), il continuera à recevoir la prime uniquement si le salaire mensuel de base du poste intérimaire est inférieur ou égal au salaire de base du poste d’attache plus la prime, entrer (10 - Satisfait - reçoit PB)",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A144,'Language terms'!B144)","v":"If the employee receives the bonus for his substantive position and is temporarily assigned to a unilingual position (NNLO codes 15, 16 or 17), he will continue to receive the bonus only if the basic monthly salary of the acting position is less than or equal to the base salary of the substantive position plus the bonus, enter (10 - Satisfied - receives PB)"}]
["N/A",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A145,'Language terms'!B145)","v":"N/A"}]
["Stop the bilingual bonus 2 months following the date of the written notice if the employee still does not meet the bilingual level","Arrêter la prime de bilinguisme deux mois après la date de l’avis écrit si l’employé ne satisfait toujours pas au niveau de bilinguisme",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'Language terms'!A146,'Language terms'!B146)","v":"Stop the bilingual bonus 2 months following the date of the written notice if the employee still does not meet the bilingual level"}]

{"sheet":"AOLS Codes","index":3,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Code ","Eng Description","FR description",null,"Status","État",null,"Definition","Définition"]
[1,"Willing to take lang. train",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B2,'AOLS Codes'!C2)","v":"Willing to take lang. train"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E2,'AOLS Codes'!F2)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H2,'AOLS Codes'!I2)","v":"Inactive"}]
[2,"Long service exemption",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B3,'AOLS Codes'!C3)","v":"Long service exemption"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E3,'AOLS Codes'!F3)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H3,'AOLS Codes'!I3)","v":"Inactive"}]
[3,"Age exemption",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B4,'AOLS Codes'!C4)","v":"Age exemption"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E4,'AOLS Codes'!F4)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H4,'AOLS Codes'!I4)","v":"Inactive"}]
[4,"Reorg. - Incumbent's Rights",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B5,'AOLS Codes'!C5)","v":"Reorg. - Incumbent's Rights"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E5,'AOLS Codes'!F5)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H5,'AOLS Codes'!I5)","v":"Inactive"}]
[5,"Transfer Cntrl-Incmb Rights",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B6,'AOLS Codes'!C6)","v":"Transfer Cntrl-Incmb Rights"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E6,'AOLS Codes'!F6)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H6,'AOLS Codes'!I6)","v":"Inactive"}]
[6,"Change of classification",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B7,'AOLS Codes'!C7)","v":"Change of classification"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E7,'AOLS Codes'!F7)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H7,'AOLS Codes'!I7)","v":"Inactive"}]
[7,"Lay-off priority",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B8,'AOLS Codes'!C8)","v":"Lay-off priority"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E8,'AOLS Codes'!F8)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H8,'AOLS Codes'!I8)","v":"Inactive"}]
[8,"Return lve absence priority",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B9,'AOLS Codes'!C9)","v":"Return lve absence priority"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E9,'AOLS Codes'!F9)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H9,'AOLS Codes'!I9)","v":"Inactive"}]
[9,"Act appt - leave of absence",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B10,'AOLS Codes'!C10)","v":"Act appt - leave of absence"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E10,'AOLS Codes'!F10)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H10,'AOLS Codes'!I10)","v":"Inactive"}]
[10,"Act appt -language training",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B11,'AOLS Codes'!C11)","v":"Act appt -language training"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E11,'AOLS Codes'!F11)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H11,'AOLS Codes'!I11)","v":"Inactive"}]
[12,"Compassionate reasons",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B12,'AOLS Codes'!C12)","v":"Compassionate reasons"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E12,'AOLS Codes'!F12)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H12,'AOLS Codes'!I12)","v":"Inactive"}]
[13,"Appt-Bil imperative pos","Nom-Impérative poste bilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B13,'AOLS Codes'!C13)","v":"Appt-Bil imperative pos"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E13,'AOLS Codes'!F13)","v":"Active"},"Imperative Appointment to a Bilingual position","Nomination impérative à un poste bilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H13,'AOLS Codes'!I13)","v":"Imperative Appointment to a Bilingual position"}]
[14,"Appt-Bilingual non-imper pos","Nom-Non-impérative poste bil",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B14,'AOLS Codes'!C14)","v":"Appt-Bilingual non-imper pos"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E14,'AOLS Codes'!F14)","v":"Active"},"Non-Imperative Appointment to a Bilingual position","Nomination non-impératicve à un poste bilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H14,'AOLS Codes'!I14)","v":"Non-Imperative Appointment to a Bilingual position"}]
[15,"Appt-English essential pos","Nom-Poste anglais essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B15,'AOLS Codes'!C15)","v":"Appt-English essential pos"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E15,'AOLS Codes'!F15)","v":"Active"},"Appointment to a English Essential position","Nomination à un poste anglais essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H15,'AOLS Codes'!I15)","v":"Appointment to a English Essential position"}]
[16,"Appt-French essential position","Nom-Poste français essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B16,'AOLS Codes'!C16)","v":"Appt-French essential position"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E16,'AOLS Codes'!F16)","v":"Active"},"Appointment to a French Essential position","Nomination à un poste français essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H16,'AOLS Codes'!I16)","v":"Appointment to a French Essential position"}]
[17,"Appt-English/French ess pos","Nom-Poste anglais/français ess",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B17,'AOLS Codes'!C17)","v":"Appt-English/French ess pos"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E17,'AOLS Codes'!F17)","v":"Active"},"Appointment to a English or French Essential position","Nomination à un poste anglais ou français essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H17,'AOLS Codes'!I17)","v":"Appointment to a English or French Essential position"}]
[18,"Appt-Bil Rotational pos",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B18,'AOLS Codes'!C18)","v":"Appt-Bil Rotational pos"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E18,'AOLS Codes'!F18)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H18,'AOLS Codes'!I18)","v":"Inactive"}]
[19,"Mts-Similar bilingual pos.",null,{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B19,'AOLS Codes'!C19)","v":"Mts-Similar bilingual pos."},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E19,'AOLS Codes'!F19)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H19,'AOLS Codes'!I19)","v":"Inactive"}]
[20,"SLE results are valid","Résultats ELS sont valides",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B20,'AOLS Codes'!C20)","v":"SLE results are valid"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E20,'AOLS Codes'!F20)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H20,'AOLS Codes'!I20)","v":"Inactive"}]
[23,"Deploy-Bilingual imper pos","Mut-Impérative poste bilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B21,'AOLS Codes'!C21)","v":"Deploy-Bilingual imper pos"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E21,'AOLS Codes'!F21)","v":"Active"},"Imperative Deployment to a Bilingual position","Mutation impérative à un postee bilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H21,'AOLS Codes'!I21)","v":"Imperative Deployment to a Bilingual position"}]
[24,"Deploy-Bilingual non-imper pos","Mut-Non-impéra poste bilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B22,'AOLS Codes'!C22)","v":"Deploy-Bilingual non-imper pos"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E22,'AOLS Codes'!F22)","v":"Active"},"Non-Imperative Deployment to a Bilingual position","Mutation non-impérative à un poste bilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H22,'AOLS Codes'!I22)","v":"Non-Imperative Deployment to a Bilingual position"}]
[25,"Deploy-English essential pos","Mut-Poste anglais essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B23,'AOLS Codes'!C23)","v":"Deploy-English essential pos"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E23,'AOLS Codes'!F23)","v":"Active"},"Deployment to a English Essential position","Mutation à un postee anglais essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H23,'AOLS Codes'!I23)","v":"Deployment to a English Essential position"}]
[26,"Deploy-French essential pos","Mut-Poste français essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B24,'AOLS Codes'!C24)","v":"Deploy-French essential pos"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E24,'AOLS Codes'!F24)","v":"Active"},"Deployment to a French Essential position ","Mutation à un poste français essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H24,'AOLS Codes'!I24)","v":"Deployment to a French Essential position "}]
[27,"Deploy-English/French ess pos","Mut-Poste angl/fran essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B25,'AOLS Codes'!C25)","v":"Deploy-English/French ess pos"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E25,'AOLS Codes'!F25)","v":"Active"},"Deployment  to a English or French Essential position","Mutation à un poste anglais ou français essentiel",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H25,'AOLS Codes'!I25)","v":"Deployment  to a English or French Essential position"}]
[28,"Deploy/Bilingual Rotation Pos - people working abroad","Mut-Poste de rotation bilingue - personnes travaillant à l'étranger",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B26,'AOLS Codes'!C26)","v":"Deploy/Bilingual Rotation Pos - people working abroad"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E26,'AOLS Codes'!F26)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H26,'AOLS Codes'!I26)","v":"Inactive"}]
[30,"Data Change","Modification Donné",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B27,'AOLS Codes'!C27)","v":"Data Change"},"Active","Actif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E27,'AOLS Codes'!F27)","v":"Active"},"Data Change to OL (for use when there is no Assignments, Promotion, Deployment or Transfer). \nWhen a change to ol data is required e.g. Linguistic status has changed following new SLE results. ","Modification des données LO (À utiliser lorsqu'ucune nomination, promotion, mutation ou aucun trransfert a lieu) Lorsqu'une modification aux données sur les LO est requis, p.ex., le profil linguistique de la personne a changé à ;a suite des nouveaux résultats d'ELS. ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H27,'AOLS Codes'!I27)","v":"Data Change to OL (for use when there is no Assignments, Promotion, Deployment or Transfer). \nWhen a change to ol data is required e.g. Linguistic status has changed following new SLE results. "}]
[50,"Appt-Agree become bilingual","Nom-Engagement dev bilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B28,'AOLS Codes'!C28)","v":"Appt-Agree become bilingual"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E28,'AOLS Codes'!F28)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H28,'AOLS Codes'!I28)","v":"Inactive"}]
[51,"Appt-Medical grounds","Nom-Raison médicale",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B29,'AOLS Codes'!C29)","v":"Appt-Medical grounds"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E29,'AOLS Codes'!F29)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H29,'AOLS Codes'!I29)","v":"Inactive"}]
[52,"Appt-Elig immediate annuity","Nom-Adm pension immédiate",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B30,'AOLS Codes'!C30)","v":"Appt-Elig immediate annuity"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E30,'AOLS Codes'!F30)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H30,'AOLS Codes'!I30)","v":"Inactive"}]
[53,"Deploy-Agree become bilingua","Mut-Engagement dev bilingue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B31,'AOLS Codes'!C31)","v":"Deploy-Agree become bilingua"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E31,'AOLS Codes'!F31)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H31,'AOLS Codes'!I31)","v":"Inactive"}]
[54,"Deploy-Medical grounds","Mutation-Raison médicale",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B32,'AOLS Codes'!C32)","v":"Deploy-Medical grounds"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E32,'AOLS Codes'!F32)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H32,'AOLS Codes'!I32)","v":"Inactive"}]
[55,"Deploy-Elig immediate annuity","Mut-Adm pension immédiate",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B33,'AOLS Codes'!C33)","v":"Deploy-Elig immediate annuity"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E33,'AOLS Codes'!F33)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H33,'AOLS Codes'!I33)","v":"Inactive"}]
[60,"Act appt encumbered bil pos","Nom int poste bil non vacant",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B34,'AOLS Codes'!C34)","v":"Act appt encumbered bil pos"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E34,'AOLS Codes'!F34)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H34,'AOLS Codes'!I34)","v":"Inactive"}]
[61,"Act appt bil pos/lang training","Nom int poste bil/form langue",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B35,'AOLS Codes'!C35)","v":"Act appt bil pos/lang training"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E35,'AOLS Codes'!F35)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H35,'AOLS Codes'!I35)","v":"Inactive"}]
[62,"Act appt pos rotational system","Nom intérim poste permutant",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!B36,'AOLS Codes'!C36)","v":"Act appt pos rotational system"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!E36,'AOLS Codes'!F36)","v":"Inactive"},"Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'AOLS Codes'!H36,'AOLS Codes'!I36)","v":"Inactive"}]

{"sheet":"LSI Codes","index":4,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Code ","Eng Description","FR description","Status","État","Definition","Définition"]
[10,"10-Meets OL req - Entlitled to BB","10-Satisfait - reçoit PB","Active","Actif","Use this value when the employee MEETS the OL requirement of the Position, and IS ENTITLED to the Bilingual Bonus","Utilisez cette valeur lorsque l'employé satisfait à l'exigence de LO du poste et EST Admissible à la prime au bilinguisme",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B2,'LSI Codes'!C2)","v":"10-Meets OL req - Entlitled to BB"}]
["11","Awaiting SLE results","En attente résults ELS","Inactive","Inactif","Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B3,'LSI Codes'!C3)","v":"Awaiting SLE results"}]
["12","Pos ling data missing-Bil",null,"Inactive","Inactif","Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B4,'LSI Codes'!C4)","v":"Pos ling data missing-Bil"}]
["13","Bil-Appt status missing/uni",null,"Inactive","Inactif","Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B5,'LSI Codes'!C5)","v":"Bil-Appt status missing/uni"}]
[14,"14-Meets OL req-Not Entd to BB","14-Satisf LO-ne reçoit pas","Active","Actif","Use this value when the employee MEETS the OL requirement of the Position, but IS NOT ENTITLED to the Bilingual Bonus (ie – Executives, Translators, NFB)","Utilisez cette valeur lorsque l'employé satisfait à l'exigence de LO du poste, mais N'EST PAS admissible à la prime bilingue (c.-à-d. Cadres, traducteurs, ONF) ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B6,'LSI Codes'!C6)","v":"14-Meets OL req-Not Entd to BB"}]
[15,"15-Not required to meet OL req","15-Pas obligé-Satisf exig. LO","Active","Actif","Use this value when the employee is NOT REQUIRED TO MEET any OL requirement (ie – Casuals, Acting less than 4 months, etc..)","Utilisez cette valeur lorsque l'employé N'EST PAS REQUIS DE RÉPONDRE à une exigence de LO (c.-à-d. occasionnels, agissant moins de 4 mois, etc.) ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B7,'LSI Codes'!C7)","v":"15-Not required to meet OL req"}]
[16,"16-Does not meet - gets BB","16-Ne rencontre pas-reçoit PB","Active","Actif","Use this value when the employee DOES NOT MEET the OL requirement, but IS STILL ENTITLED to the Bilingual Bonus","Utilisez cette valeur lorsque l'employé NE RÉPOND PAS à l'exigence de LO, mais EST TOUJOURS Admissible à la prime au bilinguisme ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B8,'LSI Codes'!C8)","v":"16-Does not meet - gets BB"}]
["20","20 - Employee does not meet","20 - L'employé rencontre pas","Inactive","Inactif","Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B9,'LSI Codes'!C9)","v":"20 - Employee does not meet"}]
["21","Exmp appt/depl/renum/restr","Exemption nom/mut/","Inactive","Inactif","Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B10,'LSI Codes'!C10)","v":"Exmp appt/depl/renum/restr"}]
["22","Unilingual to bilingual","Unilingue à bilingue ","Inactive","Inactif","Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B11,'LSI Codes'!C11)","v":"Unilingual to bilingual"}]
["23","Raised ling prof-doesnt mt",null,"Inactive","Inactif","Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B12,'LSI Codes'!C12)","v":"Raised ling prof-doesnt mt"}]
["24","New SLE results lower prf",null,"Inactive","Inactif","Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B13,'LSI Codes'!C13)","v":"New SLE results lower prf"}]
["26","Refusal to take a new test",null,"Inactive","Inactif","Inactive","Inactif",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B14,'LSI Codes'!C14)","v":"Refusal to take a new test"}]
[30,"30-PSOLEO Must meet OL reqm'","30-DELOFP doit satisfaire LO","Active","Actif","Use this value per the Public Service Official Languages Exclusion Approval Order - When the Aptmt Official Language Status = Bilingual Non-Imperative (14 or 24) and the employee DOES NOT MEET the language requirement, and they submit an agreement to become bilingual.","Utilisez cette valeur conformément au décret d'exclusion des langues officielles dans la fonction publique - Lorsque le statut de langue officielle d'Aptmt = bilingue non impératif (14 ou 24) et que l'employé NE RENCONTRE PAS les exigences linguistiques et soumet un accord de devenir bilingue. ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B15,'LSI Codes'!C15)","v":"30-PSOLEO Must meet OL reqm'"}]
[31,"31-PSOLEO Medical grounds","31-DELOFP raison médicale","Active","Actif","Use this value per the Public Service Official Languages Exclusion Approval Order - When the Aptmt Official Language Status = Bilingual Non-Imperative (14 or 24) and the employee DOES NOT MEET, and is excluded for medical reasons","Utilisez cette valeur conformément au décret d'exclusion des langues officielles dans la fonction publique - Lorsque le statut de langue officielle d'Aptmt = bilingue non impératif (14 ou 24) et le l'employé NE RENCONTRE PAS et est exclu pour des raisons médicales ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B16,'LSI Codes'!C16)","v":"31-PSOLEO Medical grounds"}]
[32,"32-PSOLEO Elig. immed. annuity","32-DELOFP adm pension imméd","Active","Actif","Use this value per the Public Service Official Languages Exclusion Approval Order - When the Aptmt Official Language Status = Bilingual Non-Imperative (14 or 24) and the employee DOES NOT MEET and is eligible for an immediate annuity - irrevocable resignation to leave / retire within 2 years","Utilisez cette valeur conformément au décret d'exclusion des langues officielles dans la fonction publique - Lorsque le statut de langue officielle d'Aptmt = bilingue non impératif (14 ou 24) et le l'employé NE RENCONTRE PAS et est admissible à une rente immédiate - irrévocable démission pour quitter / prendre sa retraite dans les 2 ans ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B17,'LSI Codes'!C17)","v":"32-PSOLEO Elig. immed. annuity"}]
[40,"40-Act Apt encum. bil position","40-Nom inter poste bil non vac","Active","Actif","Use this value when the employee DOES NOT MEET and falls under the following exclusion under the Public Service Employment Regulations (PSER) - An acting appointment of 4 months or more, but not more than 12 months, to an encumbered bilingual position that the Commission cannot fill with an acting appointment of a person who meets the language proficiency qualification under paragraph 30(2)(a) of the Act is excluded from the application of that paragraph respecting official language proficiency","Utilisez cette valeur lorsque l'employé NE SE RENCONTRE PAS et relève de ce qui suit exclusion en vertu du Règlement sur l'emploi dans la fonction publique (REFP) - Une nomination de 4 mois ou plus, mais pas plus de 12 mois, à un poste bilingue que la Commission ne peut combler par la nomination intérimaire d'une personne qui satisfait à la qualification de compétence linguistique en vertu de l'alinéa 30 (2) a) de la Loi est exclus de l'application de cet alinéa concernant la maîtrise des langues officielles ",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B18,'LSI Codes'!C18)","v":"40-Act Apt encum. bil position"}]
[41,"41-Act Apt bil pos/lng trainin","41-Nom inter pst bil/form lang","Active","Actif","Use this value when the employee DOES NOT MEET and falls under the following exclusion under the Public Service Employment Regulations (PSER) - An acting appointment of 4 months or more, but not more than 18 months, to a bilingual position, while the incumbent is on language training, that the Commission cannot fill with an acting appointment of a person who meets the language proficiency qualification under paragraph 30(2)(a) of the Act is excluded from the application of that paragraph respecting official language proficiency","Utilisez cette valeur lorsque l'employé NE RENCONTRE PAS et relève de l'exclusion suivante du Règlement sur l'emploi dans la fonction publique (REFP) - Une nomination intérimaire de 4 mois ou plus, mais pas plus de 18 mois, à un poste bilingue, alors que le titulaire est sur la formation linguistique, que la Commission ne peut combler par la nomination intérimaire d'une personne qui satisfait à la qualification de compétence linguistique prévue à l'alinéa 30 (2) a) de la Loi est exclue de l'application de cet alinéa concernant la maîtrise des langues officielles",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B19,'LSI Codes'!C19)","v":"41-Act Apt bil pos/lng trainin"}]
[50,"50-Pos Rotatnl system","50 Poste permutant","Active","Actif","Use this value when the employee DOES NOT MEET and falls under the following exclusion under the Public Service Employment Regulations (PSER) - an acting appointment to a position in a rotational system established by the deputy head, in order to provide for the movement of employees within and outside Canada in the following organization is excluded from the application of sections 30 and 77 of the Act: Department of Citizenship and Immigration Department of Foreign Affairs and International Trade Canada Border Services Agency","Utilisez cette valeur lorsque l'employé NE SE RENCONTRE PAS et relève de l'exclusion suivante du Règlement sur l'emploi dans la fonction publique (REFP) - une nomination intérimaire à un poste dans un système de rotation établi par l'administrateur général, afin de permettre le mouvement des employés au Canada et à l'étranger dans l'organisation suivante est exclue de l'application des articles 30 et 77 de la Loi: Ministère de la Citoyenneté et de l'Immigration Ministère des Affaires étrangères et du Commerce international Agence des services frontaliers du Canada",{"$f":"IF('General Information Générale'!$Z$1=\"e\",'LSI Codes'!B20,'LSI Codes'!C20)","v":"50-Pos Rotatnl system"}]

{"sheet":"REH _ Bilingual Posn ","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet1","index":6,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,5,0,6],[2,8,6,8],[3,2,6,2],[8,1,11,1],[8,4,11,4],[8,8,11,8],[10,2,11,2],[2,0,17,0],[2,1,6,1],[2,4,6,4],[30,2,30,4],[31,1,31,4],[28,2,28,4],[29,1,29,4],[13,2,13,4],[15,2,15,4],[16,1,16,4],[17,2,17,4],[32,2,32,4],[34,0,36,0],[34,1,36,1],[34,4,36,4],[19,0,32,0],[19,1,20,1],[19,4,20,4],[21,1,21,4],[22,1,26,1],[22,4,26,4],[24,2,26,2],[27,1,27,4]]}
[null,"Business description of the Appointment Official Languages Status codes","Linguistic Status of Incumbent options",null,null,"Existing Editing in HR systems\n&\nMessage Description",null,"Applies to which specific scenario and which HR system"]
["Series","If the action is… ","Select… \nIf Employee Meets language requirements: ","Select… \nIf Employee does NOT meet language requirements: ","Select… \nIf SLE result is unrecognized by PSC",8.9,9.1,null,"Questions and Answers"]
["Series 10 - The employee meets the language requirements of the position","13 – Appointment / Promotion (Bilingual position imperative) \nPCIS website = \nAppointment - Imperative, bilingual position","10 – Meets OL Req - Entitled to BB ","15  – NOT Required to meet OL Req ","17  – Meets OL-Not PSC-No Entd BB \n(Example: Department or Agency is not subject to PSEA)",null,"If you chose codes 15 or 16 for a bilingual imperative position :\nThe Aptmt Official Language Status and Linguistic Status of Incumbent are required for Bilingual Pos (21000,50).\n\nThe position's language requirement is bilingual and either the Appointment Official Language Status and/or the Linguistic Status of Incumbent are not valued.Please ensure both values are entered and correct.","* we can note type of appointment:  for e.g. exrenal or internal appointment.  Imperative appointment in a bilingual position\n* Action Reason that can be used for this code combination :  for e.g. HIR, REH, Transfer, Data Change/  Official Langauges\n* Correction:  in the event the wrong code is used - you can use Correct History functionality.\nCorrecting historical data rows will require sending a Data Correction data row.\n* employee gets Bilingual bonus","Series 10 - The employee meets the language requirements of the position\n\nQuestion: Does 15 - NOT required to meet OL Req fit in there? "]
[null,null,"14  – Meet OL Req - NOT entitled to BB \n(e.g. EX, Translators )","16  – Does not meet - gets BB  \n(Example: Retested - notice period to meet) "]
[null,null,null,"40 – Acting appointment encumbered bilingual position - exclusion under PSER "]
[null,null,null,"41 – Acting appointment in bilingual position while incumbent on Language Training - exclusion under PSER"]
[null,null,null,"50 – Acting appointment to position in rotational system – exclusion under PSER"]
[null,"  "]
[null,"14 – Appointment / Promotion (Bilingual position non-imperative) \nPCIS website = \nAppointment - Non-imperative, bilingual position","10 – Meets OL Req - Entitled to BB  ","15  – NOT Required to meet OL Req    ","17  – Meets OL-Not PSC-No Entd BB \n(Example: Department or Agency is not subject to PSEA)",null,null,null,"Question: Does 10 - Meets OL req - Entitled to BB fit there?\nThis is NOT a NON-IMPERATIVE position\nSame question for 14  – Meet OL Req - NOT entitled to BB"]
[null,null,"14  – Meet OL Req - NOT entitled to BB\n(e.g. EX, Translators )","30 – PSOLEO Employee must meet OL requirements \n(insert a Target Date for employee to Meet) "]
[null,null,null,"31 – PSOLEO Medical Grounds exclusion "]
[null,null,null,"32 – PSOLEO Eligible Immediate Annuity exclusion  "]
[]
[null,"15 – Appointment / Promotion (English essential position)   ","Not applicable – Leave BLANK "]
[]
[null,"16 – Appointment / Promotion (French essential position) ","Not applicable – Leave BLANK "]
[null,"  "]
[null,"17 – Appointment / Promotion (English or French essential position) \nPCIS website = \nAppointment - English or French essential position ('Either-Or')","Not applicable – Leave BLANK"]
["  "]
["Series 20 - The employee does not meet and is exempt from meeting the language requirements as a result of","23 – Deployment / Transfer (Bilingual position imperative) \nPCIS website = \nDeployment - Imperative, bilingual position","10  – Meets OL Req - Entitled to BB ","15  – NOT Required to meet OL Req    ","17  – Meets OL-Not PSC-No Entd BB \n(Example: Department or Agency is not subject to PSEA)",null,null,null,"Series 20 - The employee does not meet and is exempt from meeting the language requirements as a result of"]
[null,null,"14  – Meet OL Req - NOT entitled to BB\n(e.g. EX, Translators ) ","16  – Does not meet - gets BB  \n(Example: Retested - notice period to meet) "]
[]
[null,"24 – Deployment / Transfer (Bilingual position non-imperative) \nPCIS website = \nDeployment - Non-imperative, bilingual position","10  – Meets OL Req - Entitled to BB ","15  – NOT Required to meet OL Req    ","17  – Meets OL-Not PSC-No Entd BB \n(Example: Department or Agency is not subject to PSEA)"]
[null,null,"14  – Meet OL Req - NOT entitled to BB\n(e.g. EX, Translators ) "]
[null,null,null,"30 – PSOLEO Employee must meet OL requirements \n(insert a Target Date for employee to Meet) "]
[null,null,null,"31 – PSOLEO Medical Grounds exclusion "]
[null,null,null,"32 – PSOLEO Eligible Immediate Annuity exclusion  "]
[null,"  "]
[null,"25 - Deployment / Transfer (English essential position) \nPCIS website = \nDeployment - English essential position","Not applicable – Leave BLANK"]
[null,"  "]
[null,"26 - Deployment / Transfer (French essential position) \nPCIS website = \nDeployment - French essential position","Not applicable – Leave BLANK"]
[null,"  "]
[null,"27 – Deployment / Transfer (English or French essential position) \nPCIS website = \nDeployment - English or French essential position ('Either-Or')","Not applicable – Leave BLANK"]
["  "]
["Series 30 = Non-imperative staffing action","30 – Data Change  \n(For use when no Appointment / Promotion / Deployment or Transfer is taking place, but a change to OL Data is required – e.g. linguistic profile of position is changed, or individual’s linguistic status has changed, etc…)  ","10  – Meets OL Req - Entitled to BB ","15  – NOT Required to meet OL Req    ","17  – Meets OL-Not PSC-No Entd BB \n(Example: Department or Agency is not subject to PSEA)"]
[null,null,"14  – Meet OL Req - NOT entitled to BB\n(e.g. EX, Translators ) ","16  – Does not meet - gets BB  \n(Example: Retested - notice period to meet) "]
[null,null,null,"30 – PSOLEO Employee must meet OL requirements \n(insert a Target Date for employee to Meet ) "]
["  "]