Definition
Benefit Determination with Zero Payments
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| ~.det_ben_zero_pay_ext.synthetic_aeuid | 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] |
| ~.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. |
Date | 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. |
Date | 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. |
String | XXX |
| ~.det_ben_zero_pay_ext.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