Where can I find the field/column key to the empdata form?

    EMPDATA FORM FIELD/COLUMN KEY

    Follow this Key for instructions on how to input data for each Field/Column in the Empdata Form. Hover over column headers to view help comments. DO NOT CHANGE COLUMN HEADERS.


    Naming Convention

    140066-01_empdata_divXXXXXX_mmddyyyy.csv

    *Note: if your location only has a four-digit UUA ID, you only need to use the four digits


    A. Employee_SSN

    • Employee Social Security Number (SSN) = 999-99-9999 (Hyphen/Dash is required)

    B. Employer_ID

    C. Employee_Name

    • Format: Last Name, Suffix, First Name, Middle Initial (ex. Smith, John, D)

    D. Birth_Date

    • Format MM/DD/YYYY (Must be 4-digit year)

    E. Gender (select from drop-down menu or enter M, F, N,U)

    • M = Male
      F = Female
      N = Non-Specified
      U = Non-Specified/Blank
    • Have employee self-identify. If unknown, leave blank

    F. Marital_Status (select from drop-down menu or enter M, S, D, W)

    • M = Married
      S = Single
      D = Divorced
      W = Widowed
    • Have employee self-identify. If unknown, leave blank

    G. Race_Ethnicity (select from drop-down menu or enter AS, BL, HI, NA, PI, WH TW)

    • AS = Asian
      BL = Black
      HI = Hispanic
      NA = Native American
      PI = Pacific Islander
      WH = White
      TW = Two or more races

      AS = Asian (not Hispanic or Latino): A person having origins in any of the original peoples of the Far East, Southeast Asia or the Indian Subcontinent, including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand and Vietnam.

      BL = Black or African American (not Hispanic or Latino): A person having origins in any of the black racial groups of Africa.

      HI = Hispanic or Latino: A person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin regardless of race.

      NA = American Indian or Alaska Native (not Hispanic or Latino): A person having origins in any of the original peoples of North and South America (including Central America) and who maintains tribal affiliation or community attachment.

      PI = Native Hawaiian or Other Pacific Islander (not Hispanic or Latino): A person having origins in any of the peoples of Hawaii, Guam, Samoa or other Pacific Islands.

      WH = White (not Hispanic or Latino): A person having origins in any of the original peoples of Europe, the Middle East or North Africa.

      TW = Two or More Races (not Hispanic or Latino): All persons who identify with more than one of the above five races.

    • Have employee self-identify. If unknown, leave blank

    H. Address_Line_1

    • Include unit, suite or apt numbers with Line 1 if possible, only use Address_Line_2 if necessary

    I. Address_Line_2

    • Leave blank or add additional information not included on Line 1

    J. City

    K. State (Two Digit State Abbreviation)

    L. Zip_Code

    • 5-DIGIT USPS ZIP CODE including preceding zero (if applicable)

    M. Mobile_Phone

    • Enter 10 digit phone numbers with no hyphens or parenthesis. Do not include dialing code (i.e. +1) ex. 9999999999   This will be treated as the primary phone number

    N. Work_Phone

    • Enter 10 digit phone numbers with no hyphens or parenthesis. Do not include dialing code (i.e. +1) ex. 9999999999 This will be treated as the secondary phone number. Leave blank if not applicable

    O. Work_Phone_Ext

    • 4-digit Max. Length Optional field if applicable. Leave blank if not applicable

    P. Country_Code

    • Leave BLANK unless International/Non United States (2-digit USPS Country Code)

    Q. Job_Title

    • Enter job title as defined by organization. Empower will keep historical data if changes submitted. (60 character max; free form data entry no specified format)

    R. Job_Category (select from drop-down menu or enter value as listed below)

    • Minister
      Religious Educator
      Music and AV Staff
      Membership Staff
      Admin
      Finance
      Ops Staff

    S. Job_Level (select from drop-down menu or enter M1, P1, M2, P2, MD, PD, MN, SP, SU). May refer to this link for more information: https://www.uua.org/files/2022-11/Job_Level_Rubric.pdf

    • M1 - Minister Level 1 (Minister, Lead Minister, Interim Minister)
      P1 - Program / Admin Executive Level 1 (Exec Director)
      M2 - Minister Level 2 (Associate or Assistant Minister, Minister of
      Congregational Life)
      P2 - Program / Admin Executive Level 2 (Executive Director, Director of Finance and Operations)
      MD - Minister - Director Level (Assistant Minister, Director of Religious
      Education, Director of Music)
      PD - Program / Admin Director Level (Director of Membership, Business Administrator, Congregational Administrator)
      MN - Manager Level (Office or Cong Administrator, Director of RE, Choir Director)
      SP - Specialist Level (Youth Group leader, Children's Music Coordinator)
      SU - Support Level

    T. Employee_Type (select from drop-down menu or enter Y, I, N)

    • Y = Clergy
      I = UU Ministerial Intern
      N = Blank/Null Non-Clergy

    U. Hire_Date

    • Enter original hire date at your location) Format MM/DD/YYYY (Must be 4-digit Year)

    V. Termination_Date (leave blank unless applicable)

    • MM/DD/YYYY (Must be 4-digit Year) Actual termination date and not transfer date.

    W. ReHire_Date (leave blank unless applicable)

    • MM/DD/YYYY (Must be 4-digit Year) Most current hire date

    X. Compensation_Amount

    • (Include Decimal ) ex., 20.00 or 50000.00   Used for participant Life Income Score (LIS) retirement web planning modules and forecasting. This is reported as Salary Amount on Empower secured portal

    Y. Compensation_Qualifier (based on column X. Select from drop-down menu or enter A, H, B, W, S)

    • A = Annual
      H = Hourly
      B = Bi-Weekly
      W = Weekly
      S = Semi-Monthly

    Z. Pay_Frequency (leave blank, Empower will sync the division number affiliation in column B to pay frequency)

    AA. ER_Eligibility_Date

    • Format as MM/DD/YYYY. Enter date participant became eligible for the Employer Contribution in the Plan (if known and already eligible). Leave blank if employee is not yet eligible or if employee came to you already eligible.

    AB. Base_Compensation (please leave blank, for Empower internal use only)

    AC. In_Lieu_of_FICA

    • If location DOES NOT EXCLUDE In-Lieu of FICA for Retirement Compensation (refer to EPA), please enter dollar amount of In Lieu of FICA paid to minister, if applicable, otherwise leave blank

    AD. Domestic_Partner_GrossUp

    • If location DOES NOT EXCLUDE Domestic Partner GrossUp for Retirement Compensation (refer to EPA), please enter dollar amount of Domestic Partner GrossUp, if applicable, otherwise leave blank

    AE. Imputed_Ins

    • If location DOES NOT EXCLUDE Imputed LTD and Life Insurance for Retirement Compensation (refer to EPA), please enter dollar amount of Imputed Life-Insurance or Long Term Disability, if applicable, otherwise leave blank

    AF. Total_Comp

    • Add Compensation Amount/ Salary(Column X) + In-Lieu of FICA(Column AC) + Domestic Partner Gross-up(Column AD) + Imputed LTD and Life Insurance(Column AE) = Total Compensation ***This is the amount to be included as compensation on cash.csv for purposes of determining retirement contributions.

    AG. ER_Contribution_Percent

    • Enter Elected Employer Contribution Percentage specified by EPA. Enter as whole number ex. 10 (Min 5% - Max 14%)

    AH. ER_Match_Percent

    • Elected Employer Match Percentage (if applicable, otherwise leave blank). Enter percentage specified by EPA up to Max 6% (Whole numbers only)

    AI. Highly_Comp_Employee (as defined by the IRS, earned $135,000 or more in 2022. Do not include the housing allowance.)

    • Enter Y=Yes or leave blank

    AJ. Federal_Exemptions

    • Enter number of exemptions employee has selected on W4 form, if known, or leave blank

    AK. Termination_Code (if applicable, otherwise leave blank. Select from drop-down menu or enter DE, DI, LA, R, S)

    • DE = Death
    • DI = Disability
    • LA = Laid off
    • R = Retirement
    • S = Separation of Service

    AL. Primary_Email

    • Participant personal email address. Empower can accept up to 80 characters. Treated as Primary email by Empower.

    AM. Secondary_Email

    • Leave blank if unknown. Participant secondary email address(not employers email address). Empower can accept up to 80 characters. Treated as secondary email with Empower

    AN. Home_Phone

    • Enter 10 digit phone numbers with no hyphens or parenthesis. (secondary phone number, mobile phone is primary. Enter home phone if no mobile number) ex. 9999999999

    AO. Plan_Sponsor_Assigned_ID (please leave blank, field for Empower use only)

    AP. Eligibility_Code (please leave blank, field for Empower use only)

    Published