8.6.2.6a Import Format for Fees and Classes (Property)
Level of expertise required for this Chapter: Expert; specifically for LUPMIS @ TCPD
table, th, td {border: 1px solid black;}
Data | Essential ? | Format / Remark | Example | Excel column |
Code | ESSENTIAL Codes must be UNIQUE | Number: 100,200... for general classes, 101,102... for specific classes | 101 | A |
Class (or use) | ESSENTIAL | (name) | Residential Class A | B |
Name | | (name) | Class A CBD | C |
Rate | ESSENTIAL for flat-rate | (GHc) | 15 | D |
|
Unit | | (name, e.g. year, month, trip) | year | E |
Assessed | | (not applicable anymore, 1 for yes) | 0 | F |
Rate impost (predefined) | ESSENTIAL for predefined (option 'C') | (number, < 0.1) | 0 or 0.00012 | G |
Code of zone | | (string code; if more than 1, separate by -) | A or A-B | H |
Name of zone | | (name; if more than 1, separate by -) | CBD | I |
>Comments | | (text) | no comments | J |
Alternative name 1 for subclass | | (text) | Houses in CBD | K |
Alternative name 2 for subclass | | (text) | House in centre | L |
Marker (icon) | | (text, max 5 letters), for display on Internet map | home | M |
|
Control variable | ESSENTIAL | -99 at end | -99 | N |
In total, there should be 14 columns (last column in Excel: N).
File name should contain 'use_names' (e.g. STMA_use_names_2014.csv)
General requirements:
- The 'General classes of property use' are predefined (for example: 100 for Residentials), while the specific 'class' refers to the actual, specific use.
- Empty cells are allowed, except where indicated as essential (code, rate).
- If necessary, insert empy columns or re-arrange columns in your spreadsheet.
- Observe the number -99 at the right-most column as control variable.
- No commas or and-signs (&) or quotations (" or ') are allowed anywhere in your Excel data, as they work as delimiters in the CSV file. Delete or replace them in Excel.
- Data from the CSV file will overwrite data in the LUPMIS Revenue Database. If the cell in the Excel/csv file is blank, this will NOT overwrite or delete the LUPMIS data.
- Alternative names help the import of property class and subclass, if the code is un-known, but can be expressed in words in the comment column of the property field data.