Washington Workforce Analytics (WWA) Production Release – July 15, 2024
The Office of Financial Management has made the following enhancements to the WWA Enterprise Data Warehouse.
NEW FIELDS
Employee Personal Info Dimension (secure logon only)
Field Name(s)
Universe(s)
Notes
Address Type (EE) /
Address Type Code (EE)
All, excluding
WWA EDW
Grievance
Addresses Infotype 0006.
Use with any of the employee address fields in the Employee Personal Info dimension (see Updated employee address Fields section below).
Country (EE)
All, excluding
WWA EDW
Grievance
Addresses Infotype 0006.
Use in conjunction with the new Address Type field above to specify which employee address type to use (Permanent Residence, Mailing, Out of State Work Location).
Spouse DP Surcharge / Spouse DP Surcharge
Code
All, excluding
WWA EDW
Grievance
Benefits Medical Information Infotype 0376.
Tobacco Surcharge / Tobacco Surcharge
Code
All, excluding
WWA EDW
Grievance
Benefits Medical Information Infotype 0376.
Employee Dimension
Field Name(s)
Universe(s)
Notes
Additional Payment -
Amount
WWA EDW
Headcount and
Personnel Actions
WWA EDW
Staffing
Assignments
Additional Payments Infotype 0015.
Additional Payment -
Assignment Number
WWA EDW
Headcount and
Personnel Actions
WWA EDW
Staffing
Assignments
Additional Payments Infotype 0015.
Additional Payment -
Date of Origin
WWA EDW
Headcount and
Personnel Actions
WWA EDW
Staffing
Assignments
Additional Payments Infotype 0015.
Additional Payment –
Number
WWA EDW
Headcount and
Personnel Actions
WWA EDW
Staffing
Assignments
Additional Payments Infotype 0015.
Additional Payment -
Unit
WWA EDW
Headcount and
Personnel Actions
WWA EDW
Staffing
Assignments
Additional Payments Infotype 0015.
Additional Payment -
Wage Type
WWA EDW
Headcount and
Personnel Actions
WWA EDW
Staffing
Assignments
Additional Payments Infotype 0015.
Additional Payment -
Wage Type Code
WWA EDW
Headcount and
Personnel Actions
WWA EDW
Staffing
Assignments
Additional Payments Infotype 0015.
Date – DFW Commission
All, excluding
WWA EDW
Grievance
Date Specifications Infotype 0041.
DFW only.
Out of State Work
Location Indicator
All, excluding
WWA EDW
Grievance
Addresses Infotype 0006.
If Address Type is Out of State Work Location, indicator will be the 2-character state code.
Recurring Payment -
Amount
All, excluding
WWA EDW
Grievance
Recurring Payments Infotype 0014.
Recurring Payment -
Assignment Number
All, excluding
WWA EDW
Grievance
Recurring Payments Infotype 0014.
Recurring Payment -
Calendar Type
All, excluding
WWA EDW
Grievance
Recurring Payments Infotype 0014.
Recurring Payment -
Number
All, excluding
WWA EDW
Grievance
Recurring Payments Infotype 0014.
Recurring Payment -
Payment Model
All, excluding
WWA EDW
Grievance
Recurring Payments Infotype 0014.
Recurring Payment -
Payment Model Code
All, excluding
WWA EDW
Grievance
Recurring Payments Infotype 0014.
Recurring Payment -
Unit
All, excluding
WWA EDW
Grievance
Recurring Payments Infotype 0014.
Recurring Payment -
Wage Type
All, excluding
WWA EDW
Grievance
Recurring Payments Infotype 0014.
Recurring Payment -
Wage Type Code
All, excluding
WWA EDW
Grievance
Recurring Payments Infotype 0014.
Statewide Job Grouping
(EE) / Statewide Job
Grouping Code (EE)
All, excluding
WWA EDW
Grievance
Job Relationships Infotype 1001.
This field is utilized and maintained by OFM on the Job the employee is assigned to.
Use this field with Headcount measures.
See also Statewide Job Grouping (POS) and Statewide Job Grouping (JOB).
Statewide Job Grouping
(EE) – Actions / Statewide
Job Grouping Code (EE) -
Actions
WWA EDW
Headcount and
Personnel Actions
Job Relationships Infotype 1001.
This field is utilized and maintained by OFM on the Job the employee is assigned to.
See also Statewide Job Grouping (POS) and Statewide Job Grouping (JOB).
Use this field with Action measures.
Tax Area – Residence –
Tax Area / Tax Area –
Residence – Tax Area Code
All, excluding
WWA EDW
Grievance
Residence Tax Area Infotype 0207.
Tax Area – Work –
Allocation
All, excluding
WWA EDW
Grievance
Work Tax Area Infotype 0208.
Tax Area – Work –
Tax Area / Tax Area –
Work – Tax Area Code
All, excluding
WWA EDW
Grievance
Work Tax Area Infotype 0208.
Unemployment State –
Tax Authority /
Unemployment State –
Tax Authority Code
All, excluding
WWA EDW
Grievance
Unemployment State Infotype 0209.
See Updated Fields section below for information on Unemployment State – Worksite County field updates (previously Unemployment County).
Position Dimension
Field Name(s)
Universe(s)
Notes
Standard Occupational
Code / Standard
Occupational Code Title
All, excluding
WWA EDW
Grievance
WC State, Code, Attribute Infotype 1613.
Statewide Job Grouping
(POS) / Statewide Job
Grouping Code (POS)
All, excluding
WWA EDW
Grievance
Job Relationships Infotype 1001.
This field is utilized and maintained by OFM on the Job the position is assigned to.
Use this field with Headcount measures.
See also Statewide Job Grouping (EE) and Statewide Job Grouping (JOB).
Statewide Job Grouping
(POS) - Actions /
Statewide Job Grouping
Code (POS) - Actions
WWA EDW
Headcount and
Personnel Actions
Job Relationships Infotype 1001.
This field is utilized and maintained by OFM on the Job the position is assigned to.
See also Statewide Job Grouping (EE) and Statewide Job Grouping (JOB).
Use this field with Action measures.
Job Dimension
Field Name(s)
Universe(s)
Notes
Statewide Job Grouping
(JOB) / Statewide Job
Grouping Code (Job)
WWA EDW
Staffing
Assignments
Job Relationships Infotype 1001.
This field is utilized and maintained by OFM on the Job.
Use this field with Headcount measures.
See also Statewide Job Grouping (EE) and Statewide Job Grouping (POS).
Statewide Job Grouping
(POS) - Actions /
Statewide Job Grouping
Code (POS) - Actions
WWA EDW
Headcount and
Personnel Actions
Job Relationships Infotype 1001.
This field is utilized and maintained by OFM on the Job.
See also Statewide Job Grouping (EE) and Statewide Job Grouping (POS).
Use this field with Action measures.
UPDATED FIELDS
Employee Personal Info Dimension (secure logon only)
Field Name(s)
Universe(s)
Notes
Address Line 1 (EE)
(previously
Home – Address Line 1)
All, excluding
WWA EDW
Grievance
Addresses Infotype 0006.
Use in conjunction with the new Address Type fields above to specify which employee address type to use (Permanent Residence, Mailing, Out of State).
Address Line 2 (EE)
(previously
Home – Address Line 2)
All, excluding
WWA EDW
Grievance
Addresses Infotype 0006.
Use in conjunction with the new Address Type fields above to specify which employee address type to use (Permanent Residence, Mailing, Out of State).
City (EE)
(previously Home – City)
All, excluding
WWA EDW
Grievance
Addresses Infotype 0006.
Use in conjunction with the new Address Type fields above to specify which employee address type to use (Permanent Residence, Mailing, Out of State).
County (EE) / County Code (EE)
(previously Home – County /
Home – County Code)
All, excluding
WWA EDW
Grievance
Addresses Infotype 0006.
Use in conjunction with the new Address Type fields above to specify which employee address type to use (Permanent Residence, Mailing, Out of State).
State (EE)
(previously Home – State)
All, excluding
WWA EDW
Grievance
Addresses Infotype 0006.
Use in conjunction with the new Address Type fields above to specify which employee address type to use (Permanent Residence, Mailing, Out of State).
Zip Code (EE)
(previously Home – Zip Code)
All, excluding
WWA EDW
Grievance
Addresses Infotype 0006.
Use in conjunction with the new Address Type fields above to specify which employee address type to use (Permanent Residence, Mailing, Out of State).
Employee Dimension
Field Name(s)
Universe(s)
Notes
Unemployment State –
Worksite County /
Unemployment State –
Worksite County Code
(previously Unemployment County / Unemployment County Code)
All
Unemployment State Infotype 0209.
IMPACTS
If you have queries with the existing employee personal address fields from the Employee Personal Info dimension, you will need to update your queries to include the Address Type (Permanent Residence, Mailing, Out of State Work Location) in your filters.
Employee personal address fields are no longer available in the Grievance universe. If you have Grievance queries with the employee personal address, create a Merged Dimension with the WWA EDW Headcount and Personnel Actions universe to get the updated employee personal address information.
If you have queries with the Unemployment County or Unemployment County Code, they will automatically be renamed to Unemployment State - Worksite County and/or Unemployment State - Worksite County Code.
GENERAL NOTES REGARDING NEW/UPDATED FIELDS
Ensure you include the new Address Type field(s) with any of the employee address fields in the Employee Personal Info folder. If you do not use the Address Type field, you will get multiple lines with all employee personal addresses (Permanent Residence, Mailing, Out of State Work Location) without an identifier of which address type it is.
Recurring Payment / Additional Payment fields: Results will only bring in records where there is a value in the field. Consider creating a Merged Dimension when using these fields. In addition, indirectly valued wage type amounts will display a zero rather than the amount of the Recurring or Additional Payment amount on the respective Infotype in HRMS.
Tax Area - Residence / Tax Area – Work fields: Results will only bring in records where there is a value in the field. Consider creating a Merged Dimension when using these fields.
WWA Universe user procedures have been updated to include the new/updated fields (see respective Universe and Data Design documents for more information).
