1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
| > head(FRUB01)
DATE_EXPL MAT NOM_PRENOM DIREC CPT_ANA ECHELLE ECHELON COD_FONCT N_RIP_RIB CAISSE
1 01/2014 00879U CAROLE EVRA Q71T 2F5016 25 6 24020YK73 7.99999e+17 3
2 01/2014 00879U CAROLE EVRA Q71T 2F5016 25 6 24020YK73 7.99999e+17 3
3 01/2014 00879U CAROLE EVRA Q71T 2F5016 25 6 24020YK73 7.99999e+17 3
4 01/2014 00879U CAROLE EVRA Q71T 2F5016 25 6 24020YK73 7.99999e+17 3
5 01/2014 00879U CAROLE EVRA Q71T 2F5016 25 6 24020YK73 7.99999e+17 3
6 01/2014 00879U CAROLE EVRA Q71T 2F5016 25 6 24020YK73 7.99999e+17 3
NUM_SS NUM_ADHER DATE_NAISS MOIS_EFFET ANN_EFFET CODE_PAIE NO_RUB LIB_RUB
1 5.90041e+11 565789 21021959 1 2014 1 100 SALAIRE DE BASE
2 5.90041e+11 565789 21021959 1 2014 1 176 IND.ANCIENNETE GROUPE
3 5.90041e+11 565789 21021959 1 2014 1 200 SALAIRE UNIQUE
4 5.90041e+11 565789 21021959 1 2014 1 289 I Z C V G
5 5.90041e+11 565789 21021959 1 2014 1 300 ASSURANCE SOCIALE
6 5.90041e+11 565789 21021959 1 2014 1 302 RETRAITE
CODE_NATUR DT_DEB DE_FIN MT_MOIS MT_RAPPEL TAUX ELEM_STAT
1 1 NA NA 191,317.42 0.00 0.00 0.00
2 1 NA NA 33,592.65 0.00 0.00 0.00
3 1 NA NA 1,500.00 0.00 0.00 0.00
4 1 NA NA 61,850.79 0.00 290.77 27.00
5 1 NA NA 3,373.65 0.00 1.50 224,910.07
6 1 NA NA 15,181.42 0.00 6.75 224,910.07
> str(FRUB01)
'data.frame': 114933 obs. of 25 variables:
$ DATE_EXPL : Factor w/ 1 level "01/2014": 1 1 1 1 1 1 1 1 1 1 ...
$ MAT : Factor w/ 5588 levels "00327A","00608U",..: 17 17 17 17 17 17 17 17 17 17 ...
$ NOM_PRENOM: Factor w/ 5565 levels "GARRY DUPONT",..: 5225 5225 5225 5225 5225 5225 5225 5225 5225 5225 ...
$ DIREC : Factor w/ 83 levels "Q71","Q711","Q712",..: 11 11 11 11 11 11 11 11 11 11 ...
$ CPT_ANA : Factor w/ 22 levels "2B5010","2D5015",..: 6 6 6 6 6 6 6 6 6 6 ...
$ ECHELLE : Factor w/ 30 levels "00","11","12",..: 16 16 16 16 16 16 16 16 16 16 ...
$ ECHELON : int 6 6 6 6 6 6 6 6 6 6 ...
$ COD_FONCT : Factor w/ 958 levels "01010109","01010111",..: 804 804 804 804 804 804 804 804 804 804 ...
$ N_RIP_RIB : num 8e+17 8e+17 8e+17 8e+17 8e+17 ...
$ CAISSE : int 3 3 3 3 3 3 3 3 3 3 ...
$ NUM_SS : num 5.9e+11 5.9e+11 5.9e+11 5.9e+11 5.9e+11 ...
$ NUM_ADHER : int 565789 565789 565789 565789 565789 565789 565789 565789 565789 565789 ...
$ DATE_NAISS: Factor w/ 4270 levels "01011955","01011956",..: 2888 2888 2888 2888 2888 2888 2888 2888 2888 2888 ...
$ MOIS_EFFET: int 1 1 1 1 1 1 1 1 1 1 ...
$ ANN_EFFET : int 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 ...
$ CODE_PAIE : int 1 1 1 1 1 1 1 1 1 1 ...
$ NO_RUB : Factor w/ 87 levels "100","102","104",..: 1 24 26 41 54 55 56 57 61 68 ...
$ LIB_RUB : Factor w/ 89 levels "ACC. TRAV. EMPLOYEUR",..: 88 27 89 18 5 82 83 69 42 9 ...
$ CODE_NATUR: int 1 1 1 1 1 1 1 1 1 1 ...
$ DT_DEB : int NA NA NA NA NA NA NA NA NA NA ...
$ DE_FIN : int NA NA NA NA NA NA NA NA NA NA ...
$ MT_MOIS : Factor w/ 61497 levels "-113,635.15 ",..: 24374 36690 7111 48231 34691 20137 45145 1760 39337 26027 ...
$ MT_RAPPEL : Factor w/ 971 levels "-1,005.86 ","-1,274.00 ",..: 72 72 72 72 72 72 72 72 72 72 ...
$ TAUX : num 0 0 0 290.8 1.5 ...
$ ELEM_STAT : Factor w/ 10552 levels "0.00 ","0.90 ",..: 1 1 1 4868 4704 4704 4704 4704 4704 4704 ...
>
> head(FRUB02)
DATE_EXPL MAT NOM_PRENOM DIREC CPT_ANA ECHELLE ECHELON COD_FONCT N_RIP_RIB
1 02/2014 01390H MICHELLE SAVIER QA1 2G5001 22 0 13020111 00799999000769168496
2 02/2014 01390H MICHELLE SAVIER QA1 2G5001 22 0 13020111 00799999000769168496
3 02/2014 01390H MICHELLE SAVIER QA1 2G5001 22 0 13020111 00799999000769168496
4 02/2014 01390H MICHELLE SAVIER QA1 2G5001 22 0 13020111 00799999000769168496
5 02/2014 01390H MICHELLE SAVIER QA1 2G5001 22 0 13020111 00799999000769168496
6 02/2014 01390H MICHELLE SAVIER QA1 2G5001 22 0 13020111 00799999000769168496
CAISSE NUM_SS NUM_ADHER DATE_NAISS MOIS_EFFET ANN_EFFET CODE_PAIE NO_RUB
1 1 8.51724e+11 416239 10101985 02 2014 1 100
2 1 8.51724e+11 416239 10101985 02 2014 1 143
3 1 8.51724e+11 416239 10101985 02 2014 1 176
4 1 8.51724e+11 416239 10101985 02 2014 1 300
5 1 8.51724e+11 416239 10101985 02 2014 1 302
6 1 8.51724e+11 416239 10101985 02 2014 1 304
LIB_RUB CODE_NATUR DT_DEB DE_FIN MT_MOIS MT_RAPPEL TAUX ELEM_STAT
1 SALAIRE DE BASE 1 NA NA 103243.72 0 0.00 0.0
2 PRIME DE PANIER 1 NA NA 720.00 0 40.00 18.0
3 IND.ANCIENNETE GROUPE 1 NA NA 7416.61 0 0.00 0.0
4 ASSURANCE SOCIALE 1 NA NA 1659.90 0 1.50 110660.3
5 RETRAITE 1 NA NA 7469.57 0 6.75 110660.3
6 RETRAITE ANTICIPEE 1 NA NA 276.65 0 0.25 110660.3
> str(FRUB02)
'data.frame': 115822 obs. of 25 variables:
$ DATE_EXPL : Factor w/ 1 level "02/2014": 1 1 1 1 1 1 1 1 1 1 ...
$ MAT : Factor w/ 5592 levels "00327A","00608U",..: 85 85 85 85 85 85 85 85 85 85 ...
$ NOM_PRENOM: Factor w/ 5568 levels "GARRY DUPONT",..: 1095 1095 1095 1095 1095 1095 1095 1095 1095 1095 ...
$ DIREC : Factor w/ 85 levels "Q711","Q712",..: 11 11 11 11 11 11 11 11 11 11 ...
$ CPT_ANA : Factor w/ 23 levels "000265","2B5010",..: 8 8 8 8 8 8 8 8 8 8 ...
$ ECHELLE : Factor w/ 29 levels "11","12","13",..: 12 12 12 12 12 12 12 12 12 12 ...
$ ECHELON : int 0 0 0 0 0 0 0 0 0 0 ...
$ COD_FONCT : Factor w/ 957 levels "01010109","01010111",..: 483 483 483 483 483 483 483 483 483 483 ...
$ N_RIP_RIB : Factor w/ 5527 levels "00000000000000000000",..: 4417 4417 4417 4417 4417 4417 4417 4417 4417 4417 ...
$ CAISSE : int 1 1 1 1 1 1 1 1 1 1 ...
$ NUM_SS : num 8.52e+11 8.52e+11 8.52e+11 8.52e+11 8.52e+11 ...
$ NUM_ADHER : Factor w/ 21 levels "1100SA","1300AS",..: 19 19 19 19 19 19 19 19 19 19 ...
$ DATE_NAISS: Factor w/ 4269 levels "01011955","01011956",..: 1435 1435 1435 1435 1435 1435 1435 1435 1435 1435 ...
$ MOIS_EFFET: Factor w/ 25 levels "","01","02","03",..: 3 3 3 3 3 3 3 3 3 3 ...
$ ANN_EFFET : Factor w/ 17 levels "","2011","2012",..: 5 5 5 5 5 5 5 5 5 5 ...
$ CODE_PAIE : Factor w/ 11 levels "","/","1","2",..: 3 3 3 3 3 3 3 3 3 3 ...
$ NO_RUB : Factor w/ 103 levels "","100","104",..: 2 17 27 59 60 61 62 66 74 75 ...
$ LIB_RUB : Factor w/ 100 levels "1 000",..: 97 54 35 6 91 92 77 52 11 17 ...
$ CODE_NATUR: int 1 1 1 1 1 1 1 1 1 1 ...
$ DT_DEB : int NA NA NA NA NA NA NA NA NA NA ...
$ DE_FIN : int NA NA NA NA NA NA NA NA NA NA ...
$ MT_MOIS : num 103244 720 7417 1660 7470 ...
$ MT_RAPPEL : num 0 0 0 0 0 0 0 0 0 0 ...
$ TAUX : num 0 40 0 1.5 6.75 0.25 0.5 2 1 0 ...
$ ELEM_STAT : num 0 18 0 110660 110660 ... |
Partager