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

det_ben_zero_pay_ext(clone) 0.1

Definition

Zero pay benefit determination history of individual Welfare recipients. The zero pay history describes periods of welfare receipt where individuals had a benefit reduced to zero pay.

Temporal and Spatial Information

Data source details

Datasets This distribution is not linked to any datasets
Format type
Optimized Row Columnar (ORC) or SAS7BDAT

Provenance records

Source distributions

  • Source Distributions
    Release Date No release date supplied
    Generation
Path name Data Element Definition Data Type Format
~.det_ben_zero_pay_ext.ext_dom_person_id 1Person: Age, Years Number UPDATED_DE1_DEFINITION
Lineage details:
  • Logical Path: ~.det_ben_zero_pay_ext.ext_dom_person_id from You dont have permission to view this item
Number -
~.det_ben_zero_pay_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.

 - YYYY-MM-DD
~.det_ben_zero_pay_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.

 - YYYY-MM-DD
~.det_ben_zero_pay_ext.zero_pay_rsn Payment: Benefit Zero Pay Reason, Code

This is the reason the rate went to zero.

 - XXX
~.det_ben_zero_pay_ext.ben_type Payment: Benefit group, Code

A benefit group is one in which a customer can be eligible for only one benefit type in the benefit group at one time. For example, within the Pensions Benefit Group, a customer cannot be concurrently eligible for more than one Pensions benefit type.

 - AAA

Origin

This distribution is sourced from data found in the data warehouse at Services Australia.

Benefit status rows are obtained from the following tables

  • DETM_DETIS_CJDS
  • DETM_DETIS_D3SC
  • DETM_DETIS_DHDS
  • DETM_DETIS_F2DS
  • DETM_DETIS_NSDS
  • DETM_DETIS_P1DS
  • DETM_DETIS_PGDS
  • DETM_DETIS_PNDS
  • DETM_DETIS_YBDS
  • DETM_DETIS_YCDS

Family Tax Benefit rows are obtained from the following tables:

  • DETM_DETIS_FYDS
  • FAAW_FTBR_FYCA_FTBA
  • FAAW_FTBR_FYCA_FTBB

Rent Assistance rows are derived benefit statuses. Rent assistance does not exist as a benefit type code but is derived based on a recipient’s main benefit. Rent assistance data is obtained from the following tables:

  • FADL_DTL_ASDE_RA
  • PNDL_DTL_RAARA
  • NSDL_DED_ASDE_RA
  • PGDL_DED_ASDE_RA
  • SBDL_DEDL_ASDE_RA