<?xml version='1.0' encoding='UTF-8'?>
<codeBook version="1.2.2" ID="zaf-ctcc-ctrlfpd-2000-2006-v1" xml-lang="en" xmlns="http://www.icpsr.umich.edu/DDI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.icpsr.umich.edu/DDI http://www.icpsr.umich.edu/DDI/Version1-2-2.xsd">
  <docDscr>
    <citation>
      <titlStmt>
        <titl>
          zaf-ctcc-ctrlfpd-2000-2006-v1
        </titl>
      </titlStmt>
      <prodStmt>
        <producer affiliation="University of Cape Town" role="Metadata producer">
          DataFirst
        </producer>
        <prodDate date="2020-07-28">
          2020-07-28
        </prodDate>
        <software version="4.0.9" date="2013-04-23">
          Nesstar Publisher
        </software>
      </prodStmt>
      <verStmt>
        <version>
          Version 3
        </version>
      </verStmt>
    </citation>
  </docDscr>
  <stdyDscr>
    <citation>
      <titlStmt>
        <titl>
          Cape Town RSC Levy Firm Panel Data 2000-2006
        </titl>
        <altTitl>
          CTRLFPD 2000-2006
        </altTitl>
        <IDNo>
          zaf-ctcc-ctrlfpd-2000-2006-v1
        </IDNo>
      </titlStmt>
      <rspStmt>
        <AuthEnty affiliation="DataFirst, University of Cape Town">
          Andrew Kerr
        </AuthEnty>
      </rspStmt>
      <prodStmt>
        <producer abbr="CTCC" role="Original collectors and depositors of the data">
          Cape Town City Council
        </producer>
        <software version="4.0.9" date="2013-04-23">
          Nesstar Publisher
        </software>
        <fundAg abbr="PEDL" role="Funder">
          Private Enterprise Development in Low Income Countries
        </fundAg>
      </prodStmt>
      <distStmt>
        <contact URI="support.data1st.org" email="support@data1st.org">
          DataFirst Support
        </contact>
      </distStmt>
      <serStmt>
        <serName>
          Enterprise Survey [en/oth]
        </serName>
        <serInfo>
          Kerr, Andrew. Cape Town RSC Levy Firm Panel Data 2000-2006 [dataset]. Version 1. Cape Town: Cape Town City Council and DataFirst [producers], 2007. Cape Town: DataFirst [distributor], 2015. DOI: https://doi.org/10.25828/9fw3-np87
        </serInfo>
      </serStmt>
      <verStmt>
        <version date="2015-06-29">
          v1: Data accessible through the Secure Data Service
        </version>
        <notes>
          <![CDATA[Secure variables available in this dataset include:

Post code for firms' street address (trinstpcde) 
Magisterial District where the firm is located (magdistric)
Cadastral number of the firm from a separate GIS survey (cadastralno)]]>
        </notes>
      </verStmt>
    </citation>
    <stdyInfo>
      <abstract>
        <![CDATA[Until 2006 metropolitan and district councils in South Africa, which were previously called Regional Services Councils (RSC), were permitted to raise revenue by taxing firms that operated within the council area. The City of Cape Town taxed firms based on their turnover and wage bill but also used the administration of the RSC levy, as the tax was called, to create an administrative dataset of firms. The city used this data to calculate Gross Geographic product and produce a number of reports on the local economy (cf City of Cape Town 2001). 
The City undertook a survey of all firms on the RSC tax database in 2000 and linked the firms to location based GIS data. The RSC data is thus a mixture of administrative and survey data. The dataset covers the period 2000 to 2006.
In theory any enterprise employing at least 1 worker or with a revenue of R10 000 a year was supposed to pay the RSC levy and thus be included in the database. Thus this dataset should be a census of all formal firms operating with the city of Cape Town during the period covered, except the very smallest self-employed operators. In practice, however those familiar with the RSC have said that there was evasion of the tax, with a possible 30% of firms evading. 

Around two thirds of the active firms in 2000 responded to this survey. Some of this survey data (particularly employment) was supposed to be updated every year but in practice we only have useable survey data for the first year of the panel. Much of the employment data was imputed in subsequent years and cannot be used. New entrants were captured in the database but some of the survey information is not available for these firms.

The project to create this research dataset was made possible by an exploratory grant obtained by Andrew Kerr and Martin Wittenberg of DataFirst from the Private Enterprise Development in Low-Income Countries (PEDL) research initiative. PEDL is a joint research initiative of the Centre for Economic Policy Research (CEPR) and the UK Department For International Development (DFID). It aims to develop a research programme focusing on private-sector development in low-income countries.]]>
      </abstract>
      <sumDscr>
        <collDate date="2000" event="start"/>
        <collDate date="2006" event="end"/>
        <nation abbr="zaf">
          South Africa
        </nation>
        <geogCover>
          The data covers the Metropolitan area of Cape Town. The data is available with firm-level GPS coordinates
        </geogCover>
        <geogUnit>
          The data is at the level of local firm.
        </geogUnit>
      </sumDscr>
      <notes>
        <![CDATA[Data collected every year for the firm levy database included the firm type, wage bill and revenue of each firm, as well as whether the firm had exited and when this exit took place. 
The 2000 survey collected data on age and size of firm, exporter status and use of IT in the firm, as well as data on sub-contracting and outsourcing.]]>
      </notes>
    </stdyInfo>
    <method>
      <dataColl>
        <dataCollector abbr="CTCC">
          Cape Town City Council
        </dataCollector>
        <collMode>
          Other [oth]
        </collMode>
        <sources/>
        <collSitu>
          Data was collected by the Cape Town City Council as administrative records and in 2000 with a survey. Creating this research dataset was made possible through an Exploratory Research Grant (ERG) for the project "Exploring Dynamics in South African firms" from Private Enterprise Development in Low Income Countries (PEDL.
        </collSitu>
      </dataColl>
    </method>
    <dataAccs>
      <useStmt>
        <contact affiliation="University of Cape Town" URI="support.data1st.org" email="support@data1st.org">
          DataFirst
        </contact>
        <citReq>
          Kerr, Andrew. Cape Town RSC Levy Firm Panel Data 2000-2006 [dataset]. Version 1. Cape Town: Cape Town City Council and DataFirst [producers], 2007. Cape Town: DataFirst [distributor], 2015. DOI: https://doi.org/10.25828/9fw3-np87
        </citReq>
        <conditions>
          Data available through our Secure Data Service
        </conditions>
      </useStmt>
    </dataAccs>
  </stdyDscr>
  <fileDscr ID="F1" URI="zaf-ctcc-ctrlfpd-2000-2006-v1.Nesstar?Index=0&amp;Name=rscdataforSRDC-s12">
    <fileTxt>
      <fileName>
        rscdataforSRDC-s12.NSDstat
      </fileName>
      <dimensns>
        <caseQnty>
          0
        </caseQnty>
        <varQnty>
          21
        </varQnty>
      </dimensns>
      <fileType>
        Nesstar 200801
      </fileType>
    </fileTxt>
    <notes>
      RSC firm data, created by Andrew Kerr, March 2014
    </notes>
  </fileDscr>
  <dataDscr>
    <var ID="V1" name="firmid" files="F1" dcml="0" intrvl="contin">
      <location StartPos="1" EndPos="6" width="6" RecSegNo="1"/>
      <labl>
        firm identifier
      </labl>
      <valrng>
        <range UNITS="REAL" min="11" max="805372"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V2" name="year" files="F1" dcml="0" intrvl="discrete">
      <location StartPos="7" EndPos="10" width="4" RecSegNo="1"/>
      <labl>
        Financial year, running from July 1999 to June 2000 etc
      </labl>
      <valrng>
        <range UNITS="REAL" min="2000" max="2006"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V3" name="surveyed" files="F1" dcml="0" intrvl="discrete">
      <location StartPos="11" EndPos="11" width="1" RecSegNo="1"/>
      <labl>
        dummy, =1 if firm was surveyed in 2000/2001
      </labl>
      <valrng>
        <range UNITS="REAL" min="0" max="1"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V4" name="weight" files="F1" dcml="0" intrvl="contin">
      <location StartPos="12" EndPos="12" width="1" RecSegNo="1"/>
      <labl>
        Weight to account for survey non-response
      </labl>
      <valrng>
        <range UNITS="REAL" min="1" max="4"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V5" name="revenue" files="F1" dcml="0" intrvl="contin">
      <location StartPos="13" EndPos="23" width="11" RecSegNo="1"/>
      <labl>
        firm revenue in the financial year
      </labl>
      <valrng>
        <range UNITS="REAL" min="0" max="13481176518"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V6" name="wagebill" files="F1" dcml="0" intrvl="contin">
      <location StartPos="24" EndPos="33" width="10" RecSegNo="1"/>
      <labl>
        firm wage bill in the financial year
      </labl>
      <valrng>
        <range UNITS="REAL" min="0" max="2839252425"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V7" name="siccode" files="F1" intrvl="discrete">
      <location StartPos="34" EndPos="38" width="5" RecSegNo="1"/>
      <labl>
        SIC code of major product/good/service provided
      </labl>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="character" schema="other"/>
    </var>
    <var ID="V8" name="totemploy" files="F1" dcml="0" intrvl="contin">
      <location StartPos="39" EndPos="44" width="6" RecSegNo="1"/>
      <labl>
        Total number of employees within the city, 2000 only
      </labl>
      <valrng>
        <range UNITS="REAL" min="0" max="420000"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V9" name="trinstpcde" files="F1" dcml="0" intrvl="contin">
      <location StartPos="45" EndPos="48" width="4" RecSegNo="1"/>
      <labl>
        Post code for firm's street address
      </labl>
      <valrng>
        <range UNITS="REAL" min="0" max="9999"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V10" name="magdistric" files="F1" intrvl="discrete">
      <location StartPos="49" EndPos="50" width="2" RecSegNo="1"/>
      <labl>
        Magisterial district where firm is located
      </labl>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="character" schema="other"/>
    </var>
    <var ID="V11" name="typebusine" files="F1" dcml="0" intrvl="discrete">
      <location StartPos="51" EndPos="51" width="1" RecSegNo="1"/>
      <labl>
        Type of business
      </labl>
      <valrng>
        <range UNITS="REAL" min="1" max="7"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <catgry>
        <catValu>
          1
        </catValu>
        <labl>
          Sole Proprietor
        </labl>
      </catgry>
      <catgry>
        <catValu>
          2
        </catValu>
        <labl>
          Partnership
        </labl>
      </catgry>
      <catgry>
        <catValu>
          3
        </catValu>
        <labl>
          Public/State entity
        </labl>
      </catgry>
      <catgry>
        <catValu>
          4
        </catValu>
        <labl>
          Company, CC, Trust, Club
        </labl>
      </catgry>
      <catgry>
        <catValu>
          5
        </catValu>
        <labl>
          Other
        </labl>
      </catgry>
      <catgry>
        <catValu>
          7
        </catValu>
        <labl>
          Unknown
        </labl>
      </catgry>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V12" name="estypeorg" files="F1" intrvl="discrete">
      <location StartPos="52" EndPos="54" width="3" RecSegNo="1"/>
      <labl>
        Type of organisation
      </labl>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="character" schema="other"/>
    </var>
    <var ID="V13" name="exportgoods" files="F1" intrvl="discrete">
      <location StartPos="55" EndPos="55" width="1" RecSegNo="1"/>
      <labl>
        Does the firm export goods, from survey
      </labl>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="character" schema="other"/>
    </var>
    <var ID="V14" name="exportservices" files="F1" intrvl="discrete">
      <location StartPos="56" EndPos="56" width="1" RecSegNo="1"/>
      <labl>
        Does the firm export services, from survey
      </labl>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="character" schema="other"/>
    </var>
    <var ID="V15" name="essubcontr" files="F1" intrvl="discrete">
      <location StartPos="57" EndPos="57" width="1" RecSegNo="1"/>
      <labl>
        Does company usually sub-contract or outsource work
      </labl>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="character" schema="other"/>
    </var>
    <var ID="V16" name="cadastralno" files="F1" intrvl="discrete">
      <location StartPos="58" EndPos="78" width="21" RecSegNo="1"/>
      <labl>
        cadastral number from separate GIS survey
      </labl>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="character" schema="other"/>
    </var>
    <var ID="V17" name="liquiddatestr" files="F1" intrvl="discrete">
      <location StartPos="79" EndPos="86" width="8" RecSegNo="1"/>
      <labl>
        Date of liquidation
      </labl>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="character" schema="other"/>
    </var>
    <var ID="V18" name="suspendatestr" files="F1" intrvl="discrete">
      <location StartPos="87" EndPos="94" width="8" RecSegNo="1"/>
      <labl>
        Date of suspension
      </labl>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="character" schema="other"/>
    </var>
    <var ID="V19" name="exit" files="F1" dcml="0" intrvl="discrete">
      <location StartPos="95" EndPos="95" width="1" RecSegNo="1"/>
      <labl>
        exit indicator based derived from wage bill+turnover
      </labl>
      <valrng>
        <range UNITS="REAL" min="1" max="1"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V20" name="age" files="F1" dcml="0" intrvl="contin">
      <location StartPos="96" EndPos="98" width="3" RecSegNo="1"/>
      <labl>
        Firm age, from survey
      </labl>
      <valrng>
        <range UNITS="REAL" min="-2" max="206"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
    <var ID="V21" name="entry" files="F1" dcml="0" intrvl="discrete">
      <location StartPos="99" EndPos="99" width="1" RecSegNo="1"/>
      <labl>
        an indicator of entry derived from wage bill+turnover
      </labl>
      <valrng>
        <range UNITS="REAL" min="1" max="1"/>
      </valrng>
      <sumStat type="vald">
        0
      </sumStat>
      <sumStat type="invd">
        0
      </sumStat>
      <varFormat type="numeric" schema="other"/>
    </var>
  </dataDscr>
</codeBook>
