Configure Additional Person Data for the US

The fields in the Person Management areas include all the options required for Human Resources and legislative reporting. However, your organization might require additional options.

For example, you have an employee who identifies as transgender and doesn't feel Nonbinary is applicable. You can modify the Gender field to include this as an option.

System lookup codes are predefined values you can use for legislative reporting. You can't modify them. However, you can modify their related user lookup codes. Doing so, and then refreshing their mapping, you can use the new values in your reporting.

You can modify the following codes.

These user lookup codes

Map to these system lookup codes

With this lookup type

PER_ETHNICITY

Caution: Best practice is to not modify this code. If you do, your EEO reports might be invalid.

ORA_PER_ETHNICITY

Ethnicity

SEX

ORA_PER_SEX

Gender of person

CONTACT

ORA_PER_CONTACT

Relationship

MAR_STATS

ORA_PER_MAR_STATUS

Marital status for person

PER_HIGHEST_EDUCATION_LEVEL

ORA_PER_HIGHEST_EDUCATION_LEVE

Highest education level

PER_NATIONAL_IDENTIFIER_TYPE

ORA_PER_NATIONAL_IDENTIFIER_TY

National identifier type

Example

You want to add Transgender as an option for employee gender self-identification.

  1. Modify the SEX user look-up code to include a "Transgender" option.

    1. Start the Common Lookups task.

    2. Search for the SEX user lookup type.

    3. Add a row to the Sex: Lookup Codes table.

    4. Enter the following values in the new row.

      Column name

      What you enter

      Lookup Code

      A simple code to represent your new value.

      Enter TG.

      Meaning

      The value as it would appear in the UI.

      Enter Transgender.

      Description

      Provide a meaningful description.

      Tag

      Enter +US.

    5. Save your work.

  2. Map your new type to an existing system type.

    If you don't, the user lookup code you configured won't be available in your legislative reports.

    1. Start the Extended Lookup Codes task.

    2. In Lookup Type, locate and select Sex (System Lookup).

    3. Add a row to the Sex (System Lookup): Extended Lookup Codes table.

    4. Enter the following values in the new row.

      Column name

      What you enter

      Country

      Select United States.

      Note: If the lookup code is specific to the US, you must select United States. If you don't, the lookup code is global.

      Lookup Code

      This refers to the system lookup code.

      Select Nonbinary.

      Note: This is mapping your new Transgender option to the existing Nonbinary option. While your new value appears in fields as "Transgender", it appears in reports as "Nonbinary". This maintains the integrity of your EEO and other reporting.

      Extended Code

      This must match the lookup code you defined above.

      Enter TG.

      Extended Name

      This must match the meaning you defined above.

      Enter Transgender.

      All Enterprises

      Select Yes.

    5. Save your work.