Definition
The Outcomes table provides data on outcome payments for Workforce Australia Services (Provider Services), Workforce Australia Broome Employment Services (Broome Services), and Workforce Australia Transition to Work (TtW) participants.
The Outcomes tables provide a range of information on outcome payments administered by the department from 1 July 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 |