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.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| ~.t_det_ben_zero_pay.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. |
Number | N[15] |
| ~.t_det_ben_zero_pay.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 |
| ~.t_det_ben_zero_pay.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 |
| ~.t_det_ben_zero_pay.zero_pay_rsn | Payment: Benefit Zero Pay Reason, Code |
This is the reason the rate went to zero. |
String | XXX |
| ~.t_det_ben_zero_pay.ben_grp_code | 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. |
String | 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
Custom Fields
The period end date should be treated as inclusive when determining information validity where the end date represents the date of record status change. For example, event window covers [period_start_date, period_end_date] and selecting a sample date should be of the form period_start_date ≤ sample date ≤ period_end_date.
The deceased indicator highlights individuals who are deceased at the date of extraction. This is applied to all past benefit records for a deceased individual.