Definition
The Outcomes table provides data on outcome payments for jobactive participants.
The Outcomes tables provide a range of information on outcome payments administered by the department from 1 July 2015 to 30 June 2022.
Data source details
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| dbo.t_Outcomes.DataAsAt | System: Data As At, Date | Date the information was extracted from the source system. | Date | YYYY-MM-DD |
| dbo.t_Outcomes.PLIDAId | Participant: PLIDA Id, Unique Identification Number |
Unique identifier assigned to the participant by the Employment Services System at registration, represented as a number. |
Integer | N[15] |
| dbo.t_Outcomes.POAId | Contract Referral Placements: Period of Assistance Id, Identifier |
An identifier for the Period of Assistance that a given Contract Referral Placement relates to, represented by a number. |
Integer | N[50] |
| dbo.t_Outcomes.CharacteristicsLinkageKey | Outcome: Characteristics Linkage Key, Linkage Key |
Linkage key used to join to Participant Characteristics table to source characteristics at Outcome Payment Start Date. |
VarChar | X[100] |
| dbo.t_Outcomes.PaymentId | Outcome: Payment Id, Identifier |
A numeric identifier that uniquely links a payment transaction to a specific Outcome achieved by a Participant within Workforce Australia Services. |
Integer | X[50] |
| dbo.t_Outcomes.PaymentSequenceNumber | Outcome: Payment Sequence, Number |
Values representing the chronological order of payment transactions associated with a Participant or service event within Workforce Australia Services. |
Integer | X[20] |
| dbo.t_Outcomes.ProgramTypeCode | Outcome: Program Type, Code |
Code that identifies the program type of the provider site related to the outcome payment. |
VarChar | AAA[N] |
| dbo.t_Outcomes.ProgramTypeDesc | Outcome: Program Type Description, Text |
The description of the program type of the provider site related to the outcome payment. |
VarChar | X[500] |
| dbo.t_Outcomes.ContractReferralPlacementId | Contract Referral Placement: ID, Identifier |
A unique identifier assigned to a specific instance where a participant engages in a service relationship with a provider’s site under a contract referral arrangement within a defined employment region, represented as a number. |
Integer | N[8] |
| dbo.t_Outcomes.VacancyReferralId | Outcome: Vacancy Referral Id, Identifier |
Unique identifier of the vacancy referral associated with the outcome payment. |
Integer | X[10] |
| dbo.t_Outcomes.OutcomePeriodTypeCode | Outcome: Outcome Period Type, Code |
A classification that specifies the type and duration over which a Participant’s employment outcome is assessed. |
VarChar | X[10] |
| dbo.t_Outcomes.OutcomePeriodTypeDesc | Outcome: Outcome Period Type Description, Text |
A classification that describes the type and duration over which a Participant’s employment outcome is assessed. |
VarChar | X[500] |
| dbo.t_Outcomes.PaymentGroup1 | Outcome: Payment Group 1, Code |
Specifies the Level 1 Grouping payment group associated with an employment outcome. |
VarChar | A[50] |
| dbo.t_Outcomes.PaymentGroup2 | Outcome: Payment Group 2, Code |
Specifies the Level 2 Grouping payment group associated with an employment outcome. |
VarChar | X[100] |
| dbo.t_Outcomes.PaymentCreationDate | Outcome: Payment Creation, Date |
An event representing the system-triggered generation of a payment record linked to an employment outcome, represented as a date. |
Date | YYYY-MM-DD |
| dbo.t_Outcomes.OutcomePaymentStartDate | Outcome: Outcome Payment Start, Date |
The start date of the payment tracking period for an employment outcome. |
Date | YYYY-MM-DD |
| dbo.t_Outcomes.OutcomePaymentEndDate | Outcome: Outcome Payment End, Date |
The end date of the payment tracking period for an employment outcome. |
Date | YYYY-MM-DD |
| dbo.t_Outcomes.OutcomePaymentAvailableDate | Outcome: Outcome Payment Available, Date |
The date the outcome payment became or will become available in the future. |
Date | YYYY-MM-DD |