ast_rea_beta_ext 0.2
Definition
This distribution (AST_REA) contains a longitudinal history of reported assets that relate to real estate.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| ~.ast_rea_beta_ext.ext_dom_person_id | Recipient: DOMINO person identifier, ID number |
A synthetic numeric sequence of characters used for the purposes of identifying a unique DOMINO entity.
Specific Information:
person_id has been renamed to ext_dom_person_id |
Number | N[15] |
| ~.ast_rea_beta_ext.rbid_id | Asset: Real estate or business item identifier, ID number |
A numeric identifier used to identify the Real Estate/Business item within a record. This ID links the RBID group to the RBRD group (if real estate) or the RBBD group (if business). |
Number | N[N] |
| ~.ast_rea_beta_ext.rea_type | Asset: Real estate and business type, Code |
A code for the type of real estate or business asset. |
String | XXX |
| ~.ast_rea_beta_ext.rea_prncpl_hom | Asset: Real estate property is principal home, Code |
This field indicates that this property is the principal home. |
Boolean | A |
| ~.ast_rea_beta_ext.rea_prop_sts | Asset: Property status, Code |
The status of a property asset owned by the client. |
String | AAA |
| ~.ast_rea_beta_ext.period_start_date | Event: Period start date, YYYY-MM-DD |
The date on which a reporting period relating to an event commences, expressed as YYYY-MM-DD. |
Date | YYYY-MM-DD |
| ~.ast_rea_beta_ext.period_end_date | Event: Period end date, YYYY-MM-DD |
The date on which a reporting period relating to an event ends, expressed as YYYY-MM-DD. |
Date | YYYY-MM-DD |
| ~.ast_rea_beta_ext.rea_asset_own_pc | Asset: Proportion of real estate asset owned, Percentage |
The percentage of the real estate item owned by the client. |
Number | NNN.NN |
| ~.ast_rea_beta_ext.rea_bal_sheet_valn_amt | Asset: Real estate asset balance sheet valuation amount, Total Australian currency |
Contains the asset value of the real estate asset from a balance sheet or other documentation provided by the client to support the valuation. |
Decimal | N[9].NN |
| ~.ast_rea_beta_ext.rea_house_content_tot_amt | Asset: House content total amount, Total Australian currency |
Contains the total net value of the contents (of an item of real estate) owned by the client. The ownership % is NOT applied. |
Decimal | N[9].NN |
| ~.ast_rea_beta_ext.rea_house_curtilage_amt | Asset: House curtilage amount, Total Australian currency |
Contains the gross value of the house and curtilage as assessed by the AVO (recorded in whole dollars but stored in cents). Only applicable to farming properties. (House and curtilage is the building and the immediate surrounding area of a farming property). Client can only have one item of real estate with house and curtilage amount deducted from the market value amount. |
Decimal | N[9].NN |
| ~.ast_rea_beta_ext.rea_livestock_tot_amt | Asset: Livestock total amount, Total Australian currency |
Contains the total value of livestock owned by the client or partner. |
Decimal | N[9].NN |
| ~.ast_rea_beta_ext.rea_market_val_amt | Asset: Real estate market value, Total Australian currency |
Contains the gross value of the entire item of real estate. |
Decimal | N[9].NN |
| ~.ast_rea_beta_ext.rea_mtge_loan_amt | Asset: Mortgage loan amount, Total Australian currency |
Contains the total amount of any mortgages held on the item of real estate. (Does not include loans for tractors/stock/etc). |
Decimal | N[9].NN |
| ~.ast_rea_beta_ext.rea_oth_asset_tot_amt | Asset: Other asset total amount, Total Australian currency |
Contains the current market value (recorded as whole dollars) of any other assets applicable to the real estate/business (i.e. Plant/machinery, stock, grain). |
Decimal | N[9].NN |
| ~.ast_rea_beta_ext.rea_oth_dedn_amt | Asset: Other deduction amount, Total Australian currency |
Contains the total amount of any loans/mortgages held over items relating to the real estate (not mortgages on the property itself), e.g. loan for tractor. |
Decimal | N[9].NN |
| ~.ast_rea_beta_ext.rea_former_prncpl_home_ind | Asset: Real estate asset is client’s former principal home indicator, Code |
This field is used to indicate the item of real estate was the customer's former principal home and therefore will not be considered in asset assessment processing. It will continue to be considered in the generic asset assessment. This field is not used for any other purpose. If a value of 'Y' is input the item of real estate will not be considered for asset assessment. |
Boolean | A |
| ~.ast_rea_beta_ext.rea_asset_valn_src_code | Asset: Real estate asset valuation, Code |
Source of real estate asset evaluation. |
String | XXX |
Origin
1 Extraction
The data for this distribution is extracted from the data warehouse at Services Australia. The source tables are detailed below.
- CIRC_REST_RBID contains identifying information for each item of real estate or business owned by a person. Only records relating to businesses are considered for the purposes of this distribution.
- CIRC_REST_RBRD contains the details for each real estate asset.
Records are extracted from each of these tables with the application of the following filters:
- removing deleted and provisional records, and
- removing records that do not have a logical delete date of 31 December 9999.
In the case of CIRD_REST_RDRD, provisionally deleted records are also removed.
2. Episode Generation
The extract from CIRC_REST_RBRD is organised chronologically for each recipient based on the date of event.
The episodes are then generated which can be generalised using the variable assignments in Table 1.
Table 1: Generalisation of Episode Generation Variable Assignments
| Variable | Assignment |
|---|---|
| Person ID | Person ID from extract. |
| Period Start Date | Date of Effect from extract. |
| Period End Date |
If the last row for the recipient and asset:
Otherwise:
|
| Proportion of real estate owned | Proportion of Real Estate Owned from extract divided by 100. |
| Real estate asset balance sheet valuation amount | Real estate asset balance sheet valuation amount from extract divided by 100. |
| House content total amount | House content total amount from extract divided by 100. |
| House curtilage amount | House curtilage amount from extract divided by 100. |
| Livestock total amount | Livestock total amount from extract divided by 100. |
| Real estate market value | Real estate market value from extract divided by 100. |
| Mortgage loan amount | Mortgage loan amount from extract divided by 100. |
| Other asset total amount | Other asset total amount from extract divided by 100. |
| Other deduction amount | Other deduction amount from extract divided by 100. |
| Real estate is client's former principal home indicator. | Real estate is client's former principal home indicator from extract. |
| Real estate asset valuation source code | Real estate asset valuation source code from extract. |
| Real estate identifier | Real estate identifier from extract. |
A row will only be output to the final distribution if any of the dollar amounts are non-zero or the principal home indicator or valuation source code change.
3 Merging RBID Information
The episodes obtained are then merged with the RBID extract through the Person ID and Business Identifier variables. This introduces four new variables to the final distribution:
- Real Estate Type
- Real Estate Description
- Real Estate Property is Principal Home Indicator, and
- Real Estate Property Status.