ast_oth_beta_ext 0.2
Definition
This distribution (AST_OTH) contains a longitudinal history of reported assets from non-specified classes.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| ~.ast_oth_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_oth_beta_ext.aeid_id | Asset: Other asset item identifier, ID Number | This is a numeric identifier used to identify the other asset item within a record. This ID links the AEID and AEDT groups. As each new asset is added, the new id is calculated by adding 1 to the AEID.ID currently stored in occurrence 1. | Number | N[N] |
| ~.ast_oth_beta_ext.oth_type | Asset: Other asset type, Code | Other asset type codes for clients and partners. | String | AAA |
| ~.ast_oth_beta_ext.oth_prmy_prdct | Asset: Other primary product assets, Code | Indicates whether client has other primary production assets. | Boolean | A |
| ~.ast_oth_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_oth_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_oth_beta_ext.oth_own_pc | Asset: Other asset owned, Percentage | Percentage of other asset owned. | Number | NNN.NN |
| ~.ast_oth_beta_ext.oth_rural_exempt_code | Asset: Other asset rural exemption, Code | Used to ensure that assets and deemed income from assets that should be exempt for rural processing can be recorded on the system and identified as an exempt asset and/or deemed income from assets. | String | AAA |
| ~.ast_oth_beta_ext.oth_tot_asset_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_oth_beta_ext.oth_valn_src_code | Asset: Other asset valuation, Code | Valuation code for other assets owned by clients and partners. | String | AAA |
Origin
1 Extraction
The data for this distribution is extracted from the data warehouse at Services Australia. The source tables are detailed below.
- CIRC_ASSETS_AEID uniquely identifies the asset.
- CIRC_ASSETS_AEDT records changes to asset values and ownership.
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.
2. Episode Generation
The extract from CIRC_ASSETS_AEDT 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:
|
| Percentage of asset owned | Percentage of asset owned from extract divided by 100. |
| Rural exemption code | Rural exemption code from extract. |
| Asset total amount | Asset total amount from extract divided by 100. |
| Asset valuation source code | Asset valuation source code from extract. |
3 Merging AEID Information
The episodes obtained are then merged with the AEID extract through the Person ID and Asset Identifier variables. This introduces four new variables to the final distribution:
- Asset Type
- Asset Description
- Primary Production Asset Indicator