Workforce Information Collection Process
Access to the Workforce Information Warehouse (WIW)
Access to the Workforce Information Warehouse (WIW) is available only to authorised officers for submission, reporting and analysis.
From 2019, access to the submission and reporting systems will be through the Okta Portal.
Authorised users will access the workforce profile submission and reporting systems by clicking on the applicable icons located on the home page in the Okta portal.
Access to the C3 data submission system is through the Workforce Data Submissions (C3) icon.
All submitter reports, approver reports and diversity reports are accessed through the Workforce Data Reporting (SSRS) icon.
Access is being established for all existing authorised users and they will receive an email confirming when their applications are available to them through the Okta Portal.
New users seeking access to the submission and reporting systems should complete the Workforce Profile collection access form (XLSX 71.5KB) and return this to firstname.lastname@example.org.
View the Workforce Profile Collection Overview
Submitting data to the Workforce Information Warehouse
The online interface for the Workforce Information Warehouse (WIW) allows the PSC to maintain validations centrally. Agencies with subsidiary divisions can choose how to break up data with separate submitters and approvers.
The required method of submission to WIW is to load a CSV (comma separated values) file onto a web based platform, which performs online validations and approvals. The specification for the CSV file is simply the Data Specifications document as published, but to assist agencies a simple example is available to download within the WIW Submission module itself.
Other key points when creating the CSV file are:
- The file must be UTF-8 compliant
- The file must be comma delimited
- Values should not be enclosed in quotes
- Trailing spaces should be removed from fields
- There must be one header row
About being a submitter or approver
The WIW provides workflow that ensures agencies have access to reports and approval tools to review and verify the accuracy of submitted data online before it is passed to PSC analysts. PSC relies on clusters and agencies to manage their internal approval and submission processes. Approvers will receive an email link to access their report via the Okta portal.
This report provides the option to approve or reject each submission. The accuracy and quality of workforce data is vital for workforce reporting and for the State of the NSW Public Sector Report, so approvers must be prepared to verify and sign off the information submitted on behalf of their agency or cluster.
For further information on the collection process please call or email Analytics Services.