addresses will be retired All addresses will ultimately have the source field populated source_verified Date address was last Supplements the source field, revealing the latest DATE 08/02/2009 verified against the defined date the address was verified by the source. source dataset. Although the address ufi_created date indicates the time of most recent modification. A ufi_created date of many years ago does not mean the address is incorrect, but promotes the likelihood of the validity being questioned. is_primary Primary or secondary Local Government properties are assigned and is_primary options: property address identified by a single property address, but Y = Yes, the property’s main (primary) alternative or silent addresses are sometimes linked address to properties for means of alternative access or N = No, not the property’s main (primary) future subdivision. address. i.e. an alternative property (secondary) address Reference table : VMREFTAB.ADDRESS_IS_PRIMARY.IS PRIMARY_CODE property_status Indicates whether the Currently linked to the associated VICMAP property_status options:-: address is associated with a PROPERTY property and parcel record/s P = Proposed - indicates the plan of or The parcel/property/address status is based on “proposed” “approved” subdivision yet to be approved property Land of the relevant plan of Registry’s approval A = Approved - indicates the plan of subdivision. subdivision approved (& certificate of titles The parcel_status is mirrored in property_status in issued) VMPROP, and subsequently carried through to the Reference table : VICMAP ADDRESS property_status. VMREFTAB.PR_STATUS.STATUS_CODE
addresses will be retired All addresses will ultimately have the source field populated source_verified Date address was last verified against the defined source dataset. Supplements the source field, revealing the latest date the address was verified by the source. Although the address ufi_created date indicates the time of most recent modification. A ufi_created date of many years ago does not mean the address is incorrect, but promotes the likelihood of the validity being questioned. DATE 08/02/2009 is_primary Primary or secondary property address Local Government properties are assigned and identified by a single property address, but alternative or silent addresses are sometimes linked to properties for means of alternative access or future subdivision. is_primary options: Y = Yes, the property’s main (primary) address N = No, not the property’s main (primary) address. i.e. an alternative property (secondary) address Reference table : VMREFTAB.ADDRESS_IS_PRIMARY.IS PRIMARY_CODE property_status Indicates whether the address is associated with a “proposed” or “approved” property Currently linked to the associated VICMAP PROPERTY property and parcel record/s The parcel/property/address status is based on Land Registry’s approval of the relevant plan of subdivision. The parcel_status is mirrored in property_status in VMPROP, and subsequently carried through to the VICMAP ADDRESS property_status. property_status options:-: P = Proposed - indicates the plan of subdivision yet to be approved A = Approved - indicates the plan of subdivision approved (& certificate of titles issued) Reference table : VMREFTAB.PR_STATUS.STATUS_CODE
Product-description-V6.docx