Skip to content Learn about the access keys available for Metadata Registry

ast_bus_beta_ext 0.2

Definition

This distribution (AST_BUS) contains a longitudinal history of reported assets that relate to businesses.

Data source details

Format type
Optimized Row Columnar (ORC) or SAS7BDAT
Path name Data Element Definition Data Type Format
~.ast_bus_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_bus_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_bus_beta_ext.bus_type Asset: Business type, Code

The type of business entity or asset owned or co-owned by the client.

 String AAA
~.ast_bus_beta_ext.bus_prncpl_hom Asset: Business property is principal home, Code

This field indicates that this property is the principal home.

 Boolean A
~.ast_bus_beta_ext.bus_prop_sts Asset: Business property status, Code

The business property status code.

 String AAA
~.ast_bus_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_bus_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_bus_beta_ext.bus_asset_own_pc Asset: business asset ownership amount, Percentage

The proportion of a business asset amount owned by an entity.

 Number NNN.NN
~.ast_bus_beta_ext.bus_bal_sheet_valn_amt Asset: Business valuation amount, Total Australian currency

The asset value of the business from the balance sheet or other documentation provided by the recipient to support the business valuation.

 Decimal N[9].NN
~.ast_bus_beta_ext.bus_lblty_tot_amt Asset: Business liabilities amount, Total Australian currency

The value of the total business liabilities from the balance sheet or other documentation provided by the client to support the business valuation. Total amount is deducted from the 'Total Assets from the Balance Sheet' value when calculating the Net Market Value.

 Decimal N[9].NN
~.ast_bus_beta_ext.bus_net_asset_amt Asset: Business net asset amount, Total Australian currency

Net business assets for client and partner.

 Decimal N[9].NN
~.ast_bus_beta_ext.bus_valn_src_code Asset: Business valuation, Code

The valuation source of the business asset.

 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_RBBD contains the details for each reported business.

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_REST_RBBD 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:

  • 31.12.9999

Otherwise:

  • the day before the date of event of the subsequent row.
Business Asset Ownership Amount Business Asset Ownership Amount
Business Valuation Amount Business Valuation Amount from the extract divided by 100.
Business Liabilities Amount Business Liabilities Amount from the extract divided by 100.
Business Net Asset Amount Business Net Asset Amount from the extract divided by 100.
Business Valuation Source Business Valuation Source from the extract.
Business Identifier Business Identifier from extract.

 

A row will only be output to the final distribution if:

  • it contains a non-zero amount for Non-Primary Product Asset Amount or Primary Product Asset Amount, or
  • there has been a change in the Non-Primary Product Asset Amount or Primary Product Asset Amount.

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:

  • Business Type
  • Business Asset Description
  • Business Property is Principal Home Indicator, and
  • Business Property Status.