Definition
Benefit Determination with Zero Payments
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_type | Payment: Benefit type, Code |
The type of Australian government benefit a Welfare recipient receives, as represented by a code. |
String | AAA{A} |
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.