Definition
The Workforce Profile is a data collection on the characteristics of the NSW public sector workforce. It includes demographic information such as age, gender, diversity group membership and work location; as well as employment information such as hours worked, leave patterns, remuneration and mobility within the sector. Workforce Profile data has been collected annually since 1999. An essential component of the Workforce Profile Collection is the standardisation of Full Time Equivalent (FTE). Standardising the methodology using information collected from an agency’s HR system enables comparative analysis across the Public Sector.
All government sector agencies, including State Owned Corporations (SOCs) are required to participate in the Workforce Profile Collections. Agencies external to the government sector are also encouraged to participate. The benefits of a whole-of-sector data collection are significant in providing a complete picture of the public sector. Sections 16 and 63 of the Government Sector Employment Act provide the Public Service Commissioner with the lawful basis to collect workforce profile data
Data source details
Path name | Data Element | Definition | Data Type | Format |
---|---|---|---|---|
AGED_M_End_Dt | Record: DateTime Stamp, YYYY-MM-DD |
A sequence of characters or encoded information identifying when a certain event occurred, on what day, and optionally including what particular time of day. |
DATETIME | YYYY-MM-DD(T00:00:00) |
DIVISION | You don't have permission to see this Data Element. | - | - | - |
1a_Unique_Identifier | You don't have permission to see this Data Element. |
-
Specific Information:
The unique identifier is to be maintained from one collection period to the next. |
- | - |
1b_Date_of_Birth | You don't have permission to see this Data Element. |
-
Specific Information:
The age structure of the NSW Public Sector is monitored to determine the impact of the ageing population and workforce. The information is used for workforce planning and Workforce Profile Reports. |
- | - |
1c_Gender | You don't have permission to see this Data Element. |
-
Specific Information:
Gender provides a measure of changing gender participation in the NSW public sector. Also, a key workforce diversity indicator. Information is used extensively in workforce planning and Workforce Profile Reports |
- | - |
1d_Work_Location_Postcode | Organisation: Australian Postcode, code (Postcode datafile) NNNN |
The Australian numeric descriptor for a postal delivery area for an organisation's address.
Specific Information:
The postcode of the employee’s actual work location (or depot for field staff), not Post Box location. This item relates to the location of the employee’s position that was current at the census date. |
NUMBERSTRING | NNNN |
1e_Home_Location_Postcode | You don't have permission to see this Data Element. |
-
Specific Information:
The postcode of the employee’s actual home location, not Post Box location. This item relates to the location of the employee’s residence that was current at the census date. |
- | - |
1f_GEN | You don't have permission to see this Data Element. |
-
Specific Information:
Used to track mobility through the government sector at the individual level, enabling analysis over time. |
- | - |
1g_Work_Location_Suburb | Organisation: Suburb/town/locality name, text X(46) |
The full name of the general locality containing the specific address of an organisation that provides services and/or care, recorded as a combination of alphanumeric characters.
Specific Information:
The suburb of the employee’s actual work location (or depot for field staff), not Post Box location. This item relates to the location of the employee’s position that was current at the census date. |
CHARACTERSTRING | X(46) |
1h_Home_Location_Suburb | You don't have permission to see this Data Element. |
-
Specific Information:
The suburb of the employee’s actual home location, not Post Box location. This item relates to the location of the employee’s residence that was current at the census date. |
- | - |
2a_Aboriginal_or_Torres_Strait_Islander | You don't have permission to see this Data Element. |
-
Specific Information:
Used for statutory Workforce Diversity report. |
- | - |
2b_Person_with_a_Disability | You don't have permission to see this Data Element. |
-
Specific Information:
Disability includes long-term physical, mental health, intellectual, neurological, or sensory differences which, in interaction with various attitudinal and environmental barriers, may hinder full and effective participation in society on an equal basis with others. For any employee identifying as having a disability, indicate whether some aspect of the work situation requires adjustment in order to accommodate their needs.
|
- | - |
2c_Person_from_a_Minority_Group | You don't have permission to see this Data Element. |
-
Specific Information:
A person who identifies as belonging to a designated Workforce Diversity group consisting of people who are members of a minority group in Australian society by virtue of their racial, ethnic, or ethno-religious background. |
- | - |
2d_Language_First_Spoken | You don't have permission to see this Data Element. |
-
Specific Information:
NOTE: For the purposes of Workforce Diversity data collection, a person who first spoke both English and another language is to be coded as ‘2’ (=Other Language). |
- | - |
2e_Highest_Education_Level | You don't have permission to see this Data Element. |
-
Specific Information:
Will be used to analyse the educational diversity of the NSW public sector workforce. Education qualifications at these broad levels are used in order to be able to compare NSW with ABS data and other state jurisdictions. These levels are also used in the People Matter surveys (PMES) and data from this item will be used as a cross reference with PMES data. |
- | - |
2f_Country_of_Birth | You don't have permission to see this Data Element. |
-
Specific Information:
Will be used to better analyse the diversity of the NSW public sector workforce. |
- | - |
3_Employing_Legislation_Identifier | You don't have permission to see this Data Element. |
-
Specific Information:
Provides a legislative profile for NSW Public Sector. Employing Legislation identifies which service the employee belongs to, i.e., public service, teaching service, police force, health service, transport service, other crown services, state owned corporations, external to the government sector. Where changes in employment legislation have occurred during the reference period, please use the most up to date version. |
- | - |
3a_Award_determining_Salary_Rate | You don't have permission to see this Data Element. |
-
Specific Information:
Reason for collection Codification: A full list of codes can be found in the ‘Reference list’ document on the following webpage: Federal enterprise agreements use the same codes provided by the Federal Industrial Relations Registry. Code preceded by the letter’s ‘AG’. For example, AG818106. For determinations, the number of the Determination and the year in which it was set down are used. The Determination is abbreviated for coding purposes, (eg. Determination No. 56 of 1983 becomes D5683). Award code 385 should not be used, as it represents a broad agreement that varies salaries across numerous awards. Using 385 will result in an error code when submitting a return.
|
- | - |
3b_Award_determining_Conditions_of_Employment | You don't have permission to see this Data Element. |
-
Specific Information:
Reason for collection - Analysis / Reporting: Provides a profile for NSW Public Sector. Used for restructuring/planning /forecasting/costing. Used by NSW Industrial Relations during award negotiations. This response should not used for state awards or agreements relating to single conditions of employment. Agency or occupation specific award or agreements that cover some conditions (and could be seen as supplementary to the award nominated here) can be entered in item 3c. Codification: A full list of codes can be found in the ‘Reference list’ document on the following webpage: Federal enterprise agreements use the same codes provided by the Federal Industrial Relations Registry. Code preceded by the letter’s ‘AG’. For example, AG818106. For determinations, the number of the Determination and the year in which it was set down are used. The Determination is abbreviated for coding purposes, (eg. Determination No. 56 of 1983 becomes D5683). Award code 385 should not be used, as it represents a broad agreement that varies salaries across numerous awards. Using 385 will result in an error code when submitting a return. |
- | - |
3c_Agency_or_Occupation_Specific_Award | You don't have permission to see this Data Element. |
-
Specific Information:
Reason for collection - Analysis/Reporting: Provides a profile for NSW Public Sector. Used for restructuring/planning Typically, this would be agency or occupation specific but may include special determinations and/or memorandums of understanding. This Award or Agreement is supplementary to the Award or Agreement nominated at item 3b. Codification: A full list of codes can be found in the ‘Reference list’ document on the following webpage: -8888 = Not Applicable (employees with no relevant agency or occupation specific award).
|
- | - |
3d_Usual_Hours_Worked | You don't have permission to see this Data Element. |
-
Specific Information:
Current at census date (i.e., last known usual hours worked). Most employees are contracted to work either 35 or 38 hours per week. Reason for collection - Analysis / Reporting: Used to determine full-time/part-time employment arrangements. NOTE: Please make a pro-rata adjustment to generate weekly hours for employees working on a nine-day fortnight or other non-weekly basis. |
- | - |
3e_Total_Number_of_Hours_Paid_Reference_Period | You don't have permission to see this Data Element. |
-
Specific Information:
The total actual number of paid hours that were actually worked by an employee during the reference period. This includes purchased leave. Unpaid leave, overtime, workers paid by a third party and additional hours worked under flex time are excluded from this item. Reason for collection Codification: |
- | - |
3f_Overtime_Hours | You don't have permission to see this Data Element. |
-
Specific Information:
This is the actual number of hours of overtime worked, not their pay equivalent, such as time and a half, double time etc. Exclude overtime taken as time off in lieu. Reason for collection - Analysis / Reporting: Indicator of additional employee workload. Link with employee related expenses. |
- | - |
3g_Employment_Category | You don't have permission to see this Data Element. |
-
Specific Information:
NOTE: This refers to the employee’s status as an employee of the agency regardless of the specific position they occupy or the legislation under which they were employed. See 3.11 in Definitions for advice on employees acting in executive roles under category 18 and 19. Reason for collection - Analysis / Reporting: Employment Category provides an indication of the flexibility and structure of the NSW Public Sector. This information is essential for workforce management and planning. Comparative profiles of the workforce appointment type can be developed using information from other State and Commonwealth Governments. |
- | - |
3h_Census_Date_Status | You don't have permission to see this Data Element. |
-
Specific Information:
This item relates to the employment status for an employee in the position that was current as at the census date. The census date is the last pay day of the collection period. Reason for collection - Data Management: Used to determine the ‘census date population’, i.e., a snapshot of the NSW Public Sector workforce on the census date and to validate other data items in the collection.
|
- | - |
3i_Total_Hours_Paid_in_Census_Pay_Period | You don't have permission to see this Data Element. |
-
Specific Information:
The total actual number of paid hours that were worked by an employee for the last fortnightly pay period in a reference period. This item includes paid leave and purchased leave. Reason for collection - Data Management: Used to calculate the Census fulltime equivalent (FTE) per employee. FTE is a standardised way to describing the size of the workforce and allows comparisons between various groups to be more accurately interpreted. FTE is more generally used for budgeting purposes rather than headcount. NOTE: Please make a pro-rata adjustment to generate weekly hours for employees working on a nine-day fortnight or other non-weekly basis. |
- | - |
3j_Standard_Weekly_Full_time_Award_or_Contract_hours | You don't have permission to see this Data Element. |
-
Specific Information:
The number of paid hours the employee would work each week (under the relevant Award or Agreement) as a full-time employee in that type of position or occupation. If the employee does not work under an award or agreement, enter the hours they would normally work each week under an award. Reason for collection Validation: |
- | - |
3k_Number_of_days_in_Reference_period | You don't have permission to see this Data Element. |
-
Specific Information:
The number of days covered by the reference period. Reason for collection - Data Management: Item is used to calculate full time equivalent (FTE). Validation |
- | - |
3l_Position_Code | You don't have permission to see this Data Element. |
-
Specific Information:
This item relates to the position code for the position that was current at the census date. Reason for collection Validation
Cross validation of occupational codes with Item 3m. |
- | - |
3m_ANZSCO | You don't have permission to see this Data Element. |
-
Specific Information:
Occupation is classified according to the Australian and New Zealand Standard Classification of Occupations (ANZSCO ABS Cat No 1220.0) Reason for collection |
- | - |
3n_Treasury_Code | You don't have permission to see this Data Element. |
-
Specific Information:
The majority of agencies do not have assigned Treasury Codes. Reason for collection - Analysis / Reporting: To report on specific groups of employees when required. Codification |
- | - |
3o_Division_ID | You don't have permission to see this Data Element. |
-
Specific Information:
Reason for collection Codification |
- | - |
3p_Role_or_Position_ID_Substantive_position | You don't have permission to see this Data Element. |
-
Specific Information:
For positions, Position ID identifies the position substantively occupied by an employee at census. For Public Service employees it relates to the substantive band/classification of work in which the person is employed. For separated employees, last known position substantively occupied. Reason for collection |
- | - |
3q_Role_or_Position_ID_Current_position | You don't have permission to see this Data Element. |
-
Specific Information:
For positions, Position ID identifies the position currently occupied by an employee at census, or for separated employees, last known position substantively occupied. Reason for collection |
- | - |
3r_Role_or_Position_Grade | You don't have permission to see this Data Element. |
-
Specific Information:
This is required for Executive roles under the GSE Act or aligned executive service ONLY, i.e., 3g Employment Category = 18 and 19. Reason for collection - Analysis / Reporting: This data will be used to monitor the number of Executives in the Public Sector and will enable analysis of distribution of roles within bands. |
- | - |
3s_Award_Classification | You don't have permission to see this Data Element. |
-
Specific Information:
This is required for employees whose salary rates are determined under those awards which are adjusted under the Crown Employees (Public Sector – Salaries) Award ONLY. Reason for collection - Analysis / Reporting: This data is used to monitor the number of employees under various Award Classifications. Codification |
- | - |
3t_Role_Position_Title | You don't have permission to see this Data Element. |
-
Specific Information:
From 2023, this item is mandatory for all public sector employees. Reason for collection - Analysis/Reporting: Used for analysis of occupations. |
- | - |
3u_Frontline_Nonfrontline_Role_Position | You don't have permission to see this Data Element. |
-
Specific Information:
Positions which provide services to other government agencies (e.g., positions in central agencies, service providers) are NOT considered frontline. Reason for collection - Analysis / Reporting: To identify proportion of public sector involved in providing services to the public |
- | - |
3v_People_manager_role_or_position_ID | You don't have permission to see this Data Element. |
-
Specific Information:
The role or position ID of the manager of this role. |
- | - |
3w_Role_or_position_grade–non-executives | You don't have permission to see this Data Element. |
-
Specific Information:
The grade level of the non-executive role or position within the classification under which the employee is paid.(Optional in 2025) |
- | - |
3x_Grade_year–non-executives | You don't have permission to see this Data Element. |
-
Specific Information:
The year of the non-executive role or position within the grade under which the employee is paid. Codification |
- | - |
4a_Total_Annual_Base_Remuneration_Substantive_position | You don't have permission to see this Data Element. |
-
Specific Information:
Base remuneration includes:
Excludes:
All figures should represent an annual rate and be provided as gross, i.e., before tax, and other deductions (such as union dues) should be removed.
|
- | - |
4b_Total_Annual_Base_Remuneration_Current_position | You don't have permission to see this Data Element. |
-
Specific Information:
Refers to the remuneration level at which the employee is contracted to work, not actual earnings during the period. It is determined by the award and increment level of a person's current assigned role or position, e.g., Clerk, grade 3, year 1. Excludes remuneration of any other kind. Base remuneration includes: Excludes:
For Senior Executives on contracts, this includes: Excludes:
NOTE: For most employees, the data for this item will be the same as for Item 4a, i.e., they currently occupy their assigned role or substantive position. This item relates to total annual remuneration for the employee’s position that was current as at the census date (or last known role or position if the employee has left the agency) Reason for collection |
- | - |
4c_Recruitment_Remuneration | You don't have permission to see this Data Element. |
-
Specific Information:
|
- | - |
4d_Total_Gross_Earnings_YTD | You don't have permission to see this Data Element. |
-
Specific Information:
The total actual gross earnings of the employee for the financial year to date. The number represents total remuneration because tax and other deductions are removed. This includes: Base salary, Payment made for any form of leave and public holidays, Leave loading, Workers’ compensation payments made through the payroll, All allowances (including higher duties allowance, except for those listed under exclusions), Market loadings (including recruitment and retention allowance), Overtime and penalty payments, Salary packaged/Sacrificed components, Performance related payments whether paid as bonus or an increase in the base salary, Social security (health insurance or pension schemes), Lump sum payments, & Any other payments made by the employer on behalf of the employee and forming part of their remuneration. Excluded from this number are: Employer’s contribution to superannuation on behalf of the employee, Travelling compensation allowances/payments, Meal allowances, Subsistence allowances, Reimbursements for work-related expenses (including the use of a private motor vehicle for work purposes), & Commonwealth paid parental leave. Year to date: |
- | - |
4e_Total_Gross_Earnings_in_Census_Pay_Period | You don't have permission to see this Data Element. |
-
Specific Information:
The total actual gross earnings of the employee for the last fortnightly pay period. The number represents total remuneration because tax and other deductions are removed. This includes base salary, payments for leave and public holidays, workers compensation, market loadings, overtime and penalty payments. Excluded from this number are employer's contributions to superannuation, travel and meal allowances, reimbursements for work-related expenses and Commonwealth paid parental leave. Note: Please make a pro rata adjustment to generate weekly hours for employees working on a nine-day fortnight or other non-weekly basis Codification |
- | - |
4g_Actual_Earnings_Overtime_Payments | You don't have permission to see this Data Element. | - | - | - |
4h_Actual_Earnings_Recreation_Leave_Lump_Sum | You don't have permission to see this Data Element. | - | - | - |
4i_Actual_Earnings_Redundancy_Lump_Sum | You don't have permission to see this Data Element. |
-
Specific Information:
Excluded from this number are pay outs for recreation or extended leave. |
- | - |
4j_Actual_Earnings_Extended_Leave_Lump_Sum | You don't have permission to see this Data Element. |
-
Specific Information:
Pay out for extended leave accrued by an employee, received as part of a termination payment received during the reference period. |
- | - |
4k_Actual_Earnings__Recruitment_Retention_or_Skills_Shortage_Allowance | You don't have permission to see this Data Element. |
-
Specific Information:
Retired as of June 2023 |
- | - |
4l_Salary_Maintenance | You don't have permission to see this Data Element. |
-
Specific Information:
Codes 1 and 2 only apply to employees who were declared excess employees at any point during the reference period. If an excess employee is provided with meaningful work or is place in a position at a lower grade, they are entitled to 3 calendar month's salary maintenance at their substantive grade. Reason for collection - Analysis / Reporting: To assist with Workforce Planning and Budgeting. |
- | - |
4m_Leave_Loading | You don't have permission to see this Data Element. |
-
Specific Information:
Reason for collection - Analysis / Reporting: From this data it is possible to determine the proportion of year-to-date total gross earnings that is made up of leave loading. |
- | - |
4n_Remote_Area_Allowance | You don't have permission to see this Data Element. |
-
Specific Information:
For public service employees, remote areas are defined under Section 39 of the Crown Employees (Public Service Conditions of Employment) Reviewed Award 2009. Reason for collection - Analysis / Reporting: To assist with Workforce Planning and budgeting. |
- | - |
4o_Actual_Earnings_Higher_Duties | You don't have permission to see this Data Element. |
-
Specific Information:
Reason for collection - Analysis / Reporting: To assist with Workforce Planning as an indicator of levels of higher duties across the sector. |
- | - |
4p_Total_Remuneration_Package_TRP | You don't have permission to see this Data Element. |
-
Specific Information:
NOTE: This data item is applicable to the following executives: Part 4, Division 4 of the Government Sector Employment (GSE) Act 2013.
This is not applicable to non-executives temporarily assigned to senior executive roles. Reason for collection - Analysis / Reporting: Provides ability to analyse TRP trends over time. Validation: Consistency check with Item 3g for Senior Executives. Aligns with 4a and 4b. |
- | - |
4q_Special_determination | You don't have permission to see this Data Element. |
-
Specific Information:
Determination amount (TRP) for executives who occupy a role subject to a special determination of SOORT (Statutory and Other Officers Remuneration Tribunal). Reason for collection - Analysis / Reporting: To provide ability to analyse number of Executives who occupy a role subject to a special determination of SOORT, and the cost associated. |
- | - |
4r_Actual_Earnings_Retention_Allowance | You don't have permission to see this Data Element. |
-
Specific Information:
Retired as of June 2018 |
- | - |
4s_Actual_Earnings_Skills_Shortage_Allowance | You don't have permission to see this Data Element. |
-
Specific Information:
Skills Shortage Allowance (non-Senior Executive employees at or above Grade 12 but not payable to Senior Officers) paid to the employee during the reference period (over and above the employee’s base wage or salary). Reason for collection - Analysis / Reporting: To assist with Workforce Planning. |
- | - |
4t_Employer's_contribution_to_superannuation | You don't have permission to see this Data Element. |
-
Specific Information:
(Optional in 2025) Codification |
- | - |
4u_Superannuation_type | You don't have permission to see this Data Element. |
-
Specific Information:
(Optional in 2025) |
- | - |
5a_Recreation_Leave_Accrued_at_Census_Date | You don't have permission to see this Data Element. |
-
Specific Information:
The recreation leave balance in hours accrued by the employee as at the census date. Reason for collection - Analysis / Reporting: Can be used to monitor and report on recreation leave usage and to calculate liabilities. |
- | - |
5b_Recreation_Leave_Taken_during_Reference_Period | You don't have permission to see this Data Element. |
-
Specific Information:
Reason for collection - Analysis / Reporting: Can be used for deriving average employee availability. Also used to analyse trends within Agencies |
- | - |
5c_Sick_Leave_Accrued_as_at_Census_Date | You don't have permission to see this Data Element. |
-
Specific Information:
The sick leave balance in hours accrued by the employee as at the census date. Reason for collection - Analysis / Reporting: Can be used for deriving average employee availability. Also used to analyse trends within Agencies. |
- | - |
5d_Paid_Sick_Leave_Taken | You don't have permission to see this Data Element. |
-
Specific Information:
The number of hours of paid sick leave taken by the employee during the reference period. Include:
Exclude:
Reason for collection - Analysis / Reporting: The data is used to provide trends in sick leave usage across the sector and within Agencies. In certain circumstances this can be an indication of morale and/or general health of specific segments of the workforce. May also be used for analysing changes in policies. Validation |
- | - |
5e_Unpaid_Sick_Leave_Taken | You don't have permission to see this Data Element. |
-
Specific Information:
The number of hours of unpaid sick leave taken by the employee during the reference period. Reason for collection - Analysis / Reporting: The data is used to provide trends in sick leave usage across the sector and within Agencies. |
- | - |
5f_Paid_Sick_Leave_Taken_as_Carer_Leave | You don't have permission to see this Data Element. |
-
Specific Information:
The number of hours of paid sick leave taken as Carer's Leave by the employee during the reference period, excluding Family and Community Services (FACS) leave which is recorded at item 5m, and sick leave. Reason for collection - Analysis / Reporting: The data is used to provide trends in sick leave usage across the sector and within Agencies. May also be used for analysing changes in policies. |
- | - |
5g_Extended_Leave_Accrued_as_at_Census_Date | You don't have permission to see this Data Element. |
-
Specific Information:
Only include the leave balance which is available to be taken by the employee and/or would be paid out if the employee ceased work for the agency/public sector. Employees who have left the agency do not have accrued leave as at the census date and should be coded as -8888 (Not Applicable). Reason for collection - Analysis / Reporting: To monitor and report on extended leave usage and to monitor liabilities. |
- | - |
5h_Extended_Leave_Taken_at_Full_Pay | You don't have permission to see this Data Element. |
-
Specific Information:
The number of hours* of extended leave (long service leave) taken on full pay by the employee during the reference period. Reason for collection - Analysis / Reporting: To monitor and report on extended leave usage. |
- | - |
5i_Extended_Leave_Taken_at_Half_Pay | You don't have permission to see this Data Element. |
-
Specific Information:
The number of hours* of extended leave (long service leave) taken on half pay by the employee during the reference period. Reason for collection - Analysis / Reporting: To monitor and report on extended leave usage. |
- | - |
5j_Parental_Leave_Taken_at_Full_Pay | You don't have permission to see this Data Element. |
-
Specific Information:
The number of hours* of parental leave taken on full-pay by the employee during the reference period. Parental leave refers to maternity or paternity leave. Reason for collection - Analysis / Reporting: To monitor and report on leave usage and monitor effects of policy/award changes. |
- | - |
5k_Parental_Leave_Taken_at_Half_Pay | You don't have permission to see this Data Element. |
-
Specific Information:
The number of hours* of parental leave taken at half-pay by the employee during the reference period. Parental leave refers to maternity or paternity leave Reason for collection - Analysis / Reporting: To monitor and report on leave usage and monitor effects of policy/award changes. |
- | - |
5l_Unpaid_Parental_Leave_taken | You don't have permission to see this Data Element. |
-
Specific Information:
Parental leave refers to maternity or paternity leave. Reason for collection - Analysis / Reporting: To monitor and report on leave usage and monitor effects of policy/award changes. |
- | - |
5m_Family_and_Community_Services_Leave_Taken | You don't have permission to see this Data Element. |
-
Specific Information:
NOTE: Agencies which have an equivalent form of leave should record it under this data item and provide details of their equivalent leave type. Reason for collection - Analysis / Reporting: To monitor and report on leave usage and monitor effects of policy/award changes. |
- | - |
5n_Unpaid_Leave | You don't have permission to see this Data Element. |
-
Specific Information:
Include:
Exclude:
Reason for collection - Analysis / Reporting: To monitor and report on leave usage. |
- | - |
5o_Extended_Leave_Taken_at_Double_Pay | You don't have permission to see this Data Element. |
-
Specific Information:
The number of hours* of extended leave (long service leave) taken on double pay by the employee during the reference period. Reason for collection - Analysis / Reporting: To monitor and report on extended leave usage. |
- | - |
5p_Commonwealth_Paid_Parental_Leave_Taken | You don't have permission to see this Data Element. |
-
Specific Information:
An indicator that Commonwealth Paid Parental Leave was taken during the reference period. Reason for collection - Analysis / Reporting: Used to monitor the usage of the Commonwealth Paid Parental Leave scheme. |
- | - |
5q_Special_Leave_Taken_During_Reference_Period | You don't have permission to see this Data Element. |
-
Specific Information:
NOTE: Agencies which have an equivalent form of leave should record it under this data item and provide details of their equivalent leave type. Reason for collection - Analysis / Reporting: To assist with Workforce Planning. |
- | - |
5r_Domestic_and_Family_Violence_Leave_Taken_During_the_Reference_Period | You don't have permission to see this Data Element. |
-
Specific Information:
Reason for collection - Analysis / Reporting: To monitor and report on leave usage and monitor effects of policy. Validation |
- | - |
5w_Paid_special_miscarriage_leave_taken_during_reference_period | You don't have permission to see this Data Element. |
-
Specific Information:
Leave will commence from the date the miscarriage occurs and is to be taken in one continuous block of leave at full pay. Paid special miscarriage leave must not be taken concurrently with any other form of leave available to the employee. Reason for collection - Analysis / Reporting: To monitor and report on leave usage and monitor effects of policy changes introduced on 3rd July 2021 effective 1st July 2021.
|
- | - |
5x_Paid_special_pre-term_parental_leave_taken_during_reference_period | You don't have permission to see this Data Element. |
-
Specific Information:
Leave will commence from the date the pre-term birth occurs and must be taken in one continuous block of leave at full pay up to the end of 36 weeks. Paid special pre-term parental leave must not be taken concurrently with any other form of leave available to the employee. In the event of a death of a pre-term child (or children) during a period of paid special pre-term parental leave, the remaining portion of that leave ceases and paid parental leave in accordance with Determination No. 4 of 2022 will commence.
For details, please refer to the Miscarriage and Pre-Term Birth Leave Determination. Reason for collection - Analysis / Reporting: To monitor and report on leave usage and monitor effects of policy changes introduced on 3rd July 2021 effective 1st July 2021. |
- | - |
5y_Paid_fertility_leave_taken_during_the_reference_period | You don't have permission to see this Data Element. |
-
Specific Information:
(mandatory in 2024) Reason for collection - Analysis / Reporting: To monitor and report on leave usage and monitor effects of policy changes introduced on 4th October 2022 effective 1st October 2022. |
- | - |
5z_Bonus_paid_parental_leave | You don't have permission to see this Data Element. |
-
Specific Information:
(mandatory in 2024) An additional two-week bonus paid parental leave where each parent has exhausted any paid parental leave offered by their employer. Employees who are single parents or whose partners do not have access to or are ineligible for employer paid parental leave will receive the full two weeks of bonus paid parental leave. For details, please refer to Determination No 4 of 2022 and Premier’s Memorandum M2022- 08 Paid Parental Leave – Parent with responsibility for care associated with the birth, adoption, altruistic surrogacy or permanent out-of-home care placement of a child. Reason for collection - Analysis / Reporting: To monitor and report on leave usage and monitor effects of policy changes introduced on 4th October 2022 effective 1st October 2022. |
- | - |
6a_Date_of_Most_Recent_Public_Sector_Entry | You don't have permission to see this Data Element. |
-
Specific Information:
The date of commencement for the employee's current period of employment in the NSW public sector.
NOTE: For some employees, the data for this item will be the same as for Item 6b: that is; if the employee most recently joined the NSW Public Sector on the same date, they joined the agency. Reason for collection |
- | - |
6b_Date_of_Commencement_in_Agency | You don't have permission to see this Data Element. |
-
Specific Information:
The date of an employee’s commencement in their current agency. NOTE: In the case of ongoing employees who leave the agency to work elsewhere and then return to the agency at some later date, the latest commencement date should be used. For example, an ongoing employee who left your agency to take up a position elsewhere in 1995 and returned to your agency in 2000, again as an ongoing employee, should have a date of commencement in 2000. Reason for collection |
- | - |
6c_Movement_Type | You don't have permission to see this Data Element. |
-
Specific Information:
If more than one movement has occurred during the reference period only the most recent movement must be recorded. Reason for collection |
- | - |
6d_Date_of_Separation | You don't have permission to see this Data Element. |
-
Specific Information:
Date of the most recent separation of employee from the agency, of those employees who ceased employment during the reference period. Reason for collection |
- | - |
6e_Excess_Employees_During_Reference_Period | You don't have permission to see this Data Element. |
-
Specific Information:
Employees are declared excess by an agency when they no longer have a substantive position. Validation |
- | - |
6f_Date_of_Appointment_to_Employees_Current_Role_or_Position | You don't have permission to see this Data Element. |
-
Specific Information:
The date the employee commenced work in their current role or position. Reason for collection - Analysis / Reporting: To assist with Workforce Planning and provide information relating to mobility within the public sector. |
- | - |
6h_Contract_Start_Date | You don't have permission to see this Data Element. |
-
Specific Information:
Contract start date of the employee’s current role on term and ongoing contracts.
|
- | - |
6i_Contract_End_Date | You don't have permission to see this Data Element. |
-
Specific Information:
Note: This data item is applicable to all contract employees in the following Employment Categories
|
- | - |
6j_Termination_Type | You don't have permission to see this Data Element. |
-
Specific Information:
Reason for termination of senior executive or transport service senior manager by employer.
This is not applicable to a temporary assignment to a senior executive role. |
- | - |
6k_Termination_Cost | You don't have permission to see this Data Element. |
-
Specific Information:
This is the compensation for termination of employment as specified in the executive’s contract of employment or the compensation for termination of employment determined by the Statutory and Other Offices Remuneration Tribunal (if applicable). This excludes the payment for accrued recreation or extended leave.
This is not applicable to a temporary assignment to a senior executive role. |
- | - |
7a_Agency_Code_1 | You don't have permission to see this Data Element. |
-
Specific Information:
Level 1 organisation code can be used to identify different units in an agency hierarchy i.e., sub Codification |
- | - |
7b_Agency_Code_2 | You don't have permission to see this Data Element. |
-
Specific Information:
Level 2 organisation code can be used to identify different units in your agency hierarchy i.e., sub Codification |
- | - |
7c_Agency_Code_3 | You don't have permission to see this Data Element. |
-
Specific Information:
Level 3 organisation code can be used to identify different units in your agency hierarchy i.e., sub Codification |
- | - |
8a_Calculated_Census_period_FTE | You don't have permission to see this Data Element. |
-
Specific Information:
Reason for Collection - Analysis / Reporting: A standardised method of describing the size of the workforce based on the total number of ordinary time paid hours worked (i.e., excluding overtime and unpaid work). FTE is a computed measure representing the number of employees in fulltime equivalent terms. It is not a count of the number of employees. Part-time and casual employees are converted to full-time equivalents. 3i = Total Hours Paid (Census Period) Codification: Calculated full time equivalent |
- | - |
8b_Calculated_Reference_Period_FTE | You don't have permission to see this Data Element. |
-
Specific Information:
|
- | - |
8c_Override_Census_Period_FTE | You don't have permission to see this Data Element. |
-
Specific Information:
It is possible that an inaccurate FTE will be calculated due to the normal reconciliation practices conducted within Agency HR systems. This may occur when an employee is paid in advance or has been overpaid. Where Item 8a is inconsistent with the FTE worked, Agencies should use this item to reflect actual FTE of the employee. Reason for collection - Data Management: To ensure FTEs reported are accurate. |
- | - |
8d_Override_Reference_Period_FTE | You don't have permission to see this Data Element. |
-
Specific Information:
It is possible that an inaccurate FTE will be calculated due to the normal reconciliation practices conducted within Agency HR systems. This may occur when an employee is paid in advance or has been overpaid. Where Item 8b is inconsistent with the FTE worked, Agencies should use this item to reflect actual FTE of the employee. Reason for collection - Analysis / Reporting: Refer to Item 8c. |
- | - |
9a_Sub-division_ID_level_1 | You don't have permission to see this Data Element. |
-
Specific Information:
Organisation hierarchy item that is the child entity to data item 3o Division ID. Provides departments and agencies with the opportunity for more granular analysis of the workforce profile data in the Workforce Dashboard. |
- | - |
9b_Sub-division_ID_level_2 | You don't have permission to see this Data Element. |
-
Specific Information:
Organisation hierarchy item that is the child entity to data item 9a Sub-division ID Level 1. Provides departments and agencies with the opportunity for more granular analysis of the workforce profile data in the Workforce Dashboard. |
- | - |