Skip to content Learn about the access keys available for Metadata.NSW
A NSW Government website
NSW Government
Metadata.NSW

New South Wales - Workforce Profile Collection

Download CSV
Logical Path Data Element Number of Unique Values Uniqueness Score Min Max Average
AGED_M_End_Dt Record: DateTime Stamp, YYYY-MM-DD - - - - -
DIVISION Organisation: Division, label A(70) - - - - -
1a_Unique_Identifier Employee: Identifier, X(10) - - - - -
1b_Date_of_Birth Employee: Date of Birth, N - - - - -
1c_Gender Employee: Gender, Code X(5) - - - - -
1d_Work_Location_Postcode Organisation: Australian Postcode, code (Postcode datafile) NNNN - - - - -
1e_Home_Location_Postcode Employee: Australian Postcode, NNNN - - - - -
1f_GEN Employee: Government Employee Number, Identifier X(12) - - - - -
1g_Work_Location_Suburb Organisation: Locality Name, Text X(46) - - - - -
1h_Home_Location_Suburb Employee: Locality Name, Text X - - - - -
2a_Aboriginal_or_Torres_Strait_Islander Employee: Indigenous Status, Code N - - - - -
2b_Person_with_a_Disability Employee: Disability Status, code N - - - - -
2c_Person_from_a_Minority_Group Employee: Culturally and Linguistically Diverse (CALD) Background, Yes/No Code N - - - - -
2d_Language_First_Spoken Employee: First language spoken, Code N - - - - -
2e_Highest_Education_Level Employee: Highest education level, Code N - - - - -
2f_Country_of_Birth Employee: Country of Birth, Country Label X(100) - - - - -
3_Employing_Legislation_Identifier Employee: Employment Legislation Identifier, PSC code NNN - - - - -
3a_Award_determining_Salary_Rate Employee: NSW Award determining salary rate, Industrial award code X(10) - - - - -
3b_Award_determining_Conditions_of_Employment Employee: NSW award determining conditions of employment, Industrial award code X(10) - - - - -
3c_Agency_or_Occupation_Specific_Award Employee: NSW agency or occupation specific award, Industrial award code X(10) - - - - -
3d_Usual_Hours_Worked Employee: Hours worked, Hours N[NN] - - - - -
3e_Total_Number_of_Hours_Paid_Reference_Period Employee: Hours worked, Hours N[NN] - - - - -
3f_Overtime_Hours Employee: Overtime hours, Hours N[NN] - - - - -
3g_Employment_Category Employee: Employment Status, Category Code N - - - - -
3h_Census_Date_Status Employee: Employment Status, Code N - - - - -
3i_Total_Hours_Paid_in_Census_Pay_Period Employee: Hours worked, Hours N[NN] - - - - -
3j_Standard_Weekly_Full_time_Award_or_Contract_hours Employee: NSW Award or contract, Hours N[NN] - - - - -
3k_Number_of_days_in_Reference_period Record: Period, Total Days N(5) - - - - -
3l_Position_Code Employee: Position code, N(7) - - - - -
3m_ANZSCO Employee: Occupation, Code (ANZSCO) N(6) - - - - -
3n_Treasury_Code Employee: Treasury Code, A - - - - -
3o_Division_ID Organisation: Division, Identifier NNN - - - - -
3p_Role_or_Position_ID_Substantive_position Employee: Position Identifier, X(18) - - - - -
3q_Role_or_Position_ID_Current_position Employee: Position Identifier, X(18) - - - - -
3r_Role_or_Position_Grade Employee: Position Grade, Level code X(10) - - - - -
3s_Award_Classification Employee: NSW agency or occupation specific award, Classification Code X(10) - - - - -
3t_Role_Position_Title Employee: Position Title, Label X(50) - - - - -
3u_Frontline_Nonfrontline_Role_Position Employee: Frontline position, Flag N - - - - -
3v_People_manager_role_or_position_ID Employee: Position Identifier, X(18) - - - - -
3w_Role_or_position_grade–non-executives Employee: Position Grade, Level code X(10) - - - - -
3x_Grade_year–non-executives Employee: Position Grade, Year YYYY - - - - -
4a_Total_Annual_Base_Remuneration_Substantive_position Employee: Substantive position remuneration, Actual Earnings, X(10) - - - - -
4b_Total_Annual_Base_Remuneration_Current_position Employee: Current position remuneration, Actual Earnings, X(10) - - - - -
4c_Recruitment_Remuneration Employee: Substantive position remuneration, Actual Earnings, X(10) - - - - -
4d_Total_Gross_Earnings_YTD Employee: Total gross earnings in the current financial year, Actual Earnings, X(10) - - - - -
4e_Total_Gross_Earnings_in_Census_Pay_Period Employee: Total gross earnings in the current pay period, Actual Earnings, X(10) - - - - -
4g_Actual_Earnings_Overtime_Payments Employee: Overtime hours, Actual Earnings, X(10) - - - - -
4h_Actual_Earnings_Recreation_Leave_Lump_Sum Employee: Recreation leave, Actual Earnings, X(10) - - - - -
4i_Actual_Earnings_Redundancy_Lump_Sum Employee: Redundancy payment, Actual Earnings, X(10) - - - - -
4j_Actual_Earnings_Extended_Leave_Lump_Sum Employee: Extended leave, Actual Earnings, X(10) - - - - -
4k_Actual_Earnings__Recruitment_Retention_or_Skills_Shortage_Allowance Employee: Recruitment or skills allowance, Actual Earnings, X(10) - - - - -
4l_Salary_Maintenance Employee: Salary maintenance, Code N - - - - -
4m_Leave_Loading Employee: Leave loading, Actual Earnings, X(10) - - - - -
4n_Remote_Area_Allowance Employee: Remote area allowance, Actual Earnings, X(10) - - - - -
4o_Actual_Earnings_Higher_Duties Employee: Higher duties, Actual Earnings, X(10) - - - - -
4p_Total_Remuneration_Package_TRP Employee: Total Remuneration Package, Actual Earnings, X(10) - - - - -
4q_Special_determination Employee: Determination, Actual Earnings, X(10) - - - - -
4r_Actual_Earnings_Retention_Allowance Employee: Higher duties, Actual Earnings, X(10) - - - - -
4s_Actual_Earnings_Skills_Shortage_Allowance Employee: Higher duties, Actual Earnings, X(10) - - - - -
4t_Employer's_contribution_to_superannuation Organisation: Superannuation, Total Australian Currency N(8) - - - - -
4u_Superannuation_type Employee: Superannuation, Fund type code N - - - - -
5a_Recreation_Leave_Accrued_at_Census_Date Employee: Recreation leave, Leave hours accrued X(8) - - - - -
5b_Recreation_Leave_Taken_during_Reference_Period Employee: Recreation leave, Leave hours taken X(8) - - - - -
5c_Sick_Leave_Accrued_as_at_Census_Date Employee: Paid sick leave, Leave hours taken X(8) - - - - -
5d_Paid_Sick_Leave_Taken Employee: Paid sick leave, Leave hours taken X(8) - - - - -
5e_Unpaid_Sick_Leave_Taken Employee: Unpaid sick leave, Leave hours taken X(8) - - - - -
5f_Paid_Sick_Leave_Taken_as_Carer_Leave Employee: Paid sick leave, Leave hours taken X(8) - - - - -
5g_Extended_Leave_Accrued_as_at_Census_Date Employee: Extended leave, Hours accrued X(8) - - - - -
5h_Extended_Leave_Taken_at_Full_Pay Employee: Extended leave, Hours taken X(8) - - - - -
5i_Extended_Leave_Taken_at_Half_Pay Employee: Extended leave, Hours taken X(8) - - - - -
5j_Parental_Leave_Taken_at_Full_Pay Employee: Parental leave, Hours taken X(8) - - - - -
5k_Parental_Leave_Taken_at_Half_Pay Employee: Parental leave, Hours taken X(8) - - - - -
5l_Unpaid_Parental_Leave_taken Employee: Unpaid parental leave, Hours taken X(8) - - - - -
5m_Family_and_Community_Services_Leave_Taken Employee: FACS leave, Hours taken X(8) - - - - -
5n_Unpaid_Leave Employee: Unpaid leave, Hours taken X(8) - - - - -
5o_Extended_Leave_Taken_at_Double_Pay Employee: Extended leave, Hours taken X(8) - - - - -
5p_Commonwealth_Paid_Parental_Leave_Taken Employee: Parental leave, Hours taken X(8) - - - - -
5q_Special_Leave_Taken_During_Reference_Period Employee: Special leave, Hours taken X(8) - - - - -
5r_Domestic_and_Family_Violence_Leave_Taken_During_the_Reference_Period Employee: Domestic and Family Violence leave, Hours taken X(8) - - - - -
5w_Paid_special_miscarriage_leave_taken_during_reference_period Employee: Special miscarriage leave, Hours taken X(8) - - - - -
5x_Paid_special_pre-term_parental_leave_taken_during_reference_period Employee: Parental leave, Hours taken X(8) - - - - -
5y_Paid_fertility_leave_taken_during_the_reference_period Employee: Fertility treatment leave, Hours taken X(8) - - - - -
5z_Bonus_paid_parental_leave Employee: Parental leave, Hours taken X(8) - - - - -
6a_Date_of_Most_Recent_Public_Sector_Entry Employee: Commencement Date, YYYYMMDD - - - - -
6b_Date_of_Commencement_in_Agency Employee: Commencement Date, YYYYMMDD - - - - -
6c_Movement_Type Employee: Employment Status, Movement type code NNN - - - - -
6d_Date_of_Separation Employee: Employment Separation Date, N - - - - -
6e_Excess_Employees_During_Reference_Period Employee: Declared excess, Code N - - - - -
6f_Date_of_Appointment_to_Employees_Current_Role_or_Position Employee: Position Start Date, N - - - - -
6h_Contract_Start_Date Employee: Contract start Date, YYYYMMDD - - - - -
6i_Contract_End_Date Employee: Contract end date, Date YYYYMMDD - - - - -
6j_Termination_Type Employee: Termination Type, Code N(4) - - - - -
6k_Termination_Cost Employee: Termination Cost, Total Australian Currency N(8) - - - - -
7a_Agency_Code_1 Employee: Agency code, Text X(10) - - - - -
7b_Agency_Code_2 Employee: Agency code, Text X(10) - - - - -
7c_Agency_Code_3 Employee: Agency code, Text X(40) - - - - -
8a_Calculated_Census_period_FTE Employee: Current Full-time Equivalent, FTE Quantity N - - - - -
8b_Calculated_Reference_Period_FTE Employee: Current Full-time Equivalent, FTE Quantity N - - - - -
8c_Override_Census_Period_FTE Employee: Current Full-time Equivalent, FTE Quantity N - - - - -
8d_Override_Reference_Period_FTE Employee: Current Full-time Equivalent, FTE Quantity N - - - - -
9a_Sub-division_ID_level_1 Organisation: Division, label A(70) - - - - -
9b_Sub-division_ID_level_2 Organisation: Division, label A(70) - - - - -