Main menu:
Data | Essential ? | Format / Remark | Example | Excel column |
UPN | ESSENTIAL | xxx-yyyy-aaaa format, as string | 678-0789-0123 | A |
SubUPN | xxx-yyyy-aaaaA format as string or blank or single/double/triple letter | 678-0789-0123F | B | |
Locality code | as string, max length 15 | CBD | C | |
Street name | as string, max length 50 | Oxford St | D | |
Property number | as string, max length 30 | 3 | E | |
Floor | ESSENTIAL if above ground floor | as number, 0 for ground floor | 0 | F |
Coordinates: x | UTM 30, new | 678456 | G | |
Coordinates: y | UTM 30, new | 789567 | H | |
Owner | ESSENTIAL | as string, max length 50 | Kofi | I |
Owner address | as string, max length 50 | 7 Oxford St | J | |
Owner telephone | as string!, max length 15 | 0241234567 | K | |
Owner email | as string!, max length 50 | kofi@yahoo.com | L | |
Owner id | as string, max length 12, for compatibility with older systems | S667799 | M | |
Number of rooms | as integer number | 5 | N | |
Year of construction | as number, 1800- | 2005 | O | |
Property type | as code (0-10) | 2 | P | |
Property use | ESSENTIAL | as code: 100,101..., 200..., 300... | 101 | Q |
Persons in building | as number | 4 | R | |
Roofing | as code (0-6) | 2 | S | |
Ownership type | as code (0-6) | 3 | T | |
Construction material type | as code (0-6) | 1 | U | |
Number of storeys | as integer number | 2 | V | |
Rateable value | in GHc, as integer | 30000 | W | |
Valuation code | Deprecated, not used anymore | (blank) | X | |
Sub-Metro | as string, new | Northwest | Y | |
SubUrb | as string, new | Left | Z | |
Descriptor | as code, integer | - | AA | |
Planning permit | as code (0-2) | 1 | AB | |
Planning permit number | as string, max length 30 | 678-0789-0123PP | AC | |
Building permit | as code (0-2) | 1 | AD | |
Building permit number | as string, max length 30 | 678-0789-0123BP | AE | |
'Property' | ESSENTIAL | word 'Property' | Property | AF |
Comments | as string, helpful if property use code not available | Blank | AG | |
Previous reference code | as string , works also as password for online access | 12/43794 | AH | |
Old address/house no. | as string | 12 A/B | AI | |
Exempted | 1 for exempted, otherwise blank or 0 | (blank) | AJ | |
-99 | ESSENTIAL | control variable, as number | -99 | AK |