ast_tac_beta_ext 0.2
Definition
This distribution (AST_TAC) contains a longitudinal history of reported assets that relate to trusts and company.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| ~.ast_tac_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_tac_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_tac_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_tac_beta_ext.tac_non_prmy_prdct_asset_amt | Asset: Trust and company non-primary product asset amount, Total Australian currency |
This element is used to record non-primary production assets attributed from the other trust/company. |
Decimal | N[9].NN |
| ~.ast_tac_beta_ext.tac_prmy_prdct_asset_amt | Asset: Trust and company primary product asset amount, Total Australian currency |
This element can be used to record primary production assets attributed from the other trust/company. |
Decimal | N[9].NN |
Origin
1 Extraction
The data for this distribution is extracted from the data warehouse at Services Australia. All information is sourced from the CIRD_TMISC_TRCAS table.
Records are extracted from this table 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 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:
|
| Non-Primary Product Asset Amount | Non-Primary Product Asset Amount from extract divided by 100. |
| Primary Product Asset Amount | Primary Product Asset Amount from extract divided by 100. |
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.