<?xml version="1.0" encoding="UTF-8"?>
<codeBook version="2.5" ID="zaf-ctcc-ctrlfpd-2000-2006-v1" xml-lang="en" xmlns="ddi:codebook:2_5" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="ddi:codebook:2_5 https://ddialliance.org/Specification/DDI-Codebook/2.5/XMLSchema/codebook.xsd">
<docDscr>
  <citation>
    <titlStmt>
      <IDNo></IDNo>
      <titl>zaf-ctcc-ctrlfpd-2000-2006-v1</titl>
    </titlStmt>
    <prodStmt>
      <producer abbr="" affiliation="University of Cape Town" role="Metadata producer">DataFirst</producer>
      <prodDate date="2020-07-28">2020-07-28</prodDate>
      <software version="v5">NADA</software>
    </prodStmt>
    <verStmt>
      <version>Version 3</version>
    </verStmt>
  </citation>
</docDscr>
<stdyDscr>
  <citation>
    <titlStmt>
      <titl>Cape Town RSC Levy Firm Panel Data 2000-2006</titl>
      <subTitl/>
      <altTitl/>
      <parTitl/>
      <IDNo>zaf-ctcc-ctrlfpd-2000-2006-v1</IDNo>
    </titlStmt>
    <rspStmt>
      <AuthEnty affiliation="DataFirst, University of Cape Town">Andrew Kerr</AuthEnty>
    </rspStmt>
    <prodStmt>
      <producer abbr="" affiliation="" role="Original collectors and depositors of the data">Cape Town City Council</producer>
      <copyright/>
      <software version="beta" date="2026-06-16">MetadataEditor</software>
      <prodDate/>
      <prodPlac/>
      <fundAg abbr="" role="Funder">Private Enterprise Development in Low Income Countries</fundAg>
      <grantNo/>
    </prodStmt>
    <distStmt>
      <contact affiliation="" URI="support.data1st.org" email="support@data1st.org">DataFirst Support</contact>
      <depDate date=""/>
      <distDate date=""/>
    </distStmt>
    <serStmt>
      <serName>Enterprise Survey [en/oth]</serName>
      <serInfo><![CDATA[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>
      <verResp/>
      <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>
    <biblCit format=""><![CDATA[]]></biblCit>
    <notes><![CDATA[]]></notes>
  </citation>
  <studyAuthorization date="">
    <authorizationStatement><![CDATA[]]></authorizationStatement>
  </studyAuthorization>
  <stdyInfo>
    <studyBudget><![CDATA[]]></studyBudget>
    <subject>
                  
                  
    </subject>
    <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" cycle=""/>
      <collDate date="2006" event="end" cycle=""/>
      <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>
      <geogCoverNote/>
      <geogUnit>The data is at the level of local firm.</geogUnit>
      <anlyUnit><![CDATA[]]></anlyUnit>
      <universe><![CDATA[]]></universe>
      <dataKind/>
    </sumDscr>
    <qualityStatement>
      <standardsCompliance>
        <complianceDescription/>
      </standardsCompliance>
      <otherQualityStatement/>
    </qualityStatement>
    <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>
    <exPostEvaluation completionDate="" type="">
      <evaluationProcess/>
      <outcomes/>
    </exPostEvaluation>
  </stdyInfo>
  <method>
    <dataColl>
      <timeMeth/>
      <dataCollector abbr="" role="" affiliation="">Cape Town City Council</dataCollector>
      <frequenc/>
      <sampProc><![CDATA[]]></sampProc>
      <sampleFrame>
        <sampleFrameName/>
        <custodian/>
        <universe/>
        <frameUnit isPrimary="">
          <unitType numberOfUnits=""/>
        </frameUnit>
        <updateProcedure/>
      </sampleFrame>
      <deviat/>
      <collMode>Other [oth]</collMode>
      <resInstru><![CDATA[]]></resInstru>
      <instrumentDevelopment type=""/>
      <collSitu><![CDATA[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>
      <actMin><![CDATA[]]></actMin>
      <ConOps><![CDATA[]]></ConOps>
      <weight><![CDATA[]]></weight>
      <cleanOps><![CDATA[]]></cleanOps>
    </dataColl>
    <notes><![CDATA[]]></notes>
    <anlyInfo>
      <respRate><![CDATA[]]></respRate>
      <EstSmpErr><![CDATA[]]></EstSmpErr>
      <dataAppr><![CDATA[]]></dataAppr>
    </anlyInfo>
    <stdyClas><![CDATA[]]></stdyClas>
  </method>
  <dataAccs>
    <setAvail>
      <accsPlac URI=""/>
      <origArch/>
      <avlStatus/>
      <collSize/>
      <complete/>
      <fileQnty/>
      <notes><![CDATA[]]></notes>
    </setAvail>
    <useStmt>
      <restrctn/>
      <contact affiliation="University of Cape Town" URI="support.data1st.org" email="support@data1st.org">DataFirst</contact>
      <citReq><![CDATA[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>
      <deposReq><![CDATA[]]></deposReq>
      <conditions><![CDATA[Data available through our Secure Data Service]]></conditions>
      <disclaimer><![CDATA[]]></disclaimer>
    </useStmt>
    <notes><![CDATA[]]></notes>
  </dataAccs>
  <notes><![CDATA[]]></notes>
</stdyDscr>
<fileDscr ID="F1">
  <fileTxt>
    <fileName>rscdataforSRDC-s12</fileName>
    <fileCont></fileCont>
    <dimensns>
      <caseQnty>0</caseQnty>
      <varQnty>21</varQnty>
    </dimensns>
    <dataChck></dataChck>
    <dataMsng></dataMsng>
    <verStmt>
      <version></version>
    </verStmt>
  </fileTxt>
  <notes></notes>
</fileDscr>
<dataDscr>
<var ID="V1" name="firmid" files="F1" intrvl="contin">
  <varFormat type="numeric"/>
  <location StartPos="1" EndPos="6" width="6" RecSegNo="1"/>
  <labl>firm identifier</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V2" name="year" files="F1" intrvl="discrete">
  <varFormat type="numeric"/>
  <location StartPos="7" EndPos="10" width="4" RecSegNo="1"/>
  <labl>Financial year, running from July 1999 to June 2000 etc</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V3" name="surveyed" files="F1" intrvl="discrete">
  <varFormat type="numeric"/>
  <location StartPos="11" EndPos="11" width="1" RecSegNo="1"/>
  <labl>dummy, =1 if firm was surveyed in 2000/2001</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V4" name="weight" files="F1" intrvl="contin">
  <varFormat type="numeric"/>
  <location StartPos="12" EndPos="12" width="1" RecSegNo="1"/>
  <labl>Weight to account for survey non-response</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V5" name="revenue" files="F1" intrvl="contin">
  <varFormat type="numeric"/>
  <location StartPos="13" EndPos="23" width="11" RecSegNo="1"/>
  <labl>firm revenue in the financial year</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V6" name="wagebill" files="F1" intrvl="contin">
  <varFormat type="numeric"/>
  <location StartPos="24" EndPos="33" width="10" RecSegNo="1"/>
  <labl>firm wage bill in the financial year</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V7" name="siccode" files="F1" intrvl="discrete">
  <varFormat type="character"/>
  <location StartPos="34" EndPos="38" width="5" RecSegNo="1"/>
  <labl>SIC code of major product/good/service provided</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V8" name="totemploy" files="F1" intrvl="contin">
  <varFormat type="numeric"/>
  <location StartPos="39" EndPos="44" width="6" RecSegNo="1"/>
  <labl>Total number of employees within the city, 2000 only</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V9" name="trinstpcde" files="F1" intrvl="contin">
  <varFormat type="numeric"/>
  <location StartPos="45" EndPos="48" width="4" RecSegNo="1"/>
  <labl>Post code for firm's street address</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V10" name="magdistric" files="F1" intrvl="discrete">
  <varFormat type="character"/>
  <location StartPos="49" EndPos="50" width="2" RecSegNo="1"/>
  <labl>Magisterial district where firm is located</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V11" name="typebusine" files="F1" intrvl="discrete">
  <varFormat type="numeric"/>
  <location StartPos="51" EndPos="51" width="1" RecSegNo="1"/>
  <labl>Type of business</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
  <catgry>
    <catValu>1</catValu>
    <labl>Sole Proprietor</labl>
    <catStat type="vald"/>
  </catgry>
  <catgry>
    <catValu>2</catValu>
    <labl>Partnership</labl>
    <catStat type="invd"/>
  </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>
</var>
<var ID="V12" name="estypeorg" files="F1" intrvl="discrete">
  <varFormat type="character"/>
  <location StartPos="52" EndPos="54" width="3" RecSegNo="1"/>
  <labl>Type of organisation</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V13" name="exportgoods" files="F1" intrvl="discrete">
  <varFormat type="character"/>
  <location StartPos="55" EndPos="55" width="1" RecSegNo="1"/>
  <labl>Does the firm export goods, from survey</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V14" name="exportservices" files="F1" intrvl="discrete">
  <varFormat type="character"/>
  <location StartPos="56" EndPos="56" width="1" RecSegNo="1"/>
  <labl>Does the firm export services, from survey</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V15" name="essubcontr" files="F1" intrvl="discrete">
  <varFormat type="character"/>
  <location StartPos="57" EndPos="57" width="1" RecSegNo="1"/>
  <labl>Does company usually sub-contract or outsource work</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V16" name="cadastralno" files="F1" intrvl="discrete">
  <varFormat type="character"/>
  <location StartPos="58" EndPos="78" width="21" RecSegNo="1"/>
  <labl>cadastral number from separate GIS survey</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V17" name="liquiddatestr" files="F1" intrvl="discrete">
  <varFormat type="character"/>
  <location StartPos="79" EndPos="86" width="8" RecSegNo="1"/>
  <labl>Date of liquidation</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V18" name="suspendatestr" files="F1" intrvl="discrete">
  <varFormat type="character"/>
  <location StartPos="87" EndPos="94" width="8" RecSegNo="1"/>
  <labl>Date of suspension</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V19" name="exit" files="F1" intrvl="discrete">
  <varFormat type="numeric"/>
  <location StartPos="95" EndPos="95" width="1" RecSegNo="1"/>
  <labl>exit indicator based derived from wage bill+turnover</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V20" name="age" files="F1" intrvl="contin">
  <varFormat type="numeric"/>
  <location StartPos="96" EndPos="98" width="3" RecSegNo="1"/>
  <labl>Firm age, from survey</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
<var ID="V21" name="entry" files="F1" intrvl="discrete">
  <varFormat type="numeric"/>
  <location StartPos="99" EndPos="99" width="1" RecSegNo="1"/>
  <labl>an indicator of entry derived from wage bill+turnover</labl>
  <sumStat type="vald"/>
  <sumStat type="invd"/>
</var>
</dataDscr></codeBook>
