Name: repeatBeginD

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• d1a (type: esriFieldTypeString, alias: D1a. What are the main sources of your household's livelihood in the past year? These would include selling the crops that you raised, profits from livestock, working for others, your family's own business, services provided to others (cooking, hairdressing etc.) by all the members of your household in the last 12 months which contributed to household income. We also want to know about the crops and livestock that you raised for your family's own consumption., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d1ab (type: esriFieldTypeString, alias: (Do not read list below but wait for responses and mark all affirmative answers according to income sources. Then continue to D1b and D1c for the first livelihood source on the list as mentioned by the parent. Continue this process until you are finished with all the livelihood sources mentioned. However, if none of the options applies, then specify in the Row labeled 'Other' by entering 20 (for No income source) and proceed to D1. , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d1ac (type: esriFieldTypeString, alias: D1b. [For agricultural production only] Did you produce this for your family's consumption only, for sale only, or both? Enter option 1, 2 or 3 in the D1b column and then go on to D1c for that income source. D1c. Was this income from your own family's production or family business, or did the income come from working for someone else? Enter option 1 or 2. If none of the options applies, then specify employer in the Row labeled 'Other' in the D1c column and then go on to D1d for that income source. , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d1 (type: esriFieldTypeString, alias: D1. Do you own the house that you live in, rent it, or some other arrangement?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ownH: 1= Own], [rentH: 2= Rent], [rentFreeH: 3= Live rent-free in relative's house], ... 2 more ...)
• writeTextC (type: esriFieldTypeString, alias: Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d11 (type: esriFieldTypeString, alias: D2.1 What material is used for the walls of your house?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [palm: 1= Mud / cane /palm], [mud: 2= Stone with mud /plywood/ cardboard], [cement: 3= Cement / bricks /stone with cement], ... 1 more ...)
• writeTextA (type: esriFieldTypeString, alias: Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d12 (type: esriFieldTypeString, alias: D2.2. What material is used for the roof of your house?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [noRoof: 1= Mud / cane /palm], [thatch: 2= Stone with mud /plywood/ cardboard], [mats: 3= Cement / bricks /stone with cement], ... 1 more ...)
• writeTextB (type: esriFieldTypeString, alias: Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d13 (type: esriFieldTypeString, alias: D2.3. Is your house connected to electricity?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d14 (type: esriFieldTypeString, alias: D2.4. Does this household own a Television?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d15 (type: esriFieldTypeString, alias: D2.5. Does this household own a Mbaula/Brazier?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d16 (type: esriFieldTypeString, alias: D2.6. Does this household own a Gas or Electric stove?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d17 (type: esriFieldTypeString, alias: D2.7. Does this household own an Iron?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [electric: 1= Electric Ya Magetsi], [nonElectric: 2= Non-electric Osati ya Magetsi], [no: 0= No Ayi])
• d18 (type: esriFieldTypeString, alias: D2.8. Does this household own a Sofa?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d19 (type: esriFieldTypeString, alias: D2.9. Do you have any beds or mattresses in your household?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [noBed: 1= No beds or mattresses], [mattress: 2= Mattress but no bed], [bedMattress: 3= Bed and mattress:])
• d110 (type: esriFieldTypeString, alias: D2.10. Did this household purchase/consume/receive milk (fresh), milk (powdered, excl. baby milk), cheese, or other dairy products during the last 2 weeks?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d2 (type: esriFieldTypeString, alias: D3. Does your household own any land for agricultural activities such as cultivation or keeping livestock?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d21 (type: esriFieldTypeDouble, alias: D3.1. What is the size of the land?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• d3 (type: esriFieldTypeString, alias: D4. Does your household own any livestock?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d42New (type: esriFieldTypeString, alias: D4.2 For each of the livestock owned, specify whether the household members who attended the REAL course are involved in raising this animal., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d4 (type: esriFieldTypeString, alias: D5. Aside from the REAL course/EMPOWER activities, has any member of your household received any training, inputs, equipment, financial or other assistance from any organization in the last two, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d41 (type: esriFieldTypeString, alias: D5.1. Which organization provided this assistance?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [govern: 1 = Government, specify agency], [ngo: 2 = NGO, specify name], [privComp: 3 = Private Company, specify name], ... 1 more ...)
• d41specific (type: esriFieldTypeString, alias: Specify the organization:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d43 (type: esriFieldTypeString, alias: D5.3. Was this assistance for the whole household or for some individual family members?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [wholeH: 1= Whole household], [childOn: 2= Children only], [indivMem: 3= Individual family members])
• d5 (type: esriFieldTypeString, alias: D6. Did any member of your household receive any training on business skills, entrepreneurship, improved farming techniques or other livelihood activities in the last year?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d51 (type: esriFieldTypeString, alias: D6.1. Specifically, what type of training or what technique(s)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• writeTextD (type: esriFieldTypeString, alias: Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d52 (type: esriFieldTypeString, alias: D6.2. Who or what organization provided the training?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• writeTextE (type: esriFieldTypeString, alias: Please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d6 (type: esriFieldTypeString, alias: D7. Does any member of your household belong to any business network, savings group or cooperative in the community?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d61 (type: esriFieldTypeString, alias: D7.1. Which member of the household belongs to business network, savings group or cooperative?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d7 (type: esriFieldTypeString, alias: D8. Does any member of your household have any access to any microfinance programs (savings and loans)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d71 (type: esriFieldTypeString, alias: D8.1. Which member of the household has access to microfinance programs (savings and loans)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d72 (type: esriFieldTypeString, alias: D8.2. From which source?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d83 (type: esriFieldTypeString, alias: D8.3 Did any member of your household apply for a loan in the past 12 months?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d831 (type: esriFieldTypeString, alias: D8.3.1 Who applied for this loan?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [maleHH: 1=Male household member who attended the REAL course], [femaleHH: 2=Female household member who attended the REAL course], [anotherMaleEE: 3=Another male member of household], ... 1 more ...)
• d84 (type: esriFieldTypeString, alias: D8.4 Did any member of your household receive any services from a bank in the past 12 months?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes - Inde], [no: No - Ayi])
• d8 (type: esriFieldTypeString, alias: D9. How many meals did your household eat yesterday?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [noN: 1= None], [onE: 2= One], [twt: 3= Two], ... 1 more ...)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

• EMPOWER_Outake_Form_repeatBeginD (4) -- Related To: EMPOWER_Outake_Form (0)
• repeatBeginD_d1aRepeat (5) -- Related To: d1aRepeat (5)
• repeatBeginD_livestock (6) -- Related To: livestock (6)
• repeatBeginD_d42repeat (7) -- Related To: d42repeat (7)
• repeatBeginD_d431Repeat (8) -- Related To: d431Repeat (8)
• repeatBeginD_d53Repeat (9) -- Related To: d53Repeat (9)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/20/2020 10:02:49 AM

Schema Last Edit Date: 1/20/2020 10:02:49 AM

Data Last Edit Date: 1/20/2020 10:02:49 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat