LIS - Colombia 2004 : person file Codebook generated: 2015-09-26 ------------------------------------------------------------------------------------------------------------------------------------------------ IDENTIFIERS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hid unique unit identifier 50850 1 12510 6147.07 3580.16 pid person identifier 50850 1 23 3.02 1.96 did unique country/year number -------------------------------------------------- N value 50850 202 dname country/year identifier -------------------------------------------------- N value 50850 "co04" cname country name -------------------------------------------------- N value 50850 "Colombia" iso2 2-letter country abbreviation -------------------------------------------------- N value 50850 "co" year reference year -------------------------------------------------- N value 50850 2004 wave data wave -------------------------------------------------------------------------------- N code label 50850 6 Wave VI ------------------------------------------------------------------------------------------------------------------------------------------------ FILE INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- pwgt person weight (normalised) 50850 0.02 5.22 0.2 0.3 ppopwgt person weight (inflated) 50850 76 22557 849.89 1285.3 hhmem household member (dummy) -------------------------------------------------------------------------------- N code label 560 0 not household member 50290 1 household member ------------------------------------------------------------------------------------------------------------------------------------------------ LIVING ARRANGEMENTS ------------------------------------------------------------------------------------------------------------------------------------------------ relation relationship to household head -------------------------------------------------------------------------------- N code label 12510 1000 head 7899 2000 spouse/partner 20859 3000 child 1298 4100 other relative 823 4110 spouse/partner of child 4035 4120 grandchild or greatgrandchild (incl in-laws) 618 4131 parent/grandparent/ascenda nt 255 4132 parent/grandparent/ascenda nt-in-law 1283 4140 siblings (incl in-laws) 710 4200 other non-relative 410 4220 domestic employee and his/her family 150 4230 guest/visitor/boarder/lodg er partner partner -------------------------------------------------------------------------------- N code label 931 100 has partner 17021 110 living with partner 200 120 not living with partner 32159 200 does not have partner 539 . parents living with parents -------------------------------------------------------------------------------- N code label 5693 110 living with one parent 15166 120 living with two parents 29991 . children living with own children -------------------------------------------------------------------------------- N code label 5139 110 living with own children aged 0-5 4273 120 living with own children 6-12 2383 130 living with own children 13-17 4892 140 living with own children 18+ 3722 200 not living with own children 30441 . nchildren number of own children living in household -------------------------------------------------------------------------------- N code label 3722 0 not living with own children 5499 1 living with 1 own child 5921 2 living with 2 own children 3422 3 living with 3 own children 1215 4 living with 4 own children 375 5 living with 5 own children 169 6 living with 6 own children 41 7 living with 7 own children 33 8 living with 8 own children 6 9 living with 9 own children 4 10 living with 10 own children 2 12 living with 12 own children 30441 . Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- ageyoch age of youngest own child living in household 16687 0 75 13.2 11.24 ------------------------------------------------------------------------------------------------------------------------------------------------ DEMOGRAPHICS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- age age in years 50850 0 99 29.31 20.31 sex gender -------------------------------------------------------------------------------- N code label 24067 1 male 26783 2 female marital marital status -------------------------------------------------------------------------------- N code label 10201 110 married 7960 120 in consensual union 27239 210 never married/not in union 3442 220 formerly married/in union 2008 223 widowed NOTES: 1. [co04] Mixed categories: formerly married/in union includes only separated or divorced. ------------------------------------------------------------------------------------------------------------------------------------------------ IMMIGRATION ------------------------------------------------------------------------------------------------------------------------------------------------ immigr immigrant (dummy) -------------------------------------------------------------------------------- N code label 50671 0 not immigrant 165 1 immigrant 14 . ctrybrth country of birth -------------------------------------------------------------------------------- N code label 50671 1000 born in the country 32 2000 born outside the country 20 2266 Ecuador 96 2274 Venezuela 17 2283 United States of America 14 . migrat_c migration -------------------------------------------------------------------------------- N code label 5139 205 born in Antioquia 3596 208 born in Atlántico 2502 211 born in Bogotá, distrito capital 3675 213 born in Bolívar 1240 215 born in Boyacá 3042 217 born in Caldas 1345 218 born in Caquetá 916 219 born in Cauca 1364 220 born in Cesar 2622 223 born in Córdoba 1161 225 born in Cundinamarca 583 227 born in Choco 978 241 born in Huila 1536 244 born in La Guajira 427 247 born in Magdalena 1425 250 born in Meta 2607 252 born in Narino 2480 254 born in Norte de santander 1112 263 born in Quindio 2854 266 born in Risaralda 3194 268 born in Santander 802 270 born in Sucre 2747 273 born in Tolima 3069 276 born in Valle del cauca 77 281 born in Arauca 52 285 born in Casanare 77 286 born in Putumayo 4 288 born in San Andrés y providencia 9 291 born in Amazonas 4 294 born in Guainia 21 295 born in Guaviare 2 297 born in Vaupes 9 299 born in Vichada 165 300 born abroad 14 . ------------------------------------------------------------------------------------------------------------------------------------------------ HEALTH ------------------------------------------------------------------------------------------------------------------------------------------------ disabled disabled (dummy) -------------------------------------------------------------------------------- N code label 38149 0 not disabled 439 1 disabled 12262 . NOTES: 1. [co04] Disabled refers to work disablement. disabl_c disability status -------------------------------------------------------------------------------- N code label 38149 0 not permanently disabled 439 1 permanently disabled 12262 . NOTES: 1. [co04] the disability status only in connection with work (a person is coded as disabled only if the permanent disability prevents work) ------------------------------------------------------------------------------------------------------------------------------------------------ EDUCATION ------------------------------------------------------------------------------------------------------------------------------------------------ educ highest completed education level (3-category recode) -------------------------------------------------------------------------------- N code label 30865 1 low 8452 2 medium 6834 9 indistinguishable 4699 . NOTES: 1. [co04] Mixed categories: code 9 includes all who attended tertiary education with or without degree. educ_c highest level of education completed -------------------------------------------------------------------------------- N code label 2182 0 none 774 10 pre-primary, started 1167 20 primary, started first year 1575 21 primary, first year completed 2567 22 primary, second year completed 2795 23 primary, third year completed 2100 24 primary, fourth year completed 5912 25 completed primary school 1109 30 lower secondary, started first year 2286 31 lower secondary, first year completed 2406 32 lower secondary, second year completed 2339 33 lower secondary, third year completed 2163 34 completed lower secondary school 1490 41 upper secondary, not completed 8452 42 completed upper secondary school (Bachiller) 681 50 tertiary, started first year 719 51 tertiary, first year completed 874 52 tertiary, second year completed 1028 53 tertiary, third year completed 577 54 tertiary, fourth year completed 2163 55 tertiary, fifth year completed 348 56 tertiary, sixth year completed 255 57 tertiary, seventh year completed 78 58 tertiary, eigth year completed 111 59 tertiary, nine or more years completed 4699 . enroll currently enrolled in education -------------------------------------------------------------------------------- N code label 2420 100 currently enrolled 11951 110 enrolled in full-time education 31970 200 currently not enrolled 4509 . enrlev_c country-specific education level currently enrolled in -------------------------------------------------------------------------------- N code label 758 110 enrolled in pre-primary school 5628 120 enrolled in primary school 5565 130 enrolled in secondary school 2406 140 enrolled in third level education 14 199 enrolled, unknown level 31970 200 not enrolled 4509 . literate literate -------------------------------------------------------------------------------- N code label 42460 110 can read and write 3691 200 illiterate 4699 . ------------------------------------------------------------------------------------------------------------------------------------------------ ACTIVITY STATUS ------------------------------------------------------------------------------------------------------------------------------------------------ emp employed (dummy) -------------------------------------------------------------------------------- N code label 19690 0 not employed 20516 1 employed 10644 . mainemp mainly employed (dummy) -------------------------------------------------------------------------------- N code label 22477 0 not mainly employed 17126 1 mainly employed 11247 . NOTES: 1. [co04] Definitional deviation: The mainly employed dummy is based on the main activity status in current period. unemp unemployed (dummy) -------------------------------------------------------------------------------- N code label 33586 0 not unemployed 3600 1 unemployed 13664 . clfs current labour force status -------------------------------------------------------------------------------- N code label 20167 110 employed, at work 349 120 employed, not at work 3020 200 not employed 41 210 unemployed 3539 211 ILO unemployed 20 212 other unemployed 1080 220 not in labour force 978 221 retired, pensioner or rentier 6105 222 in education 4465 223 homemaker 442 224 disabled 10644 . cmas current main activity status -------------------------------------------------------------------------------- N code label 17126 100 mainly employed 2560 200 not mainly employed 1066 211 retired from job or business 7547 220 in education 9041 230 homemaker 442 240 disabled 1821 260 unemployed 11247 . NOTES: undur: 1. [co04] Topcoded at 259 weeks. Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- undur duration of current unemployment spell 3778 1 259 51.62 61.64 jsearch type of job search -------------------------------------------------------------------------------- N code label 7132 100 searching 32029 200 not searching 11689 . leave type of long-term leave -------------------------------------------------------------------------------- N code label 349 1000 on leave from employment 20167 2000 not on leave 30334 . ------------------------------------------------------------------------------------------------------------------------------------------------ EMPLOYMENT INTENSITY ------------------------------------------------------------------------------------------------------------------------------------------------ ptime part-time in all jobs (dummy) -------------------------------------------------------------------------------- N code label 16208 0 full-time 4150 1 part-time 30492 . Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hours weekly hours worked, any information 20358 1 99 46.68 18.69 secjob multiple jobs holder (dummy) -------------------------------------------------------------------------------- N code label 19410 0 one job 966 1 more than one job 30474 . ------------------------------------------------------------------------------------------------------------------------------------------------ JOB CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ status1 status in employment, job 1 -------------------------------------------------------------------------------- N code label 9613 110 regular employee 449 121 temporary or occasional worker 1038 210 employer 8241 220 own-account worker 985 240 contributing family worker 30524 . inda1 industry (3-category recode), job 1 -------------------------------------------------------------------------------- N code label 2153 1 agriculture 4283 2 industry 13934 3 services 30480 . indb1 industry (9-category recode), job 1 -------------------------------------------------------------------------------- N code label 2153 1 agriculture, forestry and fishing 3306 2 mining and quarrying; manufacturing; utilities 977 3 construction 6112 4 wholesale and retail trade, repair; hotels and restaurants 1681 5 transport, storage and communications 249 6 financial intermediation 964 7 real estate, renting and business activities 2627 8 public administration; education; health and social work 2301 9 other community, social/personal services; activities of households; extra-territorial 30480 . indc1 industry (17-category ISIC 3.1 recode), job 1 -------------------------------------------------------------------------------- N code label 2105 1 A-agriculture, hunting and forestry 48 2 B-fishing 216 3 C-mining and quarrying 2990 4 D-manufacturing 100 5 E-electricity, gas and water supply 977 6 F-construction 4985 7 G-wholesale and retail trade; repair 1127 8 H-hotels and restaurants 1681 9 I-transport, storage and communications 249 10 J-financial intermediation 964 11 K-real estate, renting and business activities 655 12 L-public administration and defence; compulsory social security 1109 13 M-education 863 14 N-health and social work 1173 15 O-other community, social and personal service activities 1121 16 P-activities of private households as employers 7 17 Q-extra-territorial organizations and bodies 30480 . ind1_c industry in main job (based on ISIC) -------------------------------------------------------------------------------- N code label 2086 1010 agriculture, hunting & related service activities 19 1020 forestry, logging & related service activities 48 2050 fishing, operation of fish hatcheries & fish farms; rsa 64 3100 mining of coal & lignite; extraction of peat 16 3110 extract. of crude petrol & nat. gas; rsa excl. surveying 116 3130 mining of metal ores 20 3140 other mining and quarrying 760 4150 manufacture of food products and beverages 17 4160 manufacture of tobacco products 135 4170 manufacture of textiles 675 4180 manuf. of wearing apparel; dressing, dyeing of fur 195 4190 tanning & dressing of leather; manuf. of luggage, etc. 82 4200 manuf. of wood & wood products except furniture 30 4210 manuf. of paper & paper products 117 4220 publishing, printing & reproduction of recorded media 6 4230 manuf. of coke, refined petroleum products, nuclear fuel 98 4240 manuf. of chemicals & chemical products 81 4250 manuf. of rubber & plastic products 90 4260 manuf. of other non-metallic mineral products 18 4270 manuf. of basic metals 189 4280 manuf. of fabricated metal products, exc. machinery 47 4290 manuf. of machinery & equipment n.e.c 6 4300 manuf. of office, accounting & computing machinery 19 4310 manuf. of electrical mach. & apparatus n.e.c. 1 4320 manuf. of radio, tv, communication equipment 27 4330 manuf. of medical, precision & optical instruments, watches 50 4340 manuf. of motor vehicles, trailers & semi-trailers 14 4350 manuf. of other transport equipment 322 4360 manuf. of furniture; manufacturing n.e.c. 11 4370 recycling 64 5400 electricity, gas, steam and hot water supply 36 5410 collection, purification, distribution of water 977 6450 construction 685 7500 sale, maintenance & repair of motor vehicles; fuel sale 597 7510 wholesale trade & commission trade exc. motor veh. 3703 7520 retail trade exc. motor vehicles; repair of pers. goods 1127 8550 hotels and restaurants 1133 9600 land-transport; transport via pipelines 6 9610 water transport 13 9620 air transport 243 9630 supporting & auxiliary transport activities; travel ag. 286 9640 post & telecommunications 165 10650 financial intermediation exc. insurance & pension 61 10660 insurance & pension funding exc. compul. social sec. 23 10670 activities auxiliary to financial intermediation 195 11700 real estate activities 28 11710 renting of machinery & equipment w/o operator 106 11720 computer & related activities 6 11730 research and development 629 11740 other business activities 655 12750 public administration & defence; compul. social sec. 1109 13800 education 863 14850 health and social work 29 15900 sewage & refuse disposal, sanitation & similar activ. 121 15910 activities of membership organisations n.e.c. 410 15920 recreational, cultural, sporting activities 613 15930 other service activities 1121 16950 private households with employed persons 7 17990 extra-territorial organisations & bodies 30480 . sector1 sector of employment, job 1 -------------------------------------------------------------------------------- N code label 7241 100 private sector 1375 200 public sector 42234 . occa1 occupation (3-category recode), job 1 -------------------------------------------------------------------------------- N code label 3462 1 managers and professionals (ISCO 1 & 2) 15797 2 other skilled workers (ISCO 3-8, 10) 1107 3 labourers/elementary (ISCO 9) 30484 . occb1 occupation (10-category ISCO recode), job 1 -------------------------------------------------------------------------------- N code label 1634 1 managers 1828 2 professionals 845 3 technicians and associate professionals 1607 4 clerical support workers 6457 5 service and sales workers 1922 6 skilled agricultural, forestry and fishery workers 2661 7 craft and related trades workers 2305 8 plant and machine operators, and assemblers 1107 9 elementary occupations 30484 . NOTES: 1. [co04] The original classification is ISCO68 - Groups 2 and 3 may be grouped in a few cases. occ1_c occupation in main job, based on ISCO-68 -------------------------------------------------------------------------------- N code label 9 1 physical scientists and related technicians 140 2 architects and engineers 60 3 technicians related to architects and engineers 50 5 life scientists and related technicians 154 6 medical, dental, veterinary and related workers, professiona 93 7 medical, dental, veterinary and related workers, technicians 68 8 statisticians, mathematicians, systems analysts and related 19 9 economists 128 11 accountants 138 12 jurists 870 13 teachers 38 14 workers in religion 18 15 authors, journalists and related writers 81 16 sculptors, painters, photographers and related creative arti 52 17 composers and performing artists 46 18 athletes, sportsmen and related workers 67 19 professional, technical and related workers not elsewhere cl 18 20 legislative officials and government administrators 413 21 managers 32 30 clerical supervisors 16 31 government executive officials 431 32 stenographers, typists and card- and tape-punching machine o 394 33 bookkeepers, cashiers and related workers 99 34 computing machine operators 30 35 transport and communications supervisors 39 36 transport conductors 267 37 mail distribution clerks 54 38 telephone and telegraph operators 485 39 clerical and related workers not elsewhere classified 98 40 managers (wholesale and retail trade) 815 41 working proprietors (wholesale and retail trade) 72 42 sales supervisors and buyers 102 43 technical salesmen, commercial travellers and manufacturers' 181 44 insurance, real estate, securities and business services sal 2901 45 salesmen, shop assistants and related workers 15 49 sales workers not elsewhere classified 45 50 managers (catering and lodging services) 124 51 working proprietors (catering and lodging services) 5 52 housekeeping and related service supervisors 876 53 cooks, waiters, bartenders and relaters workers 1168 54 maids and related housekeeping service workers not elsewhere 368 55 building caretakers, charworkers, cleaners and related worke 329 56 launderers, dry-cleaners and pressers 266 57 hairdressers, barbers, beauticians and related workers 594 58 protective service workers 434 59 service workers not elsewhere classified 89 60 farm managers and supervisors 812 61 farmers 1059 62 agricultural and animal husbandry workers 10 63 forestry workers 41 64 fishermen, hunters and related workers 40 70 production supervisors and general foremen 135 71 miners, quarrymen, well drillers and related workers 9 72 metal processers 17 73 wood preparation workers and paper makers 17 74 chemical processers and related workers 60 75 spinners, weavers, knitters, dyers and related workers 1 76 tanners, fellmongers and pelt dressers 380 77 food and beverage processers 11 78 tobacco preparers and tobacco product makers 652 79 tailors, dressmakers, sewers, upholsterers and related worke 152 80 shoemakers and leather goods makers 194 81 cabinetmakers and related woodworkers 1 82 stone cutters and carvers 175 83 blacksmiths, toolmakers and machine-tool operators 384 84 machinery fitters, machine assemblers and precision instrume 292 85 electrical fitters and related electrical and electronics wo 10 86 broadcasting station and sound equipment operators and cinem 149 87 plumbers, welders, sheet metal and structural metal preparer 26 88 jewellery and precious metal workers 56 89 glass formers, potters and related workers 76 90 rubber and plastics product makers 4 91 paper and paperboard products makers 73 92 printers and related workers 148 93 painters 93 94 production and related workers not elsewhere classified 642 95 bricklayers, carpenters and other construction workers 7 96 stationary engine and related equipment operators 389 97 material-handling and related equipment operators, dockers a 1125 98 transport equipment operators 335 99 labourers not elsewhere classified 30484 . ten5yr1 job tenure 5+ years (dummy), job 1 -------------------------------------------------------------------------------- N code label 11927 0 no job tenure 5+ years 8294 1 job tenure 5+ years 30629 . NOTES: gross1: 1. [co04] The hourly wage was calculated from the monthly one using information on weekly hours worked. Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- tenyr1 job tenure in years, job 1 20221 0 70 6.7 8.88 gross1 gross hourly wage, job 1 7988 9.2 496535.8 2593.4 7203.31 ------------------------------------------------------------------------------------------------------------------------------------------------ WORK EXPERIENCE ------------------------------------------------------------------------------------------------------------------------------------------------ everwork ever worked in job or business (dummy) -------------------------------------------------------------------------------- N code label 9966 0 never worked 29170 1 ever worked in job or business 11714 . ------------------------------------------------------------------------------------------------------------------------------------------------ CURRENT INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- pi total income, person 46817 0 1.032e+09 2100000 7900000 pmi total income, person, monetary 47108 0 1.032e+09 2100000 7900000 pni total income, person, non-monetary 50467 0 13200000 34216.8 251784 pil labour income, person 47080 0 1.032e+09 1900000 7600000 pmil labour income, person, monetary 47371 0 1.032e+09 1800000 7600000 pnil labour income, person, non-monetary 50467 0 13200000 34216.8 251784 pile paid employment income, person 49043 0 1.032e+09 1100000 6700000 pmile paid employment income, person, monetary 49334 0 1.032e+09 1100000 6700000 pnile paid employment income, person, non-monetary 50467 0 13200000 34216.8 251784 pils self-employment income, person 48887 0 2.16e+08 732664 3500000 pmils self-employment income, person, monetary 48887 0 2.16e+08 732664 3500000 pit transfer income, person 50547 0 6e+07 236941 1900000 pmit transfer income, person, monetary 50547 0 6e+07 236941 1900000 pits social security transfers, person 50547 0 6e+07 236941 1900000 pmits social security transfers, person, monetary 50547 0 6e+07 236941 1900000 ------------------------------------------------------------------------------------------------------------------------------------------------ WINDFALL INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ NON-CONSUMPTION EXPENDITURE ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- pxit income taxes and social contributions, person 50850 0 3.11e+08 101706 1700000 pmxit income taxes and social contributions, person, monetary 50850 0 3.11e+08 101706 1700000 pxiti income taxes, person 50850 0 220700000 12656.7 1100000 pmxiti income taxes, person, monetary 50850 0 220700000 12656.7 1100000 pxits social security contributions, person 50850 0 90300000 89049.5 576252 pmxits social security contributions, person, monetary 50850 0 90300000 89049.5 576252 pxitss social security contributions, self-paid, person 50850 0 90300000 89049.5 576252 pmxitss social security contributions, self-paid, person, monetary 50850 0 90300000 89049.5 576252 ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS - LIABILITIES TRANSACTIONS ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ MAJOR AGGREGATES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- ppension individual total pension income 50547 0 6e+07 236941 1900000 ------------------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ currency currency units -------------------------------------------------------------------------------- N code label 50850 170 COP - Colombian Peso Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- deflator deflation factor 50850 1 1 1 0 grossnet gross/net income information -------------------------------------------------------------------------------- N code label 50850 100 gross, taxes and contributions fully captured