Download User`s Manual for CBMS StatSimPro 5.0
Transcript
User’s Manual for CBMS StatSimPro 5.0 October 2011 Prepared by the CBMS Network Coordinating Team Angelo King Institute for Economic and Business Studies This work was carried out by the PEP-CBMS Network Coordinating Team with the financial support of the Government of Canada provided through the International Development Research Centre (IDRC) and the Canadian International Development Agency (CIDA) User’s Manual for CBMS StatSimPro version 5.0 I. Introduction This manual contains guidelines and instructions on the use of the CBMS Statistics Simulator (StatSimPro version 5.0.) designed and customized for the LGU partners of the CBMS Network Coordinating Team. The StatSim is a MySQL application developed to simulate simple computations and tabulations usually done using statistical software or other tabulation applications and also to export indicators for use in dissemination such as tables and maps. Although this has the mentioned capability, this is not intended to replace the use of more sophisticated statistical software like SAS, Stata or SPSS. A. System Configuration It is required that the following system configuration should be met for better and faster processing: Intel Core processor or higher 1GB of RAM SVGA monitor Mouse 100MB of free hard drive space Microsoft Windows 98, Me, NT 4.0, 2000, XP, 32-bit Vista, 32-bit and 64-bit Windows 7 Microsoft Office 2003 B. Installation The step-by-step installation procedure below will update the existing CBMS encoding system in the computer. The installation is quick and simple. Steps in installing the software: 1. Insert the installation CD provided by the CBMS Team in the computer’s CD-ROM drive 2. The setup menu will automatically popup. If it does not, open windows explorer and double click the CD drive where the CD is located and run “manage.exe”. 3. The StatSim Pro 5.0 setup will prepare the Installation Wizard. 4. The Installation Wizard will start. Click “Next” to proceed with the installation. 2 5. The setup will require the user to accept the agreement upon using the software. After agreeing on the terms, click “Next”. 6. A pop-up screen will appear asking for Customer Information. Enter the name of the user as well as the company/office name. Click “Next”. 3 7. The user will be prompted to select a set-up type. Select Complete and Click “Next”. 8. Click Install to begin the Installation. 9. A pop-up screen will appear informing that the InstallShield Wizard has successfully installed CBMS StatSimPro 5.0. Click “Finish”. 4 II. General instructions Set-up and maintain a computer that will serve as your data repository. This computer should store all encoded text files and NRDB files. Before using the StatSim for processing and consolidating your data, check first for the accuracy and consistency of your text files. If needed, perform concatenation procedure (refer to Section III of the User’s Manual for the Computerized Data Encoding System) to merge encoded household data from same barangays. This is crucial prior to the simulation process. Check the matching of households in the encoded data and digitized spot map using the Household Identification Number. Complete matching of households for both datasets must be attained before processing to avoid repeating the steps. The application will guide the user through the process through clicks and dialogs. Create a copy of the CBMSdatabase folder in a remote area which will serve as back-up. III. Preparing Encoded Data for StatSim Processing A. CBMS Database Structure By now, the encoders and processors are most likely familiar with the file structure of the CBMS Database. However, it must still be noted that the general file/folder structure of the CBMS Database is: C:\CBMSDatabase\<Region>\<Province>\<Municipality>\<Barangay> The folder structure was designed so that the encoded data are stored by barangay. Thus, each barangay folders contains the text (ASCII) file where the household data are stored. Recall that the folder names make use of the Philippine Standard Geographic Codes (PSGC). For instance, if the encoded data of interest is Brgy. Pila, San Pascual, Batangas, the target file will be: C:\CBMSDatabase\04\10\26\019\041026019.hpq The file path above refers to the folder containing the encoded data (041026019.hpq) of Barangay Pila (019), San Pascual (26) in Batangas (10) in Region IVA (04). The folder structure is the same in all computers used for encoding. IV. Generating Indicators through the CBMS StatSim Pro A. Opening the StatSim 1. Starting the StatSim application a. Click on the shortcut icon from the desktop b. Click on the shortcut icon in the Start Menu 5 c. Click Start, click on All Programs, select CBMS Database and click on StatSimPro 5.0 2. Initializing the StatSim database a. The Login window will appear. For the username, default is “admin”. There is no password required. Change the database name according to the name of the province and municipality/city. Example: bulacan_hagonoy. Click the button OK. b. Another window will appear saying that the database still does not exist. Click Yes to create and initialize the database. Note: The next time the user will open StatSimPro 5.0, the database is already in the pulldown list. c. The StatsimPro is a menu and dialog driven application. Thus, the user only has to click and select from among the options to proceed and generate the desired outputs. Statsim is also a customized application for a specific CBMS questionnaire version and local government unit (LGU) using the said questionnaire version, thus all information contained in questionnaire can be derived and processed for the LGU. Each questionnaire is differentiated by the HPQ version number. st Note that this 1 version of StatSimPro 5.0 released October 2011 is specifically for the latest CBMS HPQ version 01201101. d. Configuring the database means specifying the level to be municipal, provincial or regional database. For this example, create a municipal database. 6 e. Click the button View selection. From the listed municipalities, double click on the name of the municipality and Click OK. For this example, StatSim database for the municipality of Hagonoy in Bulacan will be created. The StatSimPro 5.0 interface will now open. Quick Access Toolbar Main Tabs Database Name Application Button Tree View Status Bar Table View Note: When you are opening a configured database, you will not need to do the procedures discussed in (b) to (e). 1. Application Button – shows a menu of file-related commands such as Open, Print and etc. 7 2. Quick Access Toolbar – a customizable toolbar that displays the frequently used commands. 3. Main Tabs- display the main features and functions of the system. There are 3 main tabs: a. Home – under this tab, the user can import and export data, show or hide the status bar, and manage the report windows. b. Data – this tab is divided into 2 groups related to data management. Under this tab, the user can manage the created database, reprocess or update the imported data, match data with digitized households in NRDB, and edit thresholds to be used in processing. c. Stats/Indicators – enables the user to directly access the HPQ or BPQ crosstabs of CSPro and creat or customize reports other than the automatically generated reports. 4. Database Name – displays name of the database being accessed. 5. Tree View – shows the hierarchical view of the available reports generated by the system. There are 3 categories of automatically generated reports in the tree view namely CBMS Core Indicators, LGU Specific Indicators and CBMS composite Index. Each category can be expanded to reveal the sub-items. 6. Status Bar – found at the bottom of the user interface. It shows the progress of the importing and processing of data. 7. Table View – displays the reports selected in the tree view. B. Importing CBMS Data This section will guide you through the process of importing your encoded data file into the StatSimPro. In the importing process, the StatSimPro transforms the encoded data into a database ready for further processing and tabulation. 1. To import an encoded barangay data, go to Home in the main tab, then select Import. The user has 2 ways of importing the encoded data: one is the option to select the text file through the Auto selection of levels and the other is by the Specify path option. 8 a. Auto Selection of levels The geopolitical levels are pre-specified following the Philippine Standard Geographic Code (PSGC) folder structure. In the example below, the selection starts from the region, next is the province, followed by the list of municipalities (viewed in the first box) and all barangays under each municipality. The list of barangays can be seen at the second box in the window. Selecting the barangays is easy as selection buttons are present between the second and third box. The third box contains barangays which have been selected from the second box. Click OK to start importing of text file Click Cancel to stop Importing Option to specify the path to import the text file First box: PSGC folder structure Second box: List of barangays under each municipality st 1 button: Select a single barangay 2nd button: Deselect a single barangay 3rd button: Select multiple barangays 4th button: Deselect multiple barangays Third box: List of selected barangays from the second box b. Specify path The specify path options allow the user to manually select the encoded data similar to opening files using windows explorer. 1. In the window, click the button Add to open the browser. 2. From the browser, select the text file. Usually, as instructed during the training, all the text files follow the PSGC folder structure. For example, in selecting the text file of Brgy. Abulalas, Hagonoy, Bulacan select the text file 031409001.hpq from the folder C:\CBMSDatabase\03\14\09\001. 9 Click OK to start importing of text file Click Cancel to stop Importing Option to Auto-select the text file The user can add multiple text files by going to desired paths. municipality Click Add.. to add a text file by browsing the folders Click Remove to remove an added text file Click Clear to remove all added text files 3. After selecting the text file/files from the auto selection of levels or through specifying the paths, click OK to start. 4. After the selected files have been imported, a window will appear to ask if the user wants to import another set of data. Click Yes button to add again using the same process or No if user is already done importing desired text files. 5. Another window will appear, click Yes to start the processing. 6. A window will appear to ask if the user wants to edit the Purok names. Recall that in the CSPro-based encoding system, all puroks are encoded as codes to reduce mismatches in names. This step is very crucial because the labels/names of the puroks in this section must match their names in the NRDB file since matching of these files is both case- and space-sensitive. 7. Click Yes to edit the Purok names. 10 8. Double-click on the PurokName or click Edit to change the names. After editing all the names, click OK. 9. The user will now be prompted to select at what level the data will be processed. User can select from the label in the first box and click the button to specify the desired geopolitical levels. Click OK to start processing data Click Cancel to stop processing First Box: All levels are seen here. Highlight the desired level to process data st 1 button: Select a single level 2nd button: Deselect a single level 3rd button: Select multiple levels 4th button: Deselect multiple levels Second Box: All selected levels are seen here. C. Processing the 13+1 CBMS Core Indicators 1. The user will be asked if she/he wants to process the CBMS core indicators. Click Yes to proceed. While StatSim is processing, you will see the status of the processing activity at the lower left of the page. Please note that the length of time required in processing the data depends on the size of the file, number of text files that the user is processing and the number of selected levels (region, province, municipality, barangay, purok and households). When done, the status will now indicate “ready” or “done”. 11 D. Displaying the CBMS Core Indicators To view the data, the StatSim contains the tree view of the report tables in the left side of the interface. To display the CBMS Core Indicators, click on the CBMS Core Indicators in the report view. Choose the level of the data you wish to view. If you choose to display the CBMS Core Indicators at the barangay level, then you will be able to view an output similar to the one displayed below: Confidential info If you choose to display the CBMS Core Indicators at the household level, below is the sample output: Users can simultaneously display reports by clicking on the specific sector and indicator then chose the level of data to view. Every time the user selects a report, q new window will open and display the selected report. For example, to view the prevalence of malnutrition at the purok level, below is the output report that shows data for all puroks of Brgy. Abulalas. 12 Users can also view Selected LGU indicators and the CBMS Composite Index automatically computed by the StatSimPro. Confidential info There are 14 basic needs (14 CMS core indicators) that each household should meet. The CBMS Composite Index (CCI) is the sum of all unmet needs of the households. For example, HH#1 have (1) income below poverty threshold; (2) have children who are malnourished; and (3) have children who are not attending elementary school. Thus, the CCI of HH#1 is 3. Below is a sample output. Note that the list is sorted according to the lowest to the highest CBMS Composite Index. At the purok and higher geopolitical levels, the CCI is the average household scores at that level. In the example below, the average unmet needs of the households in Brgy. Abulalas is 1. This number is useful in targeting barangays with the highest average unmet needs. 13 E. Customizing Tables Aside from the automatically generated data, users can also create their own tables using all variables found the HPQ. Kindly refer to Manual on Executing SQL statements to generate CBMS data using Statsim. F. Matching Households in the Encoded Data and Digitized Barangay Spot Maps Before exporting the processed dataset into the NRDB Pro, you should ensure that the households in your encoded data (i.e., text file) match with the households in your digitized barangay spot maps. To do this, do the following: 1. Click on Data, select Matching. 2. You will be prompted to open your NRDB file (i.e., file with .mdb file extension). To do this, go to your CBMSDatabase folder, locate the file and click Open. 3. A report similar to the one displayed below will be shown in excel. Under the last column with the following heading: ~match, will appear any of the following codes: 1, -1, or 0. Note that Code 1 denotes that the household ID is found in your encoded file but not in the digitized spot map. Code -1 on the other hand, 14 denotes that the household ID is found in the digitized spot map but not found in the encoded file. Code 0 meanwhile denotes that the household ID match on both files, that is, the household ID can be found in both the encoded file as well as in the digitized spot map. Also, a summary report shown as below will be displayed in StatSimPro. 15 G. Instructions on Exporting Processed CBMS Data a. Core Dataset from CBMS StatSimPro to CBMS-NRDB After processing the CBMS Core Indicators using the Statistics Simulator (StatSim) and ensuring that the household IDs in the encoded file and digitized spot map match, the processed dataset can now be exported into the NRDB Pro in order to map the CBMS indicators. 1. From the Home menu, select EXPORT. 2. Select Indicators to NRDB. 3. Select the following levels to process (whichever is applicable): Municipality, Barangay, Purok and Household. 4. Click OK. The following message box will appear: You are now ready to map CBMS Core Indicators using the CBMS-NRDB. Refer to “User's Manual for building the CBMS Database and Poverty Mapping” for the steps. b. Other Processed tables Other processed tables can also be exported and opened in MS Excel. From the Home menu, select EXPORT then select the name of the desired table. The table will automatically open in Excel. 16 Level Label Record Label Core HPQ questionnaire Household Record Member Record Wages Record Owned Asset Record Crime Record Death Record Program Government Programs Record Calamity record Couples Record Crop Record Agri equipment record Fish cage record Aquatic animals record Fishing equipment record Disaster Preparedness Kit Live Animal Meat Milk Eggs Others Insurance Record for Agriculture Insurance Record Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Zone Street House Number Additiona Identity Others House Type Others Interviewer Respondent Interview date Interview Month Interview Day Interview Year Starting hour Starting minute Starting meridian Ending hour Ending minute CBMS HPQ VN01201101 DATA DICTIONARY FOR CBMS QUESTIONNAIRE VERSION 01201101 Level Name Record Name CORE_HPQ_QUEST CORE_HPQ_HH CORE_HPQ_MEM CORE_HPQ_WAGE CORE_HPQ_OWNED_ASSET CORE_HPQ_CRIME CORE_HPQ_DEATH CORE_HPQ_PROG_GOV CORE_HPQ_PROG CORE_HPQ_CALAM CORE_HPQ_COUPLE CORE_HPQ_CROP CORE_HPQ_AGRIEQUIP CORE_HPQ_FCAGE CORE_HPQ_AQUANI CORE_HPQ_AQUAEQUIP CORE_HPQ_DISASTER CORE_HPQ_LIVEANIMALS CORE_HPQ_MEAT CORE_HPQ_MILK CORE_HPQ_EGGS CORE_HPQ_OTHERS CORE_HPQ_IRFA CORE_HPQ_INSURANCE Record: Household Record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 ZONE STREET HNUM ADD_IDENT 1 Road island 2 Under the bridge 3 Park 4 Sidewalk 5 Others, specify 6 None ADD_IDENT_O HOUSE_TYPE 1 Single house 2 Duplex 3 Apartment/accessoria condominium/townhouse 4 Commercial/industrial/agricultural building/house 5 Others, specify HOUSE_TYPE_O INTERVIEWER RESPONDENT INT_DATE INT_MM 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August 9 September 10 October 11 November 12 December INT_DD 0:31 INT_YY 2006:2050 START_HR 1:12 START_MIN 0:59 START_MER 1 AM 2 PM END_HOUR 1:12 END_MIN 0:59 1 Ending meridian Quality assessment line 1 Quality assessment line 2 Got Sick? Pneumonia Bronchitis Diarrhea Influenza Hypertension Tuberculosis Heart Ailment Malaria Chicken Pox Dengue Fever Cholera Typhoid Fever Heat Stroke Asthma Other Sick Other Sick LB Received treatment/cure for sickness National Provincial District Municipal/city Private Hospital/Clinic Rural health Units Brgy.Health Station/Center Non-Medical/non-trained Hilot/Personnel Place where received cure Other place where received cure How many couples? CBMS HPQ VN01201101 END_MER 1 AM 2 PM QUAL_ASS1 QUAL_ASS2 GSICK 1 Yes 2 No S_PNEUMONIA 1 Yes 2 No S_BRONCHITIS 1 Yes 2 No S_DIARRHEA 1 Yes 2 No S_INFLUENZA 1 Yes 2 No S_HYPERTENSION 1 Yes 2 No S_TUBERCULOSIS 1 Yes 2 No S_HEART_AILMENT 1 Yes 2 No S_MALARIA 1 Yes 2 No S_CHICKEN_POX 1 Yes 2 No S_DENGUE_FEVER 1 Yes 2 No S_CHOLERA 1 Yes 2 No S_TYPHOID_FEVER 1 Yes 2 No S_HEAT_STROKE 1 Yes 2 No S_ASTHMA 1 Yes 2 No OTHER_SICK 1 Yes 2 No OTHER_SICK_LB CURE_SICK 1 Yes 2 No 3 Never had a disease CURE_NATIONAL 1 Yes 2 No CURE_PROVINCIAL 1 Yes 2 No CURE_DISTRICT 1 Yes 2 No CURE_MUNICIPAL 1 Yes 2 No CURE_PRIVATE 1 Yes 2 No CURE_RURAL 1 Yes 2 No CURE_BRGY 1 Yes 2 No CURE_HILOT 1 Yes 2 No WHERE_CURE 1 Yes 2 No WHERE_CURE_O NCOUPLE 0:30 2 Any member who died? How many deaths? Type of water facility Other types of water facility Source of Water Other sources of water Distance of water source Average Water Consumption Type of toilet facility Other types of toilet facility Tenure status of house/lot Other tenure status Total imputed rent per month Total actual rent per month Electricity Indicator Electric company? Generator? Solar? Battery? Others Other source Electric Bill CBMS HPQ VN01201101 PREVMIND 1 Yes 2 No NDEATH 1:30 WATER 1 Piped water into dwelling 2 Piped water to yard/plot 3 Public tap/stand pipe 4 Tube well or borehole 5 Protected dug well 6 Semi-protected dug well 7 Unprotected dug well 8 Protected water from spring 9 Unprotected water from spring 10 Rainwater 11 Tanker truck 12 Cart with small tank 13 Surface water (River, Dam, etc.) 14 Bottled/Mineral water 15 Others, specify _____ WATER_O SOURCE_WATER 1 Piped water into dwelling 2 Piped water to yard/plot 3 Public tap/stand pipe 4 Tube well or borehole 5 Protected dug well 6 Semi-protected dug well 7 Unprotected dug well 8 Protected water from spring 9 Unprotected water from spring 10 Rainwater 11 Tanker truck 12 Cart with small tank 13 Surface water (River, Dam, etc.) 14 Bottled/Mineral water 15 Others, specify _____ SOURCE_WATER_O WATER_DIST 1 Within premises 2 Outside premises but 250 meters or less 3 251 meters or more 4 Don't know AVE_WATER TOIL 1 Water sealed flush to sewerage system/septic tank - own use 2 Water sealed flush to sewerage system/septic tank - shared with other households 3 Closed pit 4 Open pit 5 No toilet 6 Others, specify _____ TOIL_O TENUR 1 Owner, owner-like possession of house and lot 2 Rent house/room including lot 3 Own house, rent lot 4 Own house, rent-free lot with consent of owner 5 Own house, rent-free lot without consent of owner 6 Rent-free house and lot with consent of owner 7 Rent-free house and lot without consent of owner 8 Living in a public space with rent 9 Living in a public space without rent 10 Other tenure status, specify _____ TENUR_O IMPRNT 0.00:999999.00 ACRENT 0.00:999999.00 WELEC 1 Yes 2 No ELEC_COMPANY 1 Yes 2 No ELEC_GENERATOR 1 Yes 2 No ELEC_SOLAR 1 Yes 2 No ELEC_BATTERY 1 Yes 2 No ELEC_SOURCE_O 1 Yes 2 No ELEC_SOURCE_O_LB ELEC_BILL 0.00:999999.00 3 Construction materials of walls 1 2 3 4 5 6 Construction materials of roof 1 2 3 4 5 6 Engaged in crop farming and gardening 1 2 Total income from the activity (cash) Total income from the activity (kind) Engaged in livestock/poultry 1 2 Total income from the activity (cash) Total income from the activity (kind) Engaged in fishing 1 2 Total income from the activity (cash) Total income from the activity (kind) Engaged in forestry 1 2 Total income from the activity (cash) Total income from the activity (kind) Engaged in wholesale/retail 1 2 Total income from the activity (cash) Total income from the activity (kind) Engaged in manufacturing 1 2 Total income from the activity (cash) Total income from the activity (kind) Engaged in community, social & personal serviceSERVIND Total income from the activity (cash) Total income from the activity (cash) Engaged in transportation, storage & communicatTRNIND Total income from the activity (cash) Total income from the activity (kind) Engaged in mining & quarrying Total income from the activity (cash) Total income from the activity (kind) Engaged in construction Total income from the activity (cash) Total income from the activity (kind) Other activities NEC Total income from the activity (cash) Total income from the activity (kind) Total income from entrepreneurial activities (cETOTCSH Total income from entrepreneurial activities (kETOTKND Number of waged HH members WALL Strong materials Light materials Salvaged/makeshift materials Mixed but predominantly strong Mixed but predominantly light Mixed but predominantly salvaged ROOF Strong materials Light materials Salvaged/makeshift materials Mixed but predominantly strong Mixed but predominantly light Mixed but predominantly salvaged CROPIND Yes No CROPINCSH CROPINKND POULTIND Yes No POUINCSH POUINKND FISHIND Yes No FISHINCSH FISHINKND FORIND Yes No FORINCSH FORINKND SALIND Yes No SALINCSH SALINKND MANIND Yes No MANINCSH MANINKND 1 Yes 2 No SERVINCSH SERVINKND 1 Yes 2 No TRNINCSH TRNINKND MININD 1 Yes 2 No MININCSH MININKND CNSIND 1 Yes 2 No CNSINCSH CNSINKND EOTHIND 1 Yes 2 No EOINCSH EOINKND FREQ_WAGE 0:50 Total income from salaries/wages (cash) WAGCSH 0.00:999999999.99 Total income from salaries/wages (kind) WAGKND 0.00:999999999.99 Net share of crops (cash) AGSCSH 0.00:999999999.99 Net share of crops (kind) AGSKND 0.00:999999999.99 Receipts from OFW (cash) OFWCSH 0.00:999999999.00 Receipts from OFW (kind) OFWKND 0.00:999999999.00 Receipts from abroad (cash) SUPFCSH 0.00:999999999.99 Receipts from abroad (kind) SUPFKND 0.00:999999999.99 Receipts from domestic (cash) CBMS HPQ VN01201101 SUPRCSH 4 0.00:999999999.99 Receipts from domestic (kind) SUPRKND 0.00:999999999.99 Rentals received (cash) RENTVCSH 0.00:999999999.99 Rentals received (kind) RENTVKND 0.00:999999999.99 Interest earned (cash) INTRCSH 0.00:999999999.99 Interest earned (kind) INTRKND 0.00:999999999.99 Pensions received (cash) PENCSH 0.00:999999999.99 Pensions received (kind) PENKND 0.00:999999999.99 Dividends (cash) DIVCSH 0.00:999999999.99 Dividends (kind) DIVKND 0.00:999999999.99 Other sources of income NEC (cash) OTHSCSH 0.00:999999999.99 Other sources of income NEC (kind) OTHSKND 0.00:999999999.99 Total income from other sources (cash) OTHSTOTCSH 0.00:999999999.99 Total income from other sources (kind) OTHSTOTKND 0.00:999999999.99 Total imputed rent IMPRNTTOT 0.00:999999999.99 Total income (cash) Total income (kind) Total household income Tenure in agricultural land 1 2 3 4 5 Other tenure in agricultural land Area of farm 1 2 3 4 Fishpond 1 2 Fishcage 1 2 Sea 1 2 Marsh 1 2 Lake 1 2 River 1 2 Stream/creek 1 2 Other 1 2 Other place Area of fishpond 1 2 3 4 Number of fish cage TOTINCSH TOTINKND TOTIN AGRILAND_TENUR Owned or owner-like possession Rent Not owned but with consent of owner Not owned and without consent of owner Other AGRILAND_TENUR_O AGRILAND_AREA Less than 1 hectare 1 - 3 hectares 3.1 - 5 hectares More than 5 hectares CUL_FISHPOND Yes No CUL_FISHCAGE Yes No CUL_SEA Yes No CUL_MARSH Yes No CUL_LAKE Yes No CUL_RIVER Yes No CUL_STREAM Yes No CUL_OTHER_PLACE Yes No CUL_OTHER_PLACE_LB FISHPOND_AREA Less than 1 hectare 1 - 3 hectares 3.1 - 5 hectares More than 5 hectares NFCAGE 0.69375 Number of aquatic animals Own fishing boat 1 2 3 Garbage collected 1 2 Garbage burned 1 2 Garbage composted 1 2 CBMS HPQ VN01201101 NAQUANI OWN_FISHBOAT Yes (motorized) Yes (non-motorized) No GARB_COLLECT Yes No GARB_BURN Yes No GARB_COMP Yes No 5 Garbage recycled Garbage segregated Garbage dumped to closed pit Garbage dumped to open pit Garbage throwing in river Other waste management What waste management Garbage collector Other garbage collector How frequent is the garbage collection Other frequency of collection Experienced food shortage Months of shortage_1 Number of days of shortage_1 Months of shortage_2 Number of days of shortage_2 Months of shortage_3 Number of days of shortage_3 Preliminary household size Household size Amount Harvested Cause of Low Harvest CBMS HPQ VN01201101 GARB_RECYCL 1 Yes 2 No GARB_WSEGR 1 Yes 2 No GARB_CPIT 1 Yes 2 No GARB_OPIT 1 Yes 2 No GARB_RIVER 1 Yes 2 No GARB_MGT_O 1 Yes 2 No GARB_MGT_O_LB GARB_COLLECTOR 1 Municipal/city garbage collector 2 Barangay garbage collector 3 Private garbage collector 4 Others, Specify _____ GARB_COLLECTOR_O FREQ_GARB_COLL 1 Daily 2 Thrice a week 3 Twice a week 4 Once a week 5 Other FREQ_GARB_COLL_O FSHORT 1 Yes 2 No FSMONTH_1 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August 9 September 10 October 11 November 12 December FSDAYS_1 0:31 FSMONTH_2 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August 9 September 10 October 11 November 12 December FSDAYS_2 0:31 FSMONTH_3 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August 9 September 10 October 11 November 12 December FSDAYS_3 0:31 PHSIZE HSIZE U_AMT_HARV 1 Decrease 2 Increase 3 Remained the same U_LOW_HARV 1 Increase in cost of farm inputs such as seeds, fertilizer, pesticides, etc. 2 Affected by drought 3 Affected by typhoon 6 4 5 6 7 8 Other cause Change same crops 1 2 Why change same crops 1 2 3 4 5 6 Other reason Change primary crops 1 2 why Change primary crops 1 2 3 4 5 6 Other reason Amount Livestock 1 2 3 Cause of Low Livestock 1 2 3 4 5 6 7 Other cause Amount Harvested Fish 1 2 3 Cause of Low Harvest 1 2 3 4 5 6 7 8 9 Other cause Temperature Humid 1 2 Electricity Loss 1 2 Sea Level 1 2 3 4 Water Supply 1 2 3 Low Water Supply 1 2 3 4 5 6 Other reason Flood Frequency 1 2 3 Flood Duration Flood Duration 12 Drought 1 2 3 Drought Duration CBMS HPQ VN01201101 Affected by flood Affected by pests Decrease in supply of water from the irrigation Change in primary occupation of member Others, Specify U_LOW_HARV_O_LB U_CHNG_SCROP Yes No U_CHNG_SCROP_Y The former crop is more expensive More resistant to pests and diseases The present crop does not require much water The present crop enables the member to earn more profit Availabilty of crops Others, Specify U_CHNG_SCROP_Y_O_LB U_CHNG_PCROP Yes No U_CHNG_PCROP_Y The former crop is more expensive More resistant to pests and diseases The present crop does not require much water The present crop enables the member to earn more profit Availability of crops Others, specify ___ U_CHNG_PCROP_Y_O_LB U_AMT_LVE Decrease Increase Remained the same U_LOW_LVE Increase in cost of farm inputs (feeds,chicks, etc.) Stricken with diseases (swine flu, bird flu, foot and mouth disease, etc. ) Decrease in land holding Affected by typhoon Affected by flood Affected by extreme hot weather condition Others, specify _____ U_LOW_LVE_O_LB U_AMT_FISH Decrease Increase Remained the same U_LOW_FISH Decrease in fishing area due to government restrictions Decrease in fishing area due to competition Fewer fishes Occurrence of coral bleaching Lessened the number of times fishing because of the increase in fuel prices and other expenses Occurrence of oil spill and other pollution Fishkill Frequent occurrence of typhoons Others, specify __ U_LOW_FISH_O_LB TEMP_HUMID Yes No ELEC_LOSS Yes No SEA_LEVEL Increase Decrease Remained the same Don't know WATER_SUPPLY Decrease Increase Remained the same LOW_WSUPP Drought Broken faucet/pump Lower water level in the dam Less frequent delivery of tanker truck/peddler Increase in number of consumers Others, specify _____ LOW_WSUPP_O_LB FLOOD_FREQ Yes No Did not experience flood FLOOD_DURATION FLOOD_DURATION_12 DROUGHT Yes No Not affected by drought DROUGHT_DURATION 7 1 2 3 4 5 6 Evacuate Move-Out 1 2 Evacuate Transient 1 2 Evacuation center 1 2 3 4 5 6 Other evacuation Disaster Preparedness 1 2 Buffer 1 2 3 No of Live animals < 1 month 1 month < 2 months 2 months < 3 months 3 months < 4 months 4 months < 5 months 5 months or more EVAC_MVEOUT Yes No EVAC_TRANS Yes No EVAC_CNTR School Church Covered court/gym Relative's house Neighbor or friend's house Others, specify ______ EVAC_CNTR_O_LB DISAS_PREP Yes No BUFFER_INC Yes No Not Computed NOLIVE_A 0:50 No of Meat NO_MEAT 0:50 No of Milk NO_MILK 0:50 No of Eggs NO_EGGS 0:50 No of Others NO_OTHERS 0:50 Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line number Member surname Member first name Member middle name Relation to the HH reference person Other relationship Sex Age in years Age in months Birth Date Birth Month Birth Day CBMS HPQ VN01201101 Record: Member Record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 MEMNO 1:30 MSNAME MFNAME MMNAME RELN 1 Head 2 Wife/Spouse 3 Son/Daughter 4 Son in law/Daughter in law 5 Grandson/Granddaughter 6 Father/Mother 7 Other Relatives 8 Housemaid/boy 9 Other non-relatives RELN_O SEX 1 Male 2 Female AGE_YR AGE_MO 0:11 BIRTH_DATE BIRTH_MM 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August 9 September 10 October 11 November 12 December 99 Unknown BIRTH_DD 1:31 8 Birth Year Birth Registration Civil Status Religion Other religion IP Indicator IP Group Other IP Group Not Applicable Length in years of residency Length in months of residency Country of previous residence Other country Provincial code of previous residence CBMS HPQ VN01201101 99 Unknown BIRTH_YY 1800:9999 BIRTH_REG 1 Yes 2 No CIVSTAT 1 Single 2 Married 3 Widow/er 4 Divorced / Separated 5 Common Law / Live-in 6 Unknown RELGN 1 Roman Catholic 2 Protestant 3 Iglesia ni Cristo 4 Aglipay 5 Islam 6 Born-again 7 Mormons 8 Jehova's witness 9 7th-day adventists 10 Others (specify) 11 None RELGN_O IPIND 1 Yes 2 No IPGRP 1 IPGRP_O YLEN_RESID 999 Since Birth MLEN_RESID 0:11 COUNTRY_RESID COUNTRY_RESID_O PROV_RESID_CODE 28 Ilocos Norte 29 Ilocos Sur 33 La Union 55 Pangasinan 9 Batanes 15 Cagayan 31 Isabela 50 Nueva Vizcaya 57 Quirino 77 Aurora 8 Bataan 14 Bulacan 49 Nueva Ecija 54 Pampanga 69 Tarlac 71 Zambales 10 Batangas 21 Cavite 34 Laguna 56 Quezon 58 Rizal 40 Marinduque 51 Occidental Mindoro 52 Oriental Mindoro 53 Palawan 59 Romblon 5 Albay 16 Camarines Norte 17 Camarines Sur 20 Catanduanes 41 Masbate 62 Sorsogon 4 Aklan 6 Antique 19 Capiz 79 Guimaras 30 Iloilo 45 Negros Occidental 12 Bohol 22 Cebu 46 Negros Oriental 61 Siquijor 78 Biliran 26 Eastern Samar 37 Leyte 48 Northern Samar 60 Samar 64 Southern Leyte 7 Basilan 72 Zamboanga del Norte 9 73 83 13 18 35 42 43 23 24 25 47 80 63 65 39 74 75 76 1 81 11 27 32 44 36 38 66 70 2 3 67 68 82 85 98 Municipality code Barangay code Municipality of previous residence Barangay of previous residence OFW 1 2 OFW Country Attended school 1 2 Grade/Year code 1 2 11 12 13 14 15 16 21 22 23 24 26 27 28 31 32 33 34 36 Public or private 1 2 Educational attainment code 0 1 2 11 12 13 14 15 16 17 21 22 23 24 25 26 27 28 29 CBMS HPQ VN01201101 Zamboanga del Sur Zamboanga Sibugay Bukidnon Camiguin Lanao del Norte Misamis Occidental Misamis Oriental Davao del Norte Davao del Sur Davao Oriental North Cotabato Sarangani South Cotabato Sultan Kudarat Manila NCR 2 NCR 3 NCR 4 Abra Apayao Benguet Ifugao Kalinga Mt Province Lanao del Sur Maguindanao Sulu Tawi-Tawi Agusan del Norte Agusan del Sur Surigao del Norte Surigao del Sur Compostela Valley Dinagat Islands MUN_RESID_CODE BRGY_RESID_CODE MUN_RESID_TXT BRGY_RESID_TXT OFW Yes No OFW_COUNT EDUCIND Yes No GRADEL Day Care Nurser/Kindergarten/Preparatory Grade 1 Grade 2 Grade 3 Grade 4 Grade 5 Grade 6/7 1st Year HS 2nd Year HS 3rd Year HS 4th/5th Year HS 1st year PS 2nd year PS 3rd year PS 1st year College 2nd year College 3rd year College 4th year College or higher With units Masters/Doctors SCH_TYPE Private Public EDUCAL No Grade Day Care Nurser/Kindergarten/Preparatory Grade 1 Grade 2 Grade 3 Grade 4 Grade 5 Grade 6/7 Elementary Graduate 1st Year HS 2nd Year HS 3rd Year HS 4th/5th Year HS HS graduate 1st year PS 2nd year PS 3rd year PS PS graduate 10 31 32 33 34 35 36 37 Educational attainment subcode 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 Other course Literacy indicator 1 2 Member of any community organization 1 2 Name of organization 1 Type of community organization 1 1 2 3 4 5 6 7 8 9 10 11 Other type of community organization 1 Registered voter CBMS HPQ VN01201101 1st year College 2nd year College 3rd year College 4th year College or higher College graduate With units Masters/Doctors Doctors/Masters degree SUB_EDUCAL PhD or MS in Agriculture, Fishery, Forestry, etc. Doctor of Veterinary Medicine Bachelor of Science in Agriculture (Agro & Horti) Bachelor of Science in Agriculture (Animal Husbandryi) Bachelor of Science in Agriculture (Agricultural Technology) Bachelor of Science in Agriculture - other fields/unspecified Bachelory of Science in Fishery and Forestry PhD or MA Education Guidance and Counselling, etc. BSE, including BSEE, including Home Eco and PE BS Agri Education BS Industrial Arts BS in other fields/unspecified (Educ) PhD or MS Engineering, all fields BS Chemical Engineering BS Civil Engineering BS Electrical/Electronic Engineering BS Mechanical Engineering BS Mining Engineering BS other fields/unspecified (Engr) PhD or MS Music and other fields BS Architecture BS Commercial Arts Bachelor of Science in Fine Arts Bachelor of Music Bachelor of Science in other fields/unspecified (Arts) Doctorate or MS Philo, Psycho, Spanish, Library Science, etc. Bachelor of Arts, General Course BA in Spanish,Classical;Bachelor of Lit, other fields Bachelor of Science in Philosophy Bachelor of Science in Psychology BS in General Course; Lib Science, Theo, etc/unspecified Doctor of Civil Law, Master of Laws, etc. Bachelor of Laws Bachelor of Science in Criminology Doctor of Medicine PhD or MS in Nursing, Pharmacy, etc Doctor of Dental Medicine (Dentistry) Doctor of Optometry BS Med Tech BS Nursing BS Pharmacy BS in other fields/unspeciied PhD or MA in Chemistry, Physics, Mathematics, etc BA in Geology, Geophusis, etc BS in Biology, Botany, Zoology BS Chemistry BS in Mathematics and Physics BS in other fields/unspecified PhD/MS Bank'g&Fin,BA,Cmrs,Eco,PoliSci,PAdmin,Soc'lWrk, Socio,etc BBusAd or Comrc'l Sci,BS in Commerce or Eco BS Foreign Service BS Journalism BS Nutrition or Food Nutrition BS Food Technology BS Home Economics BS Social Work and Sociology BS Statistics BS Mass Comm,HRM,etc/unspecified other Field of Study or Degree not specified COURSE_O LITERIND Yes No ORGIND Yes No ORG_NAME_1 ORG_TYPE_1 Religious Youth Cultural Political Women's Agricultural Labor Civic Cooperatives Senior Citizens Others (Specified) ORG_TYPE_O_1 REGVOTIND 11 Voted in last election Nutrition status of members 0-5 years old MNUTIND_MM MNUTIND_DD MNUTIND_YY 2005:2011 Job/Work indicator Occupation/economic activity Occupation general code Occupation subcode 1 Occupation subcode 2 Occupation subcode 3 Business/industry Not Applicable Sector code 1 Yes 2 No VOTED_LAST_ELECTION 1 Yes 2 No 3 Don't know MNUTIND 1 Above Normal 2 Normal 3 Below Normal (moderate) 4 Below Normal (severe) MNUTIND_MM 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August 9 September 10 October 11 November 12 December MNUTIND_DD 1:31 MNUTIND_YY JOBIND 1 Yes 2 No OCCUP G_OCC 1 Officials of Government and Special-Interest Organizations, Corporate Executives, Managers, Managi 2 Physical, Mathematical and Engineering Science Professionals 3 Technician and Associate Professionals 4 Clerks 5 Service Workers and Shop and Market Sales Workers 6 Farmers, Forestry Workers and Fishermen 7 Trades and Related Workers 8 Plant and Machine Operators and Assemblers 9 Laborers and Unskilled Workers 10 Special Occupations SUB_OCC_1 SUB_OCC_2 SUB_OCC_3 INDUST 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Country of economic activity Other country Province code of economic activity Municipal code of economic activity Barangay code of economic activity Municipality of economic activity Barangay of economic activity Job status 1 2 3 Working Hours Find additional work hours 1 2 Find extra work 1 2 Class of Worker 1 CBMS HPQ VN01201101 SECTOR Agriculture, Forestry and Fishing Mining and Quarrying Manufacturing Electricity, Gas, Steam and Air Conditioning Supply Water Supply; Sewerage, Waste Management and Remediation Activities Construction Wholesale and Retail Trade; Repair of Motor Vehicles and Motorcycles Transportation and Storage Accomodation and Food Service Activities Information and Communication Financial and Insurance Activities Real Estate Activities Professional, Scientific and Technical Activities Administrative and Support Service Activities Public Administration and Defense; Compulsory Social Security Education Human Health & Social Work Activities Arts, Entertainment and Recreation Other Service Activities Activities of Households as Employers; Undifferentiated Goods-and-Services Producing Activites of Activities of Extra-Territorial Organizations and Bodies COUNTRY_JOB COUNTRY_JOB_O PROV_JOB_CODE MUN_JOB_CODE BRGY_JOB_CODE MUN_JOB_TXT BRGY_JOB_TXT JSTATUS Permanent Short-term, seasonal or casual Worked on different jobs on daya to day or week to week WORK_HRS FADD_WORK_HRS Yes No FXTRA_WRK Yes No WORKCL Worked for a household 12 2 3 4 5 6 7 8 Find job 1 2 Job search method 1 2 3 4 5 6 Other job search method Reasons why did not look for work 1 2 3 4 5 6 7 8 9 Other reasons why did not look for work Last time looked for work 1 2 3 4 Had opportunity for work? 1 2 Willing to take up work? 1 2 SSS / GSIS 1 2 Board Passer 1 2 No of Degree Worked for a private establishment Worked for government/ government corporation Self emplyed without employees Employer in own family-operated farm or business Worked with pay on own family Worked without pay on own family operated farm or business Working for government of another country FJOB Yes No JSEARCH_METH Registered in public employment agency Registered in employment agency Approached employer directly Approached relatives / friends Placed or answered private advertisements Others (specified) JSEARCH_METH_O YNOTLOOKJOB Believes no work available Await results of previous application Temporary illness/disability Bad weather Waiting for rehire Too young/old, retired or permanently disabled Housekeeping Schooling Others (specified) YNOTLOOKJOB_O LASTLOOKJOB more than 1 week less than 1 month more 1month less than 6 months ago more than 6 months Never JOPPIND Yes No WTWIND Yes No SSS_IND Yes No BOARD_PASSER Yes No NO_OF_DEGREE 1:03 Profession Profession 2 Profession 3 Solo Parent 1 2 Reason for Solo Parent 1 2 3 4 5 6 7 8 9 10 Other reason for solo parent PWD Indicator 1 2 PWD Type 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Other pwd type CBMS HPQ VN01201101 PROFESSION PROFESSION2 PROFESSION3 SOLO_PARENT Yes No SOLO_PARENT_R Death of spouse Imprisonment of spouse for at least one year Mental and physical incapacity of spouse Legal or de facto separation from spouse for at least one year Annulment of marriage as decreed by court or church Abandonment of spouse for at least one year Unmarried mother or father who preferred to keep the child instead of others caring for him/her Any other person who solely provides parental care and support to a child provided he/she is a dul Any family member who solely assumes the responsibility as head of the family as a result of death Other reasons, specify _____ SOLO_PARENT_R_O PWD_IND Yes No PWD_TYPE Total blindness Partial blindness Low vision Totally deaf Partially deaf Hard of hearing Oral defect One hand No hands One leg No legs Cerebral palsy Epileptic Mentally ill Mentally retarded Autistic HUnchback Multiple impairment Others, specify ___ PWD_TYPE_O 13 PWD Cause 1 2 3 4 5 Other pwd cause PWD ID 1 2 Use of PWD ID 1 1 2 Use of PWD ID 2 1 2 Use of PWD ID 3 1 2 Use of PWD ID 4 1 2 Use of PWD ID 5 1 2 Use of PWD ID 6 1 2 Use of PWD ID 7 1 2 Other use of pwd id Senior Citizen ID 1 2 Use of SCID 1 1 2 Use of SCID 2 1 2 Use of SCID 3 1 2 Use of SCID 4 1 2 Use of SCID 5 1 2 Use of SCID 6 1 2 Use of SCID 7 1 2 Other use of scid PWD_CAUSE In-born Illness Accident Old age Others, specify ___ PWD_CAUSE_O PWD_ID Yes No PWD_ID_USE_1 Yes No PWD_ID_USE_2 Yes No PWD_ID_USE_3 Yes No PWD_ID_USE_4 Yes No PWD_ID_USE_5 Yes No PWD_ID_USE_6 Yes No PWD_ID_USE_7 Yes No PWD_ID_USE_O SCID_IND Yes No SCID_USE_1 Yes No SCID_USE_2 Yes No SCID_USE_3 Yes No SCID_USE_4 Yes No SCID_USE_5 Yes No SCID_USE_6 Yes No SCID_USE_7 Yes No SCID_USE_O Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Record: Wages Record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN Province Muncipality/City Barangay Purok Household ID Number 1:999999 Line number referenced to line number in memberWAGE_LINE Wage of a HH member (cash) 0.00:999999999.99 Wage of a HH member (kind) 0.00:999999999.99 Level: Core HPQ questionnaire Data Item Item Label Urbanity 1 2 Region 1:17 Province Muncipality/City Barangay Purok Household ID Number 1:999999 CBMS HPQ VN01201101 WAGCSHM WAGKNDM Record: Owned Asset Record Dec Zero Item Name (id) URB Rural Urban (id) REGN (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 14 Asset Line No Asset Type 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Other Asset Type Asset Indicator 1 2 Asset Quantity OA_LINE_NO OA_TYPE Radio/Radio Casette Television CD/VCD/DVD Stereo/Component Karaoke/Videoke Refrigerator/Freezer Electric Fan Electric Iron LPG Gas Stove/Range Washing Machine Microwave Oven Computer/Laptop/Netbook Internet Connection Cellphone Landline Telephone Air Conditioner Sewing Machine Car, Jeep, etc. Tricycle, Motorcycle, etc. Land (Agricultural/Residential/Commercial) Others, Specify OA_TYPE_O OA_IND Yes No OA_QTY 1:15 Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line number Type of crime Other crime Crime indicator Total victims Total male victims Total female victims Record: Crime Record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 CRIME_LINE CRIMETYPE 1 Murder / Homicide 2 Theft 3 Rape 4 Physical Injury (not including battery) 10 Other crimes (specified) CRIMETYPE_O CRIMEIND 1 Yes 2 No CTVICTTOT 1:30 CTVICTMALE 0:30 CTVICTFEMALE 0:30 Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number 1:999999 Line number Surname First Name Sex Record: Death Record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1 2 Age Cause of death 1 2 3 4 5 6 7 8 CBMS HPQ VN01201101 DEATH_LINE DEADSN DEADFN MDEADSX Male Female MDEADAGE MDEADY Diseases of the heart Diseases of the vascular system Pneumonia Tuberculosis Cancer Diarrhea Measles Complication during pregnancy or childbirth 15 9 10 11 12 13 14 15 16 Other cause Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line No Type Program Program Implementor other No Of Beneficiaries Member Member2 Member3 Member4 Member5 Rating Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line number Program Type Other program type Program indicator Program name CBMS HPQ VN01201101 Accident (ex. hit by a vehicle) Diabetes Disease of the lungs Disease of the kidney Drowned from flood Victim of landslide Electrocuted during typhoon Other causes, specify _____ MDEADY_O Record: Program Government Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 PROG_LINE_G PROG_TYPE_G 1 Pantawid Pamilyang Pilipino Program (4Ps) - Conditional Cash Transfer 2 NFA rice program 3 Comprehensive Agrarian Reform Program (CARP) 4 Philhealth - OFW 5 Philhealth - Employed 6 Philhealth - Individually paying 7 Philhealth - Sponsored 8 Philhealth - Lifetime 9 Food for School 10 Food for Work 11 Self-Employment Assistance - Kaunlaran (SEA-K) 12 Day Care Center services 13 Others PROGIND_G 1 Yes 2 No PROG_IMPLENTOR_G 1 National 2 Province 3 City/Municipality 4 Barangay 5 Congress/District 6 Private Organizations/NGOs 7 Don't know 8 Others PROG_IMPLEMENTOR_O_G PROGMEM_G_BENE PROGMEM_G PROGMEM_G2 PROGMEM_G3 PROGMEM_G4 PROGMEM_G5 PROGRATING_G 1 Yes 2 No 3 Not yet used Record: Programs Record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 PROG_LINE PROGTYPE 1 Other health insurance 2 Health Assistance 3 Supplemental Feeding 4 Education / Scholarship Program 5 Skills or Livelihood Training program 6 Credit Program 7 Housing Program 8 Others (Specify) PROGTYPE_O PROGIND 1 Yes 2 No PROGNAME 16 Implementor PROGIMPLEMENTOR National Province City/Municipality Barangay Congress/District Private Organizations/NGOs Don't know Others, specify PROGRAMIMPLEMENTOR_O PROGMEM PROGRATING 1 Yes 2 No 1 2 3 4 5 6 7 8 Others, specify Name of Member Effect rating Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line number calamity other calamity calamity indicator how many received aid? who's aid? other other who's aid Record: Calamity record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 CALAM_LINE CALAM_TYPE 1 Typhoon 2 Flood 3 Drought 4 Earthquake 5 Volcanic eruption 6 Landslide 7 Tsunami 8 Fire 9 Forest fire 10 Arm Conflict 11 Others CALAM_TYPE_O CALAM_TYPE_IND 1 Yes 2 No CALAM_HWMNY CALAM_AID 1 Yes 2 No CALAM_HUS_AID 1 Government 2 NGO 3 Relatives 4 Others (specify) CALAM_HUS_AID_O CALAM_HUS_AID_O_LB Level: Core HPQ questionnaire Record: Couples Record Data Item Item Label Urbanity Dec Zero Item Name (id) URB 1 Rural 2 Urban Region (id) REGN 1:17 Province (id) PROV Muncipality/City (id) MUN Barangay (id) BRGY Purok (id) PUROK Household ID Number (id) HCN 1:999999 Line number COUPLE_LINE Husband line number refrenced to line number inHUSBAND_LINE Wife line number refrenced to line number in meWIFE_LINE Engage in family planning FAM_PLAN 1 Yes 2 No 3 Don't know 4 Not applicable Family planning method FP_METH 1 Male sterilization 2 Female sterilization 3 Pill 4 IUD 5 Injectible 6 Implants 7 Patch 8 Condom 9 Female Condom 10 Diaphragm 11 Foam/Jelly/Cream CBMS HPQ VN01201101 17 12 13 14 15 16 17 18 Other family planning method Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line number Crop type Other type Crop Indicator Quantity harvested (in kilo) Mucus, Billings, Ovulation Basal Body Temperature Symptothermal Standard days method Calendar/Rhythm/Periodic Abstinence Withdrawal Others, specify ____ FP_METH_O Record: Crop Record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 CROP_LINE CROPTYPE 1 Palay 2 Corn 3 Coconut 4 Others, specify CROPTYPE_O CROP_IND 1 Yes 2 No CROP_VOL 0:999999999 Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number 1:999999 Line number Equipment Record: Agri equipment record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Other equipment Equipment indicator 1 2 Owner 1 2 AGRIEQUIP_LINE AGRIEQUIPTYPE Beast of burden Plow Harrow Mower Thresher/corn sheller Insecticide/pesticide sprayer Farm tractor Hand tractor Turtle/mudboat Planter/transplanter/dryer Mechanical dryer Multipurpose drying pavement Rice/cor/feed mill Harvester Warehouse granary Farmshed Irrigation pump Others AGRIEQUIPTYPE_O AGRIEQUIPIND Yes No AGRIEQUIP_OWNED Yes No Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line number CBMS HPQ VN01201101 Record: Fish cage record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 FCAGE_LINE 18 Area FCAGE_AREA 0:999999999 Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line number Type Other type Aqua Indicator Volume harvested Record: Aquatic animals record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 AQUANI_LINE AQUANITYPE 1 Tilapia 2 Milkfish 3 Catfish 4 Mudfish 5 Carp 6 Other AQUANITYPE_O AQUANI_IND 1 Yes 2 No AQUANI_VOL Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number 1:999999 Line number Equipment Record: Fishing equipment record Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1 2 3 4 5 6 7 8 Other equipment Equipment indicator 1 2 Owned 1 2 AQUAEQUIP_LINE AQUAEQUIPTYPE Fish net Electricity Bagnets Gillnets Traps Hooks and line Sift net Others AQUAEQUIPTYPE_O AQUAEQUIPIND Yes No AQUAEQUIP_OWNED Yes No Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line Number Kit Type Others CBMS HPQ VN01201101 Record: Disaster Preparedness Kit Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 KIT_LINENO KIT_TYPE 1 Water 2 Food 3 Matches/Lighter 4 Flashlight/Emergency Light 5 Radio/Transistor 6 Candle 7 Medical Kit 8 Whistle 9 Clothes 10 Blanket 11 Battery 12 Important Documents 13 Others, Specify KIT_TYPE_O 19 1 Yes 2 No KIT_IND 1 Yes 2 No KIT_XPIRY Kit Indicator Days to Consume Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line No Type Other Live animals Indicator Volume Record: Live Animal Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 LIVE_A_LINENO LIVE_A_TYPE 1 Hog/Sow 2 Goat 3 Carabao 4 Cow 5 Chicken 6 Duck 7 Others, Specify LIVE_A_TYPE_O LIVE_A_IND 1 Yes 2 No LIVE_A_VOLUME Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line No Type Other Meat indicator Volume Record: Meat Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 MEAT_LINENO MEAT_TYPE 1 Hog/Sow 2 Goat 3 Carabao 4 Cow 5 Chicken 6 Duck 7 Others, Specify MEAT_TYPE_O MEAT_IND 1 Yes 2 No MEAT_VOLUME Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line No Type Other Milk Indicator Volume CBMS HPQ VN01201101 Record: Milk Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 MILK_LINENO MILK_TYPE 1 Hog/Sow 2 Goat 3 Carabao 4 Cow 5 Chicken 6 Duck 7 Others, Specify MILK_TYPE_O MILK_IND 1 Yes 2 No MILK_VOLUME 20 Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line No Type Other Eggs Indicator Volume Record: Eggs Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 EGGS_LINENO EGGS_TYPE 1 Hog/Sow 2 Goat 3 Carabao 4 Cow 5 Chicken 6 Duck 7 Others, Specify EGGS_TYPE_O EGGS_IND 1 Yes 2 No EGGS_VOLUME Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Line No Type Others Others Indicator Volume Record: Others Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 OTHERS_LINENO OTHERS_TYPE 1 Hog/Sow 2 Goat 3 Carabao 4 Cow 5 Chicken 6 Duck 7 Others, Specify OTHERS_TYPE_O OTHERS_IND 1 Yes 2 No OTHERS_VOLUME Level: Core HPQ questionnaire Data Item Item Label Urbanity Region Province Muncipality/City Barangay Purok Household ID Number Insurance Line No Insurance For Insurance Indicator Insurance Provider Other Insurance Provider Level: Core HPQ questionnaire Data Item Item Label Urbanity CBMS HPQ VN01201101 Record: Insurance Record for Agriculture Dec Zero Item Name (id) URB 1 Rural 2 Urban (id) REGN 1:17 (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1:999999 IRFA_LINE_NO IRFA_FOR 1 Crops 2 Livestock and Poultry 3 Agricultural Equipment/Facilities IRFA_IND 1 Yes 2 No IRFA_PROVIDER 1 Government Insurance 2 Private Insurance Company 3 Bank 4 Others, Specify IRFA_PROVIDER_O Record: Insurance Record Dec Zero Item Name (id) URB 1 Rural 2 Urban 21 Region (id) REGN 1:17 Province Muncipality/City Barangay Purok Household ID Number 1:999999 Insurance Line No Insurance For (id) PROV (id) MUN (id) BRGY (id) PUROK (id) HCN 1 2 3 Insurance Indicator 1 2 Insurance Provider 1 2 3 4 Other Insurance Provider CBMS HPQ VN01201101 INS_LINE_NO INS_FOR House Motorized Vehicle Appliances INS_IND Yes No INS_PROVIDER Government Insurance Private Insurance Company Bank Others, Specify INS_PROVIDER_O 22