Download User`s Manual for CBMS StatSimPro 5.0

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