Sub122 - Job Seeker Case Load

 

Overview

Sub122 comprises of Job Seeker data.

It captures a snapshot of the state of Job Seeker at the date it was made available through ECSN.

Once a Job Seeker is registered through Centrelink, they will be assigned a Job Seeker ID and start appearing in this file.

When a Job Seeker exits, they would be removed entirely from this subscription 28 days after their exit.

We currently separate 2 instances of imports, one with the Current criteria, and the other with the Exited criteria.

For the Current criteria, we do the following:

  • Check if record exists; if it doesn't, then create it
  • If it exists, check if there has been any changes recorded compared to the previous day's data set
  • If there is any change, then update the record 

For the Exited criteria, we check whether existing Job Seekers from the Current subscription are in the Exited subscription.


If they are, set their status to Exited

The display location is separated into the following:

  • Personal Data
  • ESS Data
  • Key Dates, Alerts, and Info

Job Seeker Show Page

https://{yoursitename}.jobreadylive.com.au/jobseekers/{jobready_id}

image.png

 

Field mapping/display matrix

We obtain these fields from ESS and therefore store the details in JobReady.Live.
If you are unsure if a field is available, you can check the table below.

Field Name

CSV Field Name

 

DescriptionDo we display in JRLive? If so, where?

Extract Date

DATE

Date that the report information was extracted from the source system.

 

Org code

ORG_CODE

Code that identifies the service provider organisation.

 

Org Name

ORG_NAME

Name of the service provider Organisation

 

Site

SITE_CODE

Code that identifies a jobactive site.

ESS Data

Site Name

SITE_NAME

Name of the site providing jobactive services.

ESS Data

Region Code

REGION_CODE

Code that represents the Employment Region for the organisation site.

 

Region Name

REGION_NAME

Name that represents the Employment Region for the organisation site.

 

Contract ID

CONTRACT_ID

The contract ID of the jobactive contract referral.

ESS Data

Job Seeker ID

JOB_SEEKER_ID

The unique identifier assigned to the job seeker at registration.

ESS Data

CRN

CRN

The Centrelink Customer Reference Number (CRN).

ESS Data

Contract Referral Status

CONTRACT_REFERRAL_STATUS_DESC

Indicates if a jobseeker is referred to the jobActive caseload or exited from organisation

 

Contract Referral Date

CONTRACT_REFERRAL_DATE

Date that the job seeker is referred to the service provider for jobActive

 

Contract Referral End Date

CONTRACT_REFERRAL_END_DATE

The actual end date of a contract referral. This field will be blank for current caseload.

 

Contract Referral End Reason

CONTRACT_REFFERAL_END_REASON

The jobactive end reason of a contract referral.  For example: placed in full-time employment, training, no longer requires assistance.

This field will be blank for current caseload

 

Contract Referral Seq Num

CONTRACT_REFEERAL_SEQ_NUM

The sequence number relating to the contract referral.  This number increments based on the job seeker ID and the contract referral date.

ESS Data

Contract Ref Plc Seq Num

CRP_SEQ_NUM

The sequence number relating to the contract referral placement.  This number is incremented based on the job seeker ID, the contract referral date and the contract referral sequence number.

 

Stream Type

STREAM

The stream type  Values will be Stored in the codes:

  • SV (Stream A – Volunteer)
  • SA (Stream A)
  • SB (STREAM B)
  • SC (STREAM C)
  • ND (Stream not determined)
ESS Data

Stream Status

STREAM_STATUS

The contract referral placement status of a job seeker.

  • Commenced (COM)
  • Pending (PND)
  • Suspended (SUS)
  • Transferred (TRN)
  • Exited (EXT)
Job Seeker Index page

Stream Placement Date

STREAM_PLACEMENT_DATE

Date of placement into stream.

Not Displayed

Stream Commencement Date

STREAM_COMMENCEMENT_DATE

The actual start date in stream placement.

Key Dates, Alerts, and Info

Stream End Date

STREAM_END_DATE

The actual end date in stream placement.  This field will be blank for current caseload

 

Time in Stream

TIME_IN_STREAM

Number of weeks a job seeker has been in service (Period of Service) in a particular stream (SV, SA, SB, SC, ND).   When the field is null or blank, it indicates that the job seeker does not have a service clock of this type.

ESS Data

Commenced in Diff Stream

COMMENCED_IN_DIFF_STREAM

The stream in which job seeker is currently Commenced.  When a job seeker has two ‘current’ placements, for example one commenced and one pending, the report's information is only Stored for the pending record.  This field will display the second placement’s commenced stream of job seeker.

 

Transfer from Reason

TRANSFERRED_FROM_SITE_DATE

Code for the reason the job seeker was transferred.  For code description please refer to the Codes and Descriptions section

 

Transferred from Site Date

TRANSFERRED_FROM_SITE_CODE

Date the job seeker was transferred from the previous servicing site.

 

Transferred from Site Code

TRANSFERRED_FROM_SITE_NAME

Code identifying previous servicing site for a job seeker if they were transferred.

 

Transferred from Site Name

TRANSFER_REASON

Site name the job seeker was transferred from.

 

Phase

CURRENT_PHASE

The current phase of job seeker in codes.

  • SSJA (Self Service and Job Activity)
  • WFD (WFD Phase)
  • CM6 (Case Management)
  • CM12 (Case Management)
  • CM6T (Case Management Transitioned at 6 months)

Note:  If the job seeker is exited or transferred this field will be NULL

Not Displayed

Phase Commencement Date

PHASE_COMMENCEMENT_DATE

Date that the job seeker is commenced in their current phase ( Self-service and Job Activity, Case Management, or Work for Dole)

Not Displayed

Phase End Date

PHASE_END_DATE

The actual end date  of the phase placement

Not Displayed

Time in Phase

TIME_IN_PHASE

Number of weeks a job seeker has been in their current phase (Self Service and Job Activity, Case Management, or Work for the Dole)

Not Displayed

AAR Requirement flag

AAR_REQ_FLAG

Flag indicating if the job seeker has an AAR

Not Displayed

AAR Hours Required

AAR_HOURS_REQUIRED

Total Hours required to meet AAR

Not Displayed

WFD Priority Flag

WFD_PRIORITY_FLAG

Flag which indicates the job seeker is in the WfD phase and Work for the Dole is the principal activity to meet their Annual Activity Requirement. —Values: 'Y' or 'N'

Not Displayed

AAR Activity Flag

AAR_ACTIVITY_FLAG

Indicates if a jobseeker is commenced in an approved Annual Activity Requirement (AAR) jobactive activity.

‘Y’ indicates that a job seeker is currently commenced in an AAR activity.

‘N’ or blank indicates that a job seeker is not commenced in an AAR activity.

Not Displayed

AAR Requirement Met flag

AAR_MET_FLAG

Flag indicating if the job seeker has meet the AAR

Not Displayed

Time in Programme

TIME_IN_PROGRAMME

Number of weeks a job seeker has been in the jobactive program.  When the field is null or blank, it indicates that the job seeker does not have a service clock of this type.

Not Displayed

Time with Site

TIME_WITH_SITE

Number of weeks a job seeker has been at a site.  When the field is null or blank, it indicates that the job seeker does not have a service clock of this type.

ESS Data

Time with Provider

TIME_WITH_PROVIDER

Number of weeks a job seeker has been with a provider.   When the field is null or blank it indicates that job seeker doesn't have a service clock of this type

ESS Data

Maximum Time with Provider

MAXIMUM_TIME_WITH_PROVIDER

Number of weeks a job seeker has been in service with their Provider and has remained unemployment.  Note : A job seeker will usually be automatically transferred to another provider where the Maximum time with Provider exceeds two years (stream A) or three years (Stream B and Stream C)

 

UE Registration Date

UE_REGISTRATION_DATE

Date a job seeker registered with Department of Human Services.

Not Displayed

UE Registered Weeks

UE_REGISTERED_WEEKS

Number of whole weeks between the report date and job seekers registration start date.   Populated with *** if the job seeker has exited.

Not Displayed

DHS Registration Site

DHS_REGISTRATION_SITE

Department of Human Services site the job seeker was registered with.

Not Displayed

Job Plan Date

JOB_PLAN_DATE

Date the job seeker signed the Job Plan

Key Dates, Alerts, and Info

Job Plan Status

JOB_PLAN_STATUS

The Job plan status indicates the current processing status of the Job Plan.  
 For code description please refer to the Codes and Descriptions section

ESS Data

Allowance Type Code

ALLOWANCE_TYPE_CODE

Department of Human Service income support payment type made to the job seeker.

ESS Data

Allowance Rate

ALLOWANCE_RATE

The Allowance rate of the job seeker 

ESS Data

Allowance Start Date

ALLOWANCE_START_DATE

Date the job seeker started receiving an allowance.

Not Displayed

Allowance End Date

ALLOWANCE_END_DATE

Date the job seeker stopped receiving an allowance.

Not Displayed

Legal Requirement Code

LEGAL_REQUIREMENT_CODE

Legal requirement code for the selected job seeker

 

Legal Requirement Desc

LEGAL_REQUIREMENT_DESC

Legal requirement description of the code for the selected job seeker.

 

Suspension Reason Code

SUSPENSION_REASON_CODE

The four-letter code that identifies the reason the job seeker is currently suspended.  Where the job seeker has more than one suspension, this reason relates to the maximum end date.

 

Suspension Reason Desc

SUSPENSION_REASON_DESC

This is the description of the reason the job seeker is currently suspended.  Where the job seeker has more than one suspension, this reason relates to the maximum end date.

 

Suspension Expected End Date

SUSPENSION_EXPECTED_END_DATE

The expected end date for the job seekers suspension.  Where the job seeker has more than one suspension, this is the maximum end date.

 

Exemption Type Code

EXEMPTION_TYPE_CODE

Exemption type for activity test or participation requirements.

 

Exemption Expected End Date

EXEMPTION_EXPECTED_END_DATE

Estimated date when the job seeker will no longer be exempt from an activity test or participation requirements.  This date is estimated at the commencement of the exemption.

 

Indigenous Flag

INDIGENOUS_FLAG

Flag indicates if the job seeker is indigenous.

Key Dates, Alerts, and Info

Disability Flag

DISABILITY_FLAG

Flag indicates if the job seeker is disability indicator.  This is either PWD under JSCI or on DSP allowance.

Not Displayed

TRWC Bandwidth

TRWC_BANDWIDTH

Identifies if a job seeker has a Temporary condition that reduces their work capacity and provides the ranged assessed hours a job seeker may work.

 

PWC Bandwidth

PWC_BANDWIDTH

Identifies if a job seeker has a Permanent condition that reduces their work capacity and the provides ranged assessed hours a job seeker may work

 

Homeless Flag

HOMELESS_FLAG

Flag indicates if the job seeker is homeless.

Not Displayed

Mental Illness Flag

MENTAL_ILLNESS_FLAG

Flag indicates if the job seeker has mental illness.

Not Displayed

CALD FLAG

CALD_FLAG

Flag indicating if the job seeker had a non-English speaking background.

Key Dates, Alerts, and Info

Refugee Flag

REF_HUM_VISA_FLAG

Flag indicates if a job seeker is classified as being refugee or humanitarian visa.

Key Dates, Alerts, and Info

Principal Parent Carer Flag

PRINCIPAL_CARER_PARENT_FLAG

Flag indicates if the job seeker is Principal Carer Parent.

Key Dates, Alerts, and Info

Mature Age Flag

MATURE_AGE_FLAG

Flag indicates if the job seeker is mature age.

Key Dates, Alerts, and Info

SPI Flag

SPI_FLAG

Flag indicates if the job seeker is eligible under the stronger participation Incentive (SPI measure).

Not Displayed

ESL Flag

ESL_FLAG

Flag indicating if the job seeker is an early school leaver.

Not Displayed

Vulnerable Youth Flag

VULNERABLE_YOUTH_FLAG

Flag indicating if the job seeker is a vulnerable youth.

Key Dates, Alerts, and Info

Vulnerable Youth Student Flag

VULNERABLE_YOUTH_STUDENT_FLAG

Flag indicating if the job seeker is a vulnerable youth student.

Key Dates, Alerts, and Info

Pre Release Prisoner Flag

PRE_RELEASES_PROSONER_FLAG

Flag indicating if the job seeker is a Pre Release Prisoner.

Not Displayed

Ex-Offender Flag

EX-OFFENDER_FLAG

Flag indicates if the job seeker is ex-offender indicator.

Not Displayed

SAP/LAP Flag

SAP_LAP_FLAG

Structural Adjustment/Labour Adjustment Package Flag.

 

Special Placement Client Type

SPECIAL_PLACEMENT_CLIENT_TYPE

The special placement types for a job seeker.  The codes will be concatenated If job seeker has more than one special placement client types. For code description please refer to the Codes and Descriptions section.

 

Apprentice/ Trainee Flag

APPRENTICE_TRAINEE_FLAG

Flag indicates if the job seeker is an apprentice or trainee.

Displayed

Regional Indicator

REGIONAL_IND

Flag indicates if the job seeker is located in a Regional Location.

Not Displayed

Relocation Assistance flag

RELOCATION_ASSISTANCE_FLAG

Indicates if relocation assistance is required for the job eligibility.

 

Wage Subsidy Type

WAGE_SUBSIDY_TYPE

The wage subsidy agreement type.

Not Displayed

WS Vacancy Eligibility

WS_VACANCY_ELIGIBILITY

This flag indicates whether the job seeker’s vacancy placement is eligible for the wage subsidy.

Not Displayed

WS Agreement ID

WAS_AGREEMENT_ID

The wage subsidy agreement unique identifier.

 

Tasmanian Jobs JS Eligibility

TAS_JOB_JS_ELIG

This flag indicates whether the job seeker is eligible for the Tasmanian Jobs Programme wage subsidy.

 

Tasmanian Jobs Vacancy Eligibility

TAS_JOB_VAC_ELIG

This flag indicates whether the job seeker’s vacancy placement is eligible for the Tasmanian Jobs Programme wage subsidy.

 

Tasmanian Jobs Agreement ID

TAS_JOB_AGREE_ID

The Tasmanian Jobs Programme wage subsidy agreement unique identifier.

 

NEIS Flag

NEIS_FLAG

Indicates if a job seeker is commenced in NEIS training or commenced in the NEIS business program.

Not Displayed

Initial Interview Flag

INITIAL_INTERVIEW_FLAG

Flag indicating if the job seeker has had their first interview.

Not Displayed

Resume Completed Date

RESUME_COMPLETED_DATE

Date the job seeker's resume was completed.

Not Displayed

Resume Last Update Date

RESUME_LAST_UPDATE_DATE

Date job seeker resume was last updated.

Key Dates, Alerts, and Info

Last Diary Appointment Type

LAST_DIARY_APPT_TYPE

Last appointment type.  Stored values: IEP5(EPS Initial) or CEP5 (EPS Contact).

 

Last Diary Appointment Reason

LAST_DIARY_APPT_REASON

Last dairy appointment reason.  For Code descriptions please refer to the codes and Description Section.

 

Last Diary Appointment Date

LAST_DIARY_APPT_DATE

Job seeker’s last diary appointment date.

 

Last Diary Appointment  Consultant

LAST_DIARY_CONSULTANT

Job seeker’s last diary appointment consultant‘s name.

 

Last Diary Appointment Result

LAST_DIARY_RESULT

Latest appointment result.  For Code descriptions please refer to the codes and Description Section

 

Next Diary Appointment Type

NEXT_DIARY_APPT_ TYPE

Job seeker’s next diary appointment session type.  Stored values:  IEP5(EPS Initial) or CEP5 (EPS Contact).

ESS Data

Next Diary Appointment Reason

NEXT_DIARY_APPT_REASON

Next diary appointment reason.  For Code descriptions please refer to the codes and Description Section.

 

Next Diary Appointment Date

NEXT_DIARY_APPT_DATE

Job seeker’s next diary appointment date.

 

Next Diary Appointment Consultant

NEXT_DIARY_CONSULTANT

The job seeker's next diary appointment assigned consultant’s name.

 

Last Compliance Report - Code

LAST_COMPL_REPT_CODE

Code that Centrelink assigned to a job seeker last compliance report.

 

Last Compliance Report - Compliance Type

LAST_COMPL_RPT_TYPE

Description of the last compliance report type.

 

Last Compliance Report - Outcome Description

LAST_COMPL_RPT_OUTCOME_DESC

Full description of the outcome from the job seekers last compliance report.

 

Last Compliance Report - Outcome Reason

LAST_COMPL_RPT_OUTCOME_REASON

Description of the outcome reason for job seeker’s last compliance report.

 

Last Compliance Report - Penalty From Date

LAST_COMPL_RPT_PEN_FROM_DATE

Start date for any penalty applied to the job seeker for non-compliance.

 

Last Compliance Report - Penalty To Date

LAST_COMPL_RPT_PEN_TO_DATE

End date for any penalty applied to the job seeker for non-compliance.

 

Last Compliance Report - Outcome Date

LAST_COMPL_RPT_OUTCOME_DATE

Date of the outcome of the job seeker's last compliance report.

 

Last Job Placement - Vacancy ID

LAST_JOB_PLC_VAC_ID

Job identifier of the vacancy the job seeker is referred to.

 

Last Job Placement - Vacancy Seq No

LAST_JOB_PLC_VAC_SEQ_NO

Sequence number of the last job placement.

 

Last Job Placement - Employer

LAST_JOB_PLC_EMP

Name of the employer for the job.

 

Last Job Placement - Type

LAST_JOB_PLC_TYPE

Type of job the job seeker is referred to.  For example, government, apprenticeship.

 

Last Job Placement - Date

LAST_JOB_PLC_DATE

Date the job seeker was placed in a job.

 

Last Job Placement  - Work Type

LAST_JOB_PLC_WORK_TYPE

Work type of the job referral. For example, full time, part time, casual.

 

Last Job Placement -Referral Outcome

LAST_JOB_PLC_REFERRAL_OUTCOME

Result of the job referral. For example: employer closure not placed.

 

Last Job Placement - Found Own Employment Indicator

LAST_JOB_PLC_FOE_INDICATOR

Flag indicating if the job seeker found his or her own employment.

 

Last Job Placement - Job Placement Interim Payment Date

LAST_JOB_PLC_INTERIM_PAYMENT_DATE

Date 4 weeks after the job referral result date if the job seeker had a placement.

 

Title

TITLE

Job seeker title.  Populated with a * if the job seeker has exited

Page Header

First Given Name

FIRST_NAME

First given name of the job seeker.  Populated with * if job seeker has exited.

Page Header

Second Given Name

SECOND_NAME

Second or middle name of the job seeker.  Populated with * if job seeker has exited.

Page Header

Family Name

FAMILY_NAME

The family name of the job seeker.  Populated with * if job seeker has exited.

Page Header

Gender

GENDER

Code for job seeker gender.  Codes are: M - Male, F - Female or U – Unknown.  Gender is replaced with a '*' when a job seeker is on a provider's exited caseload.

Not Displayed

Date of Birth

DATE_OF_BIRTH

Job seeker's date of birth.  Date of birth is replaced with a '*' when a job seeker is on a provider's exited caseload.

ESS Data

Age at Extract

AGE_AT_EXTRACT

Job seeker's age at the report date.  Age of extract is replaced with a '*' when a job seeker is on a provider's exited caseload.

 

Postal Address

POSTAL_ADDRESS

Postal street address of the job seeker.  If the job seeker is a sensitive client then ‘*’ will be Stored.  Postal address is replaced with a '*' when a job seeker is on a provider's exited caseload.

Not Displayed

Postal Suburb

POSTAL_SUBURB

Postal suburb of the job seeker.  If the job seeker is a sensitive client then ‘*’ will be Stored.  Postal suburb is replaced with a '*' when a  job seeker is on a provider's exited caseload.

Not Displayed

Postal State

POSTAL_STATE

Postal state of the job seeker.  If the job seeker is a sensitive client then ‘*’ will be Stored.  Postal state is replaced with a '*' when a  job seeker is on a provider's exited caseload.

Not Displayed

Postal Postcode

POSTAL_POSTCODE

Postal postcode of the job seeker.  If the job seeker is a sensitive client then ‘*’ will be Stored.  Postal postcode is replaced with a '*' when a job seeker is on a provider's exited caseload.

Not Displayed

Residential Address

RESIDENTIAL_ADDRESS

Residential street address of the job seeker.  If the job seeker is a sensitive client then ‘*’ will be Stored.  Residential address is replaced with a '*' when a job seeker is on a provider's exited caseload.

Personal Data

Residential Suburb

RESIDENTIAL_SUBURB

Residential suburb of the job seeker.  If the job seeker is a sensitive client then ‘*’ will be Stored.  Residential suburb is replaced with a '*' when a job seeker is on a provider's exited caseload.

Personal Data

Residential State

RESIDENTIAL_STATE

Residential state of the job seeker.  If the job seeker is a sensitive client then ‘*’ will be Stored.  Residential State is replaced with a '*' when a job seeker is on a provider's exited caseload.

Personal Data

Residential Postcode

RESIDENTIAL_POSTCODE

Residential postcode of the job seeker.  If the job seeker is a sensitive client then ‘*’ will be Stored.  Residential postcode is replaced with a '*' when a job seeker is on a provider's exited caseload.

Personal Data

Preferred Phone Type

PREFERRED_PHONE_TYPE

Job seekers preferred contact method

 

Home Phone No

HOME_PHONE_NO

Home phone number for the job seeker (including area code).  If the job seeker is a sensitive client then ‘*’ will be Stored.  Home phone number is replaced with a '*' when a job seeker is on a provider's exited caseload.

Personal Data

Home Fax No

HOME_FAX_NO

Fax number for the job seeker (including area code).  If the job seeker is a sensitive client then ‘*’ will be Stored.  Home fax number.  is replaced with a '*' when a job seeker is on a provider's exited caseload.

Not Displayed

Mobile Phone No

MOBILE_PHONE_NO

Mobile phone number for the job seeker.  If the job seeker is a sensitive client then ‘*’ will be Stored.  Mobile phone number.  is replaced with a '*' when a job seeker is on a provider's exited caseload.

Personal Data

Email Address

EMAIL_ADDRESS

Email address nominated by the job seeker for contact.  If the job seeker is a sensitive client then ‘*’ will be Stored.  Email address is replaced with a '*' when a job seeker is on a provider's exited caseload.

Personal Data

Age of youngest child

AGE_YOUNGEST_CHILD

Age of jobseeker’s youngest child.

 

Interpreter Lang Code

INTERPRETER_LANG_CODE

Code for the interpreter language required by the job seeker.

 

Interpreter Lang

INTERPRETER_LANG

Interpreter language required by the job seeker.  Populated with * if the job seeker has exited.

Key Dates, Alerts, and Info

and

Personal Data

Birth Country Code

BIRTH_COUNTRY_CODE

Code for the country in which the job seeker was born.  Populated with * if the job seeker has exited.

Not Displayed

Birth Country

BIRTH_COUNTRY

Country in which the job seeker was born.  Populated with * if the job seeker has exited.

Not Displayed

Licence Type Code

LICENCE_TYPE_CODE

Code for the current type of driver’s license held by the job seeker.  Populated with * if the job seeker has exited.

Not Displayed

Licence Type

LICENCE_TYPE

Current type of driver’s license held by the job seeker.  Populated with * if the job seeker has exited.

Not Displayed

ESAt/JCA Status

ESAT_JCA_STATUS

Status of the most recent Submitted or Finalised Employment Services Assessment (ESAt) / Job Capacity Assessment (JCA).

 

ESAt/JCA Status Date

ESAT_JCA_STATUS_DATE

Date of the most recent Submitted or Finalised Employment Services Assessment (ESAt) / Job Capacity Assessment (JCA) status.

 

ESAt /JCA Recommended Referral 1

ESAT_JCA_RECOMMENDED_REFERRAL_1

Servicing referral recommended by the Employment Services Assessment (ESAt) / Job Capacity Assessment (JCA).  If the JCA status code is Unable To Complete (UNTC) then ‘*’ will be Stored.

 

ESAt / JCA Recommended Referral 2

ESAT_JCA_RECOMMENDED_REFERRAL_2

Other services recommended by the Employment Services Assessment (ESAt) / Job Capacity Assessment (JCA).  If the JCA status code is Unable To Complete (UNTC) then ‘*’ will be Stored.

 

ESAt / JCA Expiry Date

ESAT_JCA_EXPIRY_DATE

The expiry date of the Employment Services Assessment (ESAt) / Job Capacity Assessment (JCA).  If the JCA status code is Unable To Complete (UNTC) then ‘*’ will be Stored.

 

ESAt / JCA TRWC 1 Start Date

ESAT_JCA_TRWC_1_START_DATE

Start date of the temporary work capacity hours of a job seeker.  If the ESAt /JCA status code is Unable To Complete (UNTC) then ‘*’ will be Stored.

 

ESAt / JCA TRWC 1 End Date

ESAT_JCA_TRWC_1_END_DATE

End date of the temporary work capacity hours of a job seeker.  If the ESAt / JCA status code is Unable To Complete (UNTC) then ‘*’ will be Stored.

 

ESAt / JCA CWC Hrs

ESAT_JCA_CWC_HRS

Impact of permanent conditions on a client's current (baseline) work capacity hours.  If the ESAt / JCA status code is Unable To Complete (UNTC) then ‘*’ will be Stored.

 

ESAt / JCA FWC Mainstream Intervention Hrs

ESAT_JCA_FWC_MAIN_INTERV_HRS

Impact of permanent conditions on a client's future work capacity hours within two years with mainstream intervention.  If the ESAt / JCA status code is Unable To Complete (UNTC) then ‘*’ will be Stored.

 

ESAt / JCA FWC Intervention Hrs

ESAT_JCA_FWC_INTERV_HRS

Impact of permanent conditions on a client's future work capacity hours within two years with intervention. If the ESAt / JCA status code is Unable To Complete (UNTC) then ‘*’ will be Stored.

 

JSCI Assessment Date

JSCI_LAST_UPDATE_DATE

Most recent date the JSCI assessment was updated.

Not Displayed

JSCI Creation User ID

JSCI_LAST_CREATION_USER_ID

User ID that created the most recent JSCI assessment.

 

JSCI Status

JSCI_STATUS

Status of the assessment.  e.g.  Active, Pending or Inactive.

Not Displayed

JSCI Highest Education

JSCI_HIGHEST_ED

Highest level of education attained by the   job seeker on their JSCI assessment.

 

Managed By

MANAGED_BY

Logon ID of the person case managing the job seeker.

Not Displayed

Group By

GROUP_BY

A free text field to allow adding a note to a record and to allow grouping of records on a caseload.  (Initially, this field will be used to store any data removed from the Managed By field in a data clean-up.)

 

Client Note

CLIENT_NOTE

A free text field to allow adding a note to a record and to allow grouping of records on a caseload.

 

Special Requirements

SPECIAL_REQUIREMENTS

The special requirements to manage the job seeker.

 

Transition Code

TRANSITION_CODE

The code used for jobactive transition. The values will be either ES15 or VT15.

 

Ever Commenced

EVER_COMMENCED

Indicates if Job seeker has ever commenced in jobactive from
 1 July 2015.

 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.