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.
Access to the submission and reporting systems is through the Okta Portal.
Access to the 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.
New users seeking access to the submission and reporting systems should complete the Workforce Profile collection access form (XLSX 82KB) 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 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 departments 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 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 the Workforce Information team.